mdreaderfrm.java

这个学期完成的图书管理系统

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.JFrame;

class mdreaderfrm extends JFrame implements ActionListener
{
	 JLabel l_reader,l_studentname ,l_studentnumber,l_xueyuan, l_banji, l_beizhu;
	 JTextField t_reader,t_studentname ,t_studentnumber,t_xueyuan,t_banji, t_beizhu;
	 JButton b_clear,b_enter,b_update,b_back;
	 JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7;
	 
	 NetConn sql;
	 Statement sqll;
	 ResultSet rs;
	 String a1,a2,a3,a4,a5,a6,a7;
	 
	 mdreaderfrm()
	 {
		 super("修改读者窗口");
		  l_reader=new JLabel("修改读者        ");
		  l_studentname =new JLabel("输入姓名：");
		  l_studentnumber=new JLabel("学号：      ");
		  l_xueyuan =new JLabel("学院：  ");
		  l_banji  =new JLabel("班级：      ");
		  l_beizhu    =new JLabel("备注：");
		
		
		t_studentname=new JTextField("",10);
		t_studentnumber=new JTextField("",15);
		t_xueyuan=new JTextField("",10);
		t_banji=new JTextField("",10);
		 t_beizhu=new JTextField("",10);
		
		 b_clear=new JButton("清空");
		 b_enter=new JButton("查询");
		 b_update=new JButton("更新");
		 b_back=new JButton("返回");
		 b_clear.addActionListener(this);
		 b_enter.addActionListener(this);
		 b_update.addActionListener(this);
		 b_back.addActionListener(this);
		 pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();pan4=new JPanel();pan5=new JPanel();pan6=new JPanel();pan7=new JPanel();
		 pan1.add( l_reader);pan2.add( l_studentname);pan2.add( t_studentname);pan3.add( l_studentnumber);pan3.add(t_studentnumber);pan3.add(b_enter);
		 pan4.add( l_xueyuan);pan4.add(t_xueyuan);pan5.add(l_banji);pan5.add(t_banji);pan6.add( l_beizhu );pan6.add(t_beizhu );
                    pan7.add(b_clear);pan7.add(b_update);pan7.add(b_back);
		
		 setLayout(new GridLayout(7,1));
		 add(pan1);add(pan2);add(pan3);add(pan4);add(pan5);add(pan6);add(pan7);
		 
		 sql=new NetConn();
		 
		 setBounds(350,150,400,500);
		 setVisible(true);
		 
	 }
	 public void actionPerformed(ActionEvent ef)
	 {
		 if(ef.getSource()==b_back)
		 {
			 dispose();
		 }
		 else if(ef.getSource()==b_update)
		 {
			 if(t_studentname.getText().equals("")||t_studentnumber.getText().equals(""))
			 {
				l_reader.setText("姓名，学号不能为空");
				 
			 }
			 else
			 {
				try
				 {
					 sqll=sql.connect();
					 a1="'"+t_studentname.getText().trim()+"'";
					 a2="'"+ t_studentnumber.getText().trim()+"'";
					 a3="'"+t_xueyuan.getText().trim()+"'";
					 a4="'"+t_banji.getText().trim()+"'";
					 a5="'"+t_beizhu.getText().trim()+"'";
					
					l_reader.setText("1");
					String temp="UPDATE reader set studentname="+a1+", xueyuan="+a3+", banji="+a4+",beizhu="+a5+" where studentnumeber="+t_studentnumber.getText();
					 sqll.executeUpdate(temp);
					 l_reader.setText("读者修改成功");
				 }
				 catch(SQLException e3)
				 {}
			 }
		 }
		 else if(ef.getSource()==b_clear)
		 {
			t_studentname.setText("");
			 t_studentnumber.setText("");
			t_xueyuan.setText("");
			 t_banji.setText("");
			t_beizhu.setText("");
			
			 l_reader  =new JLabel("修改书籍        ");
		 }
		 else if(ef.getSource()==b_enter)
		 {
			 try
			 {
				 sqll=sql.connect();
				  String temp="SELECT * FROM reader where studentnumber="+ t_studentnumber.getText();
				 rs=sqll.executeQuery(temp);
				 l_reader.setText("1");
				 if(rs.next())
				 {
					l_reader.setText("2");
					t_studentname.setText(rs.getString(1));
					 t_studentnumber.setText(rs.getString(2));
					t_xueyuan.setText(rs.getString(3));
					 t_banji.setText(rs.getString(4));
					t_beizhu.setText(rs.getString(5));
					
					 
					 l_reader.setText("找到读者");
				 }
				 else
				 {
					 l_reader.setText("没有找到读者");
				 }
			 }
			 catch(SQLException e4)
			 {}
		 }
	 }
}