Java学习-JDBC的使用

最新推荐文章于 2024-09-14 15:21:37 发布

八度余温℃

最新推荐文章于 2024-09-14 15:21:37 发布

阅读量121

点赞数

文章标签： jdbc mysql java 数据库

本文链接：https://blog.csdn.net/weixin_44375445/article/details/107773695

版权

综合案列-登录

创建表，并插入测试数据

CREATE TABLE `user`(
	id INT PRIMARY KEY AUTO_INCREMENT,
	username VARCHAR(20) UNIQUE NOT NULL,
	PASSWORD VARCHAR(20) NOT NULL,
	phone VARCHAR(11)

)CHARSET=utf8;

INSERT INTO `user`(username,PASSWORD,phone) VALUES('zhangsan','1234','123456');
INSERT INTO `user`(username,PASSWORD,phone) VALUES('lisi','1234','1234567');
SELECT * FROM `user`;

java代码

public class LoginJdbc {
    public static void main(String[] args)throws  Exception {
        Scanner input=new Scanner(System.in);
        System.out.println("请输入用户名");
        String username=input.next();
        System.out.println("请输入密码");
        String password=input.next();
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/mycompanydb","root","1234");
        Statement statement=connection.createStatement();
        ResultSet resultSet=statement.executeQuery("select * from  user where username='"+username+"'and password='"+password+"';");
        if (resultSet!=null){
            System.out.println("登录成功");
        }else{
            System.out.println("登陆失败");
        }
        resultSet.close();
        statement.close();
        connection.close();
    }
}