做毕业设计又遇到郁闷的有关问题了,高手帮忙
日期：2014-05-18 浏览次数：20748 次
做毕业设计又遇到郁闷的问题了,高手帮忙
源码如下:
<%@ page contentType= "text/html;charset=GB2312 " %>
<%@ page import= "java.sql.* " %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
}
catch(ClassNotFoundException e)
{
out.print( "该数据驱动方式不存在! ");
}
//try
//{
con=DriverManager.getConnection( "jdbc:odbc:bysj ", "sa ", "513278 ");
sql=con.createStatement();
String userID=request.getParameter( "userID ");
String password=request.getParameter( "userpassword ");
String sqlString =new String( "SELECT userID,password FROM user WHERE userID= ' "+userID+ " ' ");//错误所在行
rs=sql.executeQuery(sqlString);
if(!rs.next())
{
out.print( "该用户不存在！请 <a href= 'login.jsp '> 重新登陆 </a> ");
}
else{
if(!rs.getString(3).equals(password))
out.print( "您输入的密码不正确！请 <a href= 'login.jsp '> 重新登陆 </a> ");
else
{
if(rs.getInt(5)==1)
response.sendRedirect( "usermain.jsp ");
if(rs.getInt(5)==2)
response.sendRedirect( "managermain.jsp ");
if(rs.getInt(5)==1)
response.sendRedirect( "leader.jsp ");
}
}
源码如下:
<%@ page contentType= "text/html;charset=GB2312 " %>
<%@ page import= "java.sql.* " %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
}
catch(ClassNotFoundException e)
{
out.print( "该数据驱动方式不存在! ");
}
//try
//{
con=DriverManager.getConnection( "jdbc:odbc:bysj ", "sa ", "513278 ");
sql=con.createStatement();
String userID=request.getParameter( "userID ");
String password=request.getParameter( "userpassword ");
String sqlString =new String( "SELECT userID,password FROM user WHERE userID= ' "+userID+ " ' ");//错误所在行
rs=sql.executeQuery(sqlString);
if(!rs.next())
{
out.print( "该用户不存在！请 <a href= 'login.jsp '> 重新登陆 </a> ");
}
else{
if(!rs.getString(3).equals(password))
out.print( "您输入的密码不正确！请 <a href= 'login.jsp '> 重新登陆 </a> ");
else
{
if(rs.getInt(5)==1)
response.sendRedirect( "usermain.jsp ");
if(rs.getInt(5)==2)
response.sendRedirect( "managermain.jsp ");
if(rs.getInt(5)==1)
response.sendRedirect( "leader.jsp ");
}
}
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
