usersaction.java

前台

package struts.houtaiaction;

import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import java.sql.*;

import conn.DBConnection;
import dao.UserDao;
import domain.Offers;
import domain.Users;

public class UsersAction extends Action{
    public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) {
    	
    	Connection conn = null;
    	PreparedStatement pstmt = null;
    	    	    	
    	UserDao pd = new UserDao();
    	List<Users> ulist = new ArrayList<Users>();
    	
    	int page;
    	int pageSize = 10;
    	int totalRow = pd.getRowNumber();
    	int totalPage = pd.getTotalPage(pageSize);
    	
    	String page0 = request.getParameter("Page");
    	if(page0 != null && page0 != ""){
    		page = Integer.parseInt(page0);
    	}else{
    		page = 1;
    	}
    	
    	if(page < 0){
    		page = 1;
    	}
    	if(page > totalPage){
    		page = totalPage;
    	}
    	
    	String sql = "SELECT * FROM webpk.users limit ?,?";    	
    	int start = (page-1)*pageSize;
    	
    	try{
    		conn = DBConnection.getConn();
    		pstmt = conn.prepareStatement(sql);
    		pstmt.setInt(1, start);
    		pstmt.setInt(2, pageSize);
    		ResultSet rs = pstmt.executeQuery();
    		
    		Users p = null;
    		while(rs.next()){
    			p = new Users();
    			p.setEmail(rs.getString("email"));    			
    			p.setPassword(rs.getString("password"));
    			p.setTruename(rs.getString("truename"));
    			p.setSex(rs.getString("sex"));
    			p.setProvince(rs.getString("province"));
    			p.setCity(rs.getString("city"));
    			p.setBirthday(rs.getDate("birthday"));
    			p.setTelephone(rs.getString("telephone"));
    			p.setMobile(rs.getString("mobile"));
    			p.setZip(rs.getString("zip"));
    			p.setAddress(rs.getString("address"));
    			p.setCredit(rs.getInt("credit"));
    			p.setIsclock(rs.getInt("isclock"));
    			p.setIsadmin(rs.getInt("isadmin"));
    			ulist.add(p);
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		DBConnection.closeConn();
    	}
    	
    	request.setAttribute("totalRecord", totalRow);		
		request.setAttribute("totalPage", totalPage); 
		request.setAttribute("whichpage", page);
    	
    	request.setAttribute("user", ulist);
    	return mapping.findForward("user");
    }
}