Java课程设计-教职工档案管理系统

职工档案理系统
．引言
11工程背景目标
职工档案理系统校教师根信息教学信息进行理教职工提供查询简介信息教学信息功理员户提供查询教师简介信息查询教学信息添加教师信息修改教师信息删教师信息等功目标该系统提供台连接MYSQL数库程序设计前台户界面设计

12工程行性研究
设计系统需java面象编程根底数库应知识功分析根目前开设课程学生已具备样知识力综合java编程知识数库应知识做出样学生信息理系统

二 需求分析
2．1系统概述
系统提供应教职工户学校理者教职工登陆根信息进行查理员登陆教师根信息进行增删改操作
2．2系统运行环境
Java程序运行eclipse软件编译运行数库MYSQL数库
三．系统设计
3．1开发设计总体思想
教职工方面：教师通户名密码登录进入教师界面界面里进行查询信息操作
学校理员方面理员通密码登入选择查询功文件功修改功查询功里面选择查询教职工简介根信息查询教学信息查询教职工简介信息时字段简介表中属性进行查找查找教学信息时教师姓名进行查找修改功里面包括教师简介信息表教学表进行增加删记录


职工档案理系统
3．2系统模块结构图



教职工登录
理员登录



教职工信息理

教职工教学信息


帮助

教职工信息查询
教职工信息修改
退出系统



教职工简介信息
教职工教学信息






删简介信息
添加简介信息

添加教学信息
删教学信息


3．3数库结构设计
支持职工档案理系统创立数库employeemanage数库里包含四表：worker表manager表employee表teaching表截图：
worker表中八属性列分：id(职工号)wname(姓名)sex(性)age(年龄)degree(学历)worktime(参加工作时间)salary(工资)dept(院)根数类型分：charcharcharintcharcharintchar











表1 worker

manager表中两属性列分：mname(理员姓名)password(密码)根数类型分：charchar理员登录系统时表获取数截图：
表2 manager

employee表中两属性列分：wname(职工姓名)password(密码)根数类型分：charchar教职工登录系统时表获取数截图：
表3 employee

teaching表中七属性列分：id(职工号)wname(姓名)grade(年级)tmajor(教授专业)snum(学生数)passrate(格率)comment(教学总评)根数类型分：charcharcharintcharcharchar截图：






表4 teaching

3．4模块设计
整系统界面选择登录方式教职工登录理员登录果选择教职工进入教职工登录界面界面求输入教职工姓名密码输入单击确认登录〞钮假设密码正确转换教职工教学信息查询页面输入教职工姓名显示该名教职工教学信息假设密码正确提示密码错误
果选择理员登录进入理员登陆界面界面输入理员姓名密码输入单击教职工信息理〞钮进入理员界面理员界面选择进行文件操作查询操作修改操作
假设查询教职工简介信息点击查询菜单项进入教职工简介信息检索界面界面检索方式中选择检索数属性检索容框中输入检索具体信息例检索姓名〞字段时键入某教职工姓名输入单击检索〞钮开始数库中数进行查询果数库检索需信息生成列表显示检索结构果没需信息页面列表中显示空
假设查询教职工教学信息点击教职工教学信息查询菜单项进入教学查询界面界面文框中输入查询教学信息教职工姓名然单击检索钮假设数库中该教职工教学信息生成列表显示教学信息假设没记录列表显示容空
果理员数库中进行修改操作理员界面选择修改菜单项项中选择修改具体容总四项修改操作：添加教职工简介信息删教职工简介信息〔两数库中worker表操作〕添加教职工教学信息删教职工教学信息〔两数库中teaching表操作〕添加信息操作中标签提示次输入添加记录值输入完毕单击添加〞钮假设输入成功提示成功假设输入失败提示失败删信息操作中输入删信息教职工姓名单击删〞钮假设删成功提示成功假设删失败提示失败
该职工档案理系统涉操作步骤



开 始
3．5系统流程描述
登录界面



帮 助
理员登录
教职工登录

输入误
输入误

成功

成功
No
选择 帮助

教学信息理界面
简介信息查询
Yes


教职工信息修改
退出系统
教职工信息查询


删教职工教学信息
删教职工简介信息
添加教职工教学信息
添加教职工简介信息

职工教学信息
职工简介信息
退出


输入教职工
姓名
选择检索方 式数

录入添加简介信息
输入删教职工姓名
输入删教职工姓名
录入添加教学信息


成功
成功


成功
成功
成功
成功
Yes
显示教职工教学信息
显示检索信息

输入误
输入误
输入误
输入误



没输出


Insert success

insert
success

delete
success

delete
success





四系统实现DBconnection类
系统编写程序保存四包中：connection包first包second包finally包
1 connection包中类：
〔1〕DBconnection类：类设置程序数库连接通设置驱动类型数源确定连接数库假设连接成功提示：connection success假设连接失败提示：connection failure
DBconnection类源代码：
package connection
import javasqlConnection
import javasqlDriverManager
import javasqlSQLException

import finallysTeachQuery

public class DBconnection {
public static void main(String[] args) {
new DBconnection()
}
public static Connection connull
public static Connection getConnection()
{
try {
String dbDrivercommysqljdbcDriver
ClassforName(dbDriver)
Systemoutprintln(Driver Suceess)
} catch (ClassNotFoundException e) {
Systemoutprintln(Driver not found)
eprintStackTrace()
}
try {
conDriverManagergetConnection(jdbcmysqllocalhost3306employeemanageroot0703112418)
Systemoutprintln(Connection Suceess)
} catch (SQLException e) {
Systemoutprintln(Connetion failure)
eprintStackTrace()
}
return con
}
public static void closeConnection()
{
if(connull)
try {
conclose()
Systemoutprintln(database close success)
} catch (SQLException e) {
Systemoutprintln(close failure)
eprintStackTrace()
}
}
}
2 first包中类：
(1)Workerfirst类：类中四方法managerLoginaddWorkerdeleteWorker queryworker作分控制理员登陆系统增加教职工根信息删学生根信息查询教职工根信息
managerLogin〔〕方法中两参数分传select语句中mname〔理员姓名〕password〔登录密码〕利select语句employee表中检索理员登录信息假设存信息返回true否返回false
addWorker)方法中八参数分传insert语句中id〔职工号〕wname〔教职工姓名〕age〔年龄〕sex〔性〕degree〔学历〕worktime〔参加工作时间〕salary〔工资〕dept〔院〕利insert语句worker教职工信息简介表中插入记录假设插入成功返回true否返回false
deleteWorker〔〕方法中参数传delete语句中wname〔教职工姓名〕利delete语句worker表中相关教职工信息删假设删成功返回true否返回false
queryWorker〔〕方法中两参数分传select语句中field(查找方式)key〔查找容〕利select语句worker表中检索教职工简介信息假设存信息返回ArrayList类象lis〔表格〕否异常处理
Workerfirst类源代码：
package first
import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javasqlSQLException
import javasqlStatement
import javautilArrayList

import secondWork
import connectionDBconnection

public class Workerfirst {

public boolean managerLogin(String mnameString password) {
DBconnection dbnew DBconnection()
Connection condbgetConnection()
boolean isfoundfalse
PreparedStatement pst
try {
pst conprepareStatement(select * from manager where mname and password)
pstsetString(1 mname)
pstsetString(2password)
ResultSet rspstexecuteQuery()
if(rsnext())
isfoundtrue

} catch (SQLException e) {
eprintStackTrace()
}

Systemoutprintln(isfound)
return isfound
}
public boolean addWorker(String id String wname String sex int ageString degreeString worktimeint salary String dept)
{
Connection con DBconnectiongetConnection()
PreparedStatement pst
try {
pst conprepareStatement(insert into worker values())

pstsetString(1 id)
pstsetString(2 wname)
pstsetString(3 sex)
pstsetInt(4 age)
pstsetString(5 degree)
pstsetString(6 worktime)
pstsetInt(7 salary)
pstsetString(8 dept)
int count pstexecuteUpdate() 返回修改记录数
if (count 1)
return true
else
return false

} catch (SQLException e) {

eprintStackTrace()
}
return false
}

public ArrayList queryWorker(String field String key) {

ArrayList lis new ArrayList()
Connection con DBconnectiongetConnection()
Statement stm
try {
stm concreateStatement()
String sql select * from worker where + field + like ＇
+ key + ＇
Systemoutprintln(sql)
ResultSet rs stmexecuteQuery(sql)

while (rsnext()) {
Work work new Work(rsgetString(1) rsgetString(2) rsgetString(3) rsgetInt(4) rsgetString(5)rsgetString(6)rsgetInt(7)rsgetString(8))
lisadd(work)
}
} catch (SQLException e) {
eprintStackTrace()
}
return lis
}

public boolean deleteWorker(String key) {

Connection con DBconnectiongetConnection()
Statement stm
try {
stm concreateStatement()
String sql delete from worker where wname like ＇
+ key + ＇
Systemoutprintln(sql)
int count stmexecuteUpdate(sql)
if (count 1)
return true
else
return false
} catch (SQLException e) {
eprintStackTrace()
}
return false
}
}

〔2〕Employeefirst类：类中方法：queryEmployee()作控制教职工登陆 queryEmployee〔〕方法中两参数分传select语句中wname〔教职工姓名〕password〔登陆密码〕利select语句teacher表中检索教师登陆信息假设存信息返回true否返回false
Employeefirst类源代码：
package first
import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javasqlSQLException
import

import connectionDBconnection
public class Employeefirst {
public boolean queryEmployee(String wnameString password) {
DBconnection dbnew DBconnection()
Connection condbgetConnection()
boolean isfoundfalse
PreparedStatement pst
try {
pst conprepareStatement(select * from employee where wname and password)
pstsetString(1 wname)
pstsetString(2password)
ResultSet rspstexecuteQuery()
if(rsnext())
isfoundtrue

} catch (SQLException e) {
eprintStackTrace()
}

Systemoutprintln(isfound)
return isfound
}
public static void main(String[] args) {
}
}
〔3〕Teaching类：该类中四方法queryTeachingaddTeachingdeleteTeaching
作分教职工户提供查询教学信息功理者户提供
询教职工教学信息添加教学信息删教学信息功
queryTeaching〔〕方法中参数传select语句中wname〔学生姓名〕利select语句查询教学信息表中容假设查询成功返回ArrayList类象lis〔表格〕否异常处理
addTeaching〔〕方法中七参数分传insert语句中id(职工号)wname〔教职工姓名〕grade〔年级〕tmajor〔教学专业〕snum〔学生数〕passrate(格率)comment〔教学总评〕利insert语句记录写入teaching表中假设插入成功返回true否返 回false
deleteTeaching〔〕方法中参数传delete语句中wname〔教职工姓名〕利delete语句steaching表中相关教职工教学信息删假设删成功返回 true否返回false
Teaching类源代码：
package first
import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javasqlSQLException
import javasqlStatement
import javautilArrayList

import finallysManagerDD

import secondTeaching
import secondWork
import connectionDBconnection

public class Teachingfirst {
public ArrayList queryTeaching(String key) {
ArrayList lis new ArrayList()
Connection con DBconnectiongetConnection()
Statement stm

try {
stm concreateStatement()
String sql select * from teaching where wname like ＇ + key
+ ＇
Systemoutprintln(sql)
ResultSet rs stmexecuteQuery(sql)

while (rsnext()) {
Teaching teach new Teaching(rsgetString(1) rsgetString(2) rs
getString(3) rsgetString(4) rsgetInt(5)rsgetString(6)rsgetString(7))
lisadd(teach)
}
} catch (SQLException e) {
eprintStackTrace()
}
return lis
}

public ArrayList queryTeach(String key) {
ArrayList lis new ArrayList()
Connection con DBconnectiongetConnection()
Statement stm

try {
stm concreateStatement()
String sql select * from teaching where wname like ＇ + ManagerDDst1
+ ＇
Systemoutprintln(sql)
ResultSet rs stmexecuteQuery(sql)

while (rsnext()) {
Teaching teach new Teaching(rsgetString(1) rsgetString(2) rs
getString(3) rsgetString(4) rsgetInt(5)rsgetString(6)rsgetString(7))
lisadd(teach)
}
} catch (SQLException e) {
eprintStackTrace()
}
return lis
}



public boolean addTeaching(String id String wname String grade String tmajor
int snumString passrateString comment) {
Connection con DBconnectiongetConnection()
PreparedStatement pst
try {
pst conprepareStatement(insert into teaching values())
pstsetString(1 id)
pstsetString(2 wname)
pstsetString(3 grade)
pstsetString(4 tmajor)
pstsetInt(5 snum)
pstsetString(6 passrate)
pstsetString(7 comment)
int count pstexecuteUpdate() 返回修改记录数
if (count 1)
return true
else
return false
} catch (SQLException e) {
eprintStackTrace()
}
return false
}

public boolean deleteTeaching(String key) {
Connection con DBconnectiongetConnection()
Statement stm
try {
stm concreateStatement()
String sql delete from teaching where wname like ＇ + key + ＇
Systemoutprintln(sql)
int count stmexecuteUpdate(sql)
if (count 1)
return true
else
return false
} catch (SQLException e) {
eprintStackTrace()
}
return false
}
}
3second包中类：
〔1〕Work类：类中八成员变量String idString wnameString sex
int ageString degreeString worktimeint salaryString dept十六成员方法类中分获取设置八变量worker表中八属性属性名变量应getXXX()setXXX()方法构造方法调象时成员变量赋值
Work类源代码：
package second

public class Work {
String id
String wname
String sex
int age
String degree
String worktime
int salary
String dept

public String getID() {
return id
}
public void setID(String id) {
thisid id
}
public String getWname() {
return wname
}
public void setWname(String wname) {
thiswname wname
}
public String getSex() {
return sex
}
public void setSex(String sex) {
thissex sex
}
public int getAge() {
return age
}
public void setAge(int age) {
thisage age
}
public String getDegree() {
return degree
}
public void setDegree(String degree) {
thisdegree degree
}
public String getWorktime() {
return worktime
}
public void setWorktime(String worktime) {
thisworktime worktime
}
public int getSalary() {
return salary
}
public void setSalary(int salary) {
thissalary salary
}
public String getDept() {
return dept
}
public void setDept(String dept) {
thisdept dept
}
public Work(String id String wname String sex int ageString degreeString worktimeint salaryString dept)
{
super()
thisid id
thiswname wname
thissex sex
thisage age
thisdegreedegree
thisworktimeworktime
thissalarysalary
thisdept dept
}
}
〔2〕Teaching类：类中七成员变量String idString wnameString gradeString tmajorint snumString passrateString comment十四成员方法类中分获取设置七变量teaching表中七属性属性名变量应getXXX()setXXX()方法构造方法调象时成员变量赋值
Teaching类源代码：
package second

public class Teaching {
String id
String wname
String grade
int snum
String tmajor
String passrate
String comment

public String getID() {
return id
}
public void setID(String id) {
thisid id
}
public String getWname() {
return wname
}
public void setWname(String wname) {
thiswname wname
}
public String getGrade() {
return grade
}
public void setGrade(String grade) {
thisgrade grade
}
public int getSnum() {
return snum
}
public void setSnum(int snum) {
thissnum snum
}
public String getTmajor() {
return tmajor
}
public void setTmajor(String tmajor) {
thistmajor tmajor
}
public String getPassRate() {
return passrate
}
public void setPassRate(String passrate) {
thispassrate passrate
}
public String getComment() {
return comment
}
public void setComment(String comment) {
this ment comment
}

public Teaching(String id String wname String grade String tmajorint snumString passrateString comment)
{
super()
thisid id
thiswname wname
thisgrade grade
thistmajor tmajor
thissnumsnum
thispassratepassrate
this mentcomment
}
}

4 finally包中类：
〔1〕LoginDD类：类登陆界面类界面设置两钮教职工钮理员钮两钮注册事件addActionListener分部类TeacherLoginActionListeneStudentLoginActionListener中默认方法actionPerformed〔〕中创立EmployeeDD类 ManagerDD类象翻开教职工登陆界面理员登录界面原登陆界面关闭
LoginDD类源代码：
package finallys
import javaawt*
import javaawtevent*

import javaxswing*
public class LoginDD extends JFrame{
JLabel l1
JButton bt1 bt2
Container cp

public LoginDD() {
l1 new JLabel(请选择户类型)
bt1 new JButton(教职工)
bt2 new JButton(理员)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(150 150 120 40)
p1add(l1)
bt1setBounds(120 230 80 30)
p1add(bt1)
bt2setBounds(220 230 80 30)
p1add(bt2)
bt1addActionListener(new TeacherLoginActionListener())注册事件
bt2addActionListener(new StudentLoginActionListener())注册事件
cp getContentPane()
thissetBounds(200 200 p1getHeight() p1getHeight())
cpadd(p1)
thissetTitle(户登录界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
Systemexit(0)
}
})
}
class TeacherLoginActionListener implements ActionListener{
public void actionPerformed(ActionEvent e){
new EmployeeDD()
dispose()
}
}
class StudentLoginActionListener implements ActionListener{
public void actionPerformed(ActionEvent e){
new ManagerDD()
dispose()
}
}

public static void main(String[] args) {
new LoginDD()
}
}



















截图：
图1 户登录界面

（2） ManagerDD类：类理员登陆界面界面两文框分输入理员姓名登录密码两钮登陆退出输入两文框中获取户输入容点击登陆〞钮时调Workerfirst类中managerLogin〔〕方法验证否存该户假设存创立Mainlogin类象翻开教职工简介界面进行操作假设存提示密码错误
ManagerDD类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*

import firstWorkerfirst
public class ManagerDD extends JFrame{
JLabel l1 l2
JTextField t1
JPasswordField t2
JButton bt1 bt2
Container cp

public static String st1
public String st2

public ManagerDD(){
l1 new JLabel(理员姓名)
l2 new JLabel(密码)
t1 new JTextField(12)
t2 new JPasswordField(12)
bt1 new JButton(教职工信息理)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(150 150 80 40)
p1add(l1)
t1setBounds(250 150 80 30)
p1add(t1)
l2setBounds(150 190 80 40)
p1add(l2)
t2setBounds(250 190 80 30)
p1add(t2)
bt1setBounds(150 230 150 30)
p1add(bt1)
bt2setBounds(320 230 80 30)
p1add(bt2)
bt1addActionListener(new LoginActionListener())注册事件
bt2addActionListener(new ExitActionListener())注册事件

cp getContentPane()
thissetBounds(200 200 p1getHeight() p1getHeight())
cpadd(p1)
thissetTitle(理员登录界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e)
{
Systemexit(0)
}
})
}
class LoginActionListener implements ActionListener {
public void actionPerformed(ActionEvent e) {

st1 t1getText()
st2 t2getText()
Workerfirst workerfirst new Workerfirst()
boolean isSuccess workerfirstmanagerLogin(st1 st2)
if (isSuccess) {
new Mainlogin()
dispose()
} else
JOptionPaneshowMessageDialog(null 户名密码错误 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
class ExitActionListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Systemexit(0)
}
}

public static void main(String[] args) {
new ManagerDD()

}
}









截图：
图2 理员登录界面


图3 教职工教学简介信息操作





〔3〕Managerteaching类：类教职工教学界面界面标签表格标签中ManagerDD类中获取教职工登录时户名显示标签中表示某某教职工教学信息表格中学生成绩调Teachinfirst类中queryTeaching()ArrayList象lis放入Vector象中形成表格
Managerteaching类源代码：
package finallys
import javaawt*
import javaxswing*
import *
import javautil*
import *
import javaxswingtableDefaultTableModel

import secondTeaching
import firstTeachingfirst
public class Managerteaching extends JFrame{
String aaManagerDDst1
JLabel selectionLabel
JPanel topPanel
Container container
JTable table
JScrollPane bookScrollPane
JPanel bottomPanel

public Managerteaching(){
container thisgetContentPane()
selectionLabel new JLabel(aa+老师教学情况)
topPanel new JPanel()
topPanelsetLayout(new FlowLayout(FlowLayoutCENTER))
topPaneladd(selectionLabel)
thisadd(BorderLayoutNORTH topPanel)

table new JTable()
bookScrollPane new JScrollPane(table)
thisadd(BorderLayoutCENTER bookScrollPane)
bottomPanel new JPanel()
thisadd(BorderLayoutSOUTH bottomPanel)

thissetTitle(教师教学情况查询)
thissetSize(600 450)
thissetVisible(true)

Teachingfirst teachnew Teachingfirst()
ArrayList lis teachqueryTeaching(aa)
Vector head new Vector()
headadd(职工号)
headadd(教职工姓名)
headadd(年级)
headadd(教授专业)
headadd(学生数)
headadd(格率)
headadd(教学总评)

Vector content new Vector()
for (int i 0 i < lissize() i++) {
Vector row new Vector()
Teaching teaching (Teaching) lisget(i)
rowadd(teachinggetID())
rowadd(teachinggetWname())
rowadd(teachinggetGrade())
rowadd(teachinggetTmajor())
rowadd(teachinggetSnum())
rowadd(teachinggetPassRate())
rowadd(teachinggetComment())
contentadd(row)
}
DefaultTableModel model new DefaultTableModel(content head)
tablesetModel(model)
repaint()
}
}
〔4〕EmployeeDD类：类教职工登陆界面界面两文框分输入教职工姓名密码两钮登陆退出输入两文框中获取户输入容点击登陆〞钮时调Employeefirst 类中queryEmployee〔〕方法验证否存该户假设存创立TeachQuery类象翻开教师界面假设存提示密码错误
EmployeeDD类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
import firstEmployeefirst
public class EmployeeDD extends JFrame {
JLabel l1 l2
JTextField t1
JPasswordField t2
JButton bt1 bt2
Container cp

public EmployeeDD(){
l1 new JLabel(教职工姓名)
l2 new JLabel(密码)
t1 new JTextField(12)
t2 new JPasswordField(12)
bt1 new JButton(登录)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(150 150 80 40)
p1add(l1)
t1setBounds(250 150 80 30)
p1add(t1)
l2setBounds(150 190 80 40)
p1add(l2)
t2setBounds(250 190 80 30)
p1add(t2)
bt1setBounds(150 230 80 30)
p1add(bt1)
bt2setBounds(250 230 80 30)
p1add(bt2)
bt1addActionListener(new LoginActionListener())注册事件
bt2addActionListener(new ExitActionListener())注册事件

cp getContentPane()
thissetBounds(200 200 p1getHeight() p1getHeight())
cpadd(p1)
thissetTitle(教职工登录界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e)
{
Systemexit(0)
}
})
}
class LoginActionListener implements ActionListener {
public void actionPerformed(ActionEvent e) {

String st1 t1getText()
String st2 t2getText()
Employeefirst employee new Employeefirst()
boolean isSuccess employeequeryEmployee (st1 st2)
if (isSuccess) {
new TeachQuery()
dispose()
} else
JOptionPaneshowMessageDialog(null 户名密码错误 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
class ExitActionListener implements ActionListener {
public void actionPerformed(ActionEvent e) {
Systemexit(0)
}
}

public static void main(String[] args) {
new EmployeeDD()
}
}



截图：
图4 教职工登录页面

（5） Mainlogin类：该类操作教职工信息界面类界面菜单栏三菜单：文件查询修改中文件〞菜单中退出〞菜单项点击时跳出话框问否真退出假设点击窗口关闭假设点击否回复原界面查询〞菜单中教职工信息简介信息〞教职工教学信息查询〞两菜单项：点击教职工信息简介〞时通注册事件创立ManagerQuery类象翻开查询教职工简介信息窗口点击教职工教学信息〞时通注册事件创立TeachQuery类象翻开查询教职工教学信息窗口修改菜单中添加教职工简介信息〞删教职工简介信息〞添加教职工教学信息〞删教职工教学信息〞四菜单项点击添加教职工简介信息〞时通注册事件创立ManagerAdd类象翻开添加教职工简介信息窗口点击删教职工简介信息〞时通注册事件创立ManagerDelete类象翻开删教职工简介信息窗口点击添加教职工教学信息〞时通注册事件创立TeachAdd类象翻开添加教职工教学信息窗口点击删教职工教学信息〞时通注册事件创立TeachDelete类象翻开删教职工教学窗口
Mainlogin类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
public class Mainlogin extends JFrame {
Container ctp
Mainlogin(){
ctp thisgetContentPane()
thissetTitle(欢送进入教职工教学系统)
ctpsetLayout(new BorderLayout())
JMenuBar menuBar new JMenuBar()
buildMainMenu(menuBar)
thissetJMenuBar(menuBar)
thissetBounds(100 100 400 300)
thissetVisible(true)
}
public void buildMainMenu(JMenuBar menuBar){
JMenu fileMenunew JMenu(文件)
JMenuItem exitMenuItemnew JMenuItem(退出)
exitMenuItemaddActionListener(new ExitActionListener())注册事件
fileMenuadd(exitMenuItem)
menuBaradd(fileMenu)

JMenu queryMenunew JMenu(查询)
JMenuItem queryMenuItemnew JMenuItem(教职工信息简介)
JMenuItem queryScoreMenuItemnew JMenuItem(教职工教学信息查询)
queryMenuItemaddActionListener(new QueryActionListener())注册事件
queryScoreMenuItemaddActionListener(new QueryScoreActionListener())注册事件
queryMenuadd(queryMenuItem)
queryMenuadd(queryScoreMenuItem)
menuBaradd(queryMenu)

JMenu changeMenunew JMenu(修改)
JMenuItem addMenuItemnew JMenuItem(添加教职工简介信息)
JMenuItem deleteMenuItemnew JMenuItem(删教职工简介信息)
JMenuItem addScoreMenuItemnew JMenuItem(添加教职工教学信息)
JMenuItem deleteScoreMenuItemnew JMenuItem(删教职工教学信息)
addMenuItemaddActionListener(new AddActionListener())注册事件
deleteMenuItemaddActionListener(new DeleteActionListener())注册事件
addScoreMenuItemaddActionListener(new AddScoreActionListener())注册事件
deleteScoreMenuItemaddActionListener(new DeleteScoreActionListener())注册事件
changeMenuadd(addMenuItem)
changeMenuadd(deleteMenuItem)
changeMenuadd(addScoreMenuItem)
changeMenuadd(deleteScoreMenuItem)
menuBaradd(changeMenu)
}
class ExitActionListener implements ActionListener{
public void actionPerformed(ActionEvent e) {

int result JOptionPaneshowConfirmDialog(null 真退出 提示信息
JOptionPaneYES_NO_OPTION JOptionPaneQUESTION_MESSAGE
null)
if (result 0)
Systemexit(0)
else if (result 1) {
}
}
}
class QueryScoreActionListener implements ActionListener{

public void actionPerformed(ActionEvent e) {
new TeachQuery()

}
}
class QueryActionListener implements ActionListener{
public void actionPerformed(ActionEvent e){
new ManagerQuery()

}
}
class AddActionListener implements ActionListener{
public void actionPerformed(ActionEvent e){
new ManagerAdd()
}
}
class DeleteActionListener implements ActionListener{
public void actionPerformed(ActionEvent e){
new ManagerDelete()
}
}
class AddScoreActionListener implements ActionListener{

public void actionPerformed(ActionEvent e) {
new TeachAdd()
}
}
class DeleteScoreActionListener implements ActionListener{
public void actionPerformed(ActionEvent e) {
new TeachDelete()
}
}
public static void main(String[] args) {
new Mainlogin()
}
}

截图：

图5 教职工理



〔6〕ManagerQuery类：类教职工简介信息查询界面类界面标签拉列表框文框钮点击拉列表框时选择检索方式检索属性单击时通注册事件部类方法里获取点击属性名称保存String型变量里文框中输入检索属性容单击检索〞钮时通注册事件部类方法中刚刚获取属性参数容参数传Workerfirst类queryWorker〔〕方法获取检索容检索容通Vector象放入ArrayList类象lis中检索结果显示表格中
ManagerQuery类源代码：
package finallys
import javaawt*
import javaxswing*
import javaawtevent*
import javautil*
import *
import javaxswingtable*
import secondWork
import firstWorkerfirst
public class ManagerQuery extends JFrame{
JLabel selectionLabel
JComboBox fieldComboBox
JPanel topPanel
JButton retrievalButton
JTextField keywordText
Container container
String fieldSelected
int selectedNum
JTable table
JScrollPane bookScrollPane
JPanel bottomPanel

public ManagerQuery(){
container thisgetContentPane()
selectionLabel new JLabel(检索方式)
fieldComboBox new JComboBox()
fieldComboBoxaddItem(请选择)
fieldComboBoxaddItem(职工号)
fieldComboBoxaddItem(教职工姓名)
fieldComboBoxaddItem(学历)
fieldComboBoxaddItem(院)

fieldComboBoxaddItemListener(new SelectedListener()) 拉列表框注册事件注册事件

keywordText new JTextField( 20)
retrievalButton new JButton(检索)
topPanel new JPanel()
topPanelsetLayout(new FlowLayout(FlowLayoutLEFT))
keywordTextsetSize(topPanelgetWidth() 2 topPanelgetWidth())
topPaneladd(selectionLabel)
topPaneladd(fieldComboBox)
topPaneladd(keywordText)
topPaneladd(retrievalButton)
thisadd(BorderLayoutNORTH topPanel)

retrievalButtonaddActionListener(new RetrievalActionListener())检索钮注册事件

table new JTable()
bookScrollPane new JScrollPane(table)
thisadd(BorderLayoutCENTER bookScrollPane)
bottomPanel new JPanel()
thisadd(BorderLayoutSOUTH bottomPanel)

thissetTitle(教职工简介查询)
thissetSize(600 450)
thissetVisible(true)
}

class SelectedListener implements ItemListener{

public void itemStateChanged(ItemEvent event) {
if (eventgetStateChange() ItemEventSELECTED) {
selectedNum fieldComboBoxgetSelectedIndex()获取文信息
}
}
}
class RetrievalActionListener implements ActionListener{
public void actionPerformed(ActionEvent event){
switch (selectedNum) {
case 1
fieldSelected id
break
case 2
fieldSelected wname
break
case 3
fieldSelected degree
break
case 4
fieldSelected dept
break
}
String key keywordTextgetText()
Workerfirst workerfirst new Workerfirst()
ArrayList lis workerfirstqueryWorker(fieldSelected key)

Vector head new Vector()
headadd(职工号)
headadd(教职工姓名)
headadd(性)
headadd(年龄)
headadd(学历)
headadd(参加工作时间)
headadd(工资)
headadd(院)

Vector content new Vector()
for (int i 0 i < lissize() i++) {
Vector row new Vector()
Work oneworker (Work) lisget(i)
rowadd(oneworkergetID())
rowadd(oneworkergetWname())
rowadd(oneworkergetSex())
rowadd(oneworkergetAge())
rowadd(oneworkergetDegree())
rowadd(oneworkergetWorktime())
rowadd(oneworkergetSalary())
rowadd(oneworkergetDept())
contentadd(row)
}
DefaultTableModel model new DefaultTableModel(content head)
tablesetModel(model)
repaint()
}
}
public static void main(String[] args) {
new ManagerQuery()
}
}





截图：
图6 教职工简介查询


（7） TeachQuery类：类教职工教学信息查询界面类界面标签文框钮文框中输入查询教职工单击查询〞钮时通注册事件部类方法里获取文框中获取教职工姓名信息信息作实参传Teachingfirst类queryTeaching〔〕方法查询结构查询结构通Vector象放入ArrayList类象lis中检索结果显示表格中
TeachQuery类源代码：
package finallys
import javaawt*
import javaxswing*
import javaawtevent*
import javautil*
import *
import javaxswingtableDefaultTableModel

import secondTeaching
import firstTeachingfirst
public class TeachQuery extends JFrame {
JLabel selectionLabel
JPanel topPanel
JButton retrievalButton
JTextField keywordText
Container container
String fieldSelected
int selectedNum
JTable table
JScrollPane bookScrollPane
JPanel bottomPanel

public TeachQuery(){
container thisgetContentPane()
selectionLabel new JLabel(教职工姓名)
keywordText new JTextField( 20)
retrievalButton new JButton(查询)
topPanel new JPanel()
topPanelsetLayout(new FlowLayout(FlowLayoutLEFT))
keywordTextsetSize(topPanelgetWidth() 2 topPanelgetWidth())
topPaneladd(selectionLabel)
topPaneladd(keywordText)
topPaneladd(retrievalButton)
thisadd(BorderLayoutNORTH topPanel)

retrievalButtonaddActionListener(new RetrievalActionListener())检索钮注册事件

table new JTable()
bookScrollPane new JScrollPane(table)
thisadd(BorderLayoutCENTER bookScrollPane)
bottomPanel new JPanel()
thisadd(BorderLayoutSOUTH bottomPanel)

thissetTitle(教职工教学信息查询)
thissetSize(600 450)
thissetVisible(true)
}

class RetrievalActionListener implements ActionListener{

public void actionPerformed(ActionEvent arg0) {
String key keywordTextgetText()
Teachingfirst oneScorenew Teachingfirst()
ArrayList lis oneScorequeryTeaching(key)

Vector head new Vector()
headadd(职工号)
headadd(教职工姓名)
headadd(年级)
headadd(教授专业)
headadd(学生数)
headadd(格率)
headadd(教学总评)

Vector content new Vector()
for (int i 0 i < lissize() i++) {
Vector row new Vector()
Teaching oneTeaching1 (Teaching) lisget(i)
rowadd(oneTeaching1 getID())
rowadd(oneTeaching1 getWname())
rowadd(oneTeaching1 getGrade())
rowadd(oneTeaching1 getTmajor())
rowadd(oneTeaching1 getSnum())
rowadd(oneTeaching1 getPassRate())
rowadd(oneTeaching1 getComment())
contentadd(row)
}
DefaultTableModel model new DefaultTableModel(content head)
tablesetModel(model)
repaint()
}
}
public static void main(String[] args) {
new TeachQuery()
}
}
截图：
图7 教职工教学信息查询

（8） ManagerAdd类：类信息简介表添加信息界面类界面中八标签八文框两钮添加〞退出〞根八标签提示分八文框中输入信息单击添加〞钮时通注册事件部类actionPerformed〔〕方法中获取八文框中信息转换成相应根数类型通Workerfirst类addWorker〔〕方法数写入数库worker表中
ManagerAdd类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
import firstWorkerfirst
public class ManagerAdd extends JFrame{
JLabel l1 l2 l3 l4 l5l6l7l8
JTextField t1 t2 t3 t4 t5t6t7t8
JButton bt1 bt2
public ManagerAdd() {
l1 new JLabel(职工号)
l2 new JLabel(教职工姓名)
l3 new JLabel(性)
l4 new JLabel(年龄)
l5 new JLabel(学历)
l6 new JLabel(参加工作时间)
l7 new JLabel(工资)
l8 new JLabel(院)
t1 new JTextField(12)
t2 new JTextField(10)
t3 new JTextField(10)
t4 new JTextField(10)
t5 new JTextField(10)
t6 new JTextField(25)
t7 new JTextField(25)
t8 new JTextField(25)
bt1 new JButton(添加)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(100 100 80 30)
p1add(l1)
t1setBounds(170 100 100 30)
p1add(t1)
l2setBounds(100 140 80 30)
p1add(l2)
t2setBounds(170 140 200 30)
p1add(t2)
l3setBounds(100 180 80 30)
p1add(l3)
t3setBounds(170 180 200 30)
p1add(t3)
l4setBounds(100 220 80 30)
p1add(l4)
t4setBounds(170 220 200 30)
p1add(t4)
l5setBounds(100 260 80 30)
p1add(l5)
t5setBounds(170 260 60 30)
p1add(t5)
l6setBounds(100 300 80 30)
p1add(l6)
t6setBounds(200 300 200 30)
p1add(t6)
l7setBounds(100 340 80 30)
p1add(l7)
t7setBounds(170 340 200 30)
p1add(t7)
l8setBounds(100 380 80 30)
p1add(l8)
t8setBounds(170 380 200 30)
p1add(t8)
bt1setBounds(140 420 80 30)
p1add(bt1)
bt2setBounds(280 420 80 30)
p1add(bt2)

bt1addActionListener(new AddListener())
bt2addActionListener(new CloseListener())

thissetBounds(200 200 p1getHeight() p1getHeight())
thisadd(p1)
thissetTitle(添加教职工教学信息界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() { 匿名类开始
public void windowClosing(WindowEvent e) 退出窗口语句写方法中
{
dispose()
}
})
}

class AddListener implements ActionListener{

public void actionPerformed(ActionEvent arg0) {
Workerfirst oneworkerfirst new Workerfirst()
String id t1getText()
String wname t2getText()
String sex t3getText()
int age IntegerparseInt(t4getText())
String degree t5getText()
String worktime t6getText()
int salary IntegerparseInt(t7getText())
String dept t8getText()
boolean issuccess oneworkerfirstaddWorker(id wname sexagedegreeworktimesalarydept)
if (issuccess) {

JOptionPaneshowMessageDialog(null insert success 提示信息
JOptionPaneINFORMATION_MESSAGE)
t1setText()
t2setText()
t3setText()
t4setText()
t5setText()
t6setText()
t7setText()
t8setText()
} else {
JOptionPaneshowMessageDialog(null insert failure 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
}
class CloseListener implements ActionListener{
public void actionPerformed(ActionEvent e) {
dispose()
}
}
public static void main(String[] args) {
new ManagerAdd()
}
}







截图：
图8 添加教学信息


图9 数库表改变

（9） ManagerDelete类：类删教职工简介信息界面类界面中标签文框两钮删〞退出〞根标签提示文框中输入删记录教职工姓名单击删〞钮时通注册事件部类actionPerformed〔〕方法中获取文框中信息作实参通Workerfirst类deleteWorker〔〕方法信息删假设删成功提示成功否提示失败
ManagerDelete类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
import firstWorkerfirst
public class ManagerDelete extends JFrame {
JLabel l1
JTextField t1
JButton bt1 bt2
public ManagerDelete () {
l1 new JLabel(请输入删教职工姓名：)
t1 new JTextField(20)
bt1 new JButton(确认删)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(100 100 250 50)
p1add(l1)
t1setBounds(150 200 100 30)
p1add(t1)
bt1setBounds(140 300 120 30)
p1add(bt1)
bt2setBounds(280 300 80 30)
p1add(bt2)

bt1addActionListener(new DeleteListener())
bt2addActionListener(new CloseListener())

thissetBounds(200 200 p1getHeight() p1getHeight())
thisadd(p1)
thissetTitle(删教职工界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() { 匿名类开始
public void windowClosing(WindowEvent e) 退出窗口语句写方法中
{
dispose()
} 窗口关闭
}) 匿名类结束
}
class DeleteListener implements ActionListener{
public void actionPerformed(ActionEvent arg0){
Workerfirst oneworkerfirst new Workerfirst()
String wname t1getText()
boolean issuccess oneworkerfirstdeleteWorker(wname)
if (issuccess) {

JOptionPaneshowMessageDialog(null delete success 提示信息
JOptionPaneINFORMATION_MESSAGE)
t1setText()
} else {
JOptionPaneshowMessageDialog(null delete failure 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
}
class CloseListener implements ActionListener{

public void actionPerformed(ActionEvent e) {
dispose()
}
}
public static void main(String[] args) {
new ManagerDelete ()
}
}




截图：
图 10 删前

图11 进行删操作

图12 删操作

（10） TeachAdd类：类添加教职工教学信息界面类界面中标签七文框两钮添加〞退出〞根七标签提示分七文框中输入信息单击添加〞钮时通注册事件部类actionPerformed〔〕方法中获取七文框中信息作实参转换成相应根数类型通Teachingfirst类addTeaching〔〕方法数写入数库teaching表中假设添加成功提示成功否提示失败
TeachAdd类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
import firstTeachingfirst
import firstTeachingfirst
public class TeachAdd extends JFrame {
JLabel l1 l2 l3 l4 l5l6l7
JTextField t1 t2 t3 t4 t5t6t7
JButton bt1 bt2

public TeachAdd(){
l1 new JLabel(职工号)
l2 new JLabel(教职工姓名)
l3 new JLabel(年级)
l4 new JLabel(教授专业)
l5 new JLabel(学生数)
l6 new JLabel(格率)
l7 new JLabel(教学总评)
t1 new JTextField(20)
t2 new JTextField(20)
t3 new JTextField(20)
t4 new JTextField(20)
t5 new JTextField(20)
t6 new JTextField(20)
t7 new JTextField(20)
bt1 new JButton(确认添加)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(100 100 80 30)
p1add(l1)
t1setBounds(170 100 100 30)
p1add(t1)
l2setBounds(100 140 80 30)
p1add(l2)
t2setBounds(170 140 200 30)
p1add(t2)
l3setBounds(100 180 80 30)
p1add(l3)
t3setBounds(170 180 200 30)
p1add(t3)
l4setBounds(100 220 80 30)
p1add(l4)
t4setBounds(170 220 200 30)
p1add(t4)
l5setBounds(100 260 80 30)
p1add(l5)
t5setBounds(170 260 60 30)
p1add(t5)
l6setBounds(100 300 80 30)
p1add(l6)
t6setBounds(170 300 60 30)
p1add(t6)
l7setBounds(100 340 80 30)
p1add(l7)
t7setBounds(170 340 60 30)
p1add(t7)
bt1setBounds(140 380 120 30)
p1add(bt1)
bt2setBounds(280 380 80 30)
p1add(bt2)

bt1addActionListener(new AddListener())
bt2addActionListener(new CloseListener())

thissetBounds(200 200 p1getHeight() p1getHeight())
thisadd(p1)
thissetTitle(添加教职工教学信息界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() { 匿名类开始
public void windowClosing(WindowEvent e) 退出窗口语句写方法中
{
dispose()
}
})
}
class AddListener implements ActionListener{
public void actionPerformed(ActionEvent arg0) {
Teachingfirst oneteach new Teachingfirst()
String id t1getText()
String wname t2getText()
String grade t3getText()
String tmajor t4getText()
int snum IntegerparseInt(t5getText())
String passrate t6getText()
String comment t7getText()
boolean issuccess oneteachaddTeaching(id wname grade tmajor snum passrate comment)
if (issuccess) {

JOptionPaneshowMessageDialog(null insert success 提示信息
JOptionPaneINFORMATION_MESSAGE)
t1setText()
t2setText()
t3setText()
t4setText()
t5setText()
t6setText()
t7setText()
} else {
JOptionPaneshowMessageDialog(null insert failure 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
}
class CloseListener implements ActionListener{

public void actionPerformed(ActionEvent e) {
dispose()
}
}
public static void main(String[] args) {
new TeachAdd()
}
}
截图：
图13 添加教学信息










图14 数库显示


〔11〕TeachDelete类：类删教职工教学信息界面类界面中标签文框两钮删〞退出〞根标签提示文框中输入删教学记录教职工姓名单击删〞钮时通注册事件部类actionPerformed〔〕方法中获取文框中信息作实参通Teachingfirst类deleteTeaching〔〕方法信息删假设删成功提示成功否提示失败
TeachDelete类源代码：
package finallys
import javaawt*
import javaawtevent*
import javaxswing*
import firstTeachingfirst
public class TeachDelete extends JFrame {
JLabel l1
JTextField t1
JButton bt1 bt2
public TeachDelete(){
l1 new JLabel(请输入删教学信息教职工姓名：)
t1 new JTextField(20)
bt1 new JButton(确认删)
bt2 new JButton(退出)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(100 100 250 30)
p1add(l1)
t1setBounds(150 150 100 30)
p1add(t1)
bt1setBounds(140 300 120 30)
p1add(bt1)
bt2setBounds(280 300 80 30)
p1add(bt2)

bt1addActionListener(new DeleteListener())
bt2addActionListener(new CloseListener())

thissetBounds(200 200 p1getHeight() p1getHeight())
thisadd(p1)
thissetTitle(删教职工教学信息界面)
thissetSize(400 400)
thissetVisible(true)
thisaddWindowListener(new WindowAdapter() { 匿名类开始
public void windowClosing(WindowEvent e) 退出窗口语句写方法中
{
dispose()
} 窗口关闭
}) 匿名类结束
}
class DeleteListener implements ActionListener{
public void actionPerformed(ActionEvent e) {
Teachingfirst oneteach new Teachingfirst()
String wname t1getText()
boolean issuccess oneteachdeleteTeaching(wname)
if (issuccess) {

JOptionPaneshowMessageDialog(null delete success 提示信息
JOptionPaneINFORMATION_MESSAGE)
t1setText()
} else {
JOptionPaneshowMessageDialog(null delete failure 提示信息
JOptionPaneINFORMATION_MESSAGE)
}
}
}
class CloseListener implements ActionListener{
public void actionPerformed(ActionEvent e) {
dispose()
}
}
public static void main(String[] args) {
new TeachDelete()
}
}
截图：
图15 进行删教学信息






（12） Help类：该类户提供帮助信息知道户正确职工档案理系统

Help类源代码：

package finallys
import javaawt*
import *
import javaxswing*
public class Help extends JFrame{
JLabel l1 l2 l3 l4
public Help(){
l1 new JLabel(职工档案理系统＼n)
l2 new JLabel(1选择退出系统钮退出系统＼n)
l3 new JLabel(2选择教职工信息查询教职工教学简介信息进行查询操作＼n)
l4 new JLabel(3选择教职工信息修改教职工教学简介信息进行删操作＼n)
JPanel p1 new JPanel()
p1setLayout(null)
l1setBounds(100 100 300 30)
p1add(l1)
l2setBounds(100 140 300 30)
p1add(l2)
l3setBounds(100 180 1000 30)
p1add(l3)
l4setBounds(100 220 1000 30)
p1add(l4)

thissetBounds(200 200 p1getHeight() p1getHeight())
thisadd(p1)
thissetTitle(帮助界面)
thissetSize(400 400)
thissetVisible(true)
}
public static void main(String args[]){
new Help()
}
}

截图：
表16 帮助界面

五．课程设计心体会
两年学生活接触次计算机课程实践体感受差时应该停留昧听理讲解更敢实践实践中猜发现缺乏处次做职工档案理系统拟定目标建立JAVA程序MYSQL数库程序连接数库中数进行访问终通设计户前台户界面数库操作数通前台户界面显示出
天实践活动认识开发套系统重细心定做面面俱充分考虑客户需求现实意义什系统运实际应中具现实意义次课外时间应该扩展课外知识阅读课外相关书籍者网视频样会编程力定提高初连接数库时出现问题便网搜索答案高手传数库连接方法视频操作顿时觉太low时间里真心啊
感谢张老师次认识锻炼时机然课程实践重复次样收获



六． 参考文献
Java程序设计实教程〔第四版〕电子工业出版社 叶核亚
Java 学实教程〔第三版〕 电子工业出版社 耿祥义



























文档香网(httpswwwxiangdangnet)户传

《香当网》用户分享的内容，不代表《香当网》观点或立场，请自行判断内容的真实性和可靠性！
该内容是文档的文本内容，更好的格式请下载文档