我的代码如下:
package newpackage;//import java.beans.*;import java.sql.*;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class userBean { public String userID;
public String password;
public String username; public void setuserID(String _userID){
this.userID=_userID;
}
public void setpassword(String _password){
this.password=_password;
}
public String getusername(){
return username;
}
public String getuserID(){
return userID;
}
public String getpassword(){
return password;
} public boolean checklogin(){
boolean loginsuccess=false;
Connection con=null;
Statement stmt=null;
ResultSet rs=null; try{
String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=pubs";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(url,"sa","admin");
String sql="select * from Users where userID='"+userID+"'";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
if(password.equals(rs.getString("password")))
{
loginsuccess=true;
username=rs.getString("username");
HttpSession session=servletRequest.getSession(); /*此处的servletRequest无法创建*/
/*session.setAttribute("username",username)*/
}
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
con.close();
}catch(Exception e1){
e1.printStackTrace();
}
}
return loginsuccess; }}
package newpackage;//import java.beans.*;import java.sql.*;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class userBean { public String userID;
public String password;
public String username; public void setuserID(String _userID){
this.userID=_userID;
}
public void setpassword(String _password){
this.password=_password;
}
public String getusername(){
return username;
}
public String getuserID(){
return userID;
}
public String getpassword(){
return password;
} public boolean checklogin(){
boolean loginsuccess=false;
Connection con=null;
Statement stmt=null;
ResultSet rs=null; try{
String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=pubs";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(url,"sa","admin");
String sql="select * from Users where userID='"+userID+"'";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
if(password.equals(rs.getString("password")))
{
loginsuccess=true;
username=rs.getString("username");
HttpSession session=servletRequest.getSession(); /*此处的servletRequest无法创建*/
/*session.setAttribute("username",username)*/
}
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
con.close();
}catch(Exception e1){
e1.printStackTrace();
}
}
return loginsuccess; }}
request.getSession().setAttribute("username",username);
...
username=rs.getString("username");
HttpSession session = request.getSession();.....