JDBC基础-将数据库数据遍历到List集合中

这里用到了自己写的JDBC工具类使用了配置文件

配置文件：pro.properties
配置文件必须和你的class文件放在一起才能链接数据库

DriverPath=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydatabase
username=root
password=123

JDBCUtils类：

import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

/**
 * JDBC工具类
 * Created by Aongi on 2017/5/1.
 * Version 1.0
 */
public class JDBCUtils {
    public JDBCUtils(){}
    private static Connection CON;
    static{
        FileReader reader;
        try {
            String a=JDBCUtils.class.getResource("pro.properties").toString().substring(6);
            reader = new FileReader(a);
            //下面也是一种拿到文件路径的方式
            //InputStream reader=JDBCUtils.class.getClassLoader().getResourceAsStream("pro.properties");
            Properties pro = new Properties();
            pro.load(reader);
            reader.close();
            Class.forName(pro.getProperty("DriverPath"));
            CON= DriverManager.getConnection(pro.getProperty("url"),pro.getProperty("username"),pro.getProperty("password"));
        } catch (Exception e) {
            throw new RuntimeException("连接数据库失败！");
        }
    }
    /*
     *链接数据库操作，返回Connection对象
     */
    public static Connection getConnection(){
        return CON;
    }
}

Students 类

/**
 * Created by Aongi on 2017/5/2.
 * Version 1.0
 */
public class Students {
    private Integer uid;
    private String uname;
    private String uaddress;
    private Integer age;

    public Students(Integer uid, String uname, String uaddress, Integer age) {
        this.uid = uid;
        this.uname = uname;
        this.uaddress = uaddress;
        this.age = age;
    }
    public Students(){}

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getUaddress() {
        return uaddress;
    }

    public void setUaddress(String uaddress) {
        this.uaddress = uaddress;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Students{" +
                "uid=" + uid +
                ", uname='" + uname + '\'' +
                ", uaddress='" + uaddress + '\'' +
                ", age=" + age +
                '}';
    }
}

JDBCdemo 类

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by Aongi on 2017/5/1.
 * Version 1.0
 */
public class JDBCdemo {
    //main方法
    public static void main(String[] args)throws Exception{
        Connection con = JDBCUtils.getConnection();
        String sql="SELECT * FROM users;";
        PreparedStatement pst=con.prepareStatement(sql);
        ResultSet rs= pst.executeQuery();
        List<Students> list = new ArrayList<Students>();
        while (rs.next()){
            list.add(new Students(rs.getInt("uid"),rs.getString("uname"),rs.getString("uaddress"),rs.getInt("age")));
        }
        rs.close();
        pst.close();
        con.close();
        for (Students s : list){
            System.out.println(s);
        }
    }

}