下面的是代码:
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*" %>
<%
String username= request.getParameter("username");
String password= request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:xumen","sheng","123456");
Statement stmt=con.createStatement();
String isCorrect="select * from tb_user where username='"+username+"'and password='"+password+"'";
ResultSet rs=stmt.executeQuery(isCorrect);
if(!rs.next())
{
response.sendRedirect("login.html");
rs.close();
stmt.close();
con.close();
}
else if(rs.getString("isCheck").equals("0"))
{
session.setAttribute("username",rs.getString("username"));
session.setAttribute("password",rs.getString("password"));
session.setAttribute("isCheck",rs.getString("isCheck"));
try
{
stmt.executeQuery("update tb_user set isCheck='"+1+"'where username='"+username+"'");
stmt.close();
con.close();
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
response.sendRedirect("index.html");
}
else
{response.sendRedirect("watch.jsp");
stmt.close();
con.close();
rs.close();
}
%>
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*" %>
<%
String username= request.getParameter("username");
String password= request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:xumen","sheng","123456");
Statement stmt=con.createStatement();
String isCorrect="select * from tb_user where username='"+username+"'and password='"+password+"'";
ResultSet rs=stmt.executeQuery(isCorrect);
if(!rs.next())
{
response.sendRedirect("login.html");
rs.close();
stmt.close();
con.close();
}
else if(rs.getString("isCheck").equals("0"))
{
session.setAttribute("username",rs.getString("username"));
session.setAttribute("password",rs.getString("password"));
session.setAttribute("isCheck",rs.getString("isCheck"));
try
{
stmt.executeQuery("update tb_user set isCheck='"+1+"'where username='"+username+"'");
stmt.close();
con.close();
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
response.sendRedirect("index.html");
}
else
{response.sendRedirect("watch.jsp");
stmt.close();
con.close();
rs.close();
}
%>
楼主查看一下:
1、数据库是否连接是否正常
2、数据库中是否有相应的用户名和密码