Emp.zip_EMP_bornjwe_eclipse+emp_empinf_forthnod

package com.yulin.dao.impl; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Types; import java.util.List; import com.yulin.dao.EmpDAO; import com.yulin.entity.Emp; import com.yulin.util.JDBCUtil; public class EmpDAOImpl implements EmpDAO { public boolean add(Emp emp) { boolean flag=false; Connection conn = JDBCUtil.getConnection(); String sql="insert into emp values(emp_seq.nextval,?,?,?,?,?,?,?)"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, emp.getEname()); ps.setString(2, emp.getJob()); if (emp.getMgr()==null) { ps.setNull(3, Types.NUMERIC); }else{ ps.setInt(3, emp.getMgr()); } ps.setDate(4,new Date(emp.getHiredate().getTime())); ps.setBigDecimal(5, emp.getSal()); ps.setBigDecimal(6, emp.getComm()); ps.setInt(7, emp.getDeptno()); boolean b = ps.execute(); if (b) { flag=false; return flag; }else{ flag=true; return flag; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { JDBCUtil.close(conn); } return false; } public boolean delete(int id) { boolean flag=false; Connection conn = JDBCUtil.getConnection(); String sql="delete from emp where empno=?"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); boolean b = ps.execute(); if (b) { flag=false; }else{ flag=true; } return flag; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { JDBCUtil.close(conn); } return false; } public boolean update(Emp emp) { Connection conn = JDBCUtil.getConnection(); String sql="update emp set ename=?," + "job=?," + "mgr=?," + "hiredate=?," + "sal=?," + "comm=?," + "deptno=? " + "where empno=?"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, emp.getEname()); ps.setString(2, emp.getJob()); ps.setInt(3, emp.getMgr()); ps.setDate(4, new Date(emp.getHiredate().getTime())); ps.setBigDecimal(5, emp.getSal()); ps.setBigDecimal(6, emp.getComm()); ps.setInt(7, emp.getDeptno()); ps.setInt(8, emp.getEmpno()); int i = ps.executeUpdate(); if (i==1) { return true; }else{ return false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { JDBCUtil.close(conn); } return false; } public List<Emp> findAll() { // TODO Auto-generated method stub return null; } public Emp findById(int id) { return null; } }