JDBC API的ResultSet实例

今天我在学习JDBC中的API---ResultSet时看到了一个练习，通过集合将数据库里面的数据存下，并进行输出

package com.itheima.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.ArrayList;
import com.ljc.account;
public class JDBCDemo {
    public static void main(String[] args) throws Exception
    {
        //Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://127.0.0.1:3306/sys?useUnicode=true&characterEncoding=utf-8&useSSL=false";

        String username="root";
        String password ="123456";
        Connection conn=DriverManager.getConnection(url,username,password);
            //定义sql语句
            String sql="select *from practice";
         Statement stmt=conn.createStatement();
        ResultSet rs =stmt.executeQuery(sql);
    ArrayList<account> list=new ArrayList< account>();
         while(rs.next())
         {
             account acc=new account();
             int id=rs.getInt(1);
             String name=rs.getString(2);
             double score=rs.getDouble(3);
             acc.setId(id);
             acc.setName(name);
             acc.setScore(score);
             list.add(acc);

         }
         System.out.println(list);


        stmt.close();
        conn.close();
    }

}

package com.ljc;

public class account {
    int id;
    String name;
    double score;

    public account() {
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public double getScore() {
        return score;
    }

    public void setScore(double score) {
        this.score = score;
    }

    @Override
    public String toString() {
        return "account{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", score=" + score +
                '}';
    }
}

执行结果如下：

通过这个API可以进行数据库的相关操作