Jdbc查询表中信息,使用集合查询
package jdbc;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class StudentQuery {
public static void main(String[] args) {
List<Student> list = new StudentQuery().findAll();
System.out.println(list);
}
public List<Student> findAll(){
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
ArrayList<Student> list=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection
("jdbc:mysql:///test?serverTimezone=GMT%2B8", "root", "123456");
String sql = "select * from users.student";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
list = new ArrayList<>();
Student s=null;
while (rs.next()){
int sid = rs.getInt("sid");
String sname = rs.getString("sname");
int sage = rs.getInt("sage");
String ssex = rs.getString("ssex");
String smajor = rs.getString("smajor");
String sclass = rs.getString("sclass");
s=new Student();
s.setSid(sid);
s.setSname(sname);
s.setSage(sage);
s.setSsex(ssex);
s.setSmajor(smajor);
s.setSclass(sclass);
list.add(s);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
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;
}
}