clslendbook_condb.java~4~

这是我在北大青鸟的第一学期的一个毕业设计

import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Calendar;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTable;
import java.util.Vector;

public class clsLendBook_condb {
   static FrmBook fm;
   static Connection conLb;
   static Statement stLb;
   static ResultSet rsLb;
    public clsLendBook_condb(FrmBook f) {
        fm=f;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            JOptionPane.showMessageDialog(fm,"找不到驱动","error",JOptionPane.ERROR_MESSAGE);
        }

        try {
            conLb = DriverManager.getConnection("jdbc:odbc:book");
            stLb=conLb.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

        } catch (SQLException ex1) {
            JOptionPane.showMessageDialog(fm,"连接失败","error",JOptionPane.ERROR_MESSAGE);
        }
    }

    static void initSearch()
    {
        try {
            rsLb=stLb.executeQuery("select top 5 lendnumber as '借书证号',booknumber as '图书编号',lenddate as '借出日期',shouldreturn as '应归还日期' from lendbook");
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(fm,"连接失败","error",JOptionPane.ERROR_MESSAGE);
        }
    }


    /**
     * 数据库中的数据显示在表格
     * @param tab JTable
     */
   static void initInfo(JTable tab,ResultSet rsparam)
   {

       DefaultTableModel dt;
       Vector vt=new Vector();
       Vector vtTemp;
    try
    {
        while (rsparam.next())
        {
            vtTemp=new Vector();
            for (int i = 1; i <= rsparam.getMetaData().getColumnCount(); i++)
            {
                vtTemp.add(rsparam.getString(i));
            }
            vt.add(vtTemp);
        }
        rsparam.last();
        Vector vtColName=new Vector();
        for(int i=1;i<=rsparam.getMetaData().getColumnCount();i++)
        {
            vtColName.add(rsparam.getMetaData().getColumnName(i));
        }

        dt=new DefaultTableModel(vt,vtColName);
        tab.setModel(dt);
    }
    catch (SQLException ex)
    {
        JOptionPane.showMessageDialog(fm,"有误","error",JOptionPane.ERROR_MESSAGE);
    }
   }

    static void InsertRecord(String CardId,String BookId)
    {
        String lendDate,returnDate;

        Calendar c=Calendar.getInstance();
        Date dd=new Date(c.getTimeInMillis());
        Time tt=new Time(c.getTimeInMillis());
        lendDate=dd+" "+tt;

       c.set(c.get(c.YEAR),c.get(c.MONTH)+2,c.get(c.DAY_OF_MONTH));
       Date d2=new Date(c.getTimeInMillis());
       Time t2=new Time(c.getTimeInMillis());
        returnDate=d2+" "+t2;

        String str="insert into lendbook values('"+CardId+"','"+BookId+"','"+lendDate+"','"+returnDate+"')";

        try {
            stLb.executeUpdate(str);
            JOptionPane.showMessageDialog(fm,"成功借书","OK",JOptionPane.INFORMATION_MESSAGE);
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(fm,"插入时出错","error",JOptionPane.ERROR_MESSAGE);
        }
    }

    static boolean ReturnBook(String CardId,String BookId)
    {
        int i=0;
        boolean b=false;
        String str="select * from lendbook where lendnumber='"+CardId+"' and booknumber='"+BookId+"'";
        try {
            ResultSet rsHr = stLb.executeQuery(str);
            while(rsHr.next())
            {
                i++;
            }
            if(i!=0)
            {
                b=true;
                String str2="delete from lendbook where lendnumber='"+CardId+"' and booknumber='"+BookId+"'";
                stLb.executeUpdate(str2);
                JOptionPane.showMessageDialog(fm,"成功还书","OK",JOptionPane.INFORMATION_MESSAGE);
            }
            else
            {
                JOptionPane.showMessageDialog(fm,"请验证输入是否有误","Sorry",JOptionPane.INFORMATION_MESSAGE);
            }
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(fm,"还书时有错","Sorry",JOptionPane.INFORMATION_MESSAGE);
        }
        return b;
    }


}