实现目的:
1.在添加学生页面点击提交后会自动跳转到此页面
2.此页面会自动获取并且添加到MySQL所对应的表
3.添加成功后会自动返回学生数据页面以告知添加成功并且数据会自动同步
实现代码:insert.jsp
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<% String drivername = "com.mysql.jdbc.Driver";
String URL ="jdbc:mysql://localhost:3306/(数据库名)";
String USER_NAME = "(登录账户)";
String PASSWORD = "(登录密码)";
Connection con = null;
Class.forName(drivername);
con = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
if (con != null){
System.out.println("数据库连接成功");
}else{
System.out.println("数据库连接失败");
}%>
</head>
<body>
<%try { Class.forName("sun.jdbc.odbc.JdbcodbcDriver");}
catch(ClassNotFoundException e){out.println(e.getMessage());}
try {Connection conn =DriverManager.getConnection(URL,USER_NAME,PASSWORD);
request.setCharacterEncoding("utf-8") ;
String id = request.getParameter("id");
String name = request.getParameter("name");
String password = request.getParameter("password");
String jiguan = request.getParameter("jiguan");
String dep = request.getParameter("dep");
String sex = request.getParameter("sex");
String y = request.getParameter("mark");
Integer mark = Integer.valueOf(y);
String tel = request.getParameter("tel");
String email = request.getParameter("email");
PreparedStatement pst = con.prepareStatement("insert into student values(?,?,?,?,?,?,?,?,?)");
pst.setString(1,id);
pst.setString(2,name);
pst.setString(3, password);
pst.setString(4,jiguan);
pst.setString(5,dep);
pst.setString(6,sex);
pst.setInt(7,mark);
pst.setString(8,tel);
pst.setString(9,email);
int temp =pst.executeUpdate();
if(temp != 0)
{%>
<jsp:forward page="admstu.jsp"></jsp:forward>
<%;}
else
{%>
<jsp:forward page="admstu.jsp"></jsp:forward>
<%;}
pst.close();
conn.close();
} catch (Exception e)
{out .println(e.getMessage());}
%>
</body>
</html>