20180208.后端登录功能、前端登录功能

 

首先需要给DAO的祖先类BaseDAO中添加按名字找数据的方法

public User findByName(String name);

然后给UserDAO添加具体实现MySql中查找数据的方法
@Override

public User findByName(String name) {
    Connection conn=getConnection();
    String sql="";
    PreparedStatement pstmt;
    sql="SELECT * from user where name = ?";
    try{
        pstmt=conn.prepareStatement(sql);
        pstmt.setString(1, name);
        ResultSet rs = pstmt.executeQuery();
        if(rs.next()){
            int user_id=rs.getInt("id");
            String user_name = rs.getString("name");
            String user_pass = rs.getString("password");
            Timestamp user_time=rs.getTimestamp("time");
            return new User(user_id,user_time,user_name,user_pass);
        }else{
            return null;
        }
    }catch(SQLException e){
        e.printStackTrace();
        return