dbconnection.java

jdbc 学习质料

package src.common;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DbConnection {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		DbConnection db=new DbConnection();
        if(getConnection()!=null){
        	System.out.print("afjsajfsj");
        }
	}
	public static Connection getConnection(){
		Connection con=null;
		try{
			Properties pro=getProperties();
			String driver=pro.getProperty("driver");
			String url=pro.getProperty("url");
			String user=pro.getProperty("user");
			String pwd=pro.getProperty("pwd");
			Class.forName(driver);
			con=DriverManager.getConnection(url,user,pwd);
		}catch(SQLException e){
			System.out.print(e.getMessage());
			}
		catch(ClassNotFoundException ex){
			System.out.print(ex.getMessage());
		}
		return con;
		
	}
	public static Properties getProperties(){
		Properties pro=new Properties();
		try{
			pro.load(new FileInputStream(new File("db.Properties")));
		}catch(Exception e){
			System.out.print(e.getMessage());
		}
		return pro;
	}

}