-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcrud all statment
90 lines (76 loc) · 2.57 KB
/
crud all statment
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
package Controller;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Util.connection;
/**
* Servlet implementation class insert1
*/
@WebServlet("/insert1")
public class insert1 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public insert1() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String a1= request.getParameter("user");
String a2= request.getParameter("Email");
String a3= request.getParameter("phone");
String a4= request.getParameter("pass");
String btn=request.getParameter("btn");
Connection con= connection.getconnection();
Statement st= null;
if(btn.equals("Save")) {
try {
st = con.createStatement();
String sql="insert into abc(user,email,phone,pass) values ('"+a1+"','"+a2+"','"+a3+"','"+a4+"')";
st.executeUpdate(sql);
con.close();
response.sendRedirect("From.jsp");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
else if(btn.equals("Update")) {
int NO=Integer.parseInt(request.getParameter("NO"));
try {
st = con.createStatement();
String sql2="update abc set user='"+a1+"',email='"+a2+"',phone='"+a3+"',pass='"+a4+"'where Auto_no='"+NO+"'";
int b=st.executeUpdate(sql2);
con.close();
response.sendRedirect("From.jsp");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(btn.equals("Delete")) {
int NO= Integer.parseInt(request.getParameter("NO"));
try {
st = con.createStatement();
String sql3="delete from abc where Auto_no='"+NO+"'";
st.executeUpdate(sql3);
con.close();
response.sendRedirect("From.jsp");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}
}