{ 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())
||
||