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