第四步:封装从数据库取出数据的方法(area表)
package com.sc.dao;
import java.sql.*;
import java.util.*;
import com.sc.bean.area;
import com.sc.tool.BaseDao;
/**
* AreaDao
* @author ZhangShaoWen
*
*/
public class AreaDao {
Connection conn = null;//定义数据库对象
PreparedStatement ps = null;//准备执行对象
ResultSet rs = null;//结果集对象
//把area表中的数据存放到list集合中并返回
public List getArea(){
List list = new ArrayList();
try {
conn = BaseDao.getConnection();
//查询数据库sql语句
String sql = "select * from area";
//查询前的准备
ps = conn.prepareStatement(sql);
//执行查询 获得结果集
rs = ps.executeQuery();
while(rs.next()){
area a = new area();
a.setId(rs.getInt("id"));
a.setaCap(rs.getInt("aCap"));
a.setaNumber(rs.getInt("aNumber"));
a.setaPeople(rs.getInt("aPeople"));
a.setaPhone(rs.getString("aPhone"));
a.setManager(rs.getString("aManagerName"));
//把area中的每一行的数据到存放到list集合中
list.add(a);
}
//关闭数据库资源
BaseDao.closeAll(conn, ps, rs);
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
//
public static void main(String[] args) {
List list = new AreaDao().getArea();
//输出结果
for(Object ob:list){
area ar = (area)ob;
System.out.println(ar.getaPhone());
}
}
}