📄 insert2.jsp
字号:
<html>
<head>
<title>注册结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#ffffff" text="#000000">
<%@page language="java" import="java.sql.*"%>
<%@page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="regBean" scope="page" class="exam.exam"/>
<%
int num=0;
String wpsed;
String wnum= new String(request.getParameter("wnum").getBytes("8859_1"));
String tname=new String(request.getParameter("tname").getBytes("8859_1"));
String tsex=request.getParameter("tsex");
String tdep=request.getParameter("give");
String sql1="select * from administrators where wnum='"+wnum+"'";
ResultSet rs1=regBean.executeQuery(sql1);
if(rs1.next())
{
rs1.close();
%>
<jsp:forward page="rereg.htm"/>
<%}
else
{rs1.close();
String sql2="select count(*) as num from administrators";
ResultSet rs2=regBean.executeQuery(sql2);
if(rs2.next()){
num=rs2.getInt("num");
if(num==1)
{
String strSQL2="update administrators set tpri='"+3+"' where wnum='"+0+"'";
regBean.executeUpdate(strSQL2);
String strSQL3="insert into administrators(wnum,wpswd,tname,tsex,tdep,tpri)values ('"+wnum+"','"+wnum+"','"+tname+"','"+tsex+"','"+tdep+"','"+1+"')";
regBean.executeUpdate(strSQL3);
}
else{
rs2.close();
String strSQL4="insert into administrators(wnum,wpswd,tname,tsex,tdep,tpri)values ('"+wnum+"','"+wnum+"','"+tname+"','"+tsex+"','"+tdep+"','"+0+"')";
regBean.executeUpdate(strSQL4);
}
%>
<jsp:forward page="okreg.htm"/>
<%
}}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -