发个jdbc工具类

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JdbcUtil 
{
	private static String db_driver;
	private static String db_url;
	private static String db_userName;
	private static String db_passWord;
	
	static
	{
		Properties pro=new Properties();
		try {
		     pro.load(new FileInputStream((JdbcUtil.class.getResource("/").getPath()+"/jdbc.properties"))); 
			db_driver=pro.getProperty("db_driver");
			db_url=pro.getProperty("db_url");
			db_userName=pro.getProperty("db_userName");
			db_passWord=pro.getProperty("db_passWord");
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection()
	{
		Connection conn=null;
		
		try {
			Class.forName(db_driver);
			
			conn=DriverManager.getConnection(db_url, db_userName, db_passWord);
			
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return conn;
	}
	
	public static void close(Connection conn,PreparedStatement ps,ResultSet rs)
	{
		if(rs!=null)
		{
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(ps!=null)
		{
			try {
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(Connection conn)
	{
		if(conn!=null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	

}

db_driver=oracle.jdbc.driver.OracleDriver
db_url=jdbc:oracle:thin:@10.66.6.10:1521:dot
db_userName=fms2
db_passWord=1qaz2wsx

评论

2 楼 zcb11051 2010-12-27  

不好意思，改回来了

1 楼 pouyang 2010-09-07  

靠，用个java代码规范工具都用错了。