public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8";
Connection connection = DriverManager.getConnection(url, "root", "123456");
String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
PreparedStatement psInsert = connection.prepareStatement(sqlInsert);
psInsert.setString(1,"小明");
psInsert.setString(2,"123456");
psInsert.executeUpdate();
String sqlSelect = "select * from tbl_user";
PreparedStatement psSelect = connection.prepareStatement(sqlSelect);
ResultSet resultSet = psSelect.executeQuery();
while (resultSet.next()) {
System.out.println(resultSet.getString(2)+"-"+resultSet.getString(3));
}
resultSet.close();
psInsert.close();psSelect.close();
connection.close();
}
PrepareStatement批处理
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true";
Connection connection = DriverManager.getConnection(url, "root", "123456");
String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
PreparedStatement psInsert = connection.prepareStatement(sqlInsert);
for (int i = 0; i < 10; i++) {
psInsert.setString(1,"小明"+i);
psInsert.setString(2,"123456");
psInsert.addBatch();
}
psInsert.executeBatch();
psInsert.close();
connection.close();
}
JDBC事务
public static void main(String[ ] args) throws Exception {
Connection connection = null;PreparedStatement psInsert =null;PreparedStatement psSelect = null;ResultSet resultSet = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/rosefinch?useUnicode=true&characterEncoding=utf8";
connection = DriverManager.getConnection(url, "root", "123456");
connection.setAutoCommit(false);
String sqlInsert = "insert into tbl_user(name,pwd) values(?,?)";
psInsert = connection.prepareStatement(sqlInsert);
psInsert.setString(1,"小明");
psInsert.setString(2,"123456");
psInsert.executeUpdate();
String sqlSelect = "select * from tbl_user";
psSelect = connection.prepareStatement(sqlSelect);
resultSet = psSelect.executeQuery();
while (resultSet.next()) {
System.out.println(resultSet.getString(2)+"-"+resultSet.getString(3));
}
connection.commit();
} catch (Exception e) {
connection.rollback();
} finally {
if (resultSet != null) resultSet.close();
if (psInsert != null) psInsert.close();
if (psSelect != null) psSelect.close();
if (connection != null) connection.close();
}
}