<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
Insert title here
<%
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();
%>
<%
response.setHeader("Refresh","1,url=KeYanProject.jsp");
%>