java教师工资管理系统完整代码

教师工资管理系统：

开发团队：206和207

时间：2012年4月8日

数据库配置：sqlserver2000

创建数据库SalaryManagement 在其下创建数据表logindata、

创建数据表Employee

创建数据表January

创建数据表February

创建数据表March

创建数据库April

创建数据表May

创建数据表June

创建数据表July

创建数据表August

创建数据表September

创建数据表October

创建数据表November

创建数据表December

开发工具JDK1.6.21和eclipse，数据库驱动jdbc配置和导入省略。程序代码如下

import java.awt.BorderLayout;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.Toolkit;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.WindowAdapter;

import java.awt.event.WindowEvent;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JDialog;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

public class Login extends JFrame{

private JLabel lbTitle, lbUser, lbPwd;

private JButton btnLogon,btnOK, btnExit;

private Boolean lean=null;

JTextField tfUser = new JTextField(15);

JPasswordField tfPwd = new JPasswordField(15);

JRadioButton radiobutton1=new JRadioButton("教师登陆");

JRadioButton radiobutton2=new JRadioButton("管理登陆");

ButtonGroup buttongroup=new ButtonGroup();

String username=tfUser.getText();

String password=new String(tfPwd.getPassword());

public Login(){

try{init();}catch(Exception e3){

e3.printStackTrace();

}

}

public void init() {

this.setTitle("登陆界面");

this.setBounds(450, 300, 400, 300);

JPanel p = new JPanel(new BorderLayout());

p.setBounds(0, 0, 500, 400);

JPanel p1 = new JPanel(new FlowLayout());

JPanel p2 = new JPanel(new GridLayout(2,1));

JPanel p21 = new JPanel(new FlowLayout());

JPanel p22 = new JPanel(new FlowLayout());

JPanel p3 = new JPanel(new FlowLayout());

buttongroup.add(radiobutton1);

buttongroup.add(radiobutton2);

this.lbUser = new JLabel(" 用户名：");

this.lbPwd = new JLabel("密码：");

this.tfUser = new JTextField(15);

this.tfPwd = new JPasswordField(15);

this.tfPwd.setEchoChar('*');

this.btnLogon=new JButton("注册");

this.btnOK = new JButton(" 登录");

this.btnExit = new JButton("退出");

this.btnLogon.addActionListener(new ActionMonitor());

this.btnOK.addActionListener(new ActionMonitor());

this.btnExit.addActionListener(new ActionMonitor());

p1.add(radiobutton1);

p1.add(radiobutton2);

p21.add(this.lbUser);

p21.add(this.tfUser);

p22.add(this.lbPwd);

p22.add(this.tfPwd);

p3.add(btnLogon);

p3.add(this.btnOK);

p3.add(this.btnExit);

p2.add(p21);

p2.add(p22);

p.add(p1, BorderLayout.NORTH);

p.add(p2, BorderLayout.CENTER);

p.add(p3, BorderLayout.SOUTH);

p.setVisible(true);

this.add(p);

this.pack();

this.setVisible(true);

this.addWindowListener(new WindowMonitor());

}

class WindowMonitor extends WindowAdapter {

public void windowClosing(WindowEvent e) {

setVisible(false);

System.exit(0);

}

}

class ActionMonitor implements ActionListener {

public void actionPerformed(ActionEvent e) {

try{

if(e.getSource()==btnOK){

if(radiobutton2.isSelected()){

ManageUser user1= new ManageUser();

user1.setName(tfUser.getText());

user1.setPassword(new String(tfPwd.getPassword()));

ManageCheck ar1 = new ManageCheck(user1);

if(ar1.check()){

new ManagementFrame().setVisible(true);

}else{

JOptionPane.showMessageDialog(null,"账号或密码错误","警告",JFrame.EXIT_ON_CLOSE);

tfUser.setText("");

tfPwd.setText("");

}

}else if(radiobutton1.isSelected()){

User user= new User();

user.setUserName(tfUser.getText());

user.setPassWord(new String(tfPwd.getPassword()));

ActionCheck ar = new ActionCheck(user);

if(ar.check()){

new TeacherFrame().setVisible(true);

}else{

JOptionPane.showMessageDialog(null,"账号或密码错误","警告",JFrame.EXIT_ON_CLOSE);

tfUser.setText("");

tfPwd.setText("");

}

}

}

else if(e.getSource() == btnExit) {

setVisible(false);

System.exit(0);

}

else if(e.getSource()==btnLogon){

new LogonFrame().setVisible(true);

}

}

catch(Exception e2){

e2.printStackTrace();

}

}

}

public static void main(String[] args){

Login frame=new Login();

Dimension screenSize=Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize =frame.getSize();

if(frameSize.height>screenSize.height)

frameSize.height=screenSize.height;

if(frameSize.width>screenSize.width)

frameSize.width=screenSize.width;

frame.setLocation((screenSize.width-frameSize.width)/2,(screenSize.height-fram eSize.height)/2);

frame.setVisible(true);

}

}

