add_reader.java

简易图书管理样板 其他功能仿照即可 小弟能力有限

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class add_reader extends JFrame implements ActionListener
{
	JLabel _ID;
	JLabel _name;
	JLabel _type;
	JLabel _limit;
	JTextField ID;
	JTextField name;
	JTextField type;
	JTextField limit;
	JButton add_true;
	JButton add_false;
	Connection con1;
	Statement sql;
	ResultSet rs;
	add_reader()
	{
		super("增加读者");
		//setSize(200,180);
		Toolkit tool=getToolkit();
		Dimension dim=tool.getScreenSize();
		setBounds(dim.width/2-100,dim.height/2-90,200,180);
		//setBounds(540,300,200,180);
		setResizable(false);
		setVisible(true);
		FlowLayout con=new FlowLayout();
		setLayout(con);
		//setLayout(new FlowLayout());
		_ID=new JLabel("读者编号：");
		_name=new JLabel("读者姓名：");
		_type=new JLabel("读者类型：");
		_limit=new JLabel("限借数量：");
		ID=new JTextField(10);
		name=new JTextField(10);
		type=new JTextField(10);
		limit=new JTextField(10);
		add_true=new JButton("确定");
		add_true.addActionListener(this);
		add_false=new JButton("取消");
		add_false.addActionListener(this);
		add(_ID);
		add(ID);
		add(_name);
		add(name);
		add(_type);
		add(type);
		add(_limit);
		add(limit);
		add(add_true);
		add(add_false);
		validate();
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==add_true)
		{
		try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
		catch(ClassNotFoundException e1)
		{
			System.out.println(""+e1);
		}
		
		try{ con1=DriverManager.getConnection("jdbc:odbc:book","admin","111111");
			sql=con1.createStatement();
			rs=sql.executeQuery("insert into reader values("+"'"+ID.getText()+"'"+","+"'"+name.getText()+"'"+","+"'"+limit.getText()+"'"+","+"'"+type.getText()+"'"+")");
			while(rs.next())
			{
				String number=rs.getString(1);
				String name=rs.getString(2);
				String date=rs.getString(3);
				String type=rs.getString(4);
				System.out.print(" "+number+" "+name+" "+limit+" "+type);
				System.out.println();
				//msg.setText(number+"  "+name+"  "+date+"  "+type+"\n");
			}
			con1.close();
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}
			JOptionPane.showMessageDialog(null,"信息添加成功");
			this.dispose();
	
	     }
	     if(e.getSource()==add_false)this.dispose();
	}
}