Adding an employee
Adding an employee
coding for adding an employee
View Answers
June 22, 2011 at 12:34 PM
1)employee.jsp:
<html> <form name="form" method="post" onsubmit="return validate();" action="insertdata.jsp"> <table> <tr><td>Enter First Name</td><td><input type="text" name="fname"></td></tr> <tr><td>Enter Last Name</td><td><input type="text" name="lname"></td></tr> <tr><td>Enter User Name</td><td><input type="text" name="uname"></td></tr> <tr><td>Enter Password</td><td><input type="password" name="pass"></td></tr> <tr><td>Enter Address</td><td><input type="text" name="address"></td></tr> <tr><td>Enter Contact No</td><td><input type="text" name="contact"></td></tr> <tr><td>Enter Email</td><td><input type="text" name="email"></td></tr> <tr><td></td><td><input type="submit" value="Add" name="button"></td></tr> </table> </form> </html>
2)insertdata.jsp:
<%@page import="java.sql.*,java.util.*"%>
<table>
<%
String uname=request.getParameter("uname");
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String pass=request.getParameter("pass");
String address=request.getParameter("address");
int contact=Integer.parseInt(request.getParameter("contact"));
String email=request.getParameter("email");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into employee(username,password,firstname,lastname,address,contactNo,email) values('"+uname+"','"+pass+"','"+fname+"','"+lname+"','"+address+"',"+contact+",'"+email+"')");
out.println("Data is successfully inserted into database.");
}
catch(Exception e){
System.out.println(e);
}
%>
</table>
Ads
Related Tutorials/Questions & Answers:
Advertisements
adding a dialogue
adding a dialogue Blockquote Hi can you help with the program below,the program is a loop that prints out a code and a quantity when prompt for the user input.what I need is to modify the code to incorporate a dialogue asking
adding a dialogue Blockquote Hi can you help with the program below,the program is a loop that prints out a code and a quantity when prompt for the user input.what I need is to modify the code to incorporate a dialogue asking
adding loop
adding loop Hi I have a program that is not compiling when I add a loop can you help me?The program below is compiling without the loop. > Blockquote mport java.util.*; import java.text.*; import java.util.Scanner
adding loop Hi I have a program that is not compiling when I add a loop can you help me?The program below is compiling without the loop. > Blockquote mport java.util.*; import java.text.*; import java.util.Scanner
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Adding JTable into existing Jframe.
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Adding JTable into existing Jframe.
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Adding JTable into existing Jframe.
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Adding JTable into existing Jframe. i need to add JTable... str; { setLayout(null); setTitle("Employee Details Application...); add(close); add(print); String[] search={"--search by--","Employee_ID
Employee form
Employee form In employee form emp Id id after any data iserted is incremented for oher data insertion. insert, delete, update buttons when we cleak the select buttoun then the created table data iserted automaticaly
Employee form In employee form emp Id id after any data iserted is incremented for oher data insertion. insert, delete, update buttons when we cleak the select buttoun then the created table data iserted automaticaly
employee records
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
employee records
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
employee records
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
employee records Pl give one script like i will creat one table name Emp_master and column name like Empcode, Empname. I like one form where I... and one report like details of employee thanks
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
Employee Salaries Define a class Employee with the following properties. Every Employee has a name and a salary. The constructor creates an Employee... the salary of the Employee to zero. The method getinfo() will return the current
application for an Employee
: in this page it should modify employee data and persist in DB 3.DISPLAY
: in this page it should modify employee data and persist in DB 3.DISPLAY
employee progarm
employee progarm Hai, I have developed a code for an employee program by using jtext fields and buttons,it has no errors but while we are compiling it it is saying that "Exception in thread "main
employee progarm Hai, I have developed a code for an employee program by using jtext fields and buttons,it has no errors but while we are compiling it it is saying that "Exception in thread "main
coding for employee management system
coding for employee management system coding for employee management system
coding for employee management system coding for employee management system
display the employee name
display the employee name when i will select one employee designation based on that employee designation display the particular designation employee name display in another select box how it possible using servlet and mysql
display the employee name when i will select one employee designation based on that employee designation display the particular designation employee name display in another select box how it possible using servlet and mysql
javascript adding a value to an array
javascript adding a value to an array How to add a value to a function argument or an array in JavaScript
javascript adding a value to an array How to add a value to a function argument or an array in JavaScript
adding view to viewcontroller
adding view to viewcontroller How to add a frame window that opens on button click .. in iPhone application
adding view to viewcontroller How to add a frame window that opens on button click .. in iPhone application
adding groups in contacts
adding groups in contacts how to add groups in contacts using servlet and jsp????pls help.thanku in advance
adding groups in contacts how to add groups in contacts using servlet and jsp????pls help.thanku in advance
Adding photo to iPhone simulator
Adding photo to iPhone simulator Hi, there is no photo in my iPhone simulator.. how can i add one? Please suggest. Thanks
Adding photo to iPhone simulator Hi, there is no photo in my iPhone simulator.. how can i add one? Please suggest. Thanks
Dynamically adding textbox and labels
Dynamically adding textbox and labels Sir, In my application I want to insert texbox and labels dynamically and want to insert database field value in that generated label. Plz help me, Thanks in advance
Dynamically adding textbox and labels Sir, In my application I want to insert texbox and labels dynamically and want to insert database field value in that generated label. Plz help me, Thanks in advance
webservices adding in eclipse
webservices adding in eclipse hi team, i am working on webservices, please guide me how to add webservices in eclispe with step by step and give some examples also. Please visit the following link: http
webservices adding in eclipse hi team, i am working on webservices, please guide me how to add webservices in eclispe with step by step and give some examples also. Please visit the following link: http