import java.awt.*;

import java.sql.*;

import javax.swing.*;

import java.awt.event.*;

public class LogonFrame extends JFrame {

Connection con;

Statement st;

JLabel jLabel1=new JLabel("职工工号");

JLabel jLabel2=new JLabel("登陆密码");

JLabel jLabel3=new JLabel("职工姓别");

JLabel jLabel4=new JLabel("职工性名");

JLabel jLabel5=new JLabel("职工年龄");

JLabel jLabel6=new JLabel("所属院系");

JLabel jLabel7=new JLabel("家庭住址");

JLabel jLabel8=new JLabel("联系电话");

JTextField jTextField1=new JTextField();

JPasswordField jTextField2=new JPasswordField();

JTextField jTextField3=new JTextField();

JTextField jTextField4=new JTextField();

JTextField jTextField5=new JTextField();

JTextField jTextField6=new JTextField();

JTextField jTextField7=new JTextField();

JRadioButton jRadioButton1=new JRadioButton("男");

JRadioButton jRadioButton2=new JRadioButton("女");

ButtonGroup buttonGroup1=new ButtonGroup();

JButton jButton1=new JButton("注册");

JButton jButton2=new JButton("取消");

public LogonFrame()

{

try{

bInit();

}

catch(Exception exception){

exception.printStackTrace();

}

}

private void bInit() throws Exception

{

con=DB.getConn();

st=con.createStatement();

this.setTitle("注册界面");

this.setLayout(null);

this.setSize(450, 450);

this.setLocationRelativeTo(null);

jLabel1.setBounds(new Rectangle(21,17,64,24));

jLabel2.setBounds(new Rectangle(21,51,53,22));

jLabel3.setBounds(new Rectangle(21,86,61,27));

jLabel4.setBounds(new Rectangle(21,122,59,25));

jLabel5.setBounds(new Rectangle(21,168,54,24));

jLabel6.setBounds(new Rectangle(21,205,54,24));

jLabel7.setBounds(new Rectangle(21,245,54,24));

jLabel8.setBounds(new Rectangle(21,285,54,25));

jTextField1.setBounds(new Rectangle(102,10,100,30));

jTextField2.setBounds(new Rectangle(102,49,200,30));

jTextField3.setBounds(new Rectangle(102,117,100,33));

jTextField4.setBounds(new Rectangle(102,163,100,29));

jTextField5.setBounds(new Rectangle(102,200,200,29));

jTextField6.setBounds(new Rectangle(102,240,200,29));

jTextField7.setBounds(new Rectangle(102,280,200,29));

jRadioButton1.setBounds(new Rectangle(102,83,65,30));

jRadioButton2.setBounds(new Rectangle(190,85,85,30));

jButton1.setBounds(new Rectangle(130,320,60,32));

jButton2.setBounds(new Rectangle(200,320,60,32));

jRadioButton1.setSelected(true);

jButton1.addActionListener(new ActionMonitor());

jButton2.addActionListener(new ActionMonitor());

this.add(jLabel1);

this.add(jTextField1);

this.add(jLabel2);

this.add(jTextField2);

this.add(jLabel3);

buttonGroup1.add(jRadioButton1);

buttonGroup1.add(jRadioButton2);

this.add(jRadioButton1);

this.add(jRadioButton2);

this.add(jLabel4);

this.add(jTextField3);

this.add(jLabel5);

this.add(jTextField4);

this.add(jLabel6);

this.add(jTextField5);

this.add(jLabel7);

this.add(jTextField6);

this.add(jLabel8);

this.add(jTextField7);

this.add(jButton1);

this.add(jButton2);

}

class ActionMonitor implements ActionListener{

public void actionPerformed(ActionEvent e)

{

String EmployeeID=jTextField1.getText();

String EmployeePassword=new String(jTextField2.getPassword());

String EmployeeSex="";

if(jRadioButton1.isSelected())

EmployeeSex+="男";

if(jRadioButton2.isSelected())

EmployeeSex+="女";

String EmployeeName=jTextField3.getText();

String EmployeeIge=jTextField4.getText();

String EmployeeCollege=jTextField5.getText();

String EmployeeAddress=jTextField6.getText();

String EmployeeTell=jTextField7.getText();

try{

if(e.getSource()==jButton1){

if(EmployeeID.equals("")|EmployeePassword.equals("")|EmployeeName.equals( "")|EmployeeIge.equals("")|EmployeeCollege.equals("")|EmployeeAddress.equals("") |EmployeeTell.equals("")){

JOptionPane.showMessageDialog(null,"内容不允许为空","警告",JFrame.EXIT_ON_CLOSE);

}else {

st.execute("set dateformat ymd");

st.executeUpdate("insert into Employee values('"+EmployeeID+"','"+EmployeePassword+"','"+EmployeeName+"','"+Employ

eeSex+"','"+EmployeeIge+"','"+EmployeeCollege+"','"+EmployeeAddress+"','"+Empl oyeeTell+"')");

JOptionPane.showMessageDialog(null,"职工添加成功！","提示",JFrame.EXIT_ON_CLOSE);

jTextField1.setText("");

jTextField2.setText("");

jTextField3.setText("");

jTextField4.setText("");

jTextField5.setText("");

jTextField6.setText("");

}

}else if(e.getSource()==jButton2){

jTextField1.setText("");

jTextField2.setText("");

jTextField3.setText("");

jTextField4.setText("");

jTextField5.setText("");

jTextField6.setText("");

jTextField7.setText("");

}

}

catch(Exception ex){

JOptionPane.showMessageDialog(null,"职工添加失败！","提示",JFrame.EXIT_ON_CLOSE);

ex.printStackTrace();

}

}

}

}

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class ManagementFrame extends JFrame implements ActionListener

{

JPanel contentPane;

JLayeredPane contentPane1;

JMenuBar jMenuBar1=new JMenuBar();

JMenu jMenu0=new JMenu("系统");

JMenuItem jMenuItem0=new JMenuItem("退出");

JMenuItem jMenuItem10=new JMenuItem("主界面");

JMenu jMenu1=new JMenu("职工管理");

JMenuItem jMenuItem1=new JMenuItem("添加职工");

JMenuItem jMenuItem2=new JMenuItem("修改职工");

JMenuItem jMenuItem3=new JMenuItem("删除职工");

JMenu jMenu2=new JMenu("工资管理");

JMenuItem jMenuItem4=new JMenuItem("添加工资");

JMenuItem jMenuItem5=new JMenuItem("修改工资");

JMenuItem jMenuItem8=new JMenuItem("工资查询");

JMenu jMenu3=new JMenu("职工查询");

JMenuItem jMenuItem6=new JMenuItem("按工号查询");

JMenuItem jMenuItem7=new JMenuItem("按姓名查询");

JMenu jMenu4=new JMenu("帮助");

JMenuItem jMenuItem9=new JMenuItem("互动");

public ManagementFrame()

{

try{

setDefaultCloseOperation(EXIT_ON_CLOSE);

Init();

}

catch(Exception exception){

exception.printStackTrace();

}

}

private void Init() throws Exception

{

setContentPane(new Layeredpane());

setSize(new Layeredpane().getWidth(),new Layeredpane().getHeight());

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setTitle("教师工资管理小系统");

setLocationRelativeTo(null);

jMenuItem0.addActionListener(this);

jMenuItem1.addActionListener(this);

jMenuItem2.addActionListener(this);

jMenuItem3.addActionListener(this);

jMenuItem4.addActionListener(this);

jMenuItem5.addActionListener(this);

jMenuItem6.addActionListener(this);

jMenuItem7.addActionListener(this);

jMenuItem8.addActionListener(this);

jMenuItem9.addActionListener(this);

jMenuItem10.addActionListener(this);

setJMenuBar(jMenuBar1);

jMenuBar1.add(jMenu0);

jMenuBar1.add(jMenu1);

jMenuBar1.add(jMenu2);

jMenuBar1.add(jMenu3);

jMenuBar1.add(jMenu4);

jMenu0.add(jMenuItem10);

jMenu0.add(jMenuItem0);

jMenu1.add(jMenuItem1);

jMenu1.add(jMenuItem2);

jMenu1.add(jMenuItem3);

jMenu2.add(jMenuItem4);

jMenu2.add(jMenuItem5);

jMenu2.add(jMenuItem8);

jMenu3.add(jMenuItem6);

jMenu3.add(jMenuItem7);

jMenu4.add(jMenuItem9);

}

public void actionPerformed(ActionEvent actionEvent)

{

if(actionEvent.getSource()==jMenuItem0)

{

System.exit(0);

}

if(actionEvent.getSource()==jMenuItem1)

{

AddEmployee addemployee=new AddEmployee();

this.remove(this.getContentPane());

this.setContentPane(addemployee);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem2)

{

ModifyEmployee ModifyEmp=new ModifyEmployee();

this.remove(this.getContentPane());

this.setContentPane(ModifyEmp);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem3)

{

DeleteEmployee DeleteEmp=new DeleteEmployee();

this.remove(this.getContentPane());

this.setContentPane(DeleteEmp);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem4)

{

AddSalary AddSal=new AddSalary();

this.remove(this.getContentPane());

this.setContentPane(AddSal);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem5)

{

ModifySalary ModifySal=new ModifySalary();

this.remove(this.getContentPane());

this.setContentPane(ModifySal);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem8)

{

SalaryInquire SalaryInq=new SalaryInquire();

this.remove(this.getContentPane());

this.setContentPane(SalaryInq);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem6)

{

InquireOnGH OnGH=new InquireOnGH();

this.remove(this.getContentPane());

this.setContentPane(OnGH);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem7)

{

InquireOnName OnName=new InquireOnName();

this.remove(this.getContentPane());

this.setContentPane(OnName);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem9)

{

EmployeeHelp EmployeeH=new EmployeeHelp();

this.remove(this.getContentPane());

this.setContentPane(EmployeeH);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem10){

Layeredpane layeredpane=new Layeredpane();

this.remove(this.getContentPane());

this.setContentPane(layeredpane);

this.setVisible(true);

}

}

}

import java.awt.*;

import java.awt.event.*;

import java.beans.Statement;

import java.sql.Connection;

import javax.swing.*;

public class TeacherFrame extends JFrame implements ActionListener {

Connection conn;

Statement stmt;

JPanel contentPane;

JLayeredPane contentPane1;

JMenuBar jMenuBar1=new JMenuBar();

JMenu jMenu0=new JMenu("系统");

JMenuItem jMenuItem0=new JMenuItem("退出");

JMenuItem jMenuItem1=new JMenuItem("主界面");

JMenu jMenu1=new JMenu("工资管理");

JMenuItem jMenuItem2=new JMenuItem("工资查询");

JMenu jMenu2=new JMenu("职工查询");

JMenuItem jMenuItem4=new JMenuItem("按工号查询");

JMenuItem jMenuItem5=new JMenuItem("按姓名查询");

JMenu jMenu3=new JMenu("帮助");

JMenuItem jMenuItem6=new JMenuItem("互动");

JMenu jMenu4=new JMenu("密码设置");

JMenuItem jMenuItem7=new JMenuItem("增加密码");

JMenuItem jMenuItem8=new JMenuItem("修改密码");

public TeacherFrame()

{

try{

setDefaultCloseOperation(EXIT_ON_CLOSE);

jbInit();

}

catch(Exception exception){

exception.printStackTrace();

}

}

private void jbInit() throws Exception

{

setContentPane(new Layeredpane());

setSize(new Layeredpane().getWidth(),new Layeredpane().getHeight());

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setTitle("教师工资管理小系统");

setLocationRelativeTo(null);

jMenuItem0.addActionListener(this);

jMenuItem1.addActionListener(this);

jMenuItem2.addActionListener(this);

jMenuItem4.addActionListener(this);

jMenuItem5.addActionListener(this);

jMenuItem6.addActionListener(this);

setJMenuBar(jMenuBar1);

jMenuBar1.add(jMenu0);

jMenuBar1.add(jMenu1);

jMenuBar1.add(jMenu2);

jMenuBar1.add(jMenu4);

jMenuBar1.add(jMenu3);

jMenu0.add(jMenuItem1);

jMenu0.add(jMenuItem0);

jMenu1.add(jMenuItem2);

jMenu2.add(jMenuItem4);

jMenu2.add(jMenuItem5);

jMenu3.add(jMenuItem6);

jMenu4.add(jMenuItem7);

jMenu4.add(jMenuItem8);

}

public void actionPerformed(ActionEvent actionEvent)

{

if(actionEvent.getSource()==jMenuItem0)

{

System.exit(0);

}

if(actionEvent.getSource()==jMenuItem1)

{

Layeredpane layeredpane=new Layeredpane();

this.remove(this.getContentPane());

this.setContentPane(layeredpane);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem2)

{

SalaryInquire SalaryInq=new SalaryInquire();

this.remove(this.getContentPane());

this.setContentPane(SalaryInq);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem4)

{

InquireOnGH OnGH=new InquireOnGH();

this.remove(this.getContentPane());

this.setContentPane(OnGH);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem5)

{

InquireOnName OnName=new InquireOnName();

this.remove(this.getContentPane());

this.setContentPane(OnName);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem6)

{

EmployeeHelp EmployeeH=new EmployeeHelp();

this.remove(this.getContentPane());

this.setContentPane(EmployeeH);

this.setVisible(true);

}

if(actionEvent.getSource()==jMenuItem7)

{

}

if(actionEvent.getSource()==jMenuItem8)

{

}

}

}

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class ActionCheck {

private User user;

ActionCheck(User user) {

https://www.360docs.net/doc/834299947.html,er = user;

}

public boolean check() {

boolean isAdmin = false;

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

String sql = "";

try {

conn = DB.getConn();

sql = "select * from Employee where employeeid=? and password=?";

pstmt = DB.getPstmt(conn, sql);

pstmt.setString(1, user.getUserName());

pstmt.setString(2, user.getPassWord());

rs = DB.getRs(pstmt);

if (rs.next()) {

isAdmin = true;

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DB.close(rs);

DB.close(pstmt);

DB.close(conn);

}

return isAdmin;

}

public User getUser() {

return user;

}

public void setUser(User user) {

https://www.360docs.net/doc/834299947.html,er = user;

}

}

import java.awt.*;

import java.sql.*;

import javax.swing.*;

import java.awt.event.*;

public class AddEmployee extends JPanel implements ActionListener {

Connection con;

Statement st;

JButton jButton1=new JButton("确定");

JLabel jLabel1=new JLabel("职工工号");

JLabel jLabel2=new JLabel("职工姓名");

JLabel jLabel3=new JLabel("职工性别");

JLabel jLabel4=new JLabel("职工年龄");

JLabel jLabel5=new JLabel("所属院系");

JLabel jLabel6=new JLabel("家庭住址");

JLabel jLabel7=new JLabel("联系电话");

JTextField jTextField1=new JTextField();

JTextField jTextField2=new JTextField();

JTextField jTextField3=new JTextField();

JTextField jTextField4=new JTextField();

JTextField jTextField5=new JTextField();

JTextField jTextField6=new JTextField();

JRadioButton jRadioButton1=new JRadioButton("男");

JRadioButton jRadioButton2=new JRadioButton("女");

ButtonGroup buttonGroup1=new ButtonGroup();

public AddEmployee()

{

try{

jbInit();

}

catch(Exception exception){

exception.printStackTrace();

}

}

private void jbInit() throws Exception

{

con=DB.getConn();

st=con.createStatement();

this.setLayout(null);

jLabel1.setBounds(new Rectangle(21,17,64,24));

jLabel2.setBounds(new Rectangle(21,51,53,22));

jLabel3.setBounds(new Rectangle(21,86,61,27));

jLabel4.setBounds(new Rectangle(21,122,59,25));

jLabel5.setBounds(new Rectangle(21,168,54,24));

jLabel6.setBounds(new Rectangle(21,205,54,24));

jLabel7.setBounds(new Rectangle(21,245,54,24));

jTextField1.setBounds(new Rectangle(102,10,200,30));

jTextField2.setBounds(new Rectangle(102,49,200,30));

jTextField3.setBounds(new Rectangle(102,117,80,33));

jTextField4.setBounds(new Rectangle(102,163,200,29));

jTextField5.setBounds(new Rectangle(102,200,200,29));

jTextField6.setBounds(new Rectangle(102,240,200,29));

jRadioButton1.setBounds(new Rectangle(102,83,65,30));

jRadioButton2.setBounds(new Rectangle(190,85,85,30));

jButton1.setBounds(new Rectangle(130,280,150,32));

jRadioButton1.setSelected(true);

jButton1.addActionListener(this);

this.add(jLabel1);

this.add(jTextField1);

this.add(jLabel2);

this.add(jTextField2);

this.add(jLabel3);

buttonGroup1.add(jRadioButton1);

buttonGroup1.add(jRadioButton2);

this.add(jRadioButton1);

this.add(jRadioButton2);

this.add(jLabel4);

this.add(jTextField3);

this.add(jLabel5);

this.add(jTextField4);

this.add(jLabel6);

this.add(jTextField5);

this.add(jLabel7);

this.add(jTextField6);

this.add(jButton1);

}