booklendframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class BookLendFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel studentNameLabel,bookNameLabel,borrowDateLabel,remarksLabel;
private JTextField nameText,borrowDateText,remarksText;
private JComboBox bookNameBox;
private JPanel panel1,panel2;
private JButton clearButton,okButton,cancelButton;
public BookLendFrame()
{
super("书籍出借");
int findFlag=0;
c=getContentPane();
c.setLayout(new BorderLayout());
studentNameLabel=new JLabel("借阅者名称",JLabel.CENTER);
bookNameLabel=new JLabel("书名",JLabel.CENTER);
borrowDateLabel=new JLabel("借阅日期",JLabel.CENTER);
remarksLabel=new JLabel("备注",JLabel.CENTER);
nameText=new JTextField(12);
borrowDateText=new JTextField(12);
remarksText=new JTextField(12);
clearButton=new JButton("清空");
okButton=new JButton("确定");
cancelButton=new JButton("取消");
bookNameBox=new JComboBox();
//将图书馆里面有的书查询显示在ComboBox中；
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo where bookNum>borrowedCount");
while(rs.next())
{
findFlag=1;
bookNameBox.addItem(rs.getString("bookName"));
}
stmt.close();
con.close();
if(findFlag==0)
JOptionPane.showMessageDialog(null,"图书馆没有书籍了!");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束


panel1=new JPanel();
panel1.setLayout(new GridLayout(4,2));
panel1.add(studentNameLabel);
panel1.add(nameText);
panel1.add(bookNameLabel);
panel1.add(bookNameBox);
panel1.add(borrowDateLabel);
panel1.add(borrowDateText);
panel1.add(remarksLabel);
panel1.add(remarksText);
panel2=new JPanel();
panel2.add(clearButton);
panel2.add(okButton);
panel2.add(cancelButton);
clearButton.addActionListener(this);
okButton.addActionListener(this);
cancelButton.addActionListener(this);

c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(300,250);
setVisible(true);
}

public void actionPerformed(ActionEvent e)
{
int lendFlag=0;
int borrowCount=0;

if(e.getSource()==cancelButton)
this.dispose();
else if(e.getSource()==clearButton)
{
nameText.setText("");
borrowDateText.setText("");
remarksText.setText("");
}
else if(e.getSource()==okButton)
{
if(nameText.getText().equals(""))
JOptionPane.showMessageDialog(null,"借阅者名称不能为空");
else if(borrowDateText.getText().equals(""))
JOptionPane.showMessageDialog(null,"借阅日期不能为空");
/*else if(returnDateText.getText().equals(""))
JOptionPane.showMessageDialog(null,"归还日期不能为空");*/
else
{
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("insert into bookBrowse values(?,?,?,?,?,?)");
pstmt.setString(1,nameText.getText());
pstmt.setString(2,bookNameBox.getSelectedItem().toString());
pstmt.setString(3,borrowDateText.getText());
pstmt.setString(4,"");
pstmt.setString(5,remarksText.getText());
pstmt.setString(6,"0");
pstmt.executeUpdate();
lendFlag=1;
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束


//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
{
if(bookNameBox.getSelectedItem().toString().equals(rs.getString("bookName")))
{
borrowCount=Integer.parseInt(rs.getString("borrowedCount"));
break;
}
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束

if(lendFlag==1)
{
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("update bookInfo set borrowedCount=? where bookName=?");
borrowCount++;
pstmt.setString(1,String.valueOf(borrowCount));
pstmt.setString(2,bookNameBox.getSelectedItem().toString());
pstmt.executeUpdate();
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束
}
}
}
}
}