基于Java的企业员工车辆信息管理系统实验报告（含源文件）

Java考核

课程名称 Java程序设计 题目名称 企业车辆信息管理系统 学生学院 计算机 专业班级 学 号 学生姓名 指导教师

2015年 11 月 27 日

难度系数 独立完成工作量占总工作量的比例 程序功能完成情况 报告内容与格式 总评成绩

一、题目要求

编程实现一个简单的企业车辆信息管理系统，使其可以对员工信息进行存储，修改查询等功能。 二、程序界面 主界面：

删除员工记录窗口界面：

添加员工记录窗口界面：

查看所有员工信息窗口界面：

查询修改员工信息界面：

三、源代码

主窗口界面代码：

package com.easen;

import java.awt.BorderLayout; import java.awt.Color; import java.awt.Font;

import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.*;

public class Main {

public static void main(String[] args) {

new MyFrame(); }

{ try { //判断信息是否输入完整 if(jt_name.getText().equals(\|| jt_age.getText().equals(\|| jt_number.getText().equals(\

suggest.setText(\请完善员工信息！\ else if(yes.getState() && (jt_brand.getText().equals(\|| jt_color.getText().equals(\

suggest.setText(\请完善车辆信息！\ else { String vehicle = \ if(yes.getState()) vehicle = \有\ else if(no.getState()) vehicle = \无\ Connection con = Sql_connection.getConnection(); java.sql.Statement sql = con.createStatement(); String query = \ ResultSet result = sql.executeQuery(query); while(result.next()) { if(result.getString(\ { suggest.setText(\该工号已存在，请重新输入一个工号!\

return; } } sql.executeUpdate(\message values('\ge.getText()+\enceplate.getText()+\

suggest.setText(\添加成功!\ sql.close(); con.close(); } } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } }

//重写单选框的监听器方法 @Override

public void itemStateChanged(ItemEvent e) { if(no.getState()) { jt_brand.setText(\ jt_color.setText(\ jt_licenceplate.setText(\ jt_brand.setEditable(false); jt_color.setEditable(false); jt_licenceplate.setEditable(false); } else { jt_brand.setEditable(true); jt_color.setEditable(true); jt_licenceplate.setEditable(true); } }

}

修改查询员工信息界面代码：

package com.easen;

import java.awt.Checkbox;

import java.awt.CheckboxGroup; import java.awt.GridLayout;

import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.ItemEvent; import java.awt.event.ItemListener; import java.sql.Connection; import java.sql.ResultSet;

import java.sql.SQLException; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JTextField;

class Alterframe extends JFrame implements ActionListener, ItemListener {

//设置画板

JPanel jp0 = new JPanel(); JPanel jp1 = new JPanel(); JPanel jp2 = new JPanel(); JPanel jp3 = new JPanel(); JPanel jp4 = new JPanel(); JPanel jp5 = new JPanel(); JPanel jp6 = new JPanel(); JPanel jp7 = new JPanel(); JPanel jp8 = new JPanel(); JPanel jp9 = new JPanel();

JPanel jp10 = new JPanel(); //设置提示标签

JLabel jl_enter = new JLabel(\请输入工号\ JLabel jl_name = new JLabel(\员工姓名\ JLabel jl_sex = new JLabel(\性别\ JLabel jl_age = new JLabel(\年龄\

JLabel jl_vehicle = new JLabel(\有无车：\ JLabel jl_brand = new JLabel(\车型号\ JLabel jl_color = new JLabel(\颜色\

JLabel jl_licenceplate = new JLabel(\车牌号\ JLabel suggest = new JLabel(\ JLabel jl_yes = new JLabel(\有\ JLabel jl_no = new JLabel(\无\ //设置可输入的单行文本域

JTextField jt_enter = new JTextField(\ JTextField jt_name = new JTextField(\ JTextField jt_sex = new JTextField(\ JTextField jt_age = new JTextField(\ JTextField jt_brand = new JTextField(\ JTextField jt_color = new JTextField(\

JTextField jt_licenceplate = new JTextField(\ //设置修改返回等按钮

JButton search = new JButton(\查询\ JButton alter = new JButton(\修改\ JButton reset = new JButton(\清空\ JButton back = new JButton(\返回\ //设置单选框

CheckboxGroup cbg = new CheckboxGroup(); Checkbox yes = new Checkbox(\ Checkbox no = new Checkbox(\ Alterframe() { //设置网格布局以及大小 setTitle(\查询并修改员工信息\ setLayout(new GridLayout(10, 1)); setBounds(200, 0, 800, 800); //将组件添加至画板中 jp0.add(jl_enter); jp0.add(jt_enter); jp0.add(search); jp1.add(jl_name); jp1.add(jt_name); jp3.add(jl_sex); jp3.add(jt_sex); jp4.add(jl_age); jp4.add(jt_age); jp5.add(jl_vehicle);

jp5.add(yes); jp5.add(jl_yes); jp5.add(no); jp5.add(jl_no); jp6.add(jl_brand); jp6.add(jt_brand); jp7.add(jl_color); jp7.add(jt_color);

jp8.add(jl_licenceplate); jp8.add(jt_licenceplate); jp9.add(alter); jp9.add(reset); jp9.add(back); jp10.add(suggest);

//为按钮及单选框添加监听器 search.addActionListener(this); yes.addItemListener(this); no.addItemListener(this); alter.addActionListener(this); reset.addActionListener(this); back.addActionListener(this);

add(jp0); add(jp1); add(jp3); add(jp4); add(jp5); add(jp6); add(jp7); add(jp8); add(jp9); add(jp10); }

//重写监听器方法 @Override

public void actionPerformed(ActionEvent e) { if(e.getSource() == search) search(); else if(e.getSource() == alter) alter(); else if(e.getSource() == reset) reset(); else if(e.getSource() == back) setVisible(false); }

//查询

private void search() { try

{ suggest.setText(\ Connection con = Sql_connection.getConnection(); java.sql.Statement sql = con.createStatement(); String query = \ ResultSet result = sql.executeQuery(query); while(result.next()) { if(result.getString(\ { jt_name.setText(result.getString(\ //jt_number.setText(result.getString(\ jt_sex.setText(result.getString(\ jt_age.setText(result.getString(\ jt_brand.setText(result.getString(\ jt_color.setText(result.getString(\ jt_licenceplate.setText(result.getString(\ if(result.getString(\有\ yes.setState(true); else no.setState(true); suggest.setText(\ return; } } suggest.setText(\没有这条记录,请重新输入工号!\ } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } }

//修改

private void alter() { try { Connection con = Sql_connection.getConnection(); java.sql.Statement sql = con.createStatement(); if(jt_name.getText().equals(\|| jt_age.getText().equals(\jt_sex.getText().equals(\

suggest.setText(\请完善员工信息!\ else if(yes.getState() && (jt_brand.getText().equals(\jt_color.getText().equals(\

suggest.setText(\请完善车辆信息!\ else { String vehicle = \ if(yes.getState())

||

||

本文来源：https://www.bwwdw.com/article/6pth.html