public List<Master> select(){
int row = 0;
String sql = "select *from master";
List<Master> list = new ArrayList<Master>();
try {
conn = getConnection();
stmt = conn.prepareStatement(sql);
rst = stmt.executeQuery();
while(rst.next()) {
int id = rst.getInt("id");
String name = rst.getString("name");
String password = rst.getString("password");
int money = rst.getInt("money");
Master master = new Master();
master.setId(id);
master.setName(name);
master.setPassword(password);
master.setMoney(money);
list.add(master);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
closeAll();
}
return list;
}