bookapply.java

这个也是关于图书管理系统的代码

package com.xmspk.ebp.books;

import java.sql.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.xmspk.ebp.books.Database;
import com.xmspk.ebp.books.BookObj;
import com.xmspk.ebp.books.Util;
/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Apr 18, 2003
 * Time: 10:23:37 AM
 * To change this template use Options | File Templates.
 */
public class BookApply {
    public BookApply(){

    }

    public static int getSequence()
     {
         String sql = new String("Select bookSeq.nextval As SeqNum From Dual");
         java.sql.Connection conn = Database.Connect();
         PreparedStatement stmt = Database.getStatement(conn, sql);
         ResultSet rs = null;
         int SeqNum = 0;
         try
         {
             stmt.executeQuery();
             rs = stmt.getResultSet();
             if(rs.next())
             {
                 SeqNum = rs.getInt("SeqNum");
                 rs.close();
             }
         }
         catch(Exception e)
         {
             e.printStackTrace();
         }
         finally
         {
             Database.releaseStatement(stmt);
             Database.DisConnect(conn);
         }
         return SeqNum;
     }

    public void Insert(BookObj bo)
    {
        String sql = new String("Insert Into book Values(?,?,?,?,?,?,?,?,?,?,to_date(?,'YYYY-MM-DD'))");
        Connection conn = Database.Connect();
        PreparedStatement  stmt = Database.getStatement(conn,sql);
        try
        {
                stmt.setInt(1,bo.seqid);
                stmt.setString(2,bo.book_id);
                stmt.setString(3,bo.name);
                stmt.setString(4,bo.author);
                stmt.setString(5,bo.publish_com);
                stmt.setString(6,bo.price);
                stmt.setString(7,bo.introduction);
                stmt.setString(8,bo.description);
                stmt.setString(9,bo.sorts);
                stmt.setString(10,bo.status);
                stmt.setString(11, bo.book_date);
                stmt.executeUpdate();

        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
           Database.releaseStatement(stmt);
           Database.DisConnect(conn);
        }
    }

    public static void Update(String book_id,String name,String author,String publish_com,String price,String introduction,String description,String sorts,int oid)
    {
        String sql = new String("Update book set book_id=?,name=?, author=?, publish_com=?,price=?,introduction=?,description=?,sorts=? where id=?");
        Connection conn = Database.Connect();
        PreparedStatement  stmt = Database.getStatement(conn,sql);
        try
        {
                //stmt.setInt(1,bo.seqid);
                stmt.setString(1,book_id);
                stmt.setString(2,name);
                stmt.setString(3,author);
                stmt.setString(4,publish_com);
                stmt.setString(5,price);
                stmt.setString(6,introduction);
                stmt.setString(7,description);
                stmt.setString(8,sorts);
                stmt.setInt(9,oid);
                //stmt.setString(10,bo.status);
                stmt.executeUpdate();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
           Database.releaseStatement(stmt);
           Database.DisConnect(conn);
        }
    }

    public static void Delete(int oid)
    {
        String sql = new String("Delete From book Where id = ?");
        //System.out.println(sql.toString());
        Connection conn = Database.Connect();
        PreparedStatement  stmt = Database.getStatement(conn,sql);
        try
        {
            stmt.setInt(1,oid);
            stmt.executeUpdate();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
           Database.releaseStatement(stmt);
           Database.DisConnect(conn);
        }
    }

    public static BookObj[] Query()
    {
        Util faint=new Util();
        String sql = new String("Select * From book ");
        java.sql.Connection conn = Database.Connect();
        PreparedStatement stmt = Database.getStatement(conn, sql);
        ResultSet rs = null;
        BookObj bo[] = null;
        int counter = 0;
        int i = 0;
        try
        {
            stmt.executeQuery();
            rs = stmt.getResultSet();
            if(rs != null)
            {
                rs.last();
                counter = rs.getRow();
                bo = new BookObj[counter];
                rs.beforeFirst();
                for(i = 0; i < counter; i++)
                {
                    rs.next();
                    bo[i] = new BookObj();
                    bo[i].book_id = rs.getString("book_id");
                    bo[i].name = faint.Blank(rs.getString("name"));
                    bo[i].author = faint.Blank(rs.getString("author"));
                    bo[i].publish_com = faint.Blank(rs.getString("publish_com"));
                    bo[i].price = faint.Blank(rs.getString("price"));
                    bo[i].introduction = faint.Blank(rs.getString("introduction"));
                    bo[i].description = faint.Blank(rs.getString("description"));
                    bo[i].sorts = faint.Blank(rs.getString("sorts"));
                    bo[i].book_date = faint.Blank(rs.getString("book_date"));
                }
                rs.close();
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            Database.releaseStatement(stmt);
            Database.DisConnect(conn);
        }
        return bo;
    }


/*
     public static void main(String args[])
    {
       BookApply curObject = new BookApply();
       curObject.Update("1e11121","1e112121","212111","3e1211","4212","51211","6e111","7e111",71);
    }
  */
}