Java连接mysql原始方法

        
	private static String mysqlUrl = "jdbc:mysql://192.168.1.1:3306/test?useUnicode=true&characterEncoding=utf-8";
	
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement preStatement = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("成功加载MySql驱动！");
			
			conn = DriverManager.getConnection(mysqlUrl, "user", "password");
			String sql = "";
			preStatement = conn.prepareStatement(sql);
			
			rs = preStatement.executeQuery();
			while (rs.next()) {
				//TODO
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)rs.close();
				if(preStatement!=null)preStatement.close();
				if(conn!=null)conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
	}