JDBC之简单查询

JDBC之简单查询

try{
    //定义url、name、password用于数据库连接
     String url = "jdbc:mysql://localhost:3306/servlet";
     String name = "root";
     String password = "root";
     //定义sql,用于查询
     String sql = "select id,firstname,lastname from user1";
     //实例化以Driver对象
     Driver d = new Driver();
     //注册一个Driver
     DriverManger.registerDriver(d)
     //建立数据库连接
     Connection conn = DriverManger.getConnection(url,name,password);
     //获取需要执行的sql语句
     Statement st= conn.createStatement();
     //执行sql,并把返回的结果存入结果集
     ResultSet rs =  st.executeQuery(sql);
     //实例化一个List集合
     List<User1> list = new ArrayList<>();
     
     User1 us;
     
     while(rs.nect()){
      //实例化一个User1对象
     us = new User1();
     int id = rs.getInt("id");
     String firstname= rs.getString("firstname");
     String lastname= rs.getString("lastname");
     us.setId(id);
     us.setFirstname(firstname);
     us.setLastname(lastname);
     liat.add(us);
     }
     System.out.println(list+"\t");
     rs.close();
     st.colse();
     conn.close();
     
}catch(Exception e){
     e.printStackTrace();
}

运行结果：

数据库数据表