vehicle = \有\ else if(no.getState()) vehicle = \无\ sql.executeUpdate(\message SET name='\ehicle='\nceplate='\
suggest.setText(\修改成功!\ sql.close(); con.close(); } } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } }
//重置
private void reset() { jt_name.setText(\ jt_age.setText(\ jt_sex.setText(\ jt_brand.setText(\ jt_color.setText(\ jt_licenceplate.setText(\ suggest.setText(\ }
//重写单选框监听器方法 @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.GridLayout;
import java.awt.event.ActionEvent; import java.awt.event.ActionListener; 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 Deleteframe extends JFrame implements ActionListener {
//设置画板
JPanel jp1 = new JPanel(); JPanel jp2 = new JPanel(); JPanel jp3 = new JPanel(); //设置提示标签
JLabel jl_number = new JLabel(\请输入要删除的工号\ JLabel suggest = new JLabel(\ //设置可输入的单行文本域
JTextField jt_number = new JTextField(\ //设置删除返回等按钮
JButton delete = new JButton(\删除\ JButton back = new JButton(\返回\
Deleteframe() { //设置网格布局以及大小 setTitle(\删除员工记录\ setLayout(new GridLayout(3,1)); setBounds(450,200,300,200); //将组件添加至画板中 jp1.add(jl_number); jp2.add(jt_number); jp2.add(delete); jp2.add(back); jp3.add(suggest); //为按钮及单选框添加监听器 delete.addActionListener(this); back.addActionListener(this); add(jp1); add(jp2);
add(jp3); }
//重写监听器方法 @Override
public void actionPerformed(ActionEvent e) { if(e.getSource() == delete) delete(); else if(e.getSource() == back) setVisible(false); }
//删除
private void delete() { 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(\ { suggest.setText(\ sql.executeUpdate(\FROM message where number='\
suggest.setText(\删除成功!\ return; } } suggest.setText(\没有这条记录，请重新输入工号!\ sql.close(); con.close(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } }
查看员工信息界面代码：
package com.easen;
import java.awt.Dimension; import java.sql.Connection; import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JFrame; import javax.swing.JScrollPane; import javax.swing.JTable;
class Searchframe extends JFrame {
final Object[] columnname = {\姓名\工号\性别\年龄\有无车\车型号\车颜色\车牌号\
Object[][] o = new Object[40][8];
Searchframe() { setTitle(\查看记录\ setBounds(400, 100, 800, 400); JTable view = new JTable(o,columnname); view.setPreferredScrollableViewportSize(new Dimension(600,100)); view.setRowHeight(30); add(view); add(new JScrollPane(view)); try { int i = 0; Connection con = Sql_connection.getConnection(); java.sql.Statement sql = con.createStatement(); String query = \ ResultSet result = sql.executeQuery(query); while(result.next()) { o[i][0] = result.getString(\ o[i][1] = result.getString(\ o[i][2] = result.getString(\ o[i][3] = result.getString(\ o[i][4] = result.getString(\ o[i][5] = result.getString(\ o[i][6] = result.getString(\ o[i][7] = result.getString(\ i ++; } con.close(); sql.close(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } }
数据库连接代码：
package com.easen;
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
//连接数据库
class Sql_connection {
public static Connection getConnection() throws
SQLException,java.lang.ClassNotFoundException
{ String url = \ Class.forName(\ String userName = \ String password = \
Connection con = DriverManager.getConnection(url,userName,password); return con; } }
四、测试数据及运行结果
1.先查看数据库的员工数据：
2.修改工号008为有车，型号为奥迪，颜色蓝，车牌粤B12345