编程环境
Win10 JDK1.8 MySQL5.5.58 IDEA2018.2.2
JDBC编程步骤
加载驱动
1.在IDEA工程下新建一个bin文件夹,然后在Windows文件资源管理器中打开该文件夹,将mysql-connector-java-5.1.36.jar复制到该文件夹中;
2.在IDEA工程目录中右键单击mysql-connector-java-5.1.36.jar,选择Add As Library…,点击确定即可导入jar包。
3.初始化:
Class.forName("com.mysql.jdbc.Driver");
创建连接
Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/user?useSSL=true&characterEncoding=utf-8&user=root&password=root");
写SQL
增
String sql = "insert into userinfo(username, password) values(?, ?)";
删
String sql = "delete from userinfo where id = ?";
改
String sql = "update userinfo set password =? where id=?";
查
String sql = "select * from userinfo";