数据库表
create table users(
id int primary key auto_increment,
username varchar(50),
password varchar(50)
);
javabean封装实体类
package com.m.domain;
public class Users {
private Integer id;
private String username;
private String password;
public Users(){
}
public Users(Integer id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "Users [id=" + id + ", username=" + username + ", password=" + password + "]";
}
}
测试类
package com.m.demo2;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.m.JDBCUtils.JDBCUtils;
import com.m.domain.Users;
public class Select {
public static void selectSave() throws IOException, Exception {
Connection conn = JDBCUtils.getConnection();
String sql="select * from users";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
List<Users> list=new ArrayList<>();
while(rs.next()) {
list.add(new Users(rs.getInt("id"),rs.getString("username"),rs.getString("password")));
}
//遍历
list.stream().forEach(a->System.out.println(a));
JDBCUtils.closeAll(rs, ps, conn);
}
public static void main(String[] args) throws IOException, Exception {
selectSave();
}
}