JDBC连接

public class DButils {
private static String driver;
private static String url;
private static String username;
private static String password;

static {
	//静态代码块
	Properties p = new Properties();
	InputStream in = null;
	
	try {
		in= DButils.class.getClassLoader().getResourceAsStream("jdbc.properties");
		p.load(in);
		driver=p.getProperty("driver");
		password=p.getProperty("password");
		url=p.getProperty("url");
		username=p.getProperty("username");
		
		//注册驱动
		Class.forName(driver);
	} catch (IOException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally {
		if(in!=null) {
			try {
				in.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

//得到连接
public static Connection getConnection() throws SQLException {
	return DriverManager.getConnection(url, username, password);
}
//增删改  关闭资源  
public static void close(Connection conn,PreparedStatement ps) {
	//按连接顺序从后往前关
	if(ps!=null) {
		try {
			ps.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if(conn!=null) {
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}
//查询  关闭资源
public static void close(Connection conn,PreparedStatement ps,ResultSet rs) {
	if(ps!=null) {
		try {
			ps.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if(conn!=null) {
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	if(rs!=null) {
		try {
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

}