addreaderfrm.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 Addreaderfrm extends JFrame implements ActionListener
{
	 JLabel l_reader, l_studentname,l_studentnumber,l_xueyuan,l_banji,l_beizhu;
	 JTextField t_studentname,t_studentnumber,t_xueyuan,t_banji,t_beizhu;
	 JButton b_clear,b_add,b_back;
	 JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7;
	 
	 NetConn sql;
	 Statement sqll;
	 
	 String a1,a2,a3,a4,a5,a6,a7;

	 
	 Addreaderfrm()
	 {
		 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("",10);
		 t_xueyuan  =new JTextField("",10);
		 t_banji   =new JTextField("",10);
		 t_beizhu  =new JTextField("",10);
		
		 b_clear   =new JButton("清空");
		 b_add     =new JButton("添加");
		 b_back    =new JButton("返回");
		 b_clear.addActionListener(this);
		 b_add.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);
		 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_add);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);
		
		 
		 
	 }
	 public void actionPerformed(ActionEvent ec)
	 {
		 if(ec.getSource()==b_back)
		 {
			 dispose();
		 }
		 else if(ec.getSource()==b_clear)
		 {
			
			 t_studentname.setText("");
			 t_studentnumber.setText("");
			 t_xueyuan.setText("");
			 t_banji.setText("");
			 t_beizhu .setText("");
			 
			
		 }
		 else if(ec.getSource()==b_add)
		 {
			 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="insert into reader (studentname, studentnumber, xueyuan, banji, beizhu) VALUES ("+a1+","+a2+","+a3+","+a4+","+a5+")";
					 sqll.executeUpdate(temp);
					 l_reader.setText("读者添加成功");
				 }
				 catch(SQLException e3)
				 {}
			 }
		 }
	 }
	
}