图书管理系统3).txt

1） 图书信息的录入、修改、删除功能。 2） 读者信息的登记、修改、删除功能。 3） 借阅关系中的借出、归还功能。 4） 图书的查询功能

	private JPanel bu_bo_panel= new JPanel();
	 
	public bo_return_dia(){
		bo_return_dialog=new JDialog(frameDemo.mainFrame,"图书借阅");
		JPanel mainpanel=(JPanel)bo_return_dialog.getContentPane();
		
		la_bo_panel.setLayout(new GridLayout(4,1,2,2));
		la_bo_rno.setHorizontalAlignment(SwingConstants.CENTER);
		la_bo_panel.add(la_bo_rno);
		la_bo_bno.setHorizontalAlignment(SwingConstants.CENTER);
		la_bo_panel.add(la_bo_bno);
		la_bo_outday.setHorizontalAlignment(SwingConstants.CENTER);
		la_bo_panel.add(la_bo_outday);
		la_bo_inday.setHorizontalAlignment(SwingConstants.CENTER);
		la_bo_panel.add(la_bo_inday);
		
		tf_bo_panel.setLayout(new GridLayout(4,1,2,2));
		tf_bo_panel.add(tf_bo_rno);
		tf_bo_panel.add(tf_bo_bno);
		tf_bo_panel.add(tf_bo_outday);
		tf_bo_panel.add(tf_bo_inday);
		
		bu_bo_panel.setLayout(new FlowLayout());
		bu_bo_panel.add(bo_return_butt);
		bo_return_butt.addActionListener(this);
		bu_bo_panel.add(bo_reset_butt);
		bo_reset_butt.addActionListener(this);
		
		mess_bo_panel.setLayout(new GridLayout(1,2));
		mess_bo_panel.add(la_bo_panel);
		mess_bo_panel.add(tf_bo_panel);
		
		mainpanel.setLayout(new BorderLayout());
		mainpanel.add(mess_bo_panel,BorderLayout.CENTER);
		mainpanel.add(bu_bo_panel,BorderLayout.SOUTH);
		
		bo_return_dialog.setSize(400,260);
		bo_return_dialog.setLocation(200,180);
		bo_return_dialog.setVisible(true);
	}
	
	public void actionPerformed(ActionEvent e){
		String com=e.getActionCommand();
		if(com=="归还"){
			String bo_rno=tf_bo_rno.getText();
			String bo_bno=tf_bo_bno.getText();
			try{
		   
	    	bo_sql bo_ret_=new bo_sql();
	    	bo_ret_.bo_del(bo_rno,bo_bno,tf_bo_inday.getText());	   
		}catch(SQLException exc){
			System.out.println("注册异常");
			exc.printStackTrace();
			System.exit(1);
		}catch(ClassNotFoundException exc){
			System.out.println("未发现类");
			System.exit(1);
		}
			
		
			      
		}
		else{
			tf_bo_rno.setText("");
			tf_bo_bno.setText("");
			tf_bo_outday.setText("");
			tf_bo_inday.setText("");

			
		}
		
	}
}
借阅查询：
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

class bo_sel_dia implements ActionListener{
	private JDialog bo_sel_dialog=null;
	
	private JLabel la_bo_no=new JLabel("图书证号");
	private JLabel la_bo_mess=new JLabel();
	static JLabel nulllabel=new JLabel();
	
	private JTextField tf_bo_no=new JTextField(10);
	
	private JButton jb_bo_sel=new JButton("查询");
	private JButton jb_bo_del=new JButton("清除");
	
	private JPanel jp_bo_sel=new JPanel();
	static JPanel jp_bo_tab=new JPanel();
	private JPanel jp_bo_main=new JPanel();
	private JPanel jp_bo_del=new JPanel();
	
	public bo_sel_dia(){
		bo_sel_dialog=new JDialog(frameDemo.mainFrame,"读者借阅查询");
		JPanel mainpanel=(JPanel)bo_sel_dialog.getContentPane();
		
		jp_bo_sel.setLayout(new FlowLayout());
		jp_bo_sel.add(la_bo_no);
		jp_bo_sel.add(tf_bo_no);
		jp_bo_sel.add(jb_bo_sel);
		jb_bo_sel.addActionListener(this);
	
		jp_bo_main.setLayout(new BorderLayout());
		jp_bo_main.add(la_bo_mess,BorderLayout.NORTH);
	    jp_bo_main.add(jp_bo_tab,BorderLayout.CENTER);
		
		jp_bo_del.add(jb_bo_del);
		jb_bo_del.addActionListener(this);
		
		
		jp_bo_main.setLayout(new BorderLayout());
		jp_bo_main.add(la_bo_mess,BorderLayout.NORTH);
		jp_bo_main.add(jp_bo_tab,BorderLayout.CENTER);
		
		mainpanel.setLayout(new BorderLayout());
		mainpanel.add(jp_bo_sel,BorderLayout.NORTH);
		mainpanel.add(jp_bo_main,BorderLayout.CENTER);
		mainpanel.add(jp_bo_del,BorderLayout.SOUTH);
		
		
		bo_sel_dialog.setSize(480,260);
		bo_sel_dialog.setLocation(160,180);
		bo_sel_dialog.setVisible(true);
	}
	
	public void actionPerformed(ActionEvent e){
		String com = e.getActionCommand();
		if(com.equals("查询"))
		  { la_bo_mess.setText("读者 "+tf_bo_no.getText()+" 的借阅情况如下:");
		  try{
		  
		    bo_sql bo_sql_=new bo_sql();
	        bo_sql_.bo_sel(tf_bo_no.getText());
		  }catch(SQLException exc){
			System.out.println("注册异常");
			exc.printStackTrace();
			System.exit(1);
		}catch(ClassNotFoundException exc){
			System.out.println("未发现类");
			System.exit(1);
		}
		}
		if(com.equals("清除")){
			
			tf_bo_no.setText("");
			la_bo_mess.setText("");
		} 
		
	}
}
连接代码：
   读者管理连接代码：
import java.sql.*;
import javax.swing.*;
class r_sql{
	
	  String driver="sun.jdbc.odbc.JdbcOdbcDriver";

	   private Connection con=null;
	   private Statement stmt=null;
	   private ResultSet rs=null;
	
	   
	   
	   public r_sql()throws SQLException,ClassNotFoundException{
	   	Class.forName(driver);
		con=DriverManager.getConnection("jdbc:odbc:图书管理系统");
		stmt=con.createStatement();
       }
	
       public void r_insert( String r_no,String r_name,String r_sex,String r_age,String r_addr,String r_dept) throws SQLException 
       {
		String sql="insert into Reader(Rno,Rname,Rsex,Rage,Raddr,Rdept)" 
		             +"values('"+r_no+"','"+r_name+"','"+r_sex+"','"+r_age+"','"+r_addr+"','"+r_dept+"')";
		            
		stmt.execute(sql);
		
	}
	
	public void r_sel(String r_no)throws SQLException,ClassNotFoundException{
		
		String sql="select *from Reader where Rno='"+r_no+"'";
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			r_sel_dia.tf_r_name.setText(rs.getString("Rname"));
			r_sel_dia.tf_r_sex.setText(rs.getString("Rsex"));
			r_sel_dia.tf_r_age.setText(rs.getString("Rage"));
			r_sel_dia.tf_r_addr.setText(rs.getString("Raddr"));
			r_sel_dia.tf_r_dept.setText(rs.getString("Rdept"));
		}else{
			JOptionPane.showMessageDialog(null,"查询的读者不存在","查询的读者不存在",
			                              JOptionPane.INFORMATION_MESSAGE);
		}

	}
	
	public void r_del(String r_no)throws SQLException,ClassNotFoundException{
		String sql="select *from Reader where Rno='"+r_no+"'";
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			r_sel_dia.tf_r_name.setText(rs.getString("Rname"));
			r_sel_dia.tf_r_sex.setText(rs.getString("Rsex"));
			r_sel_dia.tf_r_age.setText(rs.getString("Rage"));
			r_sel_dia.tf_r_addr.setText(rs.getString("Raddr"));
			r_sel_dia.tf_r_dept.setText(rs.getString("Rdept"));
			
			
			sql="delete from Reader where Rno='"+r_no+"'";
			stmt.execute(sql);
			
		}else{
			JOptionPane.showMessageDialog(null,"删除的读者不存在","删除的读者不存在",
			                              JOptionPane.INFORMATION_MESSAGE);
		}
	
		
	}


}
图书管理连接：
import java.sql.*;
import javax.swing.*;

class b_sql{

    private Connection con=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	//String sql=null;
	
	public b_sql()throws SQLException,ClassNotFoundException{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:图书管理系统");
		stmt=con.createStatement();
	}   

public void b_reg(String b_no,String b_name,String b_auth,String b_typle,
	                   String b_puli)
	                   throws SQLException,ClassNotFoundException{
		String sql="insert into Book(Bno,Bname,Bauth,Bpubl,Bclass)"
		      +"values('"+b_no+"','"+b_name+"','"+b_auth+"','"+b_puli+"','"+b_typle+"')";
		            
		stmt.execute(sql);
		
		
		
	}
	
	public void b_sel(String b_no)throws SQLException,ClassNotFoundException{
		
		String sql="select *from Book where Bno='"+b_no+"'";
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			b_sel_dia.tf_b_name.setText(rs.getString("Bname"));
			b_sel_dia.tf_b_auth.setText(rs.getString("Bauth"));
			b_sel_dia.tf_b_puli.setText(rs.getString("Bpubl"));
			b_sel_dia.tf_b_typle.setText(rs.getString("Bclass"));
		}else{
			JOptionPane.showMessageDialog(null,"查询的图书不存在","查询的图书不存在",
			                              JOptionPane.INFORMATION_MESSAGE);
		}
		
	}
	
	public void b_del(String b_no)throws SQLException,ClassNotFoundException{
		String sql="select *from Book where Bno='"+b_no+"'";
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			b_sel_dia.tf_b_name.setText(rs.getString("Bname"));
			b_sel_dia.tf_b_auth.setText(rs.getString("Bauth"));
			b_sel_dia.tf_b_puli.setText(rs.getString("Bpubl"));
			b_sel_dia.tf_b_typle.setText(rs.getString("Bclass"));
		

			
		    sql="delete from Book where Bno='"+b_no+"'";
			stmt.execute(sql);
		}else{
			JOptionPane.showMessageDialog(null,"删除的图书不存在","删除的图书不存在",
			                              JOptionPane.INFORMATION_MESSAGE);
		}
		
	}
}
借阅连接：
import java.sql.*;
import javax.swing.*;
import java.util.*;
import java.text.*;

class bo_sql{

    private Connection con=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	
	public bo_sql()throws SQLException,ClassNotFoundException{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:图书管理系统");
		stmt=con.createStatement();
	}
	
	public void bo_reg(String bo_rno,String bo_bno,String bo_outday,String bo_inday)
	                   throws SQLException,ClassNotFoundException{
	    int Num=0;              	
	                   	
	    String sql="select count(*) from Borrow where Rno='"+bo_rno+"'";
		rs=stmt.executeQuery(sql);
		
		if(rs.next()){
		
			Num=rs.getInt(1);
			if(Num>4){
				JOptionPane.showMessageDialog(null,"该读者借阅书籍已超过最大限度！","借阅警告",
			                              JOptionPane.INFORMATION_MESSAGE);
			}else
		   {
	    	sql="insert into Borrow(Rno,Bno,Bouttime,Bintime)" 
		             +"values('"+bo_rno+"','"+bo_bno+"','"+bo_outday+"','"+bo_inday+"')";
		            
		    stmt.execute(sql);
	      }             	
	    }
	}                   	
	                   	
		
		
	
	
	public void bo_del(String bo_rno,String bo_bno,String bo_inday)throws SQLException,ClassNotFoundException{
		
		String sql="select *from Borrow where Rno='"+bo_rno+"' and Bno='"+bo_bno+"'";
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			bo_return_dia.tf_bo_outday.setText(rs.getString("Bouttime"));
			bo_return_dia.tf_bo_outday.setEnabled(false);
			bo_return_dia.tf_bo_inday.setText(bo_inday);
			
			
		    sql="delete from Borrow where Rno='"+bo_rno+"' and Bno='"+bo_bno+"'";
			stmt.execute(sql);
		}else{
			JOptionPane.showMessageDialog(null,"该读者暂无借阅记载","该读者暂无借阅记载,无法归还",
			                              JOptionPane.INFORMATION_MESSAGE);
		}
		
	    }
	
	
	
	public void bo_sel(String bo_rno)throws SQLException,ClassNotFoundException{
		
		String[] strTableTitle={"姓名","性别","借阅图书","借出日期","应还日期"};
		String[][] strTableData=null;
		JTable table;
		
		int Num=0;
		
		String sql="select count(*) from BorrowAndReturn where Rno='"+bo_rno+"'";
		rs=stmt.executeQuery(sql);
		
		if(rs.next())
			Num=rs.getInt(1);
	    else{
	    	JOptionPane.showMessageDialog(null,"该读者暂无借阅记载","该读者暂无借阅记载",
			                              JOptionPane.INFORMATION_MESSAGE);
	    }
	    		
		rs=null;
		strTableData=new String[Num][5];
		int row=0;
			
		sql="select * from BorrowAndReturn where Rno='"+bo_rno+"'";
		rs=stmt.executeQuery(sql);	
		while(rs.next()){
			strTableData[row][0]=rs.getString("Rname");
			strTableData[row][1]=rs.getString("Rsex");
			strTableData[row][2]=rs.getString("Bname");
			strTableData[row][3]=rs.getString("Bouttime");
			strTableData[row][4]=rs.getString("Bintime");
			row++;
				
			}
		table=new JTable(strTableData,strTableTitle);
		bo_sel_dia.jp_bo_tab.add(new JScrollPane(table));	
	}
	
}