JDBC实现链接 MySQL数据库

public class DBjdbc {
	private static String Driver = "com.mysql.jdbc.Driver";
	private static String ulr = "jdbc:mysql://localhost:3306/数据库名字";
	private static String username = "数据库用户名";
	private static String password = "用户密码";

//	创建链接
	static {
		try {
			Class.forName(Driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(ulr, username, password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
//关闭链接，释放资源
	public static void close(Connection conn, PreparedStatement pata, ResultSet rs) {
		try {
			if (conn != null) {
				conn.close();
			}
			if (pata != null) {
				pata.close();
			}
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static void close(Connection conn, PreparedStatement pata) {
		close(conn,pata,null);
	}
	public static void close(Connection conn) {
		close(conn,null,null);
	}
}