duzheshezhiframe.java

一个简单的图书管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class DuZheSheZhiFrame extends JFrame implements ActionListener{
    public final static int TO_INSEART=1,TO_UPDATE=2;
    int insql;
    ShuJuKu db=new ShuJuKu();
    ResultSet rs1;
    
    JTextField fields[];
    JLabel labels[];
    JLabel label;
    JTable dztable=null;
	DefaultTableModel dzdefaultModel=null;
    
    JTextArea textArea;
    JButton b1,b2,b3;
    String dangqianduzhe;
    String labelsName[]={"读者号","读者姓名","读者邮箱","所属院系","借阅数目","读者类别","读者密码"};
    public DuZheSheZhiFrame(int inseartOrUpdate){
        super("读者信息设置"); 
        insql=inseartOrUpdate;
        
        labels=new JLabel[7];
        fields=new JTextField[7];
        
        JPanel p1=new JPanel();
        JPanel p2=new JPanel();
        JPanel p3=new JPanel();
        JPanel p4=new JPanel();
        JPanel p5=new JPanel();
        JPanel p6=new JPanel();
        
        p1.setLayout(new GridLayout(7,1,0,15));
        p2.setLayout(new GridLayout(7,1,0,10));
         
        for(int i=0;i<7;i++){
            labels[i]=new JLabel(labelsName[i]+":");
            fields[i]=new JTextField(15);
            p1.add(labels[i]);
            p2.add(fields[i]); 
        }
         
        p3.setBorder(BorderFactory.createTitledBorder("备注"));
        textArea=new JTextArea(5,15);
        JScrollPane t=new JScrollPane(textArea);
        
        b1=new JButton("确定按钮");
        b1.addActionListener(this);
        b2=new JButton("取消按钮");
        b2.addActionListener(this);
        b3=new JButton("借阅信息");
        b3.addActionListener(this);
        
        
        //-----
        p6=new JPanel();
		String[] name={"书名","书号","日期","借还"};
		String[][] data=new String[0][0];
		dzdefaultModel=new DefaultTableModel(data,name);
		dztable=new JTable(dzdefaultModel);
		dztable.setPreferredScrollableViewportSize(new Dimension(600,80));
		JScrollPane s1=new JScrollPane(dztable);
		p6.add(s1);
		//------
		
		
		
        
        p3.add(t);
        
        p4.add(p1);
        p4.add(p2);
        p4.add(p3);
        
        p5.add(b1);
        p5.add(b2);
        p5.add(b3);
        
        fields[4].setEnabled(false);
        
        Container c=getContentPane();
        c.add(p4,BorderLayout.NORTH);
        c.add(p6,BorderLayout.CENTER);
        c.add(p5,BorderLayout.SOUTH);
    }
     
    public void actionPerformed(ActionEvent e) {
        if(e.getSource()==b2)
		{
			db.closeConnection();
			this.dispose();
		}
		else if(e.getSource()==b3){
			
			    String strSQL;
			    dangqianduzhe=(String)fields[0].getText();
	            strSQL="select tushubiao.tushuhao,tushubiao.duzhehao,tushubiao.jiehuanriqi,tushubiao.xingwei, tushuxinxi.tushuhao, tushuxinxi.tushuming From tushubiao,tushuxinxi where tushubiao.tushuhao=tushuxinxi.tushuhao and tushubiao.duzhehao ='"+dangqianduzhe+"'";
	            try{
	               
	                int rowCount=dzdefaultModel.getRowCount()-1;//取得table中的数据行；
	                int j=rowCount;
	                for(int i=0;i<=rowCount;i++){
	             	dzdefaultModel.removeRow(j);   //删除rowCount行的数据；
	        	    dzdefaultModel.setRowCount(j); //重新设置行数；
	        	    j=j-1;
	                }
		            rs1=db.getResult(strSQL);
		            while(rs1.next()){
		               Vector data=new Vector();
			           data.addElement(rs1.getString(6));
			           data.addElement(rs1.getString(1));
			           data.addElement(rs1.getString(3));
		 	           data.addElement(rs1.getString(4));
		 	           
			           dzdefaultModel.addRow(data);
		           }
		           dztable.revalidate();
	          } catch(SQLException sqle){
			    System.out.println(sqle.toString());
		      }
	            catch(Exception ex){
			    System.out.println(ex.toString());
		      }
		}
        else if(e.getSource()==b1){
         
            
             if(fields[0].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"读者编号不能为空！");
			}
			else if(fields[1].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"读者姓名不能为空！");
			}
			else if(fields[2].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"读者邮箱不能为空！");
			}	
			else if(fields[3].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"读者院系不能为空！");
			}
			else if(fields[5].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"读者类别不能为空！");
			}
			else if(!(fields[5].getText().trim().equals("学生")||fields[5].getText().trim().equals("老师")))
			{
				JOptionPane.showMessageDialog(null,"读者类别只能为老师或学生！");
			}
			else
			{
			  //--设置窗口功能--
			  if(insql==1){
				try
				{
					String strSQL="insert into duzhexinxi(duzhehao,duzhename,duzheyouxiang,duzheyuanxi,jieyueshumu,duzheleibie,duzhemima,duzhebeizhu) values('"+
					fields[0].getText().trim()+"','"+
					fields[1].getText().trim()+"','"+
					fields[2].getText().trim()+"','"+
					fields[3].getText().trim()+"','"+
					"0"+"','"+
					fields[5].getText().trim()+"','"+
					fields[6].getText().trim()+"','"+
					textArea.getText().trim()+"')";
					if(db.updateSql(strSQL))
					{
						JOptionPane.showMessageDialog(null,"添加信息成功！");
						this.dispose();
					}
					else
					{
						JOptionPane.showMessageDialog(null,"添加信息失败请认真填写各项信息!");
						this.dispose();
					}
					db.closeConnection();
				}
			        catch(Exception ex)
			        {
				      System.out.println(ex.toString());
			        }
		     }
		     //--修改窗口功能--
		     else{
		     	try
				{
					String strSQL="update duzhexinxi set duzhename='"+fields[1].getText().trim()+"',"+"duzheyouxiang='"+fields[2].getText().trim()+"',"+"duzheyuanxi='"+fields[3].getText().trim()+"',"+"duzheleibie='"+fields[5].getText().trim()+"',"+"duzhemima='"+fields[6].getText().trim()+"',"+"duzhebeizhu='"+textArea.getText().trim()+"'where duzhehao='"+fields[0].getText().trim()+"'";
					if(db.updateSql(strSQL))
					{
						JOptionPane.showMessageDialog(null,"修改信息成功！");
						this.dispose();
					}
					else
					{
						JOptionPane.showMessageDialog(null,"修改信息失败！");
						this.dispose();
					}
					db.closeConnection();
				}
			        catch(Exception ex)
			        {
				      System.out.println(ex.toString());
			        }	
		     }
	    	}
        }
    }
    
}