📄 forzhuce.java
字号:
//Forzhuce.java
//添加注册资料的servlet
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
import java.lang.*;
import java.lang.String.*;
public class Forzhuce extends HttpServlet
{
//初始化数据库类
static Connection conn;
static Connection connn;
String ST = new String();
DBConnectionBean dbcb = new DBConnectionBean();
//定义doPost方法用来接受数据
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
//定义输出流
req.setCharacterEncoding("gb2312");
res.setContentType("text/html;charset=gb2312");
PrintWriter out = res.getWriter();
//提取表单数据
String textname = req.getParameter("textname");
String textpass = req.getParameter("textpass");
String selectsex = req.getParameter("selectsex");
String textclass = req.getParameter("textclass");
String selectobject = req.getParameter("selectobject");
String textaddress = req.getParameter("textaddress");
String chengji = req.getParameter("chengji");
int ichengji = new Integer(chengji).intValue();
try
{
//随机生成用户登陆用的ID
Random rand = new Random();
int q = 0;
int iID = 0;
while(q==0)
{
iID = rand.nextInt(999) + 1;
String SID = ST.valueOf(iID);
connn = dbcb.openConnection();
PreparedStatement y = connn.prepareStatement
("select SID from allStuday where SID=?");
y.setString(1,SID);
ResultSet result = y.executeQuery();
boolean rowfound = false;
rowfound = result.next();
if(rowfound==true)
{
q = 0;
}
else
{
q = 1;
}
}
//桥接连接数据库
conn = dbcb.openConnection();
System.out.println("数据库连接成功....");
//定义sql命令,保存资料
PreparedStatement s = conn.prepareStatement
("insert allStuday values(?,?,?,?,?,?,?,?)");
s.setInt(1,iID);
s.setString(2,textpass);
s.setString(3,textname);
s.setString(4,selectsex);
s.setString(5,textaddress);
s.setString(6,textclass);
s.setString(7,selectobject);
s.setInt(8,ichengji);
int rows = s.executeUpdate();
if(rows==0)
{
System.out.println("数据超出规格，注册失败！");
}
conn.close();
connn.close();
System.out.println(textname + "注册成功!");
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
out.println("<title>");
out.println("注册成功!");
out.println("</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
out.println("</script>");
out.println("</head>");
out.println("<body>");
out.println("<div align='center'>");
out.println("<p>");
out.println(textname + " 您已经成功注册!");
out.println("</p>");
out.println("<p>");
out.println("请牢牢记住您的ID: " + iID);
out.println("</p>");
out.println("<p>");
out.println("<a href='/myside/examin/loginD.jsp'>");
out.println("点这里用您的ID登陆开始考试!");
out.println("</a>");
out.println("</p>");
out.println("</div>");
out.println("</body>");
out.println("</html>");
out.close();
}
//三个常见异常
catch(SQLException e)
{
System.out.println(e.toString());
}
catch(Exception e)
{
System.out.println(e.toString());
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -