项目功能
随着经济的发展，企业正向着大型化、规模化发展，而对于大中型企业，员工、职称等跟工资管理有关的信息随之急剧增加。在这种情况下单靠人工来处理员工的工资不但显得力不从心，而且极容易出错。如何设计一个小型企业工资的数据库管理系统，由计算机代替人工执行一系列诸如增加新员工，删除旧员工，工资查询，统计等操作。这样就使办公人员可以轻松快捷地完成工资管理的任务。实现工资的集中管理。
功能：可供财务人员对本单位的人员以及工资进行增加、删除、修改、查询，对人事的管理及工资发放中的应发工资合计等项目由系统自动进行计算；同时系统还可对人事及工资管理情况进行多角度查询
每个子功能介绍
基础功能：登录与增查删改
可以选择登录方式：员工或者管理员（账密默认为admin，123456）
查询分为员工查询和管理员查询，员工只可以根据自己的信息查询，不具备修改的能力，管理员有多种查询功能，在各个模块之间进行操作时，下面有实时的信息显示
管理员具有添加员工，部门等，以及可以添加管理员的功能，修改员工信息，部门信息，设定工资信息。
进阶功能与特色功能：遍历信息与统计
访问数据库，遍历信息，生成表格。根据选择分析并统计数据
关键代码
java swing mysql实现的员工工资管理系统项目源码
登录界面，判断使用权限，输出对应的内容
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
private void initComponents() {
jComboBox1 = new javax.swing.JComboBox();
username = new javax.swing.JTextField();
jPasswordField1 = new javax.swing.JPasswordField();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jLabel4 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("登录界面");
jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "管理员", "员工" }));
jComboBox1.addItemListener(new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
// TODO Auto-generated method stub
if(e.getStateChange() == ItemEvent.SELECTED){
if("员工".equals(e.getItem())){
jButton1.setText("查询工资");
jLabel2.hide();
username.hide();
jPasswordField1.hide();
jLabel3.hide();
jPasswordField1.hide();
}else{
jButton1.setText("登录");
jLabel2.show();
username.show();
jPasswordField1.show();
jLabel3.show();
jPasswordField1.show();
}
}
}
});
//username.setText("quan");
jLabel1.setText("身份：");
jLabel2.setText("用户名：");
jLabel3.setText("密码：");
jButton1.setText("登录");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setText("退出");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jLabel4.setForeground(new java.awt.Color(255, 0, 0));
jLabel4.setText("注：员工可以匿名登录");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(80, 80, 80)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel1)
.addComponent(jLabel3)
.addComponent(jLabel2))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(username, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jComboBox1, javax.swing.GroupLayout.Alignment.LEADING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(18, 18, 18)
.addComponent(jLabel4))))
.addGroup(layout.createSequentialGroup()
.addGap(110, 110, 110)
.addComponent(jButton1)
.addGap(39, 39, 39)
.addComponent(jButton2)))
.addContainerGap(54, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(65, 65, 65)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jLabel4))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(username, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(35, 35, 35)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2))
.addContainerGap(102, Short.MAX_VALUE))
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO add your handling code here:
status = (String) jComboBox1.getSelectedItem();
name = username.getText();
String password = jPasswordField1.getText();
if(status.equals("管理员")){
if(name.equals("")){
JOptionPane.showMessageDialog(null, "用户名不能为空！！");
}else if(password.equals("")){
JOptionPane.showMessageDialog(null,"密码不能为空！！");
}else{
String sql = "select username from userlist where status = '"+ status +"' and username = '"+ name +"' and password = '"+ password +"'";
//String sql = "select * from userlist";
System.out.println(sql);
DBConn db = new DBConn();
if (db.Check(sql) != 0){
new MainFrame().setVisible(true);
this.hide();
}else {
JOptionPane.showMessageDialog(null, "用户名与密码不对！！");
}
}
}else{
new SalarySearch().setVisible(true);
}
}//GEN-LAST:event_jButton1ActionPerformed
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO add your handling code here:
int selection = JOptionPane.showConfirmDialog(this,
"是否退出？", "退出提示", JOptionPane.OK_CANCEL_OPTION,
JOptionPane.WARNING_MESSAGE);
if (selection == JOptionPane.OK_OPTION) {
System.exit(0);
}
}//GEN-LAST:event_jButton2ActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Login().setVisible(true);
}
});}
数据库使用代码，建立对应的数据库文件
/*
Navicat MySQL Data TransferSource Server : localhost
Source Server Version : 50523
Source Host : localhost:3306
Source Database : salarydbTarget Server Type : MYSQL
Target Server Version : 50523
File Encoding : 65001Date: 2013-07-03 20:47:40
*/SET FOREIGN_KEY_CHECKS=0;– Table structure for department
DROP TABLE IF EXISTS department;
CREATE TABLE department (
ID varchar(20) COLLATE utf8_unicode_ci NOT NULL,
Name varchar(25) COLLATE utf8_unicode_ci NOT NULL,
Director varchar(25) COLLATE utf8_unicode_ci NOT NULL,
Number int(16) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;– Records of department
INSERT INTO department VALUES (‘ks001’, ‘经理室’, ‘赢政’, ‘10’);
INSERT INTO department VALUES (‘ks002’, ‘财务室’, ‘刘邦’, ‘6’);
INSERT INTO department VALUES (‘ks003’, ‘军机部’, ‘李鸿章’, ‘6’);
INSERT INTO department VALUES (‘ks004’, ‘外交部’, ‘张仪’, ‘8’);
INSERT INTO department VALUES (‘ks005’, ‘技术科’, ‘朱元璋’, ‘10’);
INSERT INTO department VALUES (‘ks006’, ‘董事会’, ‘李世民’, ‘10’);– Table structure for employee
DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
ID varchar(10) COLLATE utf8_unicode_ci NOT NULL,
name varchar(25) COLLATE utf8_unicode_ci NOT NULL,
sex char(2) COLLATE utf8_unicode_ci NOT NULL,
age int(6) NOT NULL,
department varchar(50) COLLATE utf8_unicode_ci NOT NULL,
position varchar(25) COLLATE utf8_unicode_ci NOT NULL,
phone varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
time datetime DEFAULT NULL,
address varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
– Records of employee
INSERT INTO employee VALUES (‘0001’, ‘赢政’, ‘男’, ‘37’, ‘经理室’, ‘经理’, ‘10086’, ‘0201-01-01 00:00:00’, ‘咸阳’);
INSERT INTO employee VALUES (‘0002’, ‘刘邦’, ‘男’, ‘40’, ‘技术科’, ‘技术长’, ‘10087910’, ‘2001-05-06 00:00:00’, ‘长安’);
INSERT INTO employee VALUES (‘0003’, ‘武则天’, ‘女’, ‘30’, ‘财务室’, ‘经理’, ‘10088’, ‘1999-08-07 00:00:00’, ‘长安’);
INSERT INTO employee VALUES (‘0004’, ‘刘秀’, ‘男’, ‘46’, ‘军机部’, ‘副部长’, ‘123548788’, ‘2013-05-07 00:00:00’, ‘桂林’);
INSERT INTO employee VALUES (‘0005’, ‘西施’, ‘女’, ‘23’, ‘财务室’, ‘会计’, ‘10089’, ‘2001-02-03 00:00:00’, ‘越国’);
INSERT INTO employee VALUES (‘0006’, ‘李清照’, ‘女’, ‘25’, ‘财务室’, ‘出纳’, ‘125478’, ‘2012-03-04 00:00:00’, ‘宋国’);
INSERT INTO employee VALUES (‘0007’, ‘杨玉环’, ‘女’, ‘29’, ‘财务室’, ‘会计’, ‘125478’, ‘2010-02-04 00:00:00’, ‘长安’);
INSERT INTO employee VALUES (‘0008’, ‘孙权’, ‘男’, ‘35’, ‘外交部’, ‘部长’, ‘150478’, ‘2005-05-04 00:00:00’, ‘江东’);
INSERT INTO employee VALUES (‘0009’, ‘李世民’, ‘男’, ‘54’, ‘董事会’, ‘会长’, ‘100865’, ‘1998-05-08 00:00:00’, ‘西安’);
INSERT INTO employee VALUES (‘0010’, ‘项羽’, ‘男’, ‘40’, ‘经理室’, ‘副经理’, ‘1008670’, ‘2000-02-05 00:00:00’, ‘彭城’);
INSERT INTO employee VALUES (‘0011’, ‘李鸿章’, ‘男’, ‘52’, ‘军机部’, ‘部长’, ‘1008699’, ‘2001-05-08 00:00:00’, ‘北京’);
INSERT INTO employee VALUES (‘0012’, ‘张仪’, ‘男’, ‘44’, ‘外交部’, ‘部长’, ‘10089’, ‘2002-02-04 00:00:00’, ‘魏国’);
INSERT INTO employee VALUES (‘0013’, ‘朱元璋’, ‘男’, ‘35’, ‘技术科’, ‘部长’, ‘100896’, ‘2013-05-07 00:00:00’, ‘南京’);
INSERT INTO employee VALUES (‘0014’, ‘貂蝉’, ‘女’, ‘25’, ‘经理室’, ‘助理’, ‘10086972’, ‘2005-05-04 00:00:00’, ‘洛阳’);
INSERT INTO employee VALUES (‘0015’, ‘李渊’, ‘男’, ‘55’, ‘董事会’, ‘董事’, ‘25897’, ‘2001-02-05 00:00:00’, ‘长安’);– Table structure for salary
DROP TABLE IF EXISTS salary;
CREATE TABLE salary (
salaryID int(4) NOT NULL AUTO_INCREMENT,
ID varchar(10) COLLATE utf8_unicode_ci NOT NULL,
name varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
basepay int(10) DEFAULT NULL,
welfare int(10) DEFAULT NULL,
reward int(10) DEFAULT NULL,
insurance int(10) DEFAULT NULL,
funds int(10) DEFAULT NULL,
month varchar(25) COLLATE utf8_unicode_ci NOT NULL,
remark varchar(25) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (salaryID,ID)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;– Records of salary
INSERT INTO salary VALUES (‘1’, ‘0001’, ‘赢政’, ‘3000’, ‘100’, ‘100’, ‘100’, ‘500’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘13’, ‘0002’, ‘刘邦’, ‘3000’, ‘200’, ‘100’, ‘100’, ‘400’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘15’, ‘0003’, ‘武则天’, ‘2500’, ‘100’, ‘200’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘16’, ‘0004’, ‘刘秀’, ‘2900’, ‘100’, ‘150’, ‘250’, ‘200’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘17’, ‘0005’, ‘西施’, ‘2800’, ‘100’, ‘100’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘18’, ‘0006’, ‘李清照’, ‘2700’, ‘120’, ‘150’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘19’, ‘0007’, ‘杨玉环’, ‘2680’, ‘200’, ‘150’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘20’, ‘0008’, ‘孙权’, ‘2900’, ‘100’, ‘200’, ‘100’, ‘500’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘21’, ‘0009’, ‘李世民’, ‘2870’, ‘200’, ‘100’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘22’, ‘0010’, ‘项羽’, ‘2600’, ‘200’, ‘100’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘23’, ‘0011’, ‘李鸿章’, ‘2800’, ‘200’, ‘100’, ‘100’, ‘300’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘24’, ‘0012’, ‘张仪’, ‘2900’, ‘200’, ‘150’, ‘100’, ‘500’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘25’, ‘0013’, ‘朱元璋’, ‘2600’, ‘250’, ‘200’, ‘100’, ‘400’, ‘1月’, ‘未结算’);
INSERT INTO salary VALUES (‘26’, ‘0001’, ‘赢政’, ‘3000’, ‘100’, ‘200’, ‘100’, ‘300’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘27’, ‘0001’, ‘赢政’, ‘3000’, ‘250’, ‘200’, ‘100’, ‘400’, ‘3月’, ‘未结算’);
INSERT INTO salary VALUES (‘28’, ‘0002’, ‘刘邦’, ‘3000’, ‘250’, ‘150’, ‘100’, ‘400’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘29’, ‘0002’, ‘刘邦’, ‘3000’, ‘300’, ‘150’, ‘100’, ‘500’, ‘3月’, ‘未结算’);
INSERT INTO salary VALUES (‘30’, ‘0003’, ‘武则天’, ‘2900’, ‘200’, ‘150’, ‘100’, ‘300’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘31’, ‘0003’, ‘武则天’, ‘2800’, ‘250’, ‘120’, ‘100’, ‘500’, ‘3月’, ‘未结算’);
INSERT INTO salary VALUES (‘33’, ‘0004’, ‘刘秀’, ‘2580’, ‘500’, ‘200’, ‘100’, ‘300’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘35’, ‘0004’, ‘刘秀’, ‘2900’, ‘200’, ‘150’, ‘100’, ‘300’, ‘3月’, ‘未结算’);
INSERT INTO salary VALUES (‘37’, ‘0005’, ‘西施’, ‘2900’, ‘200’, ‘100’, ‘100’, ‘300’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘39’, ‘0005’, ‘西施’, ‘2800’, ‘200’, ‘150’, ‘100’, ‘300’, ‘3月’, ‘未结算’);
INSERT INTO salary VALUES (‘40’, ‘0006’, ‘李清照’, ‘2900’, ‘200’, ‘100’, ‘100’, ‘300’, ‘2月’, ‘未结算’);
INSERT INTO salary VALUES (‘41’, ‘0006’, ‘李清照’, ‘2900’, ‘200’, ‘100’, ‘100’, ‘300’, ‘3月’, ‘未结算’);– Table structure for userlist
DROP TABLE IF EXISTS userlist;
CREATE TABLE userlist (
status varchar(20) COLLATE utf8_unicode_ci NOT NULL,
username varchar(20) COLLATE utf8_unicode_ci NOT NULL,
password varchar(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;– Records of userlist
INSERT INTO userlist VALUES (‘管理员’, ‘admin’, ‘123456’);
INSERT INTO userlist VALUES (‘管理员’, ‘quan’, ‘1’);
INSERT INTO userlist VALUES (‘管理员’, ‘wufeng’, ‘123456’);– Table structure for view_salary
DROP TABLE IF EXISTS view_salary;
CREATE TABLE view_salary (
ID int(10) NOT NULL AUTO_INCREMENT,
工号 varchar(10) COLLATE utf8_unicode_ci NOT NULL,
姓名 varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
部门 varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
职位 varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
总工资 int(10) DEFAULT NULL,
月份 varchar(10) COLLATE utf8_unicode_ci NOT NULL,
备注 varchar(10) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;– Records of view_salary
INSERT INTO view_salary VALUES (‘1’, ‘0001’, ‘赢政’, ‘经理室’, ‘经理’, ‘2600’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘9’, ‘0002’, ‘刘邦’, ‘技术室’, ‘技术长’, ‘2800’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘11’, ‘0003’, ‘武则天’, ‘财务室’, ‘经理’, ‘2400’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘12’, ‘0004’, ‘刘秀’, ‘军机部’, ‘大王’, ‘2700’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘13’, ‘0005’, ‘西施’, ‘财务室’, ‘会计’, ‘2600’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘14’, ‘0006’, ‘李清照’, ‘财务室’, ‘出纳’, ‘2570’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘15’, ‘0007’, ‘杨玉环’, ‘财务室’, ‘会计’, ‘2630’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘16’, ‘0008’, ‘孙权’, ‘外交部’, ‘部长’, ‘2600’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘17’, ‘0009’, ‘李世民’, ‘董事会’, ‘会长’, ‘2770’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘18’, ‘0010’, ‘项羽’, ‘经理室’, ‘副经理’, ‘2500’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘19’, ‘0011’, ‘李鸿章’, ‘军机部’, ‘部长’, ‘2700’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘20’, ‘0012’, ‘张仪’, ‘外交部’, ‘部长’, ‘2650’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘21’, ‘0013’, ‘朱元璋’, ‘技术科’, ‘部长’, ‘2550’, ‘1月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘22’, ‘0001’, ‘赢政’, ‘经理室’, ‘经理’, ‘2900’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘23’, ‘0001’, ‘赢政’, ‘经理室’, ‘经理’, ‘2950’, ‘3月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘24’, ‘0002’, ‘刘邦’, ‘技术室’, ‘技术长’, ‘2900’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘25’, ‘0002’, ‘刘邦’, ‘技术室’, ‘技术长’, ‘2850’, ‘3月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘26’, ‘0003’, ‘武则天’, ‘财务室’, ‘经理’, ‘2850’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘27’, ‘0003’, ‘武则天’, ‘财务室’, ‘经理’, ‘2570’, ‘3月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘35’, ‘0004’, ‘刘秀’, ‘军机部’, ‘副部长’, ‘2850’, ‘3月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘36’, ‘0004’, ‘刘秀’, ‘军机部’, ‘副部长’, ‘2750’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘37’, ‘0005’, ‘西施’, ‘财务室’, ‘会计’, ‘2800’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘39’, ‘0005’, ‘西施’, ‘财务室’, ‘会计’, ‘2750’, ‘3月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘40’, ‘0006’, ‘李清照’, ‘财务室’, ‘出纳’, ‘2800’, ‘2月’, ‘未结算’);
INSERT INTO view_salary VALUES (‘41’, ‘0006’, ‘李清照’, ‘财务室’, ‘出纳’, ‘2800’, ‘3月’, ‘未结算’);
特色遍历功能
/*
• To change this template, choose Tools | Templates
• and open the template in the editor.
*//*
• SalaryShow.java
•
• Created on 2013-6-24, 9:28:40
*/package code;
import java.awt.Toolkit;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;/**
*• @author Administrator
*/
public class SalaryShow extends javax.swing.JFrame {
/** Creates new form SalaryShow */
private Toolkit tk = Toolkit.getDefaultToolkit();
int x = tk.getScreenSize().width / 2 - 250;
int y = tk.getScreenSize().height / 2 - 250;
DefaultTableModel dtm = null;
public SalaryShow() {
initTable();
initComponents();
setLocation(x,y);
}
private void initTable(){
String head[] = {“工号”,“姓名”,“部门”,“职位”,“总工资”,“月份”,“备注”};
Object obj[][] = new Object[0][0];
dtm = new DefaultTableModel(obj,head);
String sql = “select distinct 工号,姓名,部门,职位,总工资,月份,备注 from view_salary”;
try{
DBConn db = new DBConn();
Vector v;
ResultSet rs = db.Search(sql);
while (rs.next()) {
v = new Vector();
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
v.add(rs.getString(4));
v.add(rs.getString(5));
v.add(rs.getString(6));
v.add(rs.getString(7));
dtm.addRow(v);
}
db.close();
} catch (SQLException ex) {
System.out.println(ex);
}
}
/** This method is called from within the constructor to• initialize the form.
• WARNING: Do NOT modify this code. The content of this method is
• always regenerated by the Form Editor.
*/
@SuppressWarnings(“unchecked”)
// //GEN-BEGIN:initComponents
private void initComponents() {
title = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle(“员工工资一览表”);
title.setText(“员工工资一览表”);
jTable1.setModel(dtm);
jScrollPane1.setViewportView(jTable1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(209, 209, 209)
.addComponent(title))
.addGroup(layout.createSequentialGroup()
.addGap(105, 105, 105)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 323, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(27, 27, 27)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 467, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(24, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(title, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 303, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(39, Short.MAX_VALUE))
);
pack();
}// //GEN-END:initComponents/**
• @param args the command line arguments
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new SalaryShow().setVisible(true);
}
});
}
*/// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JTable jTable1;
private javax.swing.JLabel title;
// End of variables declaration//GEN-END:variables}
统计功能
/*
• To change this template, choose Tools | Templates
• and open the template in the editor.
*//*
• Statistics.java
•
• Created on 2013-6-23, 14:14:39
*/package code;
import java.awt.Toolkit;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;/**
*• @author Administrator
*/
public class Statistics extends javax.swing.JFrame {
/** Creates new form Statistics */
private Toolkit tk = Toolkit.getDefaultToolkit();
int x = tk.getScreenSize().width / 2 - 180;
int y = tk.getScreenSize().height / 2 - 180;
DefaultComboBoxModel dcm;
String[] head = {“部门”, “负责人”, “总人数”, “总工资”};
Object[][] obj = new Object[0][0];
DefaultTableModel dtm = new DefaultTableModel(obj, head);
public Statistics() {
initComboBox();
initComponents();
setTitle(“信息统计”);
setLocation(x,y);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
}
///初始化下拉列表
private void initComboBox(){
Vector v = new Vector();
DBConn db = new DBConn();
try{
ResultSet rs = db.Search(“select distinct name from department”);
while(rs.next()){
v.addElement(rs.getString(“name”)); //添加到向量尾部，大小加1
}
dcm = new DefaultComboBoxModel(v);
}catch(SQLException ex){
ex.printStackTrace();
}finally{
db.close();
}
}
private void initTable(String sql){
try {
// String[] head = {“部门”, “负责人”, “总人数”, “总工资”};
// Object[][] obj = new Object[0][0];
dtm = new DefaultTableModel(obj, head);
Vector v;
DBConn db = new DBConn();
ResultSet rs = db.Search(sql);
while (rs.next()) {
v = new Vector();
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
v.add(rs.getString(4));
dtm.addRow(v);
jTable1.setModel(dtm);
}
db.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
/** This method is called from within the constructor to• initialize the form.
• WARNING: Do NOT modify this code. The content of this method is
• always regenerated by the Form Editor.
*/
@SuppressWarnings(“unchecked”)
// //GEN-BEGIN:initComponents
private void initComponents() {
jname = new javax.swing.JComboBox();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
jseason = new javax.swing.JComboBox();
jButton1 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jname.setModel(dcm);
jLabel1.setText(“部门名称:”);
jLabel2.setText(“季度:”);
jseason.setModel(new javax.swing.DefaultComboBoxModel(new String[] { “–请选择季度–”, “第一季度”, “第二季度”, “第三季度”, “第四季度” }));
jButton1.setText(“查询”);
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jTable1.setModel(dtm);
jScrollPane1.setViewportView(jTable1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(44, 44, 44)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(28, 28, 28)
.addComponent(jseason, javax.swing.GroupLayout.PREFERRED_SIZE, 96, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(39, 39, 39)
.addComponent(jButton1))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jname, 0, 190, Short.MAX_VALUE)
.addGap(189, 189, 189))))
.addGroup(layout.createSequentialGroup()
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 399, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 378, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(56, 56, 56)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(19, 19, 19)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jseason, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(jButton1))
.addGap(20, 20, 20)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 228, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(50, Short.MAX_VALUE))
);
pack();
}// //GEN-END:initComponentsprivate void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO add your handling code here:
String name = (String) jname.getSelectedItem();
int index = jseason.getSelectedIndex();
String sql = null;
if(index == 1){
sql = “select 部门,director,number,sum(总工资) from view_salary,department where " +
“department.name=部门 and 月份 in (‘1月’,‘2月’,‘3月’) and 部门=’”+ name +”’ group by 部门,director,number ";
System.out.println(sql);
}else if(index == 2){
sql = “select 部门,director,number,sum(总工资) from view_salary,department where " +
“department.name=部门 and 月份 in (‘4月’,‘5月’,‘6月’) and 部门=’”+ name +”’ group by 部门,director,number ";
System.out.println(sql);
}else if(index == 3){
sql = “select 部门,director,number,sum(总工资) from view_salary,department where " +
“department.name=部门 and 月份 in (‘7月’,‘8月’,‘9月’) and 部门=’”+ name +”’ group by 部门,director,number ";
System.out.println(sql);
}else if(index == 4){
sql = “select 部门,director,number,sum(总工资) from view_salary,department where " +
“department.name=部门 and 月份 in (‘10月’,‘11月’,‘12月’) and 部门=’”+ name +”’ group by 部门,director,number ";
System.out.println(sql);
}else{
JOptionPane.showMessageDialog(null, “请选择季度”);
}
initTable(sql);
}//GEN-LAST:event_jButton1ActionPerformed/**
• @param args the command line arguments
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Statistics().setVisible(true);
}
});
}
*/
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JTable jTable1;
private javax.swing.JComboBox jname;
private javax.swing.JComboBox jseason;
// End of variables declaration//GEN-END:variables}结果截图
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
