contactbean.java~2~

一个很不错的电子商务后台管理系统 这是一个电子商务网站的后台管理系统 要运行此系统必须具备以下条件 1.首先要把SNSQL文本中的SQL脚本确保在SQL Server中执行 2.包Se

package xian.bin.page;

import java.util.*;
import java.sql.*;

public class ContactBean {
  private Connection con=null;
  Vector v;
  public ContactBean() throws Exception{
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:sqlserver","","");
      v=new Vector();
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }

  public int getAvailableCount()throws Exception{
    int ret=0;
    Statement stmt=con.createStatement();
    String strSql="select count(*)from manager";
    ResultSet rt=stmt.executeQuery(strSql);
    while(rt.next()){
      ret=rt.getInt(1);
    }
    return ret;
  }

  public PageBean listData(String page)throws Exception{
    try{
      PageBean pageBean=new PageBean(this);
      int pageNum=Integer.parseInt(page);
      Statement stmt=con.createStatement();
      String strSql="select top"+pageNum*pageBean.rowsPerPage+"*from contact order by admin";
      ResultSet rt=stmt.executeQuery(strSql);
      int i=0;
      while(rt.next()){
        if(i>(pageNum-1)*pageBean.rowsPerPage-1){
          Object[] obj=new Object[3];
          obj[0]=rt.getString(1);
          obj[1]=rt.getString(2);
          obj[2]=rt.getString(3);
          v.add(obj);
        }
        i++;
      }
      rt.close();
      stmt.close();

      pageBean.curPage=pageNum;
      pageBean.data=v;
      return pageBean;
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }

  public Vector getResult()throws Exception{
    return v;
  }
}