ssm二手信息交易系统.rar

/* * CommAdd.java * * Created on __DATE__, __TIME__ */ package hzu.com.cn.view; import hzu.com.cn.dao.ComTypeDao; import hzu.com.cn.dao.CommDao; import hzu.com.cn.model.Comm; import hzu.com.cn.util.Dbutil; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JOptionPane; /** * * @author __USER__ */ public class CommAdd extends javax.swing.JInternalFrame { /** Creates new form CommAdd */ String id; public CommAdd() { initComponents(); jComboBox1.removeAllItems(); Connection connection = null; Dbutil dbutil = new Dbutil(); ComTypeDao comTypeDao = new ComTypeDao(); try { connection = dbutil.getCon(); ResultSet resultSet = comTypeDao.GettypeResultSet(connection); while (resultSet.next()) { jComboBox1.addItem(resultSet.getString(2) + ""); } jComboBox2.removeAllItems(); for (int i = 2000; i < 2017; i++) { jComboBox2.addItem(i + ""); } jComboBox3.removeAllItems(); for (int i = 1; i < 13; i++) { jComboBox3.addItem(i + ""); } jRadioButton1.setSelected(true); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public CommAdd(String s) { initComponents(); id = s; jComboBox1.removeAllItems(); Connection connection = null; Dbutil dbutil = new Dbutil(); ComTypeDao comTypeDao = new ComTypeDao(); try { connection = dbutil.getCon(); ResultSet resultSet = comTypeDao.GettypeResultSet(connection); while (resultSet.next()) { jComboBox1.addItem(resultSet.getString(2) + ""); } jComboBox2.removeAllItems(); for (int i = 2000; i < 2017; i++) { jComboBox2.addItem(i + ""); } jComboBox3.removeAllItems(); for (int i = 1; i < 13; i++) { jComboBox3.addItem(i + ""); } jRadioButton1.setSelected(true); CommDao commDao = new CommDao(); int k = Integer.parseInt(s); ResultSet resultSet1 = commDao.GetComResultSet(connection, k); if (resultSet1.next()) { jTextField1.setText(resultSet1.getString(2)); jTextArea1.setText(resultSet1.getString(3)); jTextField2.setText(resultSet1.getFloat(6) + ""); jTextField3.setText(resultSet1.getInt(5) + ""); jTextField4.setText(resultSet1.getString(7)); jTextField5.setText(resultSet1.getFloat(8) + ""); jComboBox1.setSelectedItem(resultSet1.getString(4)); jComboBox2.setSelectedItem(resultSet1.getInt(10)); jComboBox3.setSelectedItem(resultSet1.getString(11)); } else { JOptionPane.showMessageDialog(null, "错误"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); JOptionPane.showMessageDialog(null, e.getMessage()); } finally { try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } jButton1.setText("修改"); } public CommAdd(String s,int uu) { initComponents(); id = s; jComboBox1.removeAllItems(); Connection connection = null; Dbutil dbutil = new Dbutil(); ComTypeDao comTypeDao = new ComTypeDao(); try { connection = dbutil.getCon(); ResultSet resultSet = comTypeDao.GettypeResultSet(connection); while (resultSet.next()) { jComboBox1.addItem(resultSet.getString(2) + ""); } jComboBox2.removeAllItems(); for (int i = 2000; i < 2017; i++) { jComboBox2.addItem(i + ""); } jComboBox3.removeAllItems(); for (int i = 1; i < 13; i++) { jComboBox3.addItem(i + ""); } jRadioButton1.setSelected(true); CommDao commDao = new CommDao(); int k = Integer.parseInt(s); ResultSet resultSet1 = commDao.GetComResultSet(connection, k); if (resultSet1.next()) { jTextField1.setText(resultSet1.getString(2)); jTextArea1.setText(resultSet1.getString(3)); jTextField2.setText(resultSet1.getFloat(6) + ""); jTextField3.setText(resultSet1.getInt(5) + ""); jTextField4.setText(resultSet1.getString(7)); jTextField5.setText(resultSet1.getFloat(8) + ""); jComboBox1.setSelectedItem(resultSet1.getString(4)); jComboBox2.setSelectedItem(resultSet1.getInt(10)); jComboBox3.setSelectedItem(resultSet1.getString(11)); } else { JOptionPane.showMessageDialog(null, "错误"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); JOptionPane.showMessageDialog(null, e.getMessage()); } finally { try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } jButton1.setVisible(false); } /** This method is called from within the constructor to * initialize the form. * WARNING: Do NOT modify this code. The content of this method is * always regenerated by the Form Editor. */ //GEN-BEGIN:initComponents // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); jComboBox1 = new javax.swing.JComboBox(); jLabel2 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jScrollPane1 = new javax.swing.JScrollPane(); jTextArea1 = new javax.swing.JTextArea(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jTextField2 = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); jTextField3 = new javax.swing.JTextField(); jLabel6 = new javax.swing.JLabel(); jComboBox2 = new javax.swing.JComboBox(); jLabel7 = new javax.swing.JLabel(); jComboBox3 = new javax.swing.JComboBox(); jLabel8 = new javax.swing.JLabel(); jTextField4 = new javax.swing.JTextField(); jLabel9 = new javax.swing.JLabel(); jTextField5 = new javax.swing.JTextField(); jLabel10 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jRadioButton1 = new javax.swing.JRadioButton(); jRadioButton2 = new javax.swing.JRadioButton(); setClosable(true); setIconifiable(true); jLabel1.setText("\u5546\u54c1\u7c7b\u578b\u540d"); jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); jLabel2.setText("\u5546\u54c1\u540d"); jTextArea1.setColumns(20); jTextArea1.setRows(5); jScrollPane1.setViewportView(jTextArea1); jLabel3.setText("\u5546\u54c1\u63cf\u8ff0"); jLabel4.setText("\u5355\u4ef7"); jLabel5.setText("\u6570\u91cf"); jLabel6.setText("\u5546\u54c1\u751f\u4ea7\u65e5\u671f \u5e74"); jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); jLabel7.setText("\u6708"); jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); jLabel8.setText("\u8054\u7cfb\u4eba"); jLabel9.setText("\u7535\u8bdd\u53f7\u7801"); jLabel10.setText("\u6027\u522b"); jButton1.setText("\u63d0\u4ea4"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setText("\u53d6\u6d88"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jRadioButton1.setText("\u7537"); jRadioButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton1ActionPerformed(evt); } }); jRadioButton2.setText("\u5973"); jRadioButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton2ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout( getContentPane()); getContentPane().setLayout(layout); layout .setH