addKeyan.jsp 1.4 KB

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