java web sqlserver_JavaWeb程序对SQLserver数据库的增删改查操作

1 package com.ll;2

3 import java.io.IOException;4 import java.sql.*;5 import java.util.ArrayList;6 import java.util.List;7

8 import javax.servlet.ServletException;9 import javax.servlet.annotation.WebServlet;10 import javax.servlet.http.HttpServlet;11 import javax.servlet.http.HttpServletRequest;12 import javax.servlet.http.HttpServletResponse;13

14 import dao.Studentdao2;15

16 /**17 * Servlet implementation class GoodsServlet18 */

19 @WebServlet("/GoodsServlet")20 public classGoodsServlet extends HttpServlet {21 private static final long serialVersionUID = 1L;22

23 /**24 * @see HttpServlet#HttpServlet()25 */

26 publicGoodsServlet() {27 super();28 //TODO Auto-generated constructor stub

29 }30

31 /**32 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)33 */

34 protected voiddoGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {35 //TODO Auto-generated method stub

36 String action = request.getParameter("action");37 if(action.equals("zongjin")){38

39 try{40 query(request,response);41 } catch(Exception e) {42 //TODO Auto-generated catch block

43 e.printStackTrace();44 }45 }46

47

48

49 }50

51 /**52 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)53 */

54 protected voiddoPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {55 //TODO Auto-generated method stub

56 }57

58

59 public voidquery(HttpServletRequest request, HttpServletResponse response) throws Exception{60 Studentdao2 conn = newStudentdao2();61 String sql = "Select *from Student";62

63 /*

64 //调用函数去向数据库中添加数据65 String addsql = "于海-19-软件1501-男";66 conn.addsql(addsql);67 */

68

69

70 /*

71 //删除数据库中的数据72 String strdelete = "Delete from Student Where 姓名 = '于海'";73 conn.deletesql(strdelete);74 */

75

76 /*

77 //修改数据库中的数据78 String update = "Update Student set 姓名='宗进' Where 姓名 = '小明' ";79 conn.updateSql(update);80 */

81

82

83 ResultSet rs =conn.executeQuery1(sql);//调用自制函数来接受查询的结果

84 List list = newArrayList();85 while(rs.next())86 {87 Student f = newStudent();88 //equals比较的结果为false是因为从数据库中返回的字符串为"宗进 "

89 f.setBanji(rs.getString("班级"));90 f.setName(rs.getString("姓名"));91 f.setSex(rs.getString("性别"));92 f.setTime(rs.getString("年龄"));93

94 list.add(f);95

96 }97

98 request.setAttribute("list", list);99 request.getRequestDispatcher("sql2.jsp").forward(request, response);100

101

102

103

104 }105 publicString cat(String str){106 String[] arr = str.split(" ");107 String s = arr[0];108 returns;109

110 }111

112 }