本文共 2881 字,大约阅读时间需要 9 分钟。
1.要获取student表中的数据,先建一个Student类
//封装Student表数据的JavaBeanpublic class Student { private int id; private String name; private int fenshu; 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 int getFenshu() { return fenshu; } public void setFenshu(int fenshu) { this.fenshu = fenshu; } @Override public String toString() { return "Student [id=" + id + ", name=" + name + ", fenshu=" + fenshu + "]"; } }
2.实现
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;public class JdbcDemo05 { public static void main(String[] args) { Listlist=new JdbcDemo05().findAll(); System.out.println(list); System.out.println(list.size()); } public List findAll(){ Connection conn = null; Statement stmt = null; ResultSet rs = null; List list=null; try { //1.注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //2.获取数据库的连接对象 try { conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/ceshi?serverTimezone=GMT%2B8", "root","123456"); //3.定义sql String sql= "select * from student"; //4.获取执行sql的对象 stmt = conn.createStatement(); //5.执行sql rs=stmt.executeQuery(sql); //6.遍历结果集,封装对象,装载集合 Student student=null; list=new ArrayList (); while(rs.next()) { //获取数据 int id=rs.getInt("id"); String name=rs.getString("name"); int fenshu=rs.getInt("fenshu"); //创建student对象,并赋值 student =new Student(); student.setId(id); student.setName(name); student.setFenshu(fenshu); //装载集合 list.add(student); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { if(rs != null){ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if(stmt != null){ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if(conn != null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } return list; }}
3.结果
[Student [id=1, name=张三, fenshu=99], Student [id=2, name=李四, fenshu=99], Student [id=3, name=wangwu, fenshu=2000]]3
转载地址:http://idezi.baihongyu.com/