package co.zhiyou100.dao.impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.security.auth.message.callback.PrivateKeyCallback.Request;
import com.zhiyou100.dao.DeptDao;
import com.zhiyou100.pojo.Dept;
import com.zhiyou100.util.DBUtil;
//承接deptdao的子类
public class DeptDaoIpml implements DeptDao{
@Override
public List<Dept> find() {
/**
* 查询数据库
*/
String sql="select * from emp";
Object[]obj={};
//调用数据库的方法
ResultSet rs=DBUtil.select(sql, obj);
//创建新的数组列表
List<Dept>list=new ArrayList<>();
//.....这儿
try {
while(rs.next()){
int d_id=rs.getInt(1);
String d_name=rs.getString(2);
String d_duty=rs.getString(3);
//...这儿
Dept dept=new Dept(d_id, d_name, d_duty);
//...这儿
list.add(dept);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
return list;
}
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.security.auth.message.callback.PrivateKeyCallback.Request;
import com.zhiyou100.dao.DeptDao;
import com.zhiyou100.pojo.Dept;
import com.zhiyou100.util.DBUtil;
//承接deptdao的子类
public class DeptDaoIpml implements DeptDao{
@Override
public List<Dept> find() {
/**
* 查询数据库
*/
String sql="select * from emp";
Object[]obj={};
//调用数据库的方法
ResultSet rs=DBUtil.select(sql, obj);
//创建新的数组列表
List<Dept>list=new ArrayList<>();
//.....这儿
try {
while(rs.next()){
int d_id=rs.getInt(1);
String d_name=rs.getString(2);
String d_duty=rs.getString(3);
//...这儿
Dept dept=new Dept(d_id, d_name, d_duty);
//...这儿
list.add(dept);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
return list;
}