set_reader.java

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

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class set_reader extends JFrame implements ActionListener
{
	JLabel _ID;
	JLabel _name;
	JLabel _type;
	JLabel _limit;
	JTextField ID;
	JTextField name;
	JTextField type;
	JTextField limit;
	JButton ID_true;
	JButton set_true;
	JButton set_false;
	Connection con1;
	Statement sql;
	ResultSet rs;
	set_reader()
	{
		super("修改读者信息");
		Toolkit tool=getToolkit();
		Dimension dim=tool.getScreenSize();
		setBounds(dim.width/2-125,dim.height/2-90,250,180);
		//setSize(250,180);
		setResizable(false);
		setVisible(true);
		FlowLayout con=new FlowLayout();
		setLayout(con);
		_ID=new JLabel("读者编号：");
		_name=new JLabel("读者姓名：");
		_type=new JLabel("读者类型：");
		_limit=new JLabel("限借数量：");
		ID=new JTextField(8);
		name=new JTextField(15);
		type=new JTextField(15);
		limit=new JTextField(15);
		ID_true=new JButton("确定");
		ID_true.addActionListener(this);
		set_true=new JButton("修改");
		set_true.addActionListener(this);
		set_false=new JButton("取消");
		set_false.addActionListener(this);
		add(_ID);
		add(ID);
		add(ID_true);
		add(_name);
		add(name);
		add(_type);
		add(type);
		add(_limit);
		add(limit);
		add(set_true);
		add(set_false);
		validate();
		
	}
	public void actionPerformed(ActionEvent e)
	{
			if(e.getSource()==ID_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("select * from reader where number='"+ID.getText()+"'");
		//	while(rs.next())
		//	{
			//	String number=rs.getString(1);
			//	String name=rs.getString(2);
			//	String limit=rs.getString(3);
			//	String type=rs.getString(4);
			//	System.out.print(" "+number+" "+name+" "+limit+" "+type);
			//	System.out.println();
				//msg.setText("  编号 "+"  姓名 "+"  类型 "+"  限借数量 "+"\n"+"   "+number+"  "+name+"  "+type+"  "+limit+"\n");
			//}
			while(rs.next()){
					name.setText(rs.getString(2));
					limit.setText(rs.getString(3));	
					type.setText(rs.getString(4));
				}
			con1.close();
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}
	
	     }
	     if(e.getSource()==set_true)
	     {
	     	try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	 	  	}
			catch(ClassNotFoundException e1)
			{
			System.out.println(""+e1);
			}
			try{
				con1=DriverManager.getConnection("jdbc:odbc:book");
				sql=con1.createStatement();
				rs=sql.executeQuery("update reader set name='"+name.getText()+"',type='"+type.getText()+"',limit='"+limit.getText()+"'where number='"+ID.getText()+"'");
				con1.close();	 
			}
			catch(SQLException e2){
				System.out.println(e2);
			}
			JOptionPane.showMessageDialog(null,"信息修改成功");
			this.dispose();
	     }
	     //else
	     	//JOptionPane.showMessageDialog(null,"用户不存在!");
	     if(e.getSource()==set_false)this.dispose();
	}
}