import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL("jdbc:mysql://localhost/testdb");
dataSource.setUser("root");
dataSource.setPassword("password");
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
resultSet.close();
statement.close();
connection.close();
Statement statement = connection.createStatement();
statement.addBatch("INSERT INTO users (id, name) VALUES (1, 'John')");
statement.addBatch("INSERT INTO users (id, name) VALUES (2, 'Jane')");
statement.addBatch("INSERT INTO users (id, name) VALUES (3, 'Mike')");
int[] result = statement.executeBatch();
connection.commit();
statement.close();
connection.close();
PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM users WHERE id = ?");
preparedStatement.setInt(1, 1);
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
resultSet.close();
preparedStatement.close();
connection.close();
