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资源内容详尽，对我有使用价值，谢谢资源主的分享。
程皮
- 粉丝: 280
- 资源: 2567
最新资源
- 【独家首发】鲸鱼算法WOA优化Transformer-LSTM负荷数据回归预测【含Matlab源码 6386期】.zip
- 【独家首发】开普勒算法KOA优化Transformer-LSTM负荷数据回归预测【含Matlab源码 6387期】.zip
- MATLAB轴承动力学模拟：不同故障类型下的滚动轴承性能分析与时域波形输出,MATLAB轴承动力学模拟：不同故障类型下的滚动轴承性能分析与时域波形输出,MATLAB轴承动力学代码（正常、外圈故障、内圈
- 【JCR1区】鸽群算法PIO-CNN-SVM故障诊断分类预测【含Matlab源码 5787期】.zip
- 【独家首发】金枪鱼算法TSO优化Transformer-LSTM负荷数据回归预测【含Matlab源码 6385期】.zip
- 【BiLSTM数据预测】双向长短时记忆BiLSTM（多输入单输出）数据预测【含Matlab源码 1826期】.zip
- 【BiLSTM数据预测】双向长短时记忆BiLSTM数据预测【含Matlab源码 1793期】.zip
- 【LSTM时间序列预测】深度学习的长短期记忆网络LSTM时间序列预测未来【含Matlab源码 2345期】.zip
- 【LSTM数据预测】BP+ELM+LSTM+BiLSTM+SAELSTM数据预测【含Matlab源码 1825期】.zip
- 【风速预测】DBN算法风速预测【含Matlab源码 1400期】.zip
- 【LSTM回归预测】长短期记忆网络数据回归预测（多输入多输出）【含Matlab源码 3200期】.zip
- 【ARMA仿真】 ARMA模型卡尔曼滤波【含Matlab源码 2431期】.zip
- 【ARMA故障预测】ARMA故障预测【含Matlab源码 2432期】.zip
- 【ARMA时间序列分析】ARMA时间序列分析【含Matlab源码 2430期】.zip
- 【预测模型】模糊小波神经网络目标威胁评估【含Matlab源码 1621期】.zip
- 【BiLSTM数据预测】双向长短时记忆BiLSTM数据预测【含Matlab源码 1824期】.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
