clientpage.java

使用jsp+Servlet,采用MVC模式,实现了一典型小型电子商务网站的全过程.包括前台和后台的全部功能.适合于初学者学习使用.

package com.eshop.page;


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

import com.eshop.util.DBManager;
import com.eshop.vo.Account;

/**
 * @author JON
 */
public class ClientPage extends PageBusiness {

	String accountTable="account";
	
	/**
	 *构造方法
	 */
	public ClientPage()throws Exception
	{
		super();	
		v=new Vector();
	}
	/**
	 *获得所有记录数
	 */
	public int getAvailableCount(String conditions)throws Exception
	{
		DBManager dbManager=new DBManager();
		Connection conn=null;
		int ret=0;
		try
		{
				 conn=dbManager.GetConnection();
				ret=this.getAvailableCountHelper(conn,accountTable,conditions);
				conn.close();
	    }
	    catch(Exception e)
	    {
	    	
	    } 
	    finally
	    {
	    	try{conn.close();}catch(Exception e2){}
	    }
	    return ret;
	}

    /**
     *查询数据库，获得要显示的信息，然后通过pageBean返回
     */
	public PageBean listData(String page,String conditions)throws Exception
	{
		DBManager dbManager=new DBManager();
		Connection conn=null;
		try
		{
			conn = dbManager.GetConnection();
            PageBean pageBean = new PageBean(this, conditions);
            int pageNum = Integer.parseInt(page);
            String sql = "SELECT top " + pageNum * pageBean.rowsPerPage + " userid,name FROM ACCOUNT where " + conditions + " and status=0 order by userid desc";
            sql = "SELECT TOP " + pageBean.rowsPerPage + " * FROM (" + sql + ") a1 order by userid asc";
            String searchSql = "SELECT * FROM (SELECT userid,name rownumber() OVER(ORDER BY USERID) AS ROW_NEXT FROM ACCOUNT where " + conditions + " )AS ACCOUNT_TEMP WHERE ROW_NEXT BETWEEN ? and ? ";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            ResultSet rs;
           Account account;
            for(rs = pstmt.executeQuery(); rs.next(); v.add(account))
            {
            	account = new Account();
            	account.setUserid(rs.getString("userid"));
                account.setName(rs.getString("name"));
                        }

            rs.close();
            pstmt.close();
            conn.close();
            pageBean.curPage = pageNum;
            pageBean.data = v;
            
            return pageBean;
		}
		catch(Exception e)
		{		   
		   	e.printStackTrace();
			throw e;
			
		}
		finally
		{
				try{conn.close();}catch(Exception e2){}
		}
	}
	public Vector getResult()throws Exception
	{
		return v;
	}

}