代码:
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); } } }