operation-system-of-emp-use-swing.rar_operation_swing oracle

package 登陆界面; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; public class Caozuo { Connection conn = null; Statement st = null; ResultSet rs = null; PreparedStatement pst = null; public Caozuo() { conn = DatabaseTools.getConnection(); } public Vector<Vector<String>> getAllEmps() { Vector<Vector<String>> emps = new Vector<Vector<String>>(); String sql = "select * from emp"; try { st = conn.createStatement(); rs = st.executeQuery(sql); while (rs.next()) { Vector<String> v = new Vector<String>(); v.add(rs.getString("empno")); v.add(rs.getString("ename")); v.add(rs.getString("job")); v.add(rs.getString("hiredate")); v.add(rs.getString("mgr")); v.add(rs.getString("sal")); v.add(rs.getString("comm")); v.add(rs.getString("mgr")); emps.add(v); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(st); // DatabaseTools.closeconn(conn); } return emps; } public Vector<String> getziduan() { Vector<String> a = new Vector<String>(); String sql = "select * from emp"; try { st = conn.createStatement(); rs = st.executeQuery(sql); ResultSetMetaData rsm = rs.getMetaData(); int f = rsm.getColumnCount(); for (int i = 1; i < f + 1; i++) { a.add(rsm.getColumnName(i)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(st); DatabaseTools.closeconn(conn); } /* * a.add("员工编号"); a.add("员工姓名"); a.add("员工职位"); a.add("入职日期"); * a.add("顶头上司"); a.add("员工薪水"); a.add("员工津贴"); a.add("部门编号"); */ return a; } public Vector<Vector<String>> getEmpsByName(String nameLike) { Vector<Vector<String>> emps = new Vector<Vector<String>>(); String sql = "select * from emp where ename like ?"; try { pst = conn.prepareStatement(sql); pst.setString(1, nameLike); rs = pst.executeQuery(); while (rs.next()) { Vector<String> v = new Vector<String>(); v.add(rs.getString("empno")); v.add(rs.getString("ename")); v.add(rs.getString("job")); v.add(rs.getString("hiredate")); v.add(rs.getString("mgr")); v.add(rs.getString("sal")); v.add(rs.getString("comm")); v.add(rs.getString("mgr")); emps.add(v); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(pst); // DatabaseTools.closeconn(conn); } return emps; } public boolean dengluyanzheng(Emp emp) { boolean f = false; try { st = conn.createStatement(); String sql = "select ename,empno from emp"; rs = st.executeQuery(sql); while (rs.next()) { if (rs.getString("ename").equals(emp.getEname()) && Integer.toString(rs.getInt("empno")) .equalsIgnoreCase(emp.getEmpno())) { f = true; break; } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(st); DatabaseTools.closeconn(conn); } return f; } public int charu(Emp emp) { int f = 0; String sql = "insert into emp values(?,?,?,?,?,?,?,?)"; try { pst = conn.prepareStatement(sql); pst = conn.prepareStatement(sql); pst.setInt(1, Integer.parseInt(emp.getEmpno())); pst.setString(2, emp.getEname()); if (emp.getJob().equals("")) { pst.setString(3, null); } else { pst.setString(3, emp.getJob()); } if (emp.getMgr().equals("")) { pst.setString(4, null); } else { pst.setString(4, emp.getMgr()); } if (emp.getHiredate().equals("")) { pst.setDate(5, null); } else { pst.setDate(5, java.sql.Date.valueOf(emp.getHiredate())); } if (emp.getSal().equals("")) { pst.setString(6, null); } else { pst.setInt(6, Integer.parseInt(emp.getSal())); } if (emp.getComm().equals("")) { pst.setString(7, null); } else { pst.setInt(7, Integer.parseInt(emp.getComm())); } pst.setInt(8, Integer.parseInt(emp.getDeptno())); f = pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(st); DatabaseTools.closeconn(conn); } return f; } public int deleteEmpByName(String text) { int f = 0; String sql = "delete emp where ename like ?"; try { pst = conn.prepareStatement(sql); pst.setString(1, text); f = pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closest(pst); DatabaseTools.closeconn(conn); } return f; } public int update(String empno2, String ziduan2, String ziduanvalue2) { int f = 0; String sql = "select * from emp where empno=" + empno2 + ""; String sql2 = "update emp set " + ziduan2 + "=? where empno=" + empno2 + ""; try { // 判断输入的字段的类型 st = conn.createStatement(); rs = st.executeQuery(sql); ResultSetMetaData rss = rs.getMetaData(); String type = "varchar2"; for (int i = 1; i < rss.getColumnCount() + 1; i++) { if (rss.getColumnName(i).equalsIgnoreCase(ziduan2)) { type = rss.getColumnTypeName(i); break; } } // 修改时将字段值的类型转换成与数据库一致。 pst = conn.prepareStatement(sql2); if (type.equalsIgnoreCase("varchar2")) { pst.setString(1, ziduan2); } if (type.equalsIgnoreCase("Date")) { pst.setDate(1, java.sql.Date.valueOf(ziduan2)); } if (type.equalsIgnoreCase("number")) { pst.setInt(1, Integer.parseInt(ziduan2)); } f = pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return f; } public Vector<Vector<String>> getEmpsByWhatsay(String whatsay) { Vector<Vector<String>> emps = new Vector<Vector<String>>(); try { pst = conn.prepareStatement(whatsay); rs = pst.executeQuery(); ResultSetMetaData rsm=rs.getMetaData(); int f=rsm.getColumnCount(); while (rs.next()) { Vector<String> v = new Vector<String>(); for (int i = 1; i < f+1; i++) { v.add(rs.getString(rsm.getColumnName(i))); } emps.add(v); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(pst); // DatabaseTools.closeconn(conn); } return emps; } public int updateByWhatsay(String whatsay) { int f = 0; try { pst = conn.prepareStatement(whatsay); f = pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return f; } public Vector<String> getziduan2(String sql) { Vector<String> a = new Vector<String>(); //String sql = "select * from emp"; try { st = conn.createStatement(); rs = st.executeQuery(sql); ResultSetMetaData rsm = rs.getMetaData(); int f = rsm.getColumnCount(); for (int i = 1; i < f + 1; i++) { a.add(rsm.getColumnName(i)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DatabaseTools.closers(rs); DatabaseTools.closest(st); DatabaseTools.closeconn(conn); } return a; } }