1、 String user = jTextField1.getText().trim(); String password = jTextField2.getText().trim(); if (user.equals(wsm) & password.equals() new yuangongxinxiguanli().setVisible(true); setVisible(false); else JOptionPane.showMessageDialog(null, 请正确输入!); public static void main(String args) java.awt.EventQu
2、eue.invokeLater(new Runnable() public void run() new denglu().setVisible(true); );员工信息关系系统界面:package 人事管理系统;public class yuangongxinxiguanli extends javax.swing.JFrame public yuangongxinxiguanli() initComponents(); setLocation(450,220); SuppressWarnings(unchecked) / private void initComponents() jBu
3、tton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); jButton4 = new javax.swing.JButton(); jButton5 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jButton1
4、.setText(查询员工信息 jButton1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent evt) jButton1ActionPerformed(evt); jButton2.setText(添加员工信息 jButton2.addActionListener(new java.awt.event.ActionListener() jButton2ActionPerformed(evt); jButton3.setTe
5、xt(删除员工信息 jButton3.addActionListener(new java.awt.event.ActionListener() jButton3ActionPerformed(evt); jLabel1.setFont(new java.awt.Font(宋体, 0, 24); / NOI18N jLabel1.setText(员工信息管理系统 jButton4.setText(修改员工信息 jButton4.addActionListener(new java.awt.event.ActionListener() jButton4ActionPerformed(evt);
6、jButton5.setText(退出系统 jButton5.addActionListener(new java.awt.event.ActionListener() jButton5ActionPerformed(evt); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane(); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.Grou
7、pLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGap(91, 91, 91) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton1, javax.swing.GroupLayo
8、ut.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_V
9、ALUE) .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGap(47, 47, 47) .addComponent(jLabel1) .addContainerGap(
10、52, Short.MAX_VALUE) ); layout.setVerticalGroup( .addGap(14, 14, 14) .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SI
11、ZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE) .addCompo
12、nent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(36, Short.MAX_VALUE) pack(); / chaxun ch=new chaxun(); ch.setVisible(true);
13、ch.setLocation(400,220); private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) tianjia ti=new tianjia(); ti.setVisible(true); ti.setLocation(400,220);/ TODO add your handling code here: private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) xiugai xi=new xiugai(); xi.set
14、Visible(true); xi.setLocation(400,220); private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) shanchu sh=new shanchu(); sh.setVisible(true); sh.setLocation(400,220); private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) System.exit(0); / Variables declaration - do not m
15、odify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JLabel jLabel1; / End of variables declaration 查询按钮代码:可选择项查询按钮代码: try String xuanze=
16、 jComboBox1.getSelectedItem().toString().trim(); String tianxie=jTextField1.getText().trim(); Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver String url=jdbc:microsoft:sqlserver: + /127.0.0.1:1433;DatabaseName=员工信息管理库; Connection con=DriverManager.getConnection(url,sa,900526 java.sql.Stat
17、ement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(select * from 员工 where +xuanze+=+tianxie+ DefaultTableModel dt=(DefaultTableModel) jTable1.getModel(); dt.getDataVector().clear(); dt.fireTableDataChanged(); while(rs.next () Vector v1=new Vector(); v1.add(rs.getString(1); v1.add(rs.ge
18、tString(2); v1.add(rs.getString(3); v1.add(rs.getString(4); v1.add(rs.getString(5); v1.add(rs.getString(6); v1.add(rs.getString(7); dt.addRow(v1); rs.close(); stmt.close(); con.close(); catch (ClassNotFoundException ex) ex.getMessage(); catch(SQLException ex)查询全部信息按钮代码:try select * from 员工 Logger.ge
19、tLogger(chaxun.class.getName().log(Level.SEVERE, null, ex); new chaxun().setVisible(true);添加界面代码: try String yuangonghao = jtf_yuangonghao.getText().trim(); String phonenumber = jtf_phonenumber.getText().trim(); String name = jtf_name.getText().trim(); String age = jtf_age.getText().trim(); String s
20、ex = jtf_sex.getText().trim(); String post = jtf_post.getText().trim(); String pay = jtf_pay.getText().trim(); String url = Connection con = DriverManager.getConnection(url, , String str=insert into 员工 values(?,?) PreparedStatement stmt = con.prepareStatement(str); stmt.setString(1,yuangonghao); stmt.setString(2,name); stmt.setString(3,age); stmt.setString(4,sex); stmt.setString(5,post); stmt.setString(6,phonenumber); stmt.setString(7,pay); ResultSet rs=stmt.executeQuery(); catch (SQLException ex) if (ex.getSQLState().equals(HY000添加成功 if(ex.getSQLState().equals(23000) JOptionPan
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1