package DAY02;
/**
* 若一个类的每一个实例专门用来存储一系列数据
* 而没有任何业务罗技方法,
* 那么该类的每一个实例都是值对象:VO ValueObject
* 若当前类的每一个实例表示的是是数据库中某张表的一条记录时,那么该类
* 也称为:实体类
* @author Ward
*
*/
public class UserInfo {
private int id;
private String username;
private String password;
private int account;
private String email;
public UserInfo(){
}
public UserInfo(int id, String username, String password, int account, String email) {
super();
this.id = id;
this.username = username;
this.password = password;
this.account = account;
this.email = email;
}
public int getId() {
return id;
}
public void setId(int 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;
}
public int getAccount() {
return account;
}
public void setAccount(int account) {
this.account = account;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String toString() {
return id+","+username+","+password+","+account+","+email;
}
}
---------------------------------------------------------------------------------------
package DAY02;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import day01.DBUtil;
/**
* 遍历查询结果集 ResultSet
*
* 通常对结果集的遍历是一次性的,若希望重复使用结果集中的数据,都是先 将遍历结果集得到的结果以java对象的形式全部保存起来, 然后重复使用。
* JDBC提供了一种叫做可滚动结果集,意思是该结果集可以来回查看每一条记录 但是基本不用。
*
* @author Ward
*
*/
public class demo7UserInfo {
public static void main(String[] args) {
Connection conn = null;
try {
conn = DBUtil.getConnection();
Statement state = conn.createStatement();
String sql = "SELECT id,username,password,account,email " + " FROM userinfo ";
ResultSet rs = state.executeQuery(sql);
List<UserInfo> list = new ArrayList<UserInfo>();
while (rs.next()) {
int id = rs.getInt("id");
String username = rs.getString("username");
String password = rs.getString("password");
int account = rs.getInt("account");
String email = rs.getString("email");
UserInfo userinfo = new UserInfo(id, username, password, account, email);
list.add(userinfo);
}
for(UserInfo u:list) {
System.out.println(u);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.closeConnection();
}
}
}