这里写代码片
package com.first.DBHelper;
import java.sql.*;
public class DBhelp {
static final String URL = "jdbc:mysql://localhost:3306/user?useUnicode=true&&characterEncoding=UTF-8";
static final String USER_NAME = "root";
static final String PASSWORD = "123";
public static Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
// 执行查询的方法
public static ResultSet executeQuery(String sql,Connection conn, Object...objects) {//Object...objects 动态的object数组
ResultSet rs=null;
try {
PreparedStatement ps = conn.prepareStatement(sql);
if(objects.length!=0){
for (int i = 0; i < objects.length; i++) {
ps.setObject(i+1, objects[i]);
}
}
rs = ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
// 执行添加 修改 删除
public static void executeUpdate(String sql,Connection conn,Object...objects) {
try {
PreparedStatement ps = conn.prepareStatement(sql);
int count = ps.executeUpdate();
if(objects.length!=0){
for (int i = 0; i < objects.length; i++) {
ps.setObject(i+1, objects[i]);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//进行Connection 关闭
public static void colseConn(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
这里写代码片