import java.sql.*;public class DbControl {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:xxx";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public DbControl() {
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
}
catch(Exception e) {
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sConnstr) {
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sDBdriver,String sConnstr) {
try
{
Class.forName(sDBdriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:xxx";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public DbControl() {
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
}
catch(Exception e) {
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sConnstr) {
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sDBdriver,String sConnstr) {
try
{
Class.forName(sDBdriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
解决方案 »
- 同上贴。着急中……请高手帮帮忙(JTabbedPane操作)
- 用java写一个求字符串中某个子字符串的个数的程序
- FileChannel的read()问题
- JAVA 网络编程
- 刚开始学java今天上课讲了个问题不太懂!!请教高手讲解!
- 唉,如果有人能把这个问题帮我搞定就好了,先谢谢大家了
- “不再沉默中 爆发, 就在 沉默中 灭亡!”我的编程成长经历!!!!
- 这个属于刷新问题么?大家帮忙看看
- Servlet与Applet之间传递 ArrayList[自定义结构] 对象时发生的问题。
- 紧急求救:WebSphere连接池的问题
- 请大家介绍几本经典好书
- 小弟正学JAVA,请问我需要了解多少关于数据库的知识啊
我一定给分
java对数据库的操作已经简化了很多的了,
如果你的基本功够扎实的话,很容易就上手
的,但是如果你忽略了基本的东西的话,就会
陷入一些例如环境设置等的烦恼,
本立道生,只要你的根基打好了,无论要想哪个方向
发展,都会事半功倍