DeleteRow.jsp
<%@ page language="java" import="java.lang.*" import="java.sql.*" %>
<%
Connection con = null;
String url = "jdbc:
mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
String str=request.getParameter("r1");
String name=request.getParameter("empname");
String code=request.getParameter("empid");
int EmpID=Integer.parseInt(code);
try {
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
String sql = "delete from Employee where empid= ?";
PreparedStatement prest = con.prepareStatement(sql);
prest.setInt(1,EmpID);
int i = prest.executeUpdate();
out.println("Successfully delete from database!");
con.close();
}
catch(Exception e) {
out.println(e);
}
%>
------------------------------------
InsertData.jsp
<%@ page language="java" import="java.lang.*" import="java.sql.*" %>
<%
Connection con = null;
String url = "jdbc:
mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
String str=request.getParameter("r1");
String empname=request.getParameter("empname");
String code=request.getParameter("empid");
int EmpID=Integer.parseInt(code);
try {
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
PreparedStatement pst = con.prepareStatement("insert into Employee values(?,?)");
pst.setString(1,code);
pst.setString(2,empname);
int i = pst.executeUpdate();
if(i!=0){
out.println("<br>Record has been inserted");
}
else{
out.println("failed to insert the data");
}
}
catch(Exception e) {
out.println(e.toString());
}
%>