dbconnection.java

来自「基于mvc的java进销存系统」· Java 代码 · 共 49 行

/*
 * DBConnection.java
 *
 * Created on 2007年4月22日, 下午8:03
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 *
 * @author s
 */
public class DBConnection {
    
    /** Creates a new instance of DBConnection */
    public DBConnection() {
    }
    public static Connection getConn(){
        Connection conn=null;
        try{
            String driver = PropertiesUtil.getDb_resource().getString("driver_class").trim();
            Class.forName(driver);
            String url = PropertiesUtil.getDb_resource().getString("url").trim();
            String username = PropertiesUtil.getDb_resource().getString("username").trim();
            String passwd = PropertiesUtil.getDb_resource().getString("passwd").trim();
            conn = DriverManager.getConnection(url,username,passwd);
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }catch(SQLException se){
            se.printStackTrace();
        }
        return conn;
    } 
    public void releaseConn(Connection con){
        try {
            con.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    } 
}