职工管理系统论文(6)

职工管理系统

public String selectWorker(String [] stem,Statement stmt){ try{ String sql=\ \ +stem[3]+\ ResultSet sc=stmt.executeQuery(sql); if(sc.next()){ ret=sc.getString(\ }else{ ret=\ } }catch(Exception e){ e.printStackTrace(); } return ret; } public String insertDate(String [] stem,String str,Statement stmt){ try{ String sql=\

(salary_id,worker_id,salary_much,worker_protect,worker_rent)\ +\ +stem[5]+\ if(stmt.executeUpdate(sql)>0){ ret=\ ret=\ } }catch(Exception e){ e.printStackTrace(); } return ret; } public ResultSet selectAllWorker(Statement stmt){ try{ String sql=\ sc=stmt.executeQuery(sql); }catch(Exception e){ e.printStackTrace(); } return sc; }}

package mySencondPackage; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class JDBC { public Statement link(){ try{ Class.forName(\ String url = \ String user = \ String pass = \ Connection conn = DriverManager.getConnection(url, user, pass); // 创建一个 Statement对象 Statement stmt = conn.createStatement(); return stmt;

- 26 -

}else{

职工管理系统

}catch(Exception e){ e.printStackTrace(); return null; } }}

package mySencondPackage;

import java.awt.HeadlessException; import java.awt.event.FocusEvent; import java.awt.event.FocusListener; import java.sql.Connection; import java.sql.ResultSet;

import java.sql.SQLException; import java.sql.Statement;

import javax.swing.JOptionPane; import javax.swing.JTable; public class ManageSalary { String str; Statement stmt; MyJPanelWorker myJPanelWorker; MyFrameWindow myFrameWindow; String [] stem; ResultSet sc; JTable table; public ManageSalary(String str,Statement stmt,MyJPanelWorker myFrameWorker,MyFrameWindow myFrameWindow){ this.str=str; this.stmt=stmt; this.myJPanelWorker=myFrameWorker; this.myFrameWindow=myFrameWindow; stem=str.split(\ } public void manage(){ if(stem[0].equals(\ addSalary(); }else if(stem[0].equals(\}else if(stem[0].equals(\ selectSalary(); }else if(stem[0].equals(\ selectWorker(); } } public void addSalary(){ HandleSalary handleSalary=new HandleSalary(); String str1=handleSalary.selectWorker(stem,stmt); if(str1.equals(\ JOptionPane.showMessageDialog(null, \对不起，没有该员工！\return; ResultSet st=handleSalary.selectWorkerSalary(stem,stmt); try {if(st.next()){

- 27 -

} 职工管理系统

JOptionPane.showMessageDialog(null, \该职工以计发工资\ return ; } } catch (Exception e) { e.printStackTrace(); } String str2=handleSalary.insertDate(stem,str1,stmt); if(str2.equals(\ JOptionPane.showMessageDialog(null, \添加成功\ myJPanelWorker.setText(); }else{ return; } } public void updateSalary(){ try{ HandleSalary handleSalary=new HandleSalary(); String str1=handleSalary.updateSalary(stem,stmt); if(str1.equals(\ JOptionPane.showMessageDialog(null,\修改成功！\ } }catch(Exception e){ e.printStackTrace(); } } public void selectWorker(){ try{ HandleSalary handleSalary=new HandleSalary(); sc=handleSalary.selectAllWorker(stmt); this.table=new OnShow().onShowWorker(sc); myJPanelWorker.setJTable(table); myFrameWindow.setVisible(true); }catch(Exception e){ e.printStackTrace(); } public void selectSalary(){ try{ HandleSalary handleSalary=new HandleSalary(); sc=handleSalary.selectWorkerSalary(stem, stmt); table=new OnShow().onShowSalary(sc); myJPanelWorker.setJTable(table); myFrameWindow.setVisible(true); }catch(Exception e){ } } public JTable getJtable(){ return this.table; }}

package mySencondPackage; import mySencondPackage.*;

import java.awt.HeadlessException; import java.awt.TextArea;

import java.io.DataInputStream; import java.io.DataOutputStream; import java.net.Socket; import java.sql.Connection; import java.sql.DriverManager;

- 28 -

}职工管理系统

import java.sql.ResultSet;

import java.sql.SQLException; import java.sql.Statement; import java.util.Vector;

import javax.swing.JOptionPane; import javax.swing.JTable;

import com.sun.xml.internal.bind.v2.runtime.unmarshaller.Receiver; public class ManageWorker { MyJPanelInformation myJPanelInformation; String str = null; ResultSet sc = null; //Vector as = new Vector(); HandleDate handleDate; MyFrameWindow myFrameWindow; WorkerInformation workerInformation; Statement stmt; String[] stem; JTable table; public ManageWorker() { }; public ManageWorker(WorkerInformation workerInformation, String str, MyJPanelInformation myFrameInformation, MyFrameWindow myFrameWindow) { this.str = str; this.myFrameWindow = myFrameWindow; this.myJPanelInformation = myFrameInformation; handleDate = new HandleDate(); this.workerInformation = workerInformation; stmt=new JDBC().link(); stem = str.split(\} public void delete() { String set = handleDate.deleteWorkerInformation(stem, stmt, myJPanelInformation); if (set.equals(\ JOptionPane.showMessageDialog(null, \删除成功!\ myJPanelInformation.setText(); } else { return; } } public void check() { try{ sc = handleDate.selectInfromation(stem, stmt, myJPanelInformation); if (sc.getFetchSize()==0) { JOptionPane.showMessageDialog(null, \没有相应的记录\ } else { this.table=new OnShow().onShowWorker(sc); myJPanelInformation.setJTable(table); myFrameWindow.setVisible(true); }}catch(Exception e){ e.printStackTrace(); } }

- 29 -

职工管理系统

public String selectEqual(){ try { for (int i = 0; i < stem.length; i++) { if (stem[i].replaceAll(\ JOptionPane.showMessageDialog(null, \请补充完没有填写的信息或在表格中更改\ return \ } } handleDate.selectEqualInfromation(\ this.sc = handleDate.sc; if (sc.next()) { if ((sc.getString(\ .equals(stem[3].replaceAll(\ !(stem[3].replaceAll(\ JOptionPane.showMessageDialog(null, \职工号不能相同\ return \ } } handleDate.selectEqualInfromation(\ null); this.sc = handleDate.sc; if (sc.next()) { if ((sc.getString(\ .equals(stem[6].replaceAll(\ !(stem[6].replaceAll(\ JOptionPane.showMessageDialog(null, \该用职工已存在\ return \ } } } catch (Exception e) { e.printStackTrace(); } return \} public void addWorker() { try {for (int i = 1; i < stem.length; i++) { if (stem[i].replaceAll(\ JOptionPane.showMessageDialog(null, \请补充完没有填写的信息\ return; } } handleDate.selectEqualInfromation(\ this.sc = handleDate.sc; if (sc.next()) { if ((sc.getString(\ .equals(stem[3].replaceAll(\ JOptionPane.showMessageDialog(null, \职工号不能相同\ return; } } handleDate.selectEqualInfromation(\ null); this.sc = handleDate.sc; if (sc.next()) { if ((sc.getString(\ .equals(stem[6].replaceAll(\ JOptionPane.showMessageDialog(null, \该用职工已存在\ return; } } String str=handleDate.insertDate(stem, stmt); if(str.equals(\

- 30 -