package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import classes.Emp;
public class EmpDao {
private static final String sql="select * from emp limit ?,?";
private static final String sql2="select count(*) from emp";
private static final String sql3="insert into emp values(?,?,?)";
private static final String sql4="delete from emp where id=?";
private static final String sql5="update emp set name=?,salary=? where id=?";
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
public List<Emp> getEmpList(int page,int rowsPerPage){
List<Emp> list=null;
try {
con=ConnectionUtil.getConnection();
ps=con.prepareStatement(sql);
ps.setInt(1,rowsPerPage*(page-1));
ps.setInt(2,rowsPerPage);
rs=ps.executeQuery();
list = new ArrayList();
while(rs.next()){
Emp emp=new Emp(rs.getInt(1),rs.getString(2),rs.getDouble(3));
list.add(emp);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtil.release(con, ps, rs);
}
return list;
}
public int getTotalPage(int rowsPerPage) {
int totalPage=0;
try {
con=ConnectionUtil.getConnection();
ps=con.prepareStatement(sql2);
rs=ps.executeQuery();
if(rs.next()){
totalPage=rs.getInt(1);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtil.release(con, ps, rs);
}
if(totalPage%rowsPerPage!=0){
return totalPage/rowsPerPage+1;
}
return totalPage/rowsPerPage;
}
public void addEmp(int id,String name,double salary){
try {
con=ConnectionUtil.getConnection();
ps=con.prepareStatement(sql3);
ps.setInt(1,id);
ps.setString(2,name);
ps.setDouble(3,salary);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtil.release(con, ps, rs);
}
}
public void delEmp(int id){
try {
con=ConnectionUtil.getConnection();
ps=con.prepareStatement(sql4);
ps.setInt(1,id);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtil.release(con, ps, rs);
}
}
public void updateEmp(int id,String name,double salary){
try {
con=ConnectionUtil.getConnection();
ps=con.prepareStatement(sql5);
ps.setString(1,name);
ps.setDouble(2,salary);
ps.setInt(3,id);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnectionUtil.release(con, ps, rs);
}
}
}
empinfo.rar （41个子文件） 
empinfo 
.project 1KB .mymetadata 294B WebRoot css style.css 9KB WEB-INF web.xml 375B lib classes dao ConnectionUtil.class 2KB db.properties 97B UserDao.class 2KB EmpDao.class 4KB classes User.class 985B Emp.class 985B META-INF MANIFEST.MF 39B img 
bg.gif 446B tableheader-bg.gif 3KB nane.gif 12KB content_bg.gif 143B button.gif 104B top_left.gif 258B footer_bg.gif 439B bullet_grey.gif 128B footer.gif 2KB tableheader-bg-grey.gif 1KB bullet_green.gif 182B jsp login.jsp 411B update_form.jsp 3KB add_form.jsp 3KB validate.jsp 153B add.jsp 382B login_form.jsp 2KB emp_user_list.jsp 2KB update.jsp 390B foot.jsp 79B header.jsp 222B emp_admin_list.jsp 3KB delete.jsp 270B .myeclipse src dao EmpDao.java 3KB UserDao.java 858B db.properties 97B ConnectionUtil.java 2KB classes User.java 575B Emp.java 571B .classpath 423B
评论4
最新资源