使用实体类保存结果集
public class Demo_JDBC {
public static void main(String[] args) throws Exception {
// 1. 注册驱动
Class.forName("com.mysql.jdbc.Driver");
// 2. 获取链接Connection
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yiyousu", "root", "mysqlmysql");
// 3. 得到执行SQL语句的对象Satatement
Statement stmt = (Statement) conn.createStatement();
// 4. 执行SQL语句,并返回结果
ResultSet rs = stmt.executeQuery("select * from `test`");
List<Test> list = new ArrayList<>();
// 5. 处理结果
while (rs.next()) {
Test t = new Test();
t.setId(rs.getInt("id"));
t.setName(rs.getString("name"));
t.setAge(rs.getInt("age"));
list.add(t);
}
// 6. 关闭资源
rs.close();
stmt.close();// 关闭读取器
conn.close();// 关闭数据库链接
for (Test test : list) {
System.out.println(test);
}
}
}
/**
* Test模型实体
*
* @author JerichoPH
*/
class Test {
private int id;
private String name;
private int age;
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 getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + age;
result = prime * result + id;
result = prime * result + ((name == null) ? 0 : name.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
Test other = (Test) obj;
if (age != other.age)
return false;
if (id != other.id)
return false;
if (name == null) {
if (other.name != null)
return false;
} else if (!name.equals(other.name))
return false;
return true;
}
@Override
public String toString() {
return "Test [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
网友评论