JBuilder做的员工管理系统

package test; import javax.swing.*; import java.awt.*; import java.awt.event.*; import com.borland.jbcl.layout.*; import java.sql.*; /** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2010</p> * <p>Company: </p> * @author not attributable * @version 1.0 */ public class Add extends JFrame { TextField textField1 = new TextField(); TextField textField2 = new TextField(); TextField textField3 = new TextField(); TextField textField4 = new TextField(); TextField textField5 = new TextField(); TextField textField6 = new TextField(); TextField textField7 = new TextField(); TextField textField8 = new TextField(); XYLayout xYLayout1 = new XYLayout(); TextField textField9 = new TextField(); Button button2 = new Button(); JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JLabel jLabel5 = new JLabel(); JLabel jLabel6 = new JLabel(); JLabel jLabel7 = new JLabel(); JLabel jLabel8 = new JLabel(); JLabel jLabel9 = new JLabel(); public Add() { setBak(); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } private void jbInit() throws Exception { this.getContentPane().setLayout(xYLayout1); textField1.setBackground(SystemColor.inactiveCaption); textField1.setColumns(10); textField1.setText(""); textField2.setBackground(SystemColor.inactiveCaption); textField2.setColumns(10); textField2.setText(""); textField2.addActionListener(new Add_textField2_actionAdapter(this)); textField3.setBackground(SystemColor.inactiveCaption); textField3.setColumns(10); textField3.setText(""); textField4.setBackground(SystemColor.inactiveCaption); textField4.setColumns(27); textField4.setText(""); textField5.setBackground(SystemColor.inactiveCaption); textField5.setColumns(24); textField5.setText(""); textField6.setBackground(SystemColor.inactiveCaption); textField6.setColumns(10); textField6.setText(""); textField7.setBackground(SystemColor.inactiveCaption); textField7.setColumns(10); textField7.setText(""); textField8.setBackground(SystemColor.inactiveCaption); textField8.setColumns(27); textField8.setText(""); textField9.setBackground(SystemColor.inactiveCaption); textField9.setSelectionStart(10); button2.setBackground(SystemColor.activeCaptionBorder); button2.setFont(new java.awt.Font("Dialog", 0, 20)); button2.setLabel("录入"); button2.addActionListener(new Add_button2_actionAdapter(this)); xYLayout1.setWidth(533); xYLayout1.setHeight(392); jLabel1.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel1.setText("编号："); jLabel2.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel2.setText("姓名："); jLabel3.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel3.setText("部门："); jLabel4.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel4.setText("性别："); jLabel5.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel5.setText("职位："); jLabel6.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel6.setText("工资："); jLabel7.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel7.setText("电话："); jLabel8.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel8.setText("家庭住址："); jLabel9.setFont(new java.awt.Font("Dialog", 0, 20)); jLabel9.setText("备注："); this.getContentPane().add(textField2, new XYConstraints(364, 13, 106, -1)); this.getContentPane().add(textField3, new XYConstraints(364, 55, 108, -1)); this.getContentPane().add(textField9, new XYConstraints(125, 52, 113, 24)); this.getContentPane().add(textField6, new XYConstraints(123, 91, 114, -1)); this.getContentPane().add(textField1, new XYConstraints(126, 15, 112, 25)); this.getContentPane().add(textField7, new XYConstraints(365, 89, 106, -1)); this.getContentPane().add(textField4, new XYConstraints(121, 127, 350, -1)); this.getContentPane().add(textField8, new XYConstraints(118, 208, 351, -1)); this.getContentPane().add(textField5, new XYConstraints(120, 166, 350, -1)); this.getContentPane().add(jLabel1, new XYConstraints(32, 6, 62, 40)); this.getContentPane().add(jLabel2, new XYConstraints(279, 8, 70, 39)); this.getContentPane().add(jLabel4, new XYConstraints(30, 47, 74, 37)); this.getContentPane().add(jLabel5, new XYConstraints(30, 85, 77, 36)); this.getContentPane().add(jLabel3, new XYConstraints(278, 46, 76, 37)); this.getContentPane().add(jLabel6, new XYConstraints(277, 84, 75, 33)); this.getContentPane().add(jLabel7, new XYConstraints(27, 120, 64, 39)); this.getContentPane().add(jLabel8, new XYConstraints(10, 157, 101, 40)); this.getContentPane().add(jLabel9, new XYConstraints(27, 198, 61, 41)); this.getContentPane().add(button2, new XYConstraints(198, 271, 96, -1)); } public void setBak(){ ((JPanel)this.getContentPane()).setOpaque(false); ImageIcon img = new ImageIcon("3.jpg"); JLabel background = new JLabel(img);this.getLayeredPane().add(background, new Integer(Integer.MIN_VALUE)); background.setBounds(0, 0, img.getIconWidth(), img.getIconHeight()); } void button2_actionPerformed(ActionEvent e) { String m2m=""; if(textField1.getText().equals("")||textField2.getText().equals("")|| textField3.getText().equals("")||textField4.getText().equals("")||textField5.getText().equals("") ||textField6.getText().equals("")||textField7.getText().equals("")){ m2m += "请输入员工信息,返回！"; JOptionPane.showMessageDialog(this,m2m);} else{ /*连接数据库*/ String url = "jdbc:odbc:PMS"; //取得连接的url名，注是access的dsn名 Connection con; //实例化一个Connection对象 Statement stmt; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载jdbc-odbc桥驱动 } catch(java.lang.ClassNotFoundException ee) { System.err.print("ClassNotFoundException: "); //加载jdbc-odbc桥错误 System.err.println(ee.getMessage()); //其他错误 } try { con = DriverManager.getConnection(url); //数据库连接 stmt = con.createStatement(); String strInsert="INSERT INTO 员工信息表 (员工编号,姓名,性别,所在部门,职位,家庭住址,电话,基本工资) VALUES ('"+textField1.getText().toString()+ "','"+textField2.getText().toString()+"','"+textField9.getText().toString()+"','"+textField3.getText().toString()+ "','"+textField6.getText().toString()+"','"+textField5.getText().toString()+"','"+textField4.getText().toString()+ "','"+textField7.getText().toString()+"' )"; stmt.execute(strInsert); String pop = ""; pop += "增加的员工信息为："; pop +="\n"; pop +=textField1.getText().toString(); pop +="\n"; pop +=textField2.getText().toString(); pop +="\n"; pop +=textField9.getText().toString(); pop +="\n"; pop +=textField3.getText().toString(); pop +="\n"; pop +=textField6.getText().toString(); pop +="\n"; pop +=textField7.getText().toString(); pop +="\n"; pop +=textField4.getText().toString(); pop +="\n"; pop +=textField5.getText().toString(); pop +="\n"; JOptionPane.showMessageDialog(this