📄 user_modify_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_modify_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="update student set s_id=?,psw=?,name=?,sex=?,semester=?,major=?,phone=?,credit_hour=?,age=?,political=? where s_id=?";
String sql2="update teacher set t_id=?,psw=?,name=?,dept=?,phone=? where t_id=?";
String sql3="update administrator set id=?,psw=?,age=?,phone=?,name=? where id=?";
Connection con=test1.getConnection();
if(request.getParameter("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.setString(11,request.getParameter("h_user_id"));
ps.executeUpdate();}
else if(request.getParameter("user_class").equals("teacher")){
PreparedStatement ps=con.prepareStatement(sql2);
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 dept=request.getParameter("dept");
String new_dept=new String(dept.getBytes("ISO-8859-1"),"gb2312");
ps.setString(4,new_dept);
ps.setString(5,request.getParameter("phone"));
ps.setString(6,request.getParameter("h_user_id"));
ps.executeUpdate();
}
else{
PreparedStatement ps=con.prepareStatement(sql3);
ps.setString(1,request.getParameter("user_id"));
ps.setString(2,request.getParameter("password"));
ps.setInt(3,Integer.parseInt(request.getParameter("age")));
ps.setString(4,request.getParameter("phone"));
String name=request.getParameter("name");
String new_name=new String(name.getBytes("ISO-8859-1"),"gb2312");
ps.setString(5,new_name);
ps.setString(6,request.getParameter("h_user_id"));
ps.executeUpdate();
}
out.println("修改成功。");
con.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -