123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <%@page 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>添加信息</title>
- </head>
- <body>
- <%
- request.setCharacterEncoding("UTF-8");
- //String TeaName = new String(request.getParameter("TeaName").getBytes("iso-8859-1"),"utf-8");
- //System.out.println(request.getParameter("TeaName").getBytes("iso-8859-1"));
- /* for(byte b:TeaName.getBytes()){
- System.out.println((int)b);
- } */
- String TeaName = request.getParameter("TeaName");
- String TeaAge = request.getParameter("TeaAge");
- String TeaSex = request.getParameter("TeaSex");
- 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 teachermessage values(null,?,?,?)";
- PreparedStatement pstmt = conn.prepareStatement(sql);//执行数据库语句
- pstmt.setString(1,TeaName);//TeaName TeaAge,TeaSex插入到数据库表中
- pstmt.setString(2,TeaAge);
- pstmt.setString(3,TeaSex);
- int result = pstmt.executeUpdate();//数据库表的更新
- String msg = "添加失败,单击跳转到教师信息页";
- if(result==1){
- msg = "添加成功,点击回到老师信息首页";
- }
- pstmt.close();
- conn.close();
- %>
- <script>window.alert('<%= msg %>');</script>
- <%
- response.setHeader("Refresh","1,url=TeachMessage.jsp");
- %>
- </body>
- </html>
|