JPanel jpanel=new JPanel(); jpanel.add(label);
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,\
//------------------------------------------------ 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);
/* f.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){ System.exit(0); } }
11
);*/ }
//------------------------------------------------ int i=0;
public void showRecord() {
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{
String url = \Access Driver (*.mdb)};DBQ=Book.mdb\直接使用当前类目录下的数据库文件 Connection con=DriverManager.getConnection(url);
String s=\
Statement sql=con.createStatement(); ResultSet rs=sql.executeQuery(s);
while(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); ar[i][0]=bname; ar[i][1]=bno; ar[i][2]=price;
12
ar[i][3]=writer; ar[i][4]=publish; ar[i][5]=indate; i++; }
count=\
L.setText(\书库现在共有图书\本\ f.repaint();
con.close(); }catch(SQLException g) {
System.out.println(\ System.out.println(\ } }
public void actionPerformed(ActionEvent e) {
String cmd=e.getActionCommand(); if(cmd.equals(\确定\ {
f.hide(); }
if(cmd.equals(\返回\ f.hide(); }
public static void main(String []arg){
BookBrower a=new BookBrower(); a.showRecord(); } }
3图书查询：程序名QueryBook.java
13
import java.awt.event.*; import javax.swing.*; import java.awt.*;
import java.awt.Container; import java.util.*; import java.sql.*;
class QueryBook implements ActionListener {
JFrame f3; Container cp;
JPanel jp1,jp2,jp3,jp4,jp,jpanelWest; JButton jbt1,jbt2;//按钮，确定、取消
JLabel label; //标签：请输入图书号
JTextField tf,tf1,tf2,tf3,tf4,tf5,tf6; //定义文本框 JLabel label1,label2,label3,label4;
QueryBook() {
f3=new JFrame();
cp=f3.getContentPane(); // 初始化面板、按钮、标签、文本框 jp1=new JPanel(); jp2=new JPanel(); jp3=new JPanel(); jp4=new JPanel();
jpanelWest=new JPanel(); jp=new JPanel();
//------------------------------------------------ jbt1=new JButton(\确定\ jbt2=new JButton(\取消\
//------------------------------------------------
label=new JLabel(\color=#CC00FF size='4'>请输入图书号：\ label.setForeground(Color.blue); tf=new JTextField(20);
//------------------------------------------------ tf1=new JTextField(20); tf2=new JTextField(20); tf3=new JTextField(20); tf4=new JTextField(20); tf5=new JTextField(20); tf6=new JTextField(20);
14
//------------------------------------------------ //布局,添加控件
JPanel jpanel=new JPanel(); jpanel.add(label); jpanel.add(tf);
JPanel pp4=new JPanel(); JPanel jpane4=new JPanel();
cp.add(jpanel,\
JPanel pp2=new JPanel(new GridLayout(6,1)); JPanel pp3=new JPanel();
pp4.setLayout(new GridLayout(6,1));
pp4.add(new JLabel(\图书名\
pp2.add(tf1);
pp4.add(new JLabel(\图书号\ pp2.add(tf2);
pp4.add(new JLabel(\单 价\ pp2.add(tf3);
pp4.add(new JLabel(\作 者\ pp2.add(tf4);
pp4.add(new JLabel(\出版社\ pp2.add(tf5);
pp4.add(new JLabel(\入库时间\ pp2.add(tf6); pp3.add(jbt1); pp3.add(jbt2);
cp.add(pp4,\ cp.add(pp2,\ cp.add(pp3,\
cp.add(jpane4,\
//------------------------------------------------ Toolkit kit=Toolkit.getDefaultToolkit(); Dimension screen=kit.getScreenSize();
int x=screen.width; /*取得显示器窗口的宽度*/ int y=screen.height; /*取得显示器窗口的高度*/ f3.setSize(350,330); int xcenter=(x-350)/2; int ycenter=(y-330)/2;
15