access.java

java开发的办公系统 1.系统管理 (地区管理,部门管理,菜单管理,用户管理,角色管理,权限) 2.工作流管理 (流程类别,流程) 3.字典管理 (国家,省份,城市,公共数据字典) 4.项目

package com.vere.db;
/**
 * <p>Title: 办公自动化系统</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: verecom</p>
 * @author 胡杨
 * @version 1.0
 */
import java.sql.*;

import com.vere.util.*;

public class Access {
	private Connection conn = null;
    private Statement stmt=null;
    private ResultSet rs=null;

  public Access()  {
    
  }
  
  public Connection getConnection() {
  	 try {
		if(conn==null){
			try {
				Class.forName(Configuration.getInstance().driver);
				System.out.println("数据库驱动连接成功");
			}
			catch(ClassNotFoundException e) {
				System.out.println("Connect(): " + e.toString());
			}
			conn=DriverManager.getConnection(Configuration.getInstance().url,Configuration.getInstance().user,Configuration.getInstance().psw);
		}
        System.out.println("数据库连接成功");
        return conn;
    }
    catch(SQLException e){
        System.out.println("SQL: " + e.toString());
        return null;
    }
  }
  
  public boolean executeUpdate(String sql){
    try
    {
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        System.out.println(sql);
        int i=stmt.executeUpdate(sql);
        if(i<0)
            return false;
        //CFile.appendFile(cf.log,sql+" "+DateUtils.getDateTime());
        return true;
    }
    catch(Exception e){
    	System.out.println(e.toString());
        return false;
    }
  }
  
  public ResultSet executeQuery(String sql){
  	try
  	{
  	    stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  	    System.out.println(sql);
  	    rs=stmt.executeQuery(sql);
  	    //CFile.appendFile(cf.log,sql+" "+DateUtils.getDateTime());
  	    return rs;
  	}
  	catch(Exception e){
  		System.out.println(e.toString());
  	    return rs;
  	}
  }
  
  public DatabaseMetaData getDataBaseMetaData(){
    try {
        return conn.getMetaData();
      }
      catch(SQLException e){
          System.err.println("SQL: " + e.getMessage());
          return null;
      }
  }
  
  public ResultSetMetaData  getResultSetMetaData(String tableName){
    try {
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
        ResultSet rs = stmt.executeQuery("select top 1 * from "+tableName);
        ResultSetMetaData rd=rs.getMetaData();
        return rd;
      }
      catch(SQLException e){
          System.err.println("SQL: " + e.getMessage());
          return null;
      }
  }
  
  public void DBclose(ResultSet rs){
  	     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) {
  	     	System.out.println(e.toString());
  	     }
  	}
  
  public void DBclose(Connection conn,Statement stmt){
	     try {
	        if(stmt!=null)
	        {
				stmt.close();
				stmt=null;
	        }
	           
	        if(conn!=null)
	        {
				conn.close();
				conn=null;
	        }
	     }
	     catch(SQLException e) {
	     	System.out.println(e.toString());
	     }
	}
}