jdbc用户登入

public class jdbcdemo3 {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://127.0.0.1:3306/db1?useSSL = false";

        String password = "1234";
        String uesrname = "root";
        Connection conn = DriverManager.getConnection(url, uesrname, password);
        //接受用户输入
        String name = "zhangsan";
        String pwd = "123";
        //定义sql
        String sql = "select * from tb_uesr where username = '"+name+"' and password = '"+pwd+"' ";
        //获取statement对象
        Statement stmt = conn.createStatement();
        //执行sql
        ResultSet resultSet = stmt.executeQuery(sql);

        //判断是否登入成功
        if(resultSet.next()){
            System.out.println("登录成功");
        }else{
            System.out.println("登录失败");
        }

    }
}