Java程序连接MySQL数据库
1.连接MySQL
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3306";
String username = ${username};
String password = ${passwd};
Connection connection = DriverManager.getConnection(url, user, passwd);
Statement statement = connection.createStatement();
2.数据操作
1.查询
ResultSet resultSet = statement.executeQuery("SELECT * FROM TABLE_NAME;");
if (!resultSet.next()) {
System.out.println("当前无信息,请添加后再行查询");
return;
}
while (true) {
System.out.println(resultSet.getString("COLUMN_1") + "\t" + resultSet.getString("COLUMN_2") + "\t" + resultSet.getString("COLUMN_3"));
if (!resultSet.next()) break;
}
2.更新
1.插入
String sql = "INSERT INTO TABLE_NAME VALUES ('%s','%s','%s');";
String worksql = String.format(sql, DATA_1, DATA_2, DATA_3);
statement.executeUpdate(worksql);
2.删除
String sql = "DELETE FROM TABLE_NAME WHERE KEY='%s';";
String worksql = String.format(sql, KEY);
statement.executeUpdate(worksql);
3.修改
String sql = "UPDATE TABLE_NAME SET COLUMN_1='%s',COLUMN_2='%s' WHERE KEY='%s';";
String worksql = String.format(sql, DATA_1, DATA_2, KEY);
statement.executeUpdate(worksql);