package base.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBOperation {
protected Connection conn;
protected ResultSet rs;
protected PreparedStatement ps;
private final String url = "jdbc:mysql://localhost:3306/vote";
private final String name = "root";
private final String pass = "root";
// 获取数据库连接
public void getConn() {
try {
Class.forName("com.mysql.jdbc.Driver");// 加载mysql驱动程序
System.out.println("开始尝试连接数据库!");
conn = DriverManager.getConnection(url, name, pass);// 获取连接
System.out.println("连接成功!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// 查询
public void extQuery(String sql,Object...obj) {
try {
ps = conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++){
ps.setObject(i+1, obj[i]);
}
rs = ps.executeQuery();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//更新
public void extUpdate(String sql,Object... obj){
try {
ps=conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++){
ps.setObject(i+1, obj[i]);
}
ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeAllConn() {
try {
if (conn != null) {
conn.close();
}
if (ps != null) {
ps.close();
}
if (rs != null) {
rs.close();
}
System.out.println("数据库已关闭连接!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBOperation {
protected Connection conn;
protected ResultSet rs;
protected PreparedStatement ps;
private final String url = "jdbc:mysql://localhost:3306/vote";
private final String name = "root";
private final String pass = "root";
// 获取数据库连接
public void getConn() {
try {
Class.forName("com.mysql.jdbc.Driver");// 加载mysql驱动程序
System.out.println("开始尝试连接数据库!");
conn = DriverManager.getConnection(url, name, pass);// 获取连接
System.out.println("连接成功!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// 查询
public void extQuery(String sql,Object...obj) {
try {
ps = conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++){
ps.setObject(i+1, obj[i]);
}
rs = ps.executeQuery();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//更新
public void extUpdate(String sql,Object... obj){
try {
ps=conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++){
ps.setObject(i+1, obj[i]);
}
ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeAllConn() {
try {
if (conn != null) {
conn.close();
}
if (ps != null) {
ps.close();
}
if (rs != null) {
rs.close();
}
System.out.println("数据库已关闭连接!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}