package Servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import JavaBean.user;
import JavaBean.DB_user;
public class LoginServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
public LoginServlet()
{
super();
}
protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
{
response.setContentType( "text/html;charset=GB2312 ");
String username=request.getParameter( "logname ");
String password=request.getParameter( "logpwd ");
DB_user dbuser = new DB_user();
user us=dbuser.get(username,password);
if(us!=null)
{
request.getSession(true).setAttribute( "username ",username);
try{
request.getRequestDispatcher( "index.jsp ").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
else
{
request.setAttribute( "error ", "用户名与密码不匹配,请重试！ ");
try{
request.getRequestDispatcher( "Login.jsp ").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
}
}
package JavaBean;
import java.sql.*;
import java.io.*;
public class DB_conn{
private Connection conn=null;
public Statement sm=null;
private PrintWriter out = null;
public void connectDB(){
try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
conn=DriverManager.getConnection( "jdbc:odbc:shop ", "sa ", " ");
sm=conn.createStatement();
}
catch(Exception e){
System.out.println( "数据库连接失败！ ");
}
}
public void closeDB(){
try{
if(sm!=null)
{
sm.close();
}
conn.close();
}
catch(Exception e){
System.out.println( "数据库关闭失败！ ");
}
}
}
package JavaBean;
public class user{
private int userid;
private String username;
private String pwd;
private String email;
private int gender;
private String strgender;
private String tel;