使用jsp实现登录页面，增删改查页面，oracle数据库。

package com.user.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.user.dao.BaseDao; import com.user.dao.EmpDao; import com.user.entity.Emp; import com.user.util.Page; public class EmpDaoImpl implements EmpDao { Page page = new Page(); //创建一个操作数据库的对象 BaseDao basedao = new BaseDao(); public List<Emp> getEmpList() { String sql = "select * from emp "; Object [] obj = new Object[]{}; ResultSet rs = basedao.executeQuery(sql, obj); List<Emp> list = new ArrayList<Emp>(); try { while(rs.next()){ String ename = rs.getString("ename"); int empno =rs.getInt("empno"); String job = rs.getString("job"); int mgr = rs.getInt("mgr"); Date hiredate = rs.getDate("hiredate"); double sal = rs.getDouble("sal"); double comm = rs.getDouble("comm"); int deptno = rs.getInt("deptno"); Emp emp = new Emp(empno, ename, job, mgr, hiredate, sal, comm, deptno); list.add(emp); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public Emp getEmpByNo(int empno) { String sql = "select * from emp where empno=?"; Object[]obj = new Object[]{empno}; ResultSet rs = basedao.executeQuery(sql, obj); Emp emp =null; try { while(rs.next()){ String ename = rs.getString("ename"); empno =rs.getInt("empno"); String job = rs.getString("job"); int mgr = rs.getInt("mgr"); Date hiredate = rs.getDate("hiredate"); double sal = rs.getDouble("sal"); double comm = rs.getDouble("comm"); int deptno = rs.getInt("deptno"); emp = new Emp(empno, ename, job, mgr, hiredate, sal, comm, deptno); } return emp; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public List<Emp> getEmpByName(String name) { // TODO Auto-generated method stub return null; } public boolean addEmp(Emp emp) { String sql = "insert into emp(empno,ename,job,mgr,sal,comm,deptno) values(?,?,?,?,?,?,?)"; Object[] obj = new Object[] { emp.getEmpno(), emp.getEname(), emp.getJob(), emp.getMgr(), emp.getSal(), emp.getComm(), emp.getDeptno() }; return basedao.executeUpdate(sql, obj); } public boolean updateEmp(Emp emp) { String sql = "update emp set ename=?,job=?,mgr=?,sal=?,comm=?,deptno=? where empno=?"; Object [] obj = new Object[]{ emp.getEname(), emp.getJob(), emp.getMgr(), emp.getSal(), emp.getComm(), emp.getDeptno(),emp.getEmpno()}; return basedao.executeUpdate(sql, obj); } public boolean delEmpById(int empno) { // TODO Auto-generated method stub String sql ="delete from emp where empno =?"; Object[] obj = new Object[]{empno}; return basedao.executeUpdate(sql, obj); } public List<Emp> getEmpList(int pageIndex, int pageSize) { String sql = "select*from(select e.*,rownum rn from (select * from emp)e)where rn>=? and rn<=?"; int startRow = page.getStartRow(pageIndex, pageSize); int endRow = page.getEndRow(pageIndex, pageSize); Object[]obj= new Object[]{startRow,endRow}; ResultSet rs = basedao.executeQuery(sql, obj); List<Emp>list =new ArrayList<Emp>(); try { while(rs.next()){ String ename = rs.getString("ename"); int empno =rs.getInt("empno"); String job = rs.getString("job"); int mgr = rs.getInt("mgr"); Date hiredate = rs.getDate("hiredate"); double sal = rs.getDouble("sal"); double comm = rs.getDouble("comm"); int deptno = rs.getInt("deptno"); Emp emp = new Emp(empno, ename, job, mgr, hiredate, sal, comm, deptno); list.add(emp); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public int getTotalCount(){ String sql = "select count(*) from emp"; //空的 Object[]obj= new Object[]{}; ResultSet rs = basedao.executeQuery(sql, obj); int count=0; try { while(rs.next()){ count = rs.getInt(1); } return count; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return count; } }