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