?? memberjdialog.java
字號:
/* *文件名：memberJDialog.java * 說明：客人信息的查詢和會員的添加 */package com.redingsoft.customerinfo;import com.redingsoft.locationutil.LocationUtil;import com.redingsoft.sql.SetSQL;import com.redingsoft.sunsdk.swing.OJButton;import com.redingsoft.sunsdk.swing.xtwh_table;import java.awt.BorderLayout;import java.awt.Color;import java.awt.Dimension;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.util.logging.Level;import java.util.logging.Logger;import javax.swing.*;import javax.swing.table.*;/** * * @author Administrator */public class memberJDialog extends JDialog implements ActionListener{ //聲明面板 JPanel topPane,centerPane,bottPane,setPane,mainPane; //聲明一個滾動面板 JScrollPane sp1,sp2; //聲明4個按鈕 JButton bt1,bt2,bt3,bt4; //聲明標簽 JLabel jl1,jl2,jl3; //聲明一個表格 JTable tb1,tb2; //聲明一個文本框 JTextField tf1; //聲明表模式 DefaultTableModel dftm1,dftm2; //聲明2個數組初始化表格 String[] cols={"會員編號","會員姓名","性別","電話","地址","備注"}; String rows[][]=new String[5][6]; //構造函數 public memberJDialog(){ //實例化面板 topPane=new JPanel(); centerPane=new JPanel(); bottPane=new JPanel(); mainPane=new JPanel(); setPane=new JPanel(); //設置面板的初始大小 centerPane.setPreferredSize(new Dimension(500,100)); bottPane.setPreferredSize(new Dimension(500,180)); topPane.setPreferredSize(new Dimension(400,50)); setPane.setPreferredSize(new Dimension(490,50)); //實例化標簽 jl1=new JLabel("輸入要查詢的會員姓名"); //實例化文本框 tf1=new JTextField(15); //實例化表模式 dftm1= new DefaultTableModel(){ @Override public boolean isCellEditable(int row, int column) { return false; } }; dftm2= new xtwh_table(rows,cols); //實例化表格 tb1=new JTable(); tb2=new JTable(); //初始化表格 initTabel(); initTabel2(); //實例化滾動面板 sp1=new JScrollPane(tb1); sp2=new JScrollPane(tb2); //設置滾動面板的初始大小 sp1.setPreferredSize(new Dimension(490,120)); sp2.setPreferredSize(new Dimension(490,120)); //實例化按鈕 bt1=new OJButton("com/redingsoft/pic/find.gif","查詢","查詢會員詳細信息",true); bt2=new OJButton("com/redingsoft/pic/b1.gif","刷新","刷新會員詳細信息",true); bt3=new OJButton("com/redingsoft/pic/cancel.gif","刪除","刪除會員",true); bt4=new OJButton("com/redingsoft/pic/add.gif","添加","添加會員",true); //吧組件添加到面板上 topPane.add(jl1); topPane.add(tf1); topPane.add(bt1); topPane.add(bt2); setPane.add(bt3); setPane.add(bt4); centerPane.add(sp1); centerPane.add(setPane); bottPane.add(sp2); //設置左面板的參數 topPane.setBorder(BorderFactory.createLineBorder(Color.DARK_GRAY, 1)); centerPane.setBorder(BorderFactory.createTitledBorder("全部會員信息")); //設置又面板的參數 bottPane.setBorder(BorderFactory.createLineBorder(Color.DARK_GRAY, 1)); bottPane.setBorder(BorderFactory.createTitledBorder("查詢會員的信息")); // bottPane.setBorder(BorderFactory.createLineBorder(Color.DARK_GRAY, 1)); //添加到主面板上 //定義邊界布局 BorderLayout border=new BorderLayout(10,10); mainPane.setLayout(border); mainPane.add(BorderLayout.NORTH,topPane); mainPane.add(BorderLayout.CENTER,centerPane); // mainPane.add(BorderLayout.CENTER,centerPane); mainPane.add(BorderLayout.SOUTH,bottPane); this.add(mainPane); //添加偵聽 AddListener(); this.setBounds(0, 0, 600, 500); this.setResizable(false); this.setDefaultCloseOperation(DISPOSE_ON_CLOSE); // } //初始化表格/* * 函數名：public void initTabel() * 參數：null * 返回值：void * 功能：制作并初始化表格 ***********************************/public void initTabel(){ //設置表格的模式 String sql="select m_id 會員編號,m_name 會員姓名,m_sex 會員性別, m_tel 會員電話,m_adress 會員地址,remark 會員備注 from member where delmark=0"; // datamodel.fireTableDataChanged(); //初始化表表模式 SetSQL.initDTM(dftm1,sql); /* if(dftm1.getRowCount()!=0){ //設置表模型 tb1.setModel(dftm1); } */ tb1.setModel(dftm1); // tb=new JTable(); tb1.setRowHeight(20); tb1.setPreferredSize(new Dimension(490,500)); } //初始化表格/* * 函數名：public void initTabel() * 參數：null * 返回值：void * 功能：制作并初始化表格 ***********************************/public void initTabel2(){ //設置表格的模式 String name=tf1.getText().trim(); String sqls="select m_id 會員編號,m_name 會員姓名,m_sex 會員性別, m_tel 會員電話,m_adress 會員地址,remark 會員備注 from member where m_name='"+name+"'"; // datamodel.fireTableDataChanged(); //初始化表表模式 SetSQL.initDTM(dftm2,sqls); tb2.setModel(dftm2); tb2.setRowHeight(20); tb2.setPreferredSize(new Dimension(490,500)); }//#################################################################33//添加事件偵聽private void AddListener(){ bt1.addActionListener(this); //查詢 bt2.addActionListener(this); //刷新 bt3.addActionListener(this); //刪除 bt4.addActionListener(this); //添加}/***************************************public static void main(String[] args){new memberJDialog();}*****************************************/ public void actionPerformed(ActionEvent e) { // throw new UnsupportedOperationException("Not supported yet."); Object o=e.getSource(); int n=0; if(o==bt1){//查詢 ResultSet rs=null; String name=tf1.getText().trim(); String sql="select m_id from member where m_name='"+name+"'"; //獲得返回結果驗證是否存在此數據 rs=SetSQL.executeQuery(sql); if(true){ try { while (rs.next()) { n++; }//end while } catch (SQLException ex) { System.out.print("asadfasdfsdf"); }//try if(n==0){ WarnMsg("提示","此會員不存在！"); //rs=null; } else{ initTabel2(); } } //end if(true) }if(o==bt2){//刷新 initTabel(); }if(o==bt3){//刪除 delMemberPane del=new delMemberPane(); LocationUtil.setLocation(del); del.setModalityType(JDialog.DEFAULT_MODALITY_TYPE); del.setVisible(true); }if(o==bt4){ //添加 AddMemberPane add= new AddMemberPane(); LocationUtil.setLocation(add); add.setModalityType(AddMemberPane.DEFAULT_MODALITY_TYPE); add.setVisible(true); } } /******************************************************* * 函數名稱:WarnMsgPane(String title ,String msg ,component null) * 參數：tile 提示標題 msg 提示消息 顯示他的父組件 * 功能：為錯誤的輸入和連接錯誤做出提示 ************************************************************/ public void WarnMsg(String title,String msg){ JOptionPane.showMessageDialog(null,msg,title,JOptionPane.WARNING_MESSAGE); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -