package com.mingri.info;
import com.mingri.dbconn.DBResult;
import java.sql.ResultSet;
import java.sql.SQLException;
public class QuestString {
private int curPage; //当前页数
private int maxPage; //最大页数
private int maxRowCount; //总记录数(即从数据库中查出的所有记录)
private int pageSize=2; //每页要显示的记录数
private DBResult db; //记录集对象
private String httpFile; //当前地址栏的文件,即具体的JSP文件
private String cif; //选择的查询字段
private String ccif; //选择的查询运算符
private String qvalue; //查询关键字
private String countSql=null; //用来存储select count (*) ……语句
private String topSql=null; //用来存储 select top 2……语句
private String nowPage=null; //初始化当前页curPage变量,即获取当前页的具体页号
private String str_parameter; //在做翻页时,传递除pages以外的其他参数
private String andor; //查询的与/或条件
private String sdate; //查询起始时间,即从什么日期开始查询
private String edate; //查询结束时间,即到什么日期结束
private String orderby; //排序条件,即按什么排序
private String paixu; //排序方法,即升序或降序
public QuestString(){ //构造方法,用来设置db为一个DBResult()对象
pageSize = 2;
countSql = null;
topSql = null;
nowPage = null;
db = new DBResult();
}
public int getCurPage() {
return curPage;
}
public void setCurPage(int i) {
curPage = i;
}
public int getMaxPage() {
return maxPage;
}
public void setMaxPage(int i) {
maxPage = i;
}
public int getMaxRowCount() {
return maxRowCount;
}
public void setMaxRowCount(int i) {
maxRowCount = i;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int i) {
pageSize = i;
}
public String getHttpFile() {
return httpFile;
}
public void setHttpFile(String s) {
httpFile = s;
}
public String getCcif() {
return ccif;
}
public void setCcif(String s) {
ccif = s;
}
public String getCif() {
return cif;
}
public void setCif(String s) {
cif = s;
}
public String getQValue() {
return qvalue;
}
public void setQValue(String s) {
qvalue = s;
}
public String getStr_parameter() {
return str_parameter;
}
public void setStr_parameter(String s) {
str_parameter = s;
}
public String getAndor() {
return andor;
}
public void setAndor(String s) {
andor = s;
}
public String getSdate() {
return sdate;
}
public void setSdate(String s) {
sdate = s;
}
public String getEdate() {
return edate;
}
public void setEdate(String s) {
edate = s;
}
public String getOrderby() {
return orderby;
}
public void setOrderby(String s) {
orderby = s;
}
public String getPaixu() {
return paixu;
}
public void setPaixu(String s) {
paixu = s;
}
/**
* 通过参数传递来设置Bean中的属性
*/
public void setQuerySql(String s, String s1, String s2) {
nowPage = s1; //将表单提交过来的参数pages(第几页)的值传递给变量nowPage保存
httpFile = s; //用来动态设置处理表单请求的JSP文件
countSql = s2; //用来设置执行select count(*)……的SQL语句
try {
querySql(countSql);//调用querySql()方法,并将参数countSql传递到该方法中
} catch (Exception exception) {
exception.printStackTrace();
}
}
/**
* 执行SQL语句,获得分页显示时的各个属性
*/
public void querySql(String s) throws SQLException {
if (nowPage == null || "".equals(nowPage)) {
curPage = 1;
} else {
curPage = Integer.parseInt(nowPage);
if (curPage < 1)
curPage = 1;
}
ResultSet resultset = db.getResult(s);
if (resultset.next())
maxRowCount = resultset.getInt(1);
maxPage = maxRowCount % pageSize != 0 ? maxRowCount / pageSize + 1
: maxRowCount / pageSize;
if (curPage > maxPage)
curPage = maxPage;
resultset.close();
}
/**
* 一个字符串,用来动态的给出一个表单
* 该表单用来进行分页和统计页面间的跳转
*/
public String pageFooter() {
//创建一个表单
String s = "<form action=" + httpFile + " name=formBean methord=post>";
int i = curPage - 1;//向前翻页,即当前页减1
int j = curPage + 1;//向后翻页,即当前页加1
s = s + "<font style='font-size: 10pt'>总计<font color='red'>"
+ getMaxRowCount() + "</font>条记录," + "【共<font color='red'>"
+ getMaxPage() + "</font>页】";
s = s + "【 <font color='red'>" + pageSize
+ "</font>条/页】 当前第<font color='red'>" + getCurPage()
+ "</font>页 ";
if (curPage > 1)
s = s + " <A href=" + httpFile + "?pages=1" + str_parameter
+ ">首页</A> ";
else
s = s + " 首页 ";
if (curPage > 1)
s = s + " <A href=" + httpFile + "?pages=" + i + str_parameter
+ ">上一页</A> ";
else
s = s + " 上一页 ";
if (curPage < maxPage)
s = s + " <A href=" + httpFile + "?pages=" + j + str_parameter
+ ">下一页</A> ";
else
s = s + " 下一页 ";
if (maxPage > 1 && curPage != maxPage)
s = s + " <A href=" + httpFile + "?pages=" + maxPage
+ str_parameter + ">尾页</A>";
else
s = s + " 尾页</font>";//在页面跳转间设置隐藏表单,来保存不同的请求
s = s + "转到<input type ='text' name='pages' size='2'>页"
+ "<input type='hidden' name='ccif' value='" + ccif
+ "'><input type ='hidden' name='cif' value='" + cif
+ "'><input type ='hidden' name='qvalue' value='" + qvalue
+ "'><input type ='hidden' name='andor' value='" + andor
+ "'><input type ='hidden' name='sdate' value='" + sdate
+ "'><input type ='hidden' name='edate' value='" + edate
+ "'><input type ='hidden' name='orderby' value='" + orderby
+ "'><input type ='hidden' name='paixu' value='" + paixu
+ "'><input type='submit' name='sumbmit' value='go'></form>";
return s;
}
/**
* 根据不同条件来获取不同的查询前N条记录的SQL语句
*/
public String getString(String s) {
if (ccif.equals("=")) {
String s1 = "select top " + pageSize * curPage + " * from " + s
+ " where" + " " + cif + "=" + "'" + qvalue + "'";
return s1;
}
if (ccif.equals("LIKE")) {
String s2 = "select top " + pageSize * curPage + " * from " + s
+ " where" + " " + cif + " " + "like" + " " + "'%" + qvalue
+ "%'";
return s2;
}
if (ccif.equals("ALL")) {
String s3 = "select top " + pageSize * curPage + " * from " + s;
return s3;
}
if (ccif.equals("<")) {
String s4 = "select top " + pageSize * curPage + " * from " + s
+ " where " + cif + " < '" + qvalue + "'";
return s4;
} else {
return null;
}
}
public String getXSString(String s) {
if (ccif.equals("=")) {
String s1 = "select top " + pageSize * curPage + " * from " + s
+ " where" + " " + cif + "=" + "'" + qvalue
+ "' and whether='否'";
return s1;
}
if (ccif.equals("LIKE")) {
String s2 = "select top " + pageSize * curPage + " * from " + s
+ " where" + " " + cif + " " + "like" + " " + "'%" + qvalue
+ "%'and whether='否'";
return s2;
} else {
return null;
}
}
/**
* 根据不同条件来获得不同的计算记录总数的SQL语句
*/
public String getCount(String s) {
if (ccif.equals("=")) {
String s1 = "select count(*) from " + s + " where" + " " + cif
+ "=" + "'" + qvalue + "'";
return s1;
}
if (ccif.equals("LIKE")) {
String s2 = "select count(*) from " + s + " where" + " " + cif
+ " " + "like" + " " + "'%" + qvalue + "%'";
return s2;
}
if (ccif.equals("ALL")) {
String s3 = "select count(*) from " + s;
return s3;
}
if (ccif.equals("<")) {
String s4 = "select count(*) from " + s + " where " + cif + " < '"
+ qvalue + "'";
return s4;
} else {
return null;
}
}
public String getXSCount(String s) {
if (ccif.equal
没有合适的资源?快使用搜索试试~ 我知道了~
【毕设】基于ssm的jsp的进销存管理系统毕业设计附源码和说明.zip
共147个文件
jsp:77个
gif:14个
java:12个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 165 浏览量
2023-05-18
15:41:50
上传
评论
收藏 3.57MB ZIP 举报
温馨提示
【毕设】基于ssm的jsp的进销存管理系统毕业设计附源码和说明.zip
资源推荐
资源详情
资源评论
收起资源包目录
【毕设】基于ssm的jsp的进销存管理系统毕业设计附源码和说明.zip (147个子文件)
speaker.bmp 202B
QuestString.class 10KB
Quest.class 4KB
CalendarBean.class 3KB
SpRegist.class 2KB
KhinfoBean.class 2KB
GysinfoBean.class 2KB
SpinfoBean.class 2KB
DBResult.class 2KB
KhRegist.class 2KB
GysRegist.class 2KB
ShowTime.class 1KB
ToChinese.class 955B
.classpath 587B
org.eclipse.wst.jsdt.ui.superType.container 49B
style.css 2KB
Thumbs.db 6KB
程序使用说明.doc 76KB
left_top.GIF 2KB
cup.GIF 2KB
login_btn_bg.gif 991B
Imgmenu1_2.gif 913B
homepage.GIF 901B
email.GIF 900B
home.gif 654B
revigate.GIF 608B
datetime.gif 193B
ed-item.gif 179B
dmwaste.gif 156B
jobPane.gif 111B
Imgmenu1_1.gif 77B
subMenu_ico.GIF 71B
gysinfo.html 3KB
khinfo.html 3KB
jfreechart-1.0.9.jar 1.23MB
sqljdbc.jar 570KB
jcommon-1.0.9.jar 298KB
QuestString.java 11KB
Quest.java 3KB
CalendarBean.java 3KB
KhinfoBean.java 2KB
GysinfoBean.java 2KB
SpinfoBean.java 1KB
SpRegist.java 1KB
DBResult.java 1KB
KhRegist.java 1KB
ShowTime.java 1KB
GysRegist.java 1003B
ToChinese.java 331B
logo.jpg 68KB
login_top.jpg 49KB
login_bottom.jpg 40KB
menu_1a.JPG 22KB
menu_1.JPG 22KB
menu_6.JPG 22KB
menu_4.JPG 21KB
menu_3.JPG 21KB
menu_7.JPG 21KB
menu_5.JPG 21KB
login_btn_bg.jpg 14KB
.jsdtscope 500B
spxsth.jsp 9KB
spxs.jsp 9KB
left.jsp 7KB
sprk.jsp 7KB
sprkth.jsp 7KB
rkthjz.jsp 7KB
sprkjz.jsp 7KB
xsthjz.jsp 6KB
spxsjz.jsp 6KB
xsxxquest1.jsp 5KB
sprkquest1.jsp 5KB
rkjzquest1.jsp 5KB
xsjzquest1.jsp 5KB
spxsphquest1.jsp 4KB
modifyPrice1.jsp 4KB
usermanager.jsp 4KB
xsxxquest.jsp 3KB
sprkquest.jsp 3KB
spxsphquest.jsp 3KB
khquest.jsp 3KB
spinfo1.jsp 3KB
spquest.jsp 3KB
rkjzquest.jsp 3KB
xsjzquest.jsp 3KB
sprkthChange.jsp 3KB
spChange.jsp 3KB
addUser.jsp 3KB
spyearquest.jsp 3KB
gysquest.jsp 2KB
xsthChange.jsp 2KB
xsChange.jsp 2KB
kcquest.jsp 2KB
spquest1.jsp 2KB
gysquest1.jsp 2KB
kcquest1.jsp 2KB
khquest1.jsp 2KB
index.jsp 2KB
rkthjz1.jsp 2KB
spxsjz1.jsp 2KB
共 147 条
- 1
- 2
资源评论
Matlab科研辅导帮
- 粉丝: 1w+
- 资源: 7491
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功