dbco.java~5~

在2005年我使用java开发的一套BS系统。对初学者很有帮助。

package com.forcg;
import java.sql.*;

public class  Dbco{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:mytable";
Connection conn = null;
ResultSet rs = null;

public Dbco() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("Dbco(): " + e.getMessage());
}
}

public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + sql);
}
return rs;
}


public void executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}

}





























public class Dbco {
String sDBDriver = "org.gjt.mm.mysql.Driver";
//请修改下面参数--数据地址：localhost 数据库名：myacc 用户名:root 密码：71143794
String sConnStr = "jdbc:mysql://localhost:3306/myacc?user=root&password=71143794&useUnicode=true&characterEncoding=GB2312";
Connection conn = null;
ResultSet rs = null;
public Dbco() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("conn(): " + e.getMessage());
}
}
public void executeInsert(String sql)
        {
        try
                {
                conn=DriverManager.getConnection(sConnStr);
                Statement stmt=conn.createStatement();

                int n=stmt.executeUpdate(sql);
                }
                catch(SQLException ex)
                {
                        System.err.println("conn.executeUpdate:"+ ex.getMessage());
                }
        }
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("conn.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
        {
        try
                {
                conn=DriverManager.getConnection(sConnStr);
                Statement stmt=conn.createStatement();
                stmt.executeUpdate(sql);
                }
                catch(SQLException ex)
                {
                        System.err.println("conn.executeDelete: "+ ex.getMessage());
                }
        }
public int executeUpdate(String sql)
        {
            int n=0;
        try
                {
                conn=DriverManager.getConnection(sConnStr);
                Statement stmt=conn.createStatement();

                n=stmt.executeUpdate(sql);
                }
                catch(SQLException ex)
                {
                        System.err.println("conn.executeDelete: "+ ex.getMessage());
                }
                return n;
        }
public void Close()
   {
    try{
       if(rs!=null)
       {
          rs.close();
       }
       if(conn!=null)
       {
          conn.close();
        }
       }
       catch(SQLException ex)
                {
                        System.err.println("conn.executeDelete: "+ ex.getMessage());
                }

   }
}