test.java

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

package com.xmspk.ebp.test;
import java.sql.*;
import com.xmspk.ebp.test.Database;
/**
 * User: yancaiding
 * Date: May 7, 2003
 * Email:[e-mail]
 * Time: 9:37:13 AM
 */
public class test {

    public test(){
    }

    //实现id自动增加
    public static int getSequence()
     {
         String sql = new String("Select zzzSeq.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(int testid, String testname)
    {
        String sql = new String("Insert Into zzz Values(?,?)");
        Connection conn = Database.Connect();
        PreparedStatement  stmt = Database.getStatement(conn,sql);
        try
        {
                stmt.setInt(1,testid);
                stmt.setString(2,testname);
                stmt.executeUpdate();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
           Database.releaseStatement(stmt);
           Database.DisConnect(conn);
        }
    }

    //数据删除
    public static void Delete(int testid)
       {
           String sql = new String("Delete From zzz  Where ID = ?");
           java.sql.Connection conn = Database.Connect();
           PreparedStatement stmt = Database.getStatement(conn, sql);
           try
           {
               stmt.setInt(1,testid);
               stmt.executeUpdate();
           }
           catch(Exception e)
           {
               e.printStackTrace();
           }
           finally
           {
               Database.releaseStatement(stmt);
               Database.DisConnect(conn);
           }
       }

     //数据查询
     public static testobj Search(int testid)
           {
               testobj data=null;
               String sql = new String("Select * From  zzz  Where ID = ?");
               java.sql.Connection conn = Database.Connect();
               PreparedStatement stmt = Database.getStatement(conn, sql);
               ResultSet rs = null;
               try
               {
                   stmt.setInt(1,testid);
                   stmt.executeQuery();
                   rs = stmt.getResultSet();
                   if(rs != null)
                   {
                          rs.next();
                          data = new testobj();
                          data.testid = rs.getInt("ID");
                          data.testname = rs.getString("Name");
                          if(data.testname == null)
                             data.testname = "";

                       rs.close();
                  }

               }
               catch(Exception e)
               {
                   e.printStackTrace();
               }
               finally
               {
                   Database.releaseStatement(stmt);
                   Database.DisConnect(conn);
               }
               return data;
           }
         //数据修改
         public static void Update(String testname,int testid)
             {
                 String sqlUpdate = new String("Update zzz SET Name = ?  Where ID = ?");
                 java.sql.Connection conn = Database.Connect();
                 PreparedStatement stmt = Database.getStatement(conn, sqlUpdate);
                 try
                 {
                     stmt.setString(1, testname);
                     stmt.setInt(2, testid);
                     stmt.executeUpdate();
                 }
                 catch(Exception e)
                 {
                     e.printStackTrace();
                 }
                 finally
                 {
                     Database.releaseStatement(stmt);
                     Database.DisConnect(conn);
                 }
             }
        //数据列表
}