Java操作MySQL数据库——连接数据库
1. 在数据库中建立表
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 303 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
2.编写代码
public class Main {
private static Connection connection;
private static String url = "jdbc:mysql:///blog?useSSL=false";
private static String username = "root";
private static String password = "123456";
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(url, username, password);
String sql = "insert into user values (null,?,?)";
PreparedStatement statement = connection.prepareStatement(sql);
connection.setAutoCommit(false);
statement.setString(1, "a");
statement.setString(2, "b");
statement.executeUpdate();
connection.commit();
statement.close();
connection.close();
}
}
class User {
private Integer id;
private String username;
private String password;
public User(Integer id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}