jsp第六周作业

package org.mbw.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.mbw.entity.Login;

//模型层:用于处理登录(查询数据)
public class LoginDao {
        public static int login(Login Login) {//登录
            //boolean flag = false;
            int flag = -1 ;//-1:系统异常 0:用户密码或账号错误 1:正常
            int result = -1;
            String URL = "jdbc:mysql://localhost:3306/move?useSSL=false&useUnicode=true&characterEncoding=UTF-8";
            String USERNAME = "root";
            String PWD = "123456";
            
            Connection connection = null;
            PreparedStatement ps = null;
            ResultSet rs = null;
            
            try {
                Class.forName("com.mysql.jdbc.Driver");
                connection = DriverManager.getConnection(URL, USERNAME, PWD);
                
                String sql = "select count(*) from user where uname = ? and pwsd = ?";
                ps = connection.prepareStatement(sql);
                ps.setString(1, Login.getUname());
                ps.setString(2, Login.getPwsd());
                rs = ps.executeQuery();
                if(rs.next()) {
                    result = rs.getInt(1);
                }
                if(result>0) {//登录成功
                    return 1;
                }else {
                  return 0;//登录失败(用户名或密码有误)
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
                return -1;//登录异常
            }catch(SQLException e) {
                e.printStackTrace();
                return -1;
            }catch(Exception e) {
                e.printStackTrace();
                return -1;
            }finally {
                try {
                if(rs!=null) rs.close();
                if(ps!=null) rs.close();
                if(connection!=null) rs.close();
                }catch(SQLException e) {
                    e.printStackTrace();
                }catch(Exception e) {
                    e.printStackTrace();
                }
            }
        }
}



package org.mbw.entity;

public class Login {
       private int id;
       private String uname;
       private String pwsd;
       
   public Login() {
}
   
   public Login(String uname, String pwsd) {
        this.uname = uname;
        this.pwsd = pwsd;
    }
    public Login(int id, String uname, String pwsd) {
        this.id = id;
        this.uname = uname;
        this.pwsd = pwsd;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getPwsd() {
        return pwsd;
    }
    public void setPwsd(String pwsd) {
        this.pwsd = pwsd;
    }
       
       
}


package org.mbw.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.mbw.dao.LoginDao;
import org.mbw.entity.Login;

//控制器层:接受view请求,并分发给Model层处理
public class LoginServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    //处理登录请求
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("uname");
        String pwd = request.getParameter("upwsd");
        Login login = new Login(name,pwd);//用户名,密码
        
        //调用模型层的登录功能
        int result = LoginDao.login(login);
        if(result>0) {
            response.sendRedirect("Welcome.jsp");
        }else {
            response.sendRedirect("login.jsp");
        }
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}