f3.setLocation(xcenter,ycenter);/*显示在窗口中央*/ f3.setVisible(true);
//------------------------------------------------- jbt1.addActionListener(this);//注册监听器 jbt2.addActionListener(this);
/*f3.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){ System.exit(0); } } );*/ }
//------------------------------------------------ public void showRecord() {
try{
Class.forName(\
}catch(ClassNotFoundException e){System.out.println(\加载驱动程序失败!\
try{
String url = \Access Driver (*.mdb)};DBQ=Book.mdb\直接使用当前类目录下的数据库文件 Connection con=DriverManager.getConnection(url); Statement sql;
String ql=tf.getText().trim();
String s=\图书号 ='\ sql=con.createStatement();
ResultSet rs=sql.executeQuery(s); if(rs.next()) {
String bname=rs.getString(1); String bno=rs.getString(2); String price=rs.getString(3); String writer=rs.getString(4); String publish=rs.getString(5); String indate=rs.getString(6); tf1.setText(bname); tf2.setText(bno); tf3.setText(price); tf4.setText(writer); tf5.setText(publish);
16
tf6.setText(indate); }
else
{JOptionPane.showMessageDialog(null,\您输入的图书号不存在，请重新输入\
\输入错误\ }
con.close();
}catch(SQLException g) {
System.out.println(\ System.out.println(\ }
tf1.setEditable(false); tf2.setEditable(false); tf3.setEditable(false); tf4.setEditable(false); tf5.setEditable(false); tf6.setEditable(false);
}
public void actionPerformed(ActionEvent e) {
String cmd=e.getActionCommand(); if(cmd.equals(\确定\ {
showRecord(); tf.setText(\ }
else if(cmd.equals(\取消\ f3.hide(); }
public static void main(String []arg){
QueryBook a=new QueryBook();
17
} }
4图书删除：程序名RemoveBook.java
import java.awt.event.*; import javax.swing.*; import java.awt.*;
import java.awt.Container; import java.util.*; import java.sql.*;
class RemoveBook implements ActionListener {
JFrame f; Container cp;
JPanel jpS,jpanelWest;
JButton jbt1,jbt2,jbt3;//按钮，查询、取消、修改 JLabel label,L; //标签：请输入学号 JTextField tf; //定义文本框
JTable table;//用来接收数据库中返回的信息
Object columnName[]={\图书名\图书号\单价\作者\出版社\入库时间\ Object ar[][] =new Object[80][6]; String sno;
String count=\
RemoveBook() {
f=new JFrame();
cp=f.getContentPane(); // 初始化面板、按钮、标签、文本框 jpS=new JPanel(); jpanelWest=new JPanel();
//------------------------------------------------ jbt1=new JButton(\查询\ jbt2=new JButton(\取消\ jbt3=new JButton(\删除\
//------------------------------------------------
label=new JLabel(\请输入要删除的图书名：\
18
label.setForeground(Color.blue);
L=new JLabel(\该种图书共有\本\
//------------------------------------------------
table=new JTable(ar,columnName);//ar存放表中的数据，columnname表示列名 JScrollPane scrollpane = new JScrollPane(table);
//------------------------------------------------ tf=new JTextField(18);
//------------------------------------------------
//------------------------------------------------ //布局,添加控件
jpS.add(jbt1);
jpS.add(jbt2); jpS.add(jbt3);
JPanel jpanel=new JPanel(); jpanel.add(label); jpanel.add(tf);
JPanel pp4=new JPanel(); JPanel jpE=new JPanel();
cp.add(jpanel,\ JPanel jp=new JPanel(); //jp.add(scrollpane);
JPanel p=new JPanel();//用来放两个表 p.setLayout(new BorderLayout());
p.add(L,\ p.add(scrollpane);
cp.add(pp4,\ cp.add(p,\ cp.add(jpS,\
cp.add(jpE,\
19
//------------------------------------------------ Toolkit kit=Toolkit.getDefaultToolkit(); Dimension screen=kit.getScreenSize();
int x=screen.width; /*取得显示器窗口的宽度*/ int y=screen.height; /*取得显示器窗口的高度*/ f.setSize(400,330); int xcenter=(x-350)/2; int ycenter=(y-330)/2;
f.setLocation(xcenter,ycenter);/*显示在窗口中央*/ f.setVisible(true);
//------------------------------------------------- jbt1.addActionListener(this);//注册监听器 jbt2.addActionListener(this); jbt3.addActionListener(this);
/*f.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){ System.exit(0); } } );*/ }
//------------------------------------------------ int i=0;
public void showRecord(String ql) {
while(i>=0) {
ar[i][0]=\ ar[i][1]=\ ar[i][2]=\ ar[i][3]=\ ar[i][4]=\ ar[i][5]=\ i--; } i=0;
try{
Class.forName(\
}catch(ClassNotFoundException e){System.out.println(\加载驱动程序失败!\
try{
20