| 发表于：2007-09-21 17:03:525楼 得分:0 |
package login;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class loginservlet extends httpservlet implements servlet{
public loginservlet（)
{
super（);
}
protected void doget（httpservletrequest request,httpservletresponse response)throws servletexception,ioexception
{
response.setcontenttype（ "text/html ");
string result= " ";
string strusername=request.getparameter（ "txtusername ");
string strpassword=request.getparameter（ "txtpassword ");
resultset rs=null;
statement stmt=null;
connection conn=null;
printwriter out=response.getwriter（);
//out.println（ " <html> <body> ");
//out.println（ " <h1> 1 <hi> ");
//out.println（ " </html> </body> ");
if （（strusername== " ") ¦ ¦（strusername.equals（ " ")) ¦ ¦（strusername.length（)> 20))
{
result= "请输入用户名（不超过20个字符！）！ ";
request.setattribute（ "error_username ", result);
response.sendredirect（ "login.html ");
}
if （（strpassword== " ") ¦ ¦（strpassword.equals（ " ")) ¦ ¦strpassword.length（)> 20)
{
result= "请输入密码（不超过20个字符！）！ ";
request.setattribute（ "error_password ", result);
response.sendredirect（ "login.html ");
}
try{class.forname（ "com.microsoft.jdbc.sqlserver.sqlserverdriver ");}
catch（ classnotfoundexception e)
{ e.printstacktrace（);}
try{
conn=drivermanager.getconnection（ "jdbc:microsoft:sqlserver://127.0.0.1;databasename=jsp ", "sa ", "123456 ");
string sql= "select * from userinfo where name= ' "+strusername+ " ' and pwd= ' "+strpassword+ " ' ";
stmt=conn.createstatement（);
rs=stmt.ＥＸＥＣutequery（sql);
if（rs.next（))
{
out.println（ " <html> <body> ");
out.println（ " <h1> 1 <hi> ");
out.println（ " </html> </body> ");
request.getsession（true).setattribute（ "username ",strusername );
response.sendredirect（ "success.jsp ");
}
else
{
out.println（ " <html> <body> ");
out.println（ " <h1> 2 <hi> ");
out.println（ " </html> </body> ");
response.sendredirect（ "failure.jsp ");
}
}
catch（sqlexception e)
{
e.printstacktrace（);
}
catch（exception e)
{
e.printstacktrace（);
}
finally
{
try{
if（rs !=null)
{rs.close（);}
if（stmt !=null)
{stmt.close（);}
if（conn!=null)
{conn.close（);}
}
catch（sqlexception e)
{
e.printstacktrace（);
}
}
}
public void dopost（httpservletrequest request,httpservletresponse response)throws servletexception,ioexception
{
doget（request,response);
}
} | | |
|
