📄 user_insert_db.jsp
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'user_insert_db.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<jsp:useBean id="test1" scope="application" class="test.Connect_db"/>
<%
String sql1="insert into student values(?,?,?,?,?,?,?,?,?,?)";
String sql2="insert into teacher values(?,?,?,?,?)";
String sql3="insert into administrator(id,psw) value(?,?)";
String user_class=request.getParameter("user_class");
Connection con=test1.getConnection();
if(user_class.equals("student")){
PreparedStatement ps=con.prepareStatement(sql1);
ps.setString(1,request.getParameter("user_id"));
ps.setString(2,request.getParameter("password"));
String name=request.getParameter("name");
String new_name=new String(name.getBytes("ISO-8859-1"),"gb2312");
ps.setString(3,new_name);
String sex=request.getParameter("sex");
String new_sex=new String(sex.getBytes("ISO-8859-1"),"gb2312");
ps.setString(4,new_sex);
ps.setString(5,request.getParameter("semester"));
String major=request.getParameter("major");
String new_major=new String(major.getBytes("ISO-8859-1"),"gb2312");
ps.setString(6,new_major);
ps.setString(7,request.getParameter("phone"));
ps.setInt(8,Integer.parseInt(request.getParameter("credit_hour")));
ps.setInt(9,Integer.parseInt(request.getParameter("age")));
String political=request.getParameter("political");
String new_political=new String(political.getBytes("ISO-8859-1"),"gb2312");
ps.setString(10,new_political);
ps.executeUpdate();
}
else if(user_class.equals("teacher")){
PreparedStatement ps=con.prepareStatement(sql2);
ps.setString(1,request.getParameter("user_id"));
ps.setString(2,request.getParameter("password"));
ps.setString(3,request.getParameter("name"));
ps.setString(4,request.getParameter("dept"));
ps.setString(5,request.getParameter("phone"));
ps.executeUpdate();
}
else {
PreparedStatement ps=con.prepareStatement(sql3);
ps.setString(1,request.getParameter("user_id"));
ps.setString(2,request.getParameter("password"));
ps.executeUpdate();
}
out.print("添加成功！");
con.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -