dbconnection.java

报表,关于ireport报表的一些源码(转)

package cn.edu.hlju.oa.kygl.db;

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

import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;

import cn.edu.hlju.oa.kygl.db.entities.Ky_kyxtbmb;

/**
 *
 * @author 畅恒宇
 */
public class DBConnection {
    //是否使用数据源--缺省为不使用
    private static boolean isDS = false;
    //数据库相关信息
    private static String driveName;
    private static String url;
    private static String dbName;
    private static String userName;
    private static String password;

    static{
        System.out.println("DBConnection user.dir="+System.getProperty("user.dir"));
        System.out.println("DNConnection catalina.base="+System.getProperty("catalina.base"));
        String kyglAppPath = System.getProperty("catalina.base")+"/webapps/kygl/Config/";
        Properties prop = new Properties();

        try{
            File configFile = new File(kyglAppPath + "DBInfo.properties");
            System.out.println("DBConnection configFileExisted="+configFile.exists());
            System.out.println("DBConnection fileRealPath="+configFile.getAbsolutePath());
            prop.load(new FileInputStream(configFile));
        }catch(Exception e){
            System.err.println("DBConnection不能正确读取配置信息,写入默认配置....");
            prop.put("driveName","com.mysql.jdbc.Driver");
            prop.put("url","jdbc:mysql://localhost/");
            prop.put("dbName","try");
            prop.put("userName","root");
            prop.put("password","abcedf");
        }
        driveName = prop.getProperty("driveName");
        url = prop.getProperty("url");
        dbName = prop.getProperty("dbName");
        userName = prop.getProperty("userName");
        password = prop.getProperty("password");
    }


    public static Connection getConnection() {
        if (isDS)
            return getDSConnection();
        else
            return getDriverConnection();

    }

    private static Connection getDSConnection() {
        Context ctx;
        DataSource ds=null;
        Connection conn=null;
        try {
            ctx = new InitialContext();
            ds = (DataSource) ctx.lookup("java:comp/env/jdbc/MySQLDB");
            if (ds!=null) {
                conn=ds.getConnection();
            }
        } catch(Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    private static Connection getDriverConnection() {
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://localhost/try?user=root&password=abcdef");
            //Class.forName(driveName).newInstance();
            //conn = DriverManager.getConnection(url+dbName+"?"+"user="+userName+"&password="+password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void releaseConnection(Connection conn) {
        try {
            conn.close();
        } catch (Exception e) {
        	e.printStackTrace();
        }
    }
}