sqlconnect.java

用java来实现jdbc-odbc数据库的一个简单连接程序

package dml;

import java.sql.*;
import java.util.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SqlConnect {

    //private String strDriver;
    private Connection conn;
    private Statement stmt;
    //  private ResultSet rs;
    String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
    //sun.jdbc.odbc.JdbcOdbcDriver
    String connRUL = "jdbc:odbc:ehome";

    public SqlConnect() {
        this("","","");
    } //end of struct MySql();


    public SqlConnect(String strURL) {
        this(strURL, "", "");
    } //end of MySql(String )

    public SqlConnect(String strURL, String name, String password) {
        if (!checkStr(strURL)) {
            strURL = this.connRUL;
        }
        connect(strURL, name, password);

    } //end of struct MySql(String,String,String)

    public void connect(String strURL, String name, String password) {

        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            this.conn = DriverManager.getConnection(strURL, name, password);
            this.stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                             ResultSet.CONCUR_UPDATABLE);
        } catch (Exception e) {
            e.printStackTrace();
        }
    } //end of connect(String ,String,String)


    public ResultSet executeQuery(String str) {
        if(!checkStr(str)){
            return null;
        }
        try {
            return stmt.executeQuery(str);
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    } //end of getResultset();

    public boolean executeUpdate(String sql) {
        if (!checkStr(sql)) {
            return false;
        }
        try {
            if (stmt.executeUpdate(sql) != 0) {
                return true;
            } else {
                return false;
            }
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        } finally {
            closeAll(null, stmt, conn);
        }

    } //end of deleteRecord(String)

    public ArrayList getExecuteQuery(String sql) {
        if (!checkStr(sql)) {
            return null;
        }
        ArrayList<ArrayList> rsList;
        ResultSet rs = null;
        try {
            rs = stmt.executeQuery(sql);
            if (rs == null || !rs.next()) {
                return null;
            }
            ResultSetMetaData rsmt = rs.getMetaData();
            rsList = new ArrayList();
            do {
                ArrayList currentList = new ArrayList();
                for (int i = 1; i <= rsmt.getColumnCount(); i++) {
                    currentList.add(rs.getObject(i));
                }
                rsList.add(currentList);
            } while (rs.next());
            return rsList;
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        } finally {
            closeAll(rs, stmt, conn);
        }
    } //end of getExecuteQuery(String)


    public boolean checkStr(String str) {
        if (str == null || str.length() < 1) {
            return false;
        } else {
            return true;
        }
    }


    public void closeAll(ResultSet rs, Statement stmt, Connection conn) {
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (stmt != null) {
                stmt.close();
                stmt = null;
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }
        } catch (SQLException e) { //end of try
            e.printStackTrace();
        } //end of catch

    } //end of close All(ResultSet,Statement,Connection0
    
   public  static void main(String []args){
   		SqlConnect conn=new SqlConnect("","ray","ray");    		
   }
}