JDBC工具类
程序员文章站
2022-05-19 12:05:04
...
JDBC工具类
public class JDBCUtil {
private static String className = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/mydb2";
private static String user = "root";
private static String password = "root";
static {
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
Connection connection = DriverManager.getConnection(url, user, password);
return connection;
}
public static void getCloseConnection(Connection connection) throws SQLException {
connection.close();
}
public static int executeUpdate(String sql, Object[] params) throws SQLException {
Connection connection = getConnection();
PreparedStatement statement = connection.prepareStatement(sql);
if (params != null) {
for (int i = 0; i < params.length; i++) {
statement.setObject(i + 1, params[i]);
}
}
int n = statement.executeUpdate();
return n;
}
public static ResultSet executeQuery(Connection connection, String sql, Object[] params) throws SQLException {
PreparedStatement statement = connection.prepareStatement(sql);
if (params != null) {
for (int i = 0; i < params.length; i++) {
statement.setObject(i + 1, params[i]);
}
}
ResultSet rs = statement.executeQuery();
return rs;
}
}
上一篇: 天河区
下一篇: 牛人2009流行语录写文章