jsqbean.java

受大学生欢迎的课程设计

package MyFly.Bean;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import MyFly.DataBase.sqlBean;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class jsqBean {
    private int id;
    private int count;
    public jsqBean() {
    }
    public void setId(int id)
    {
        this.id=id;
    }

    public int getId()
    {
        return this.id;
    }
    public void setCount(int count)
    {
        this.count=count;
    }

    public int getCount()
    {
        return this.count;
    }
    /**********更新**************************/
     public int update()
     {
             String sql = "update jsq set count=count+1 where id=1";
             sqlBean ben=new sqlBean();
             return ben.Update(sql);
    }
    /***********读取一条记录***************/
   public boolean getNew()
   {
        sqlBean ben=new sqlBean();
        String sql="select top 1 * from jsq";
       ResultSet set=ben.executeQuery(sql);
       try
       {
           if (set.next())
           {
               this.setId(set.getInt(1));
               setCount(set.getInt(2));
               return true;
           }
           else
           {
               return false;
           }
       }catch(SQLException e)
       {
           System.out.println("查询失败!");
           return false;
       }
   }


}