GTU WTAD Practical 28 : jsp select query example

GTU WTAD Practical 28 :    Develop a program to perform the database driven operation like insert, Delete, Update and select. To perform the above operations create one table named Employee. Field Name   Field Type EmpId Integer Empname Varchar Emp_desig Varchar Emp_J_Date Varchar Emp_Salary Numeric

GTU WTAD Practical 28This Servlet Program Explains Database Operations (JDBC Connectivity) Insert Update Delete. Here I have created different Servlet for Insert using JDBC, Servlet for Update using JDBC and Delete using JDBC.

File Name : index.jsp

File Location : Tomcat_Apache\webapps\gtu28\

 

File Name : edit.jsp

File Location : Tomcat_Apache\webapps\gtu28\

 

File Name : InsertServlet.java

File Location : Tomcat_Apache\webapps\gtu28\WEB-INF\classes

 

File Name : UpdateServlet.java

File Location : Tomcat_Apache\webapps\gtu28\WEB-INF\classes

 

File Name : DeleteServlet.java

File Location : Tomcat_Apache\webapps\gtu28\WEB-INF\classes

 

File Name : web.xml

File Location : Tomcat_Apache\webapps\gtu28\WEB-INF\

 

Output 1

GTU WTAD Practical 28

 

Output 2

GTU WTAD Practical 28

 

Output 3

GTU WTAD Practical 28

 

Output 4

GTU WTAD Practical 28

 

Adarsh Patel

My Self Adarsh Suryakant Patel. Currently I am working as Assistant Professor at Parul Instiute of Engineering and Technology, MCA Department, Limda, Vadodara. Major Responsibility : * Lectures * Organizing Training and Expert Sessions for * Placement and Recruitment * Faculty Representative