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>
Related Tutorials/Questions & Answers:
Advertisements
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 - SQL
EMPLOYEE CALCULATE EMPLOYEE SALARY Hi friend, Please give the full details of Problem. Thanks
EMPLOYEE CALCULATE EMPLOYEE SALARY Hi friend, Please give the full details of Problem. Thanks
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
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
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
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
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
program on employee details
program on employee details to write a program on displaying the employee details like empid,empname,wonno,location,leave type by using the text fields in java swings
program on employee details to write a program on displaying the employee details like empid,empname,wonno,location,leave type by using the text fields in java swings
Auto Generated Employee ID
Auto Generated Employee ID Hello Everyone I want to generate an ID like (SCS-0001) and then it should be auto incremented each time a new employee add page is opens. I am using My Sql database
Auto Generated Employee ID Hello Everyone I want to generate an ID like (SCS-0001) and then it should be auto incremented each time a new employee add page is opens. I am using My Sql database
compute the daily wage of an employee.
compute the daily wage of an employee. B. Write a JavaScript program that would input Employee Name, Rate per hour, No. of hours worked and will compute the daily wage of an employee. If the number of hours worked exceeds
compute the daily wage of an employee. B. Write a JavaScript program that would input Employee Name, Rate per hour, No. of hours worked and will compute the daily wage of an employee. If the number of hours worked exceeds
compute the daily wage of an employee.
compute the daily wage of an employee. B. Write a JavaScript program that would input Employee Name, Rate per hour, No. of hours worked and will compute the daily wage of an employee. If the number of hours worked exceeds
compute the daily wage of an employee. B. Write a JavaScript program that would input Employee Name, Rate per hour, No. of hours worked and will compute the daily wage of an employee. If the number of hours worked exceeds
Generate Employee ID (SCS-0001,SCS-0002......)
Generate Employee ID (SCS-0001,SCS-0002......) Hello everyone i am beginner in java and i am working on my major project I want to generate bill number and employee number like SCS-0001 and so on and bill number like SCS/'date
Generate Employee ID (SCS-0001,SCS-0002......) Hello everyone i am beginner in java and i am working on my major project I want to generate bill number and employee number like SCS-0001 and so on and bill number like SCS/'date
Employee Details - JSP-Servlet
Employee Details Respected Sir/Madam, Thanks for your response. Regarding that alert box problem what I have decided is to include the contents of process.jsp in the home page itself without any submit button
Employee Details Respected Sir/Madam, Thanks for your response. Regarding that alert box problem what I have decided is to include the contents of process.jsp in the home page itself without any submit button
store the employee ID,name,login time and logout time of the employee in database
store the employee ID,name,login time and logout time of the employee in database hello...I want to store the employee ID,name,login time and logout time of the employee along with the time difference between these two
store the employee ID,name,login time and logout time of the employee in database hello...I want to store the employee ID,name,login time and logout time of the employee along with the time difference between these two
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
adding buttons - Swing AWT
adding buttons can u plzz explain how to add button to a dialog box and make them perform some event on the image loaded on the panel
adding buttons can u plzz explain how to add button to a dialog box and make them perform some event on the image loaded on the panel
adding buttons - Swing AWT
adding buttons can u plzz explain how to add button to a dialog box and make them perform some event on the image loaded on the panel
adding buttons can u plzz explain how to add button to a dialog box and make them perform some event on the image loaded on the panel
testcase for adding - JUNIT
testcase for adding hi deepak...I am new to junit.can u send me a JUnit test case for adding or multiplying of two numbers.please i need it urgently
testcase for adding hi deepak...I am new to junit.can u send me a JUnit test case for adding or multiplying of two numbers.please i need it urgently
Adding Jar into Eclipse
Adding Jar into Eclipse Hi, Please provide Step by step procedure to add jar, tld files and configurations in Eclipse Helios version and i am using Jboss5. Thanks&Regards, Shiva sADS_TO_REPLACE_1
Adding Jar into Eclipse Hi, Please provide Step by step procedure to add jar, tld files and configurations in Eclipse Helios version and i am using Jboss5. Thanks&Regards, Shiva sADS_TO_REPLACE_1
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
Adding customitem in canvas in J2ME?
Adding customitem in canvas in J2ME? In J2ME how should we add a customitem inside the canvas.Because i need to perform key event handling for customitem.The key event handling is allowed in canvas not in form.So i try to use
Adding customitem in canvas in J2ME? In J2ME how should we add a customitem inside the canvas.Because i need to perform key event handling for customitem.The key event handling is allowed in canvas not in form.So i try to use
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
Adding images in itext pdf
Adding images in itext pdf Hi, How to add image in pdf file using itext? Thanks Hi, You can use following code: PdfWriter.getInstance(document,new FileOutputStream("imagesPDF.pdf")); Read more at Inserting
Adding images in itext pdf Hi, How to add image in pdf file using itext? Thanks Hi, You can use following code: PdfWriter.getInstance(document,new FileOutputStream("imagesPDF.pdf")); Read more at Inserting
Java: Adding Row in JTable
Java: Adding Row in JTable how about if we already have the JTAble created earlier. And i just found nothing to get its DefaultTableModel, thus, I can't call insertRow() method. Is there any work around for this? I found
Java: Adding Row in JTable how about if we already have the JTAble created earlier. And i just found nothing to get its DefaultTableModel, thus, I can't call insertRow() method. Is there any work around for this? I found
jtable-adding a row dynamically
jtable-adding a row dynamically hi..i am doing a project for pharmacy .. *pblm:* when i want to enter the details in jtable while running the application there are 3 rows and 4 columns which is default bt when we we have
jtable-adding a row dynamically hi..i am doing a project for pharmacy .. *pblm:* when i want to enter the details in jtable while running the application there are 3 rows and 4 columns which is default bt when we we have
Adding checkbox to List as item
Adding checkbox to List as item can we add checkox to List Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.awt.*; import javax.swing.*; import java.awt.event.*; public class CheckBoxInList
Adding checkbox to List as item can we add checkox to List Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.awt.*; import javax.swing.*; import java.awt.event.*; public class CheckBoxInList
Dyanmically Adding Rows
Dyanmically Adding Rows Hi sir Am doing project in that i need to add date picker in dynamically adding rows but the dates are storing in first test box only ill paste my code debug that code as soon as possible. Regards
Dyanmically Adding Rows Hi sir Am doing project in that i need to add date picker in dynamically adding rows but the dates are storing in first test box only ill paste my code debug that code as soon as possible. Regards
adding the delete code
adding the delete code hello sir... i need to add a delete button to my code but i didn't know where can i put it.. i've tried but still not working.. please help me...this is the code.. package newproject1; import java.awt.
adding the delete code hello sir... i need to add a delete button to my code but i didn't know where can i put it.. i've tried but still not working.. please help me...this is the code.. package newproject1; import java.awt.
Ads