dbconnector.java

用java实现的一个bbs的portal

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Jul 18, 2003
 * Time: 3:47:17 PM
 * To change this template use Options | File Templates.
 */
package DBConnection;

import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.Connection;

public class DBConnector {

    private static DBConnector instance = null;
    private Connection conn = null;
    public Statement stmt = null;

    public DBConnector(){
        openConnector();
    }

    public static DBConnector getInstance(){
        if (instance==null)
            instance = new DBConnector();
        return instance;
    }

    public boolean openConnector(){
        if (conn != null)
            return true;
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            String url="jdbc:odbc:bbsportal";
            String user="sa";
            String password="oldie";
            conn= DriverManager.getConnection(url,user,password);
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        }catch(Exception ex){
            ex.printStackTrace();
            return false;
        }
        System.out.println("DataBase Connection Successfully !");
        return true;
    }

    public void closeConnector(){
        try{
            stmt.close();
            conn.close();
            conn = null;
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }

    public boolean delAllInfo(){
        try{
            String sql = "DELETE FROM BBSXINXI";
            stmt.execute(sql);
            sql = "DELETE FROM JIAOYIXINXI";
            stmt.execute(sql);
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return false;
    }

    public Statement getStmt() {
        return stmt;
    }

    public static void main(String args[]){
        if (DBConnector.getInstance().delAllInfo())
            System.out.println("All Info has been deleted !");
        else System.err.println("Info Deleted Error!");
        DBConnector.getInstance().closeConnector();
    }

}