jdbc连接mysql数据库并查询

代码：

public class MysqlDemo {
	public static void main(String[] args) throws Exception {
		Class.forName("com.mysql.cj.jdbc.Driver");
		// 2. 获得连接
		String url = "jdbc:mysql://47.104.176.200:3306/test";
		Connection conn = DriverManager.getConnection(url, "root", "1234");
		System.out.println(conn);
		
		queryDemo(conn);
		
		conn.close();
	}
	public static void queryDemo(Connection conn) throws SQLException{
		Statement stat = conn.createStatement();
		ResultSet resultSet = stat.executeQuery("select * from t_mobile");
		while (resultSet.next()) {
			int id = resultSet.getInt("id");// 相当于rs.getInt(1);这个方法有弊端
			String mobile = resultSet.getString("mobile");
			
			System.out.println(id+":"+mobile);
		}
	}
}