purbig.java

受大学生欢迎的课程设计

package MyFly.Bean;
import MyFly.DataBase.sqlBean;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class purBig {
    private int purID;          //编号
   private String content;      //配送内容

    public purBig()
    {

    }
    public void setPurID(int purID)
   {
       this.purID=purID;
   }
   public int getPurID()
   {
       return this.purID;
   }

   public void setContent(String content)
   {
       this.content=content;
   }

   public String getContent()
   {
       return this.content;
   }

   /********添加一条记录*************/
   public int addNew()
   {
       String sql = "insert into bigbuy (content) values (?)";
       sqlBean ben = new sqlBean();
       PreparedStatement pre = ben.executePre(sql);
       try {
           pre.setString(1, getContent());
           return pre.executeUpdate();
       } catch (SQLException ex) {
           return 0;
       }
   }

   /***********读取一条记录***************/
  public boolean getNew(int id)
  {
      String Id=Integer.toString(id);
      sqlBean ben=new sqlBean();
      String sql="select * from bigbuy where id="+Id;
      ResultSet set=ben.executeQuery(sql);
      try
      {
          if (set.next())
          {
              setPurID(id);
              setContent(set.getString(2));
              return true;
          }

      }catch(SQLException e)
      {
          return false;
      }
      return false;
  }

  /***********读取一条记录***************/
      public boolean getNew()
      {
           sqlBean ben=new sqlBean();
           String sql="select * from bigbuy limit 1";
          ResultSet set=ben.executeQuery(sql);
          try
          {
              if (set.next())
              {
                  this.setPurID(set.getInt(1));
                  setContent(set.getString(2));
                  return true;
              }
          }catch(SQLException e)
          {
              System.out.println("查询失败!");
              return false;
          }
          return false;
      }
  /**********更新**************************/
      public int update()
      {
          String sql = "update bigbuy set content=? where id=?";
          sqlBean ben=new sqlBean();
          PreparedStatement pre=ben.executePre(sql);
          try {
              pre.setString(1, getContent());
              pre.setInt(2, getPurID());
            return pre.executeUpdate();
     } catch (SQLException ex)
     {
         return 0;
     }
 }

 /**************删除*********************/
         public int delete(int ID)
         {
             String sql="delete from bigbuy where id="+Integer.toString(ID);
             sqlBean ben=new sqlBean();
             return ben.executeDelete(sql);
         }

  /*******************返回查询***************/
  public ResultSet getQuery(String sql)
  {
      sqlBean ben=new sqlBean();
      ResultSet st=ben.executeQuery(sql);
      return st;
  }
}