data_operate.java

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

package com.xmspk.ebp.books;

import java.sql.*;
import com.xmspk.ebp.books.Database;
/**
 * 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 Data_operate
 {
    public Data_operate()
    {
    }

    public static int getSequence()
    //ID自动增加设置
     {
         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.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 = ?");
        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);
        }
    }

}