tsmanage.java

小区物业管理系统（java版） java swing + access 2003

/*
 * TSManage.java
 *
 * Created on 2006年5月1日, 上午11:06
 */

package KHSManage;
import java.awt.*;
import mySql.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
/**
 *
 * @author  wang
 */
public class TSManage extends javax.swing.JFrame {
    boolean addFlag=false;
    boolean modifyFlag=false;
    ResultSet rs=null;
    DefaultTableModel TSData;
    DBSQLManager db=new DBSQLManager();
    java.util.Date submitDate=new java.util.Date();
    String submitTime=(submitDate.getYear()+1900)+"-"+(submitDate.getMonth()+1)+"-"+submitDate.getDate();//提交投诉时间
    /** Creates new form TSManage */
    public TSManage() {
        super("客户投诉");
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();//更新界面
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception e){
            System.err.println("异常："+e);
        }
        initComponents();
        setSize(540,550);
        Dimension screen=getToolkit().getScreenSize();
        setLocation((screen.width-getSize().width)/2, (screen.height-getSize().height)/2);
        displayTable();
    }
    private void displayTable(){
        String sql="select * from tsInfo";       
        try{
            String data[]=new String[7];
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                data[0]=new Integer(rs.getInt("tsCode")).toString();
                data[1]=tsKind.getItemAt(rs.getInt("tsKind")).toString();
                data[2]=rs.getString("tsTitle");
                data[3]=rs.getString("roomCode");
                data[4]=rs.getString("tsName");
                data[5]=rs.getString("tsTime");
                data[6]=rs.getString("jdName");
                TSData.addRow(data);                
            }
        }
        catch(Exception e){
            System.out.println("初始化表格显示异常:"+e);
        }
    }
    private void enabledTools(){
        tsTitle.setEnabled(true);roomCode.setEnabled(true);
        tsKind.setEnabled(true);tsName.setEnabled(true);
        tel.setEnabled(true);tsTime.setEnabled(true);
        jdName.setEnabled(true);tsContent.setEnabled(true);
        tsResult.setEnabled(true);        
    }
    private void disabledTools(){
        tsTitle.setEnabled(false);roomCode.setEnabled(false);
        tsKind.setEnabled(false);tsName.setEnabled(false);
        tel.setEnabled(false);tsTime.setEnabled(false);
        jdName.setEnabled(false);tsContent.setEnabled(false);
        tsResult.setEnabled(false);        
    }
    private void clearTools(){  //清空输入
        tsTitle.setText("");roomCode.setText("");
        tsKind.setSelectedIndex(0);
        tsName.setText("");tel.setText("");
        tsTime.setText("");jdName.setText("");
        tsContent.setText("");tsResult.setText("");
    }
    private void insert(){       
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");               
               String sql="insert into tsInfo(tsTitle,roomCode,tsKind,tsName,tel,tsTime,jdName,tsContent,tsResult) values(?,?,?,?,?,?,?,?,?)";
               PreparedStatement pre=conn.prepareCall(sql);               
               pre.clearParameters();
               pre.setString(1,tsTitle.getText().trim());
               pre.setString(2,roomCode.getText().trim());
               pre.setInt(3, tsKind.getSelectedIndex());
               pre.setString(4, tsName.getText().trim());
               pre.setString(5, tel.getText().trim());
               pre.setString(6, submitTime);
               pre.setString(7, jdName.getText().trim());
               pre.setString(8, tsContent.getText().trim());
               pre.setString(9, tsResult.getText().trim());
               int flag=pre.executeUpdate();
               if(flag==1){
                   JOptionPane.showMessageDialog(this,"添加投诉信息成功","更新",JOptionPane.INFORMATION_MESSAGE);
               }              
        }
        catch(Exception e){
                   JOptionPane.showMessageDialog(this,"添加投诉信息失败","更新",JOptionPane.ERROR_MESSAGE);
                   System.out.println("添加投诉信息异常："+e);
        }        
    }
    private void query(int key){  //查询投诉信息
        String sql="select * from tsInfo where tsCode="+key;//查询投诉信息的sql语句
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                   tsCode.setText(rs.getString("tsCode").trim());
                   tsTitle.setText(rs.getString("tsTitle").trim());
                   roomCode.setText(rs.getString("roomCode"));
                   tsKind.setSelectedIndex(rs.getInt("tsKind"));
                   tsName.setText(rs.getString("tsName").trim());
                   tel.setText(rs.getString("tel").trim());
                   tsTime.setText(rs.getString("tsTime").trim());
                   jdName.setText(rs.getString("jdName"));
                   tsContent.setText(rs.getString("tsContent").trim());
                   tsResult.setText(rs.getString("tsResult").trim());
            }
        }
        catch(Exception e){
            System.out.println("查询投诉信息异常："+e);
        }
    }
    private void update(){
        String sql="update tsInfo set tsTitle=?,roomCode=?,tsKind=?,tsName=?,tel=?,tsTime=?,jdName=?,tsContent=?,tsResult=?   where tsCode=?";
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
               PreparedStatement pre=conn.prepareCall(sql);
               pre.clearParameters();
               pre.setString(1,tsTitle.getText().trim());
               pre.setString(2,roomCode.getText().trim());
               pre.setInt(3,tsKind.getSelectedIndex());
               pre.setString(4,tsName.getText().trim());
               pre.setString(5,tel.getText().trim());           
               pre.setString(6,tsTime.getText().trim());
               pre.setString(7,jdName.getText().trim());
               pre.setString(8, tsContent.getText().trim());
               pre.setString(9, tsResult.getText().trim());
               pre.setInt(10, Integer.valueOf(tsCode.getText()).intValue());
               int flag=pre.executeUpdate();
               if(flag==1){
                   JOptionPane.showMessageDialog(this,"更新投诉信息成功","更新",JOptionPane.INFORMATION_MESSAGE);
               }             
            }
        catch(Exception e){
            JOptionPane.showMessageDialog(this,"更新投诉信息失败","更新",JOptionPane.ERROR_MESSAGE);
            System.out.println("更新投诉信息异常："+e);
        }
    }
    private void delete(int key){
            String sql="delete from tsInfo where tsCode="+key;            
            try{
               db.setSql(sql);
               db.executeUpdate();              
            }
            catch(Exception e){
                   JOptionPane.showMessageDialog(this,"删除投诉信息异常","删除错误",JOptionPane.ERROR_MESSAGE);
                   System.out.println("删除投诉信息异常："+e);
            }
     }
    private boolean check(){
        String roomCode1=roomCode.getText().trim();
        if(roomCode1.equals("")){
             JOptionPane.showMessageDialog(this,"房间代码不能为空","添加错误",JOptionPane.INFORMATION_MESSAGE);
             return false;
        }                
        else{
            return true;
        }
    }
    /** 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.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        jSearchPanel = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        kind = new javax.swing.JComboBox();
        search = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        TSTable = new javax.swing.JTable();
        jPanel1 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        tsCode = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        tsTitle = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        roomCode = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        tsKind = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        tsName = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        tel = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        tsTime = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        jdName = new javax.swing.JTextField();
        jLabel11 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        tsContent = new javax.swing.JTextArea();
        jLabel12 = new javax.swing.JLabel();
        jScrollPane3 = new javax.swing.JScrollPane();
        tsResult = new javax.swing.JTextArea();
        jPanel2 = new javax.swing.JPanel();
        add = new javax.swing.JButton();
        modify = new javax.swing.JButton();
        save = new javax.swing.JButton();
        dispose = new javax.swing.JButton();
        delete = new javax.swing.JButton();
        quit = new javax.swing.JButton();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        jLabel1.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel1.setText("\u5ba2\u6237\u6295\u8bc9");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(10, 10, 100, 30);

        jSearchPanel.setLayout(null);

        jSearchPanel.setBorder(new javax.swing.border.EtchedBorder());
        jLabel2.setText("\u6295\u8bc9\u7c7b\u522b:");
        jSearchPanel.add(jLabel2);
        jLabel2.setBounds(30, 15, 54, 15);

        kind.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "<全部>", "治安", "卫生", "其他" }));
        jSearchPanel.add(kind);
        kind.setBounds(100, 13, 90, 20);

        search.setText("\u67e5\u770b");
        search.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                searchActionPerformed(evt);
            }
        });

        jSearchPanel.add(search);
        search.setBounds(360, 13, 70, 23);

        getContentPane().add(jSearchPanel);
        jSearchPanel.setBounds(10, 40, 510, 50);

        jScrollPane1.setViewportBorder(new javax.swing.border.EtchedBorder());
        TSTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        TSData=new DefaultTableModel();
        TSData.addColumn("序号");
        TSData.addColumn("类别");
        TSData.addColumn("标题");
        TSData.addColumn("房号");
        TSData.addColumn("投诉人");
        TSData.addColumn("投诉时间");
        TSData.addColumn("接待人");
        TSTable.setModel(TSData);
        TSTable.setCellSelectionEnabled(false);
        TSTable.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseReleased(java.awt.event.MouseEvent evt) {
                TSTableMouseReleased(evt);
            }
        });

        jScrollPane1.setViewportView(TSTable);

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(10, 100, 510, 120);

        jPanel1.setLayout(null);

        jPanel1.setBorder(new javax.swing.border.EtchedBorder());
        jLabel3.setText("\u6295\u8bc9\u7f16\u53f7:");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(10, 10, 54, 15);

        tsCode.setEnabled(false);
        jPanel1.add(tsCode);
        tsCode.setBounds(70, 10, 70, 20);

        jLabel4.setText("\u6807\u9898:");
        jPanel1.add(jLabel4);
        jLabel4.setBounds(160, 10, 30, 15);

        tsTitle.setEnabled(false);
        jPanel1.add(tsTitle);
        tsTitle.setBounds(210, 10, 80, 20);

        jLabel5.setText("\u623f\u95f4\u53f7*:");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(300, 10, 50, 15);

        roomCode.setEnabled(false);
        jPanel1.add(roomCode);