package pers.arrayli.utils;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import pers.arrayli.db.JDBCUtils;
import pers.arrayli.domain.AdminUser;
import pers.arrayli.domain.CheFei;
import pers.arrayli.domain.CheWei;
import pers.arrayli.domain.PageBean;
import pers.arrayli.domain.UserInfo;
/**
* @author lzj13
* 获取数据结果集
*/
public class ResultUtils {
public static List<CheFei> list = null; // 车费信息集合
public static List<CheWei> listCheWei = null; // 车位信息集合
public static final int pageSize = 7; // 每页显示的数据个数
public static List<AdminUser> listAdmin = null; // 管理员用户集合
public static List<UserInfo> listUser = null; // 普通用户集合
/**获取普通用户的信息集合
* @param UserName 名字用户
*/
public void getUserInfos(String UserName){
// 2.连接数据库进行模糊查询
QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
String sql = "select* from t_userinfo where 1=1";
if(UserName != null){
sql = sql + " and username like '%" + UserName + "%'";
}
System.out.println("sql: " + sql);
List<UserInfo> list1 = null;
try {
list1 = queryRunner.query(sql, new BeanListHandler<UserInfo>(UserInfo.class));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("总共有 " + list1.size() + "个记录");
for (UserInfo userInfo : list1) {
System.out.println(userInfo.toString());
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("==========================listCheWei===============");
listUser = list1;
for(UserInfo userInfo:listUser){
System.out.println(userInfo.toString());
}
System.out.println("==========================listCheWei===============");
}
/*
* @param currentPage 当前页数
* @param AdminUserName 管理员名字
* @return 分页查询的结果
*/
public List<UserInfo> PageListQueryUserInfos(int currentPage,String UserName){
UserInfo [] tempList = new UserInfo[listUser.size()];
List<UserInfo> temp = new ArrayList<UserInfo>();
Iterator<UserInfo> iterator = listUser.iterator();
for(int i=0;i<listUser.size();i++){
if(iterator.hasNext()){
tempList[i] = iterator.next();
}
}
if(tempList != null){
System.out.println("===================打印arrayList=================");
for(int i=0;i<tempList.length;i++){
System.out.println(tempList[i]);
}
System.out.println("===================打印arrayList=================");
// 2.判断是否是第一页，第一页的话，从 tempList 中获取个元素
if(currentPage == 1){
for(int i=0;(i<pageSize) && (i<tempList.length);i++){
temp.add(tempList[i]);
}
}else{
int j = 0;
// 遍历过 currentPage*pageSize 个元素
for(int i = (currentPage-1)*pageSize;(j<pageSize) && (i<tempList.length);i++ ){
temp.add(tempList[i]);
j++;
}
}
}
System.out.println("temp: "+temp.toString());
return temp;
}
/**
*获取管理员的信息集合
* @param AdminUserName 要查询的人的名字
*/
public void getAdminUsers(String AdminUserName){
// 2.连接数据库进行模糊查询
QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
String sql = "select* from t_admin where 1=1";
if(AdminUserName != null){
sql = sql + " and userName like '%" + AdminUserName + "%'";
}
System.out.println("sql: " + sql);
List<AdminUser> list1 = null;
try {
list1 = queryRunner.query(sql, new BeanListHandler<AdminUser>(AdminUser.class));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("总共有 " + list1.size() + "个记录");
for (AdminUser adminUser : list1) {
System.out.println(adminUser.toString());
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("==========================listCheWei===============");
listAdmin = list1;
for(AdminUser adminUser:listAdmin){
System.out.println(adminUser.toString());
}
System.out.println("==========================listCheWei===============");
}
/**
* @param currentPage 当前页数
* @param AdminUserName 管理员名字
* @return 分页查询的结果
*/
public List<AdminUser> PageListQueryAdminUsers(int currentPage,String AdminUserName){
AdminUser [] tempList = new AdminUser[listAdmin.size()];
List<AdminUser> temp = new ArrayList<AdminUser>();
Iterator<AdminUser> iterator = listAdmin.iterator();
for(int i=0;i<listAdmin.size();i++){
if(iterator.hasNext()){
tempList[i] = iterator.next();
}
}
if(tempList != null){
System.out.println("===================打印arrayList=================");
for(int i=0;i<tempList.length;i++){
System.out.println(tempList[i]);
}
System.out.println("===================打印arrayList=================");
// 2.判断是否是第一页，第一页的话，从 tempList 中获取个元素
if(currentPage == 1){
for(int i=0;(i<pageSize) && (i<tempList.length);i++){
temp.add(tempList[i]);
}
}else{
int j = 0;
// 遍历过 currentPage*pageSize 个元素
for(int i = (currentPage-1)*pageSize;(j<pageSize) && (i<tempList.length);i++ ){
temp.add(tempList[i]);
j++;
}
}
}
System.out.println("temp: "+temp.toString());
return temp;
}
/**按车位号和区域号
* @param hao 车位号
* @param quyu 区域号
*/
public void getCheWei(String hao,String quyu){
// 2.连接数据库进行模糊查询
QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
String sql = "select* from t_chewei where 1=1";
if (hao != null) {
sql = sql + " and hao like '%" + hao + "%'";
}
if(quyu != null){
sql = sql + "and quyu like '%" + quyu + "%'";
}
System.out.println("sql: " + sql);
List<CheWei> list1 = null;
try {
list1 = queryRunner.query(sql, new BeanListHandler<CheWei>(CheWei.class));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("总共有 " + list1.size() + "个记录");
for (CheWei chewei : list1) {
System.out.println(chewei.toString());
}
System.out.println("===========================打印模糊查询结果=================");
System.out.println("==========================listCheWei===============");
listCheWei = list1;
for(CheWei chewei:listCheWei){
System.out.println(chewei.toString());
}
System.out.println("==========================listCheWei===============");
}
/**
* @param currentPage 当前页数
* @param hao 车位号
* @param quyu 区域
* @return 车位信息集合
*/
public List<CheWei> PageListQueryCheWei(int currentPage, String hao, String quyu){
CheWei [] tempList = new CheWei[listCheWei.size()];
List<CheWei> temp = new ArrayList<CheWei>();
Iterator<CheWei> iterator = listCheWei.iterator();
for(int i=0;i<listCheWei.size();i++){
if(iterator.hasNext()){
tempList[i] = iterator.next();
}
}
if(tempList != null){
System.out.println("===================打印arrayList=================");
for(int i=0;i<tempList.length;i++){
System.out.println(tempList[i]);
}
System.out.println("===================打印arrayList=============
基于JavaWeb 的停车场管理系统 .zip （863个子文件） 
CheWeiDaoImpl.class 7KB ExportExcelUtil.class 5KB UserInfoDaoImpl.class 5KB LoginServlet.class 5KB PageListServlet.class 4KB CheDaoImpl.class 4KB CheFeiDaoImpl.class 4KB AdminUserDaoImpl.class 4KB ReserveServlet.class 3KB AddCheFeiServlet.class 3KB ModCheFeiPriceServlet.class 3KB DelCheServlet.class 3KB CheFeiServiceImpl.class 3KB AddCheServlet.class 3KB ModUserInfoServlet.class 3KB UserRegisterServlet.class 3KB AddCheweiServlet.class 2KB ModAdminServlet.class 2KB CheWeiServiceImpl.class 2KB ModCheServlet.class 2KB UserInfoServiceImpl.class 2KB TestTime.class 2KB PageBean.class 2KB CheFei.class 2KB AddUserInfoServlet.class 2KB ModCheweiServlet.class 2KB DelUserInfoServlet.class 2KB AddAdminServlet.class 2KB JDBCUtils.class 2KB RechargeServlet.class 2KB UserInfo.class 2KB CheWei.class 2KB Che.class 2KB CheFeiPriceDaoImpl.class 2KB SysInfo.class 2KB DelAdminServlet.class 2KB DelCheweiServlet.class 2KB CheServiceImpl.class 2KB AdminUserServiceImpl.class 2KB SysInfoUtils.class 2KB CalculateTime.class 2KB CharsetFilter.class 1KB AdminUser.class 1KB PictureUtils.class 1KB TestDelPicture.class 1KB CheFeiPriceServiceImpl.class 1KB CheFeiPrice.class 1022B CheWeiService.class 907B CheWeiDao.class 895B UserInfoService.class 821B UserInfoDao.class 809B CheFeiDao.class 732B AdminUserService.class 656B AdminUserDao.class 644B CheService.class 561B CheDao.class 549B CheFeiService.class 537B CheFeiPriceService.class 349B CheFeiPriceDao.class 337B .classpath 2KB org.eclipse.wst.common.component 471B org.eclipse.wst.jsdt.ui.superType.container 49B easyui.css 24KB easyui.css 24KB easyui.css 24KB easyui.css 24KB common.css 13KB common.css 13KB datepicker.css 5KB datepicker.css 5KB datepicker.css 5KB datepicker.css 5KB admin_login.css 4KB admin_login.css 4KB datagrid.css 4KB datagrid.css 4KB datagrid.css 4KB datagrid.css 4KB main.css 3KB main.css 3KB tabs.css 3KB tabs.css 3KB tabs.css 3KB tabs.css 3KB calendar.css 3KB calendar.css 3KB calendar.css 3KB calendar.css 3KB tree.css 2KB tree.css 2KB tree.css 2KB tree.css 2KB layout.css 2KB layout.css 2KB layout.css 2KB layout.css 2KB panel.css 1KB panel.css 1KB panel.css 1KB panel.css 1KB共 863 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
资源评论
Foreigner2292024-01-13资源内容详尽，对我有使用价值，谢谢资源主的分享。
程皮
- 粉丝: 277
- 资源: 2566
最新资源
- java制造业MES生产管理系统源码 MES源码数据库 MySQL源码类型 WebForm
- 基于无人机航拍数据实现的三维场景重建python源代码+文档说明+数据集（高分项目）
- 【重磅，更新！】全国2000-2022年植被指数数据(分辨率30m)
- 包含Qt5Core.dll Qt5Gui.dll Qt5Network.dll Qt5Svg.dll Qt5Widgets.dl
- python3.6 get-pip.py
- python期末大作业基于ResNet的人脸表情识别项目源码+数据集+模型文件（高分项目）
- C#大型多门店4S连锁汽车维修保养管理系统源码（带文档）数据库 SQL2008源码类型 WebForm
- 【安卓毕业设计】基于Android健康检测系统的设计与实现源码（完整前后端+mysql+说明文档）.zip
- 【重磅，更新！】中国分省农户创业活动农户创业活跃度(2011-2021年)
- YOLOv5 PyTorch 格式注释番茄叶病检测数据集下载
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
