addTeacher.jsp 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2. pageEncoding="utf-8"%>
  3. <%@page import="java.sql.*" %>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  5. <html>
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  8. <title>添加信息</title>
  9. </head>
  10. <body>
  11. <%
  12. request.setCharacterEncoding("UTF-8");
  13. //String TeaName = new String(request.getParameter("TeaName").getBytes("iso-8859-1"),"utf-8");
  14. //System.out.println(request.getParameter("TeaName").getBytes("iso-8859-1"));
  15. /* for(byte b:TeaName.getBytes()){
  16. System.out.println((int)b);
  17. } */
  18. String TeaName = request.getParameter("TeaName");
  19. String TeaAge = request.getParameter("TeaAge");
  20. String TeaSex = request.getParameter("TeaSex");
  21. Class.forName("com.mysql.jdbc.Driver");
  22. String url = "jdbc:mysql://127.0.0.1:3306/teamessage?serverTimezone=UTC";
  23. String username = "root";
  24. String password = "1314";
  25. Connection conn = DriverManager.getConnection(url,username,password);
  26. String sql = "insert into teachermessage values(null,?,?,?)";
  27. PreparedStatement pstmt = conn.prepareStatement(sql);//执行数据库语句
  28. pstmt.setString(1,TeaName);//TeaName TeaAge,TeaSex插入到数据库表中
  29. pstmt.setString(2,TeaAge);
  30. pstmt.setString(3,TeaSex);
  31. int result = pstmt.executeUpdate();//数据库表的更新
  32. String msg = "添加失败,单击跳转到教师信息页";
  33. if(result==1){
  34. msg = "添加成功,点击回到老师信息首页";
  35. }
  36. pstmt.close();
  37. conn.close();
  38. %>
  39. <script>window.alert('<%= msg %>');</script>
  40. <%
  41. response.setHeader("Refresh","1,url=TeachMessage.jsp");
  42. %>
  43. </body>
  44. </html>