java课程设计小型图书管理系统(5)

String url = \Access (*.mdb)};DBQ=Book.mdb\直接使用当前类目录下的数据库文件 Connection con=DriverManager.getConnection(url); Statement sql;

String s=\图书名 ='\ 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; ar[i][3]=writer; ar[i][4]=publish; ar[i][5]=indate; i++; }

count=\

L.setText(\该种图书共有\本\

f.repaint();

con.close();System.out.println(ar[0][1]); }catch(SQLException g) {

System.out.println(\ System.out.println(\ }

}

public void deleteRecord(int index)

21

Driver

{ 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=(String)(ar[index][1]);

String s=\图书号 ='\ sql=con.createStatement(); int del=sql.executeUpdate(s); if(del==1)

{JOptionPane.showMessageDialog(null,\删除成功！\ \信息\ }

con.close(); f.repaint();

}catch(SQLException g) {

System.out.println(\ System.out.println(\ }

}

public void actionPerformed(ActionEvent e) {

String remember=\ String ql=\

String cmd=e.getActionCommand(); if(cmd.equals(\查询\ {

ql=tf.getText().trim(); remember=ql; showRecord(ql); }

22

if(cmd.equals(\删除\ {

int index=table.getSelectedRow(); if( index==-1)

JOptionPane.showMessageDialog(null,\请选定要删除的表格行\ \输入错误\

else{

deleteRecord(index); //showRecord(remember); } }

if(cmd.equals(\取消\ f.hide(); }

public static void main(String []arg){

RemoveBook a=new RemoveBook(); } }

5图书入库：程序名BookIn.java import java.awt.event.*; import javax.swing.*; import java.awt.*;

import java.awt.Container; import java.util.*; import java.sql.*;

import javax.swing.text.JTextComponent;

//extends JFrame

class BookIn implements ActionListener {

JFrame f3; Container cp;

JPanel jp1,jp2,jp3,jp4,jp,jpanelWest; JButton jbt1,jbt2;//按钮:确定、取消、 JLabel label; //标签

JTextField tf1,tf2,tf3,tf4,tf5,tf6; // JLabel label1,label2,label3,label4;

23

定义文本框

String sno; BookIn() {

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);

//------------------------------------------------ tf1=new JTextField(20); tf2=new JTextField(20); tf3=new JTextField(20); tf4=new JTextField(20); tf5=new JTextField(20); tf6=new JTextField(20);

//------------------------------------------------ //布局,添加控件

jp1.add(jbt1); jp1.add(jbt2);

sno=tf4.getText();

jp1.add(new JLabel(\您好\欢迎登陆学生信息系统\

JPanel jpanel=new JPanel(); jpanel.add(label);

24

书入库图

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;

f3.setLocation(xcenter,ycenter);/*显示在窗口中央*/ f3.setVisible(true);

//------------------------------------------------- jbt1.addActionListener(this);//注册监听器

25