JDBC练习-登录案例

需求：
1️⃣通过键盘录入用户名和密码
2️⃣判断用户是否登录成功
步骤：
1️⃣创建一个数据库表

CREATE TABLE USER(
		id INT  PRIMARY KEY AUTO_INCREMENT,
		usernamme VARCHAR(32),
		PASSWORD VARCHAR(32) 

);

INSERT INTO USER VALUES(NULL,'zhangsan','123');
INSERT INTO USER VALUES(NULL,'lisi','234');

2️⃣创建一个jdbc

/*
    练习 1️⃣通过键盘录入用户名和密码
        2️⃣判断用户是否登录成功
 */
public class jjdbcdemo09 {
    public static void main(String[] args) {
        //键盘录入用户名和密码
        Scanner sca =new Scanner(System.in);
        System.out.println("输入用户名");
        String username = sca.nextLine();
        System.out.println("输入密码");
        String password=sca.nextLine();
        //调用方法
        boolean flag = new jjdbcdemo09().login(username, password);
        if (flag){
            System.out.println("登录成功");
        }else {
            System.out.println("用户名或密码错误");
        }
        //判断结果

    }

    /**
     * 登录方法
     *
     */
    public boolean login(String username,String password){
        if (username ==null || password == null){
            return false;
        }
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        //获取连接
        try {
            conn = JDBCUtils.getConnection();
            //          SELECT *FROM USER WHERE username=""AND PASSWORD =" ";
            String sql="select * from user where username = '"+username+"' and password= '"+password+"' ";
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            return rs.next();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            JDBCUtils.close(rs,stmt,conn);
        }


        return false;
    }
}

jdbc_properties
url =jdbc:mysql://localhost:3306/db4
user=root
password=root
driver=com.mysql.jdbc.Driver