//以下就是js源代码<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="Java" import="java.sql.*" %>
<% // 定义参数;
String StudentOrTeacher;
String StuCode;
String Password; // 获取用户登录信息;
StudentOrTeacher = request.getParameter("StudentOrTeacher");
StuCode = request.getParameter("StuCode");
Password = request.getParameter("Password");
// 用户的非法访问;
if (StudentOrTeacher == null)
{
StudentOrTeacher = "";
StuCode = "";
Password = "";
} if (!StuCode.equals(""))
{
// 定义打开数据库连接的函数
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:DbConn";
Connection conn = null;
// 连接数据库
try{ Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DbConnection():"+e.getMessage());
}
try{
conn = DriverManager.getConnection(sConnStr,"sa","dba");
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
// 检验身份;
String sql;
ResultSet rs = null;
if (StudentOrTeacher.equals("Student"))
{
// 学生登录;
sql = "select * from 学生信息 where 卡号=" + StuCode + " and 密码 = '" + Password +"'"; //查询语句
}
else
{
// 教师登录;
sql = "select * from 教师信息 where 代号='" + StuCode + "' and 密码 = '" + Password +"'"; //查询语句
} try
{ Statement Stmt = conn.createStatement();
rs = Stmt.executeQuery(sql);
if (rs.next())
{ // 登录成功;
if (StudentOrTeacher.equals("Student"))
{
session.putValue("StuCode",rs.getString("卡号"));
}
else
{
session.putValue("StuCode",rs.getString("代号"));
}
session.putValue("Name",rs.getString("姓名")); if (StudentOrTeacher.equals("Student"))
{
response.sendRedirect("Student/index.jsp");
}
else
{
response.sendRedirect("Teacher/index.jsp");
}
}
else
{
// 登录失败;
response.sendRedirect("relogin.html");
} }
catch(Exception e)
{
// 查询失败;
response.sendRedirect("relogin.html"); }
}else
{
out.print("输入卡号");
} %>注释已经写得比较详细了。
<%@ page language="Java" import="java.sql.*" %>
<% // 定义参数;
String StudentOrTeacher;
String StuCode;
String Password; // 获取用户登录信息;
StudentOrTeacher = request.getParameter("StudentOrTeacher");
StuCode = request.getParameter("StuCode");
Password = request.getParameter("Password");
// 用户的非法访问;
if (StudentOrTeacher == null)
{
StudentOrTeacher = "";
StuCode = "";
Password = "";
} if (!StuCode.equals(""))
{
// 定义打开数据库连接的函数
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:DbConn";
Connection conn = null;
// 连接数据库
try{ Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DbConnection():"+e.getMessage());
}
try{
conn = DriverManager.getConnection(sConnStr,"sa","dba");
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
// 检验身份;
String sql;
ResultSet rs = null;
if (StudentOrTeacher.equals("Student"))
{
// 学生登录;
sql = "select * from 学生信息 where 卡号=" + StuCode + " and 密码 = '" + Password +"'"; //查询语句
}
else
{
// 教师登录;
sql = "select * from 教师信息 where 代号='" + StuCode + "' and 密码 = '" + Password +"'"; //查询语句
} try
{ Statement Stmt = conn.createStatement();
rs = Stmt.executeQuery(sql);
if (rs.next())
{ // 登录成功;
if (StudentOrTeacher.equals("Student"))
{
session.putValue("StuCode",rs.getString("卡号"));
}
else
{
session.putValue("StuCode",rs.getString("代号"));
}
session.putValue("Name",rs.getString("姓名")); if (StudentOrTeacher.equals("Student"))
{
response.sendRedirect("Student/index.jsp");
}
else
{
response.sendRedirect("Teacher/index.jsp");
}
}
else
{
// 登录失败;
response.sendRedirect("relogin.html");
} }
catch(Exception e)
{
// 查询失败;
response.sendRedirect("relogin.html"); }
}else
{
out.print("输入卡号");
} %>注释已经写得比较详细了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货