67,513
社区成员
发帖
与我相关
我的任务
分享
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mydb {
Connection con = null;
Statement stat = null;
ResultSet rs = null;
public CallableStatement callable = null;
static {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException e1) {
e1.printStackTrace();
} catch (IllegalAccessException e1) {
e1.printStackTrace();
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
}
}
// 取得数据库连接
public Connection GetCon() {
this.Close();// 释放所有
String url = "jdbc:mysql://"; // 连接字符串
try {
con = DriverManager.getConnection(url);
return con;
} catch (SQLException e) {
// e.printStackTrace();
this.Close();
return null;
}
}
// 执行数据库查询并返回查询结果
public ResultSet Query(String sql) {
try {
con = GetCon();
stat = con.createStatement();
rs = stat.executeQuery(sql);
return rs;
} catch (SQLException e) {
// e.printStackTrace();
this.Close();
return null;
}
}
// 执行存储过程并返回参数
public CallableStatement CallProcess(String strProc) {
try {
con = GetCon();
callable = con.prepareCall("{ call " + strProc + "}");
return callable;
} catch (Exception ex) {
// ex.printStackTrace();
this.Close();
return null;
}
}
// 执行数据库更新
public void Update(String sql) {
try {
con = GetCon();
stat = con.createStatement();
stat.executeUpdate(sql);
} catch (Exception ex) {
// ex.printStackTrace();
this.Close();
}
return;
}
// 关闭数据库连接
public void Close() {
try {
if (rs != null)
rs.close();
} catch (Exception ex) {
// ex.printStackTrace();
}
try {
if (stat != null)
stat.close();
} catch (Exception ex) {
// ex.printStackTrace();
}
try {
if (callable != null)
callable.close();
} catch (Exception ex) {
// ex.printStackTrace();
}
try {
if (con != null)
con.close();
} catch (Exception ex) {
// ex.printStackTrace();
}
return;
}
}
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mydb {
Connection con = null;
Statement stat = null;
//PreparedStatement pstat = null;
ResultSet rs = null;
public CallableStatement callable = null;
// 取得数据库连接
public Connection GetCon() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException e1) {
e1.printStackTrace();
} catch (IllegalAccessException e1) {
e1.printStackTrace();
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
}
String url = "jdbc:mysql://"; //连接字符串
try {
con = DriverManager.getConnection(url);
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
// 执行数据库查询并返回查询结果
public ResultSet Query(String sql) {
try {
con = GetCon();
stat = con.createStatement();
rs = stat.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
// 执行存储过程并返回参数
public CallableStatement CallProcess(String strProc) {
try {
con = GetCon();
callable = con.prepareCall("{ call " + strProc + "}");
} catch (Exception ex) {
ex.printStackTrace();
}
return callable;
}
// 执行数据库更新
public void Update(String sql) {
try {
con = GetCon();
stat = con.createStatement();
stat.executeUpdate(sql);
} catch (Exception ex) {
ex.printStackTrace();
}
}
// 关闭数据库连接
public void Close() {
try {
if (rs != null)
rs.close();
if (stat != null)
stat.close();
//if (pstat != null)
// pstat.close();
if (callable != null)
callable.close();
if (con != null)
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}