📄 logindenglu.java
字号:
//Logindenglu.java
//验证密码,验证是否以参加考试,传送参数
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
public class Logindenglu extends HttpServlet
{
//初始化数据库类
static Connection conn;
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 DuserID = req.getParameter("DtextID");
String Dpassword = req.getParameter("Dtextpass");
int iDuserID = new Integer(DuserID).intValue();
try
{
//桥接连接数据库
conn = dbcb.openConnection();
System.out.println("数据库连接成功....");
//定义sql命令,验证密码
PreparedStatement s = conn.prepareStatement
("select SID,Spassword,tag from allStuday where SID=? and Spassword=?");
s.setInt(1,iDuserID);
s.setString(2,Dpassword);
ResultSet result = s.executeQuery();
boolean rowfound = false;
rowfound = result.next();
System.out.println("发送SQL命令成功....");
if(rowfound==false)
{
System.out.println("用户 " + iDuserID + " 密码验证失败....拒绝登陆....");
out.println("<html>");
out.println("<head>");
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("<style type='text/css'>");
out.println("<!--");
out.println(".yangshi {font-family: 'Arial', 'Helvetica', 'sans-serif';font-size: 12px;font-weight: lighter;color:#FFFFFF;padding: 4px;border: 1px solid #6633FF;}");
out.println("-->");
out.println("</style>");
out.println("</head>");
out.println("<body>");
out.println("<table width='75%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#6699FF' class='yangshi'>");
out.println("<tr>");
out.println("<td nowrap>");
out.println("<p>");
out.println("<font color='#FF0000'>");
out.println("对不起, ");
out.println("</font>");
out.println("<font color='#FFFFFF'>");
out.println(DuserID);
out.println("</font>");
out.println("<font color='#FF0000'>");
out.println(" ,登陆失败，您的身份未经许可！");
out.println("</font>");
out.println("</p>");
out.println("<p>");
out.println("<font color='#FF0000'>");
out.println("请");
out.println("<a href='javascript:history.back()'>");
out.println("<font color='#FF7777'>");
out.println("重新登陆");
out.println("</font>");
out.println("</a>");
out.println("检查您的帐号!如果仍有问题，请与管理员联系");
out.println("</font>");
out.println("<font color='#FF0000'>");
out.println("！");
out.println("</font>");
out.println("</p>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</body>");
out.println("</html>");
out.close();
}
//如果通过验证,则查询是否已经参加考试
else if(rowfound==true)
{
int tag = result.getInt(3);
if(tag==0)
{
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv=Content-Type content='text/html; charset=gb2312'>");
out.println("<title>无标题文档</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/fun.js'>");
out.println("</script>");
out.println("</head>");
out.println("<body onLoad=MM_goToURL('parent','/myside/examin/reading.jsp?userID=" + DuserID + "');return document.MM_returnValue>");
out.println("</body>");
out.println("</html>");
out.close();
}
else
{
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("<link href='/myside/examin/img/cssexamin.css' rel='stylesheet' type='text/css'>");
out.println("</head>");
out.println("<body>");
out.println("<div align='center'>");
out.println("您的成绩已经存在，请输入您的学号，以便查询您的成绩!");
out.println("<form name='form1' method='post' action='/myside/examin/loginC.jsp'>");
out.println("学号:");
out.println("<input name='textfield' type='text' value=" + DuserID + " size='15'>");
out.println("<input type='submit' name='Submit' value='提交'>");
out.println("<p>");
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 + -