发布时间 : 星期四 文章《Java程序设计》课程设计-目录及正文更新完毕开始阅读
import java.awt.event.*; import javax.swing.*; import java.awt.*; import java.awt.Container; import java.util.*; import java.sql.*;
class BookBrower implements ActionListener{
JFrame f; Container cp; JPanel jpS,jpanelWest;
JButton jbt1,jbt2;//按钮，查询、取消、修改 JLabel label,L; //定义文本框
JTable table;//用来接收数据库中返回的信息
//标签
Object columnName[]={\图书名\图书号\单价\作者\出版社\入库时间\
Object ar[][] =new Object[80][6];
String sno; String count=\
BookBrower(){
f=new JFrame();
cp=f.getContentPane(); // 初始化面板、按钮、标签、文本框 jpS=new JPanel();
jpanelWest=new JPanel();
jbt1=new JButton(\确定\ jbt2=new JButton(\返回\label=new
JLabel(\
color=green
size='4'>图书概览
\
label.setForeground(Color.blue);
L=new JLabel(\书库现在共有图书\本\
20
table=new JTable(ar,columnName);//ar存放表中的数据，columnname表示列名
JScrollPane scrollpane = new JScrollPane(table); //布局,添加控件 jpS.add(jbt1); jpS.add(jbt2);
JPanel jpanel=new JPanel(); jpanel.add(label); JPanel pp4=new JPanel();
JPanel jpE=new JPanel();
cp.add(jpanel,\JPanel jp=new JPanel();
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);
21
}
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{ 败!\
try{
String
url
=
\
Access
Driver
Class.forName(\
}catch(ClassNotFoundException e){System.out.println(\加载驱动程序失
(*.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);
22
}
ar[i][0]=bname; ar[i][1]=bno; ar[i][2]=price; 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(\确定\ if(cmd.equals(\返回\
public static void main(String []arg){ } }
BookBrower a=new BookBrower(); a.showRecord();
23