- 浏览: 48725 次
- 性别:
- 来自: 合肥
文章分类
最新评论
先给出servlet
package com.ourchr.shop.servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.ourchr.shop.bo.ProductBO;
import com.ourchr.shop.entity.Product;
public class Product_listServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
String sPageNow = request.getParameter("pageNow");
int rowCount = new ProductBO().getRowCount();
int pageNow=1;
int pageSize = 5;
int pageCount;
if(sPageNow !=null){
pageNow = Integer.parseInt(sPageNow);
}
List<Product> products = new ProductBO().getAllProducts(pageNow,pageSize);
if(rowCount % pageSize ==0){
pageCount = rowCount/pageSize;
}else{
pageCount = rowCount/pageSize+1;
}
request.setAttribute("pageNow", pageNow);
request.setAttribute("pageCount", pageCount);
request.setAttribute("pageSize", pageSize);
request.setAttribute("rowCount", rowCount);
request.setAttribute("products",products);
request.getRequestDispatcher("/product_list.jsp").forward(request, response);
}
}
在给出jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<link rel="stylesheet" href="../css/drp.css">
<script type="text/javascript" src="js/small_window.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="js/jquery-1.4.min.js"></script>
<style type="text/css">
/* CSS Document */
body {
font: normal 11px auto "Trebuchet MS", Verdana, Arial, Helvetica,
sans-serif;
color: #4f6b72;
background: #E6EAE9;
}
a {
color: #c75f3e;
}
#mytable {
width: 100%;
padding: 0;
margin: 0;
}
caption {
padding: 0 0 5px 0;
width: 700px;
font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
text-align: right;
}
th {
font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #4f6b72;
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
border-top: 1px solid #C1DAD7;
letter-spacing: 2px;
text-transform: uppercase;
text-align: left;
padding: 6px 6px 6px 12px;
background: #CAE8EA no-repeat;
}
/*power by www.winshell.cn*/
th.nobg {
border-top: 0;
border-left: 0;
border-right: 1px solid #C1DAD7;
background: none;
}
td {
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
background: #fff;
font-size: 11px;
padding: 6px 6px 6px 12px;
color: #4f6b72;
}
/*power by www.winshell.cn*/
td.alt {
background: #F5FAFA;
color: #797268;
}
th.spec {
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #fff no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
}
th.specalt {
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #f5fafa no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #797268;
}
/*---------for IE 5.x bug*/
html>body td {
font-size: 11px;
}
body,td,th {
font-family: 宋体, Arial;
font-size: 12px;
}
.jumpTO{
width:25px;
}
</style>
</head>
<body class="body1">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="28">
<img src="images/index_32.gif" width="28" height="29" />
</td>
<td background="images/index_34.gif" style="padding-left: 10px;"
style="font-size: 12px">
<b>商品管理>>商品列表</b>
</td>
</tr>
</table>
<table width="100%" cellspacing="0" id="mytable">
<tr style="background-color: gray">
<th width="5%" scope="col">
编号
</th>
<th width="15%" scope="col">
商品名称
</th>
<th width="10%" scope="col">
添加者
</th>
<th width="15%" scope="col">
商品货号
</th>
<th width="10%" scope="col">
市场价
</th>
<th width="10%" scope="col">
进货价
</th>
<th width="10%" scope="col">
经销商价
</th>
<th width="10%" scope="col">
商品图片
</th>
<td width="15%" scope="col">
操作
</td>
</tr>
<c:forEach items="${products}" var="product">
<tr>
<td>${product.id}</td>
<td>${product.name }</td>
<td>${user.realName}</td>
<td>${product.number }</td>
<td>${product.marketPrice }</td>
<td>${product.purchasePrice }</td>
<td>${product.salePrice }</td>
<td>查看</td>
<td>
<a href="#">修改</a>
<a href="#">删除</a>
</td>
</tr>
</c:forEach>
</table>
<table width="100%" height="30" border="0" align="center"
cellpadding="0" cellspacing="0" class="rd1">
<tr>
<td nowrap class="rd19">
<DIV class=pagebar>
<DIV id=pager
style="PADDING-RIGHT: 10px; MARGIN-TOP: 10px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px; HEIGHT: auto">
<c:if test="${pageNow !=1}">
<A class=next href="product_list.do?pageNow=${pageNow-1}">上一页</A>
</c:if>
总计
<B>${rowCount}</B> 个记录 当前
<SPAN class=page_now>${pageNow}/${pageCount }</SPAN>页
<c:if test="${pageNow}!=${pageCount}"></c:if>
<A class=next href="product_list.do?pageNow=${pageNow+1}">下一页</A>
<FORM ACTION="product_list.do">
<input class="jumpTO" type="text" name="pageNow"/>
<input type="submit" value="go"/>
</FORM>
</DIV>
</DIV>
</td>
</tr>
</table>
</body>
</html>
当然数据库自己可以建立下!这里就忽略了,主要是方法掌握就行了!
对了还有dao层:
package com.ourchr.shop.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.ourchr.shop.dao.IProductDAO;
import com.ourchr.shop.entity.Product;
import com.ourchr.shop.util.ConnectionProvide;
import com.ourchr.shop.util.JDBC;
public class ProductDAO implements IProductDAO{
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
public void close(){
if(ps !=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps !=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(con !=null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public int findRowCount() {
int rowCount =0;
con = ConnectionProvide.getConnection();
try {
ps = con.prepareStatement("select count(*) from product");
rs = ps.executeQuery();
if(! rs.next()){
return 0;
}
rowCount = rs.getInt(1);
} catch (SQLException e) {
e.printStackTrace();
}
return rowCount;
}
public List<Product> findAllProducts(int pageNow,int pageSize) {
List<Product> products = new ArrayList<Product>();
con =new JDBC().getConnection() ;
String sql ="select * from product limit ?,?";
try {
ps = con.prepareStatement(sql);
ps.setInt(1, pageSize*(pageNow-1));
ps.setInt(2, pageSize);
rs = ps.executeQuery();
while(rs.next()){
Product p = new Product();
p.setId(rs.getInt("pId"));
p.setName(rs.getString("pName"));
p.setNumber(rs.getString("product_no"));
p.setMarketPrice(rs.getFloat("market_price"));
p.setPurchasePrice(rs.getFloat("purchase_price"));
p.setSalePrice(rs.getFloat("sale_price"));
p.setImage(rs.getString("image"));
products.add(p);
}
return products;
} catch (SQLException e) {
e.printStackTrace();
}
return products;
}
// public static void main(String[] args) {
// List<Product> products =new ProductDAO().findAllProducts(3, 2);
// for(Product product:products){
// System.out.println(product.getId());
// }
// }
}
我使用的是连接池,大家可以随意
package com.ourchr.shop.servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.ourchr.shop.bo.ProductBO;
import com.ourchr.shop.entity.Product;
public class Product_listServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
String sPageNow = request.getParameter("pageNow");
int rowCount = new ProductBO().getRowCount();
int pageNow=1;
int pageSize = 5;
int pageCount;
if(sPageNow !=null){
pageNow = Integer.parseInt(sPageNow);
}
List<Product> products = new ProductBO().getAllProducts(pageNow,pageSize);
if(rowCount % pageSize ==0){
pageCount = rowCount/pageSize;
}else{
pageCount = rowCount/pageSize+1;
}
request.setAttribute("pageNow", pageNow);
request.setAttribute("pageCount", pageCount);
request.setAttribute("pageSize", pageSize);
request.setAttribute("rowCount", rowCount);
request.setAttribute("products",products);
request.getRequestDispatcher("/product_list.jsp").forward(request, response);
}
}
在给出jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<link rel="stylesheet" href="../css/drp.css">
<script type="text/javascript" src="js/small_window.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="js/jquery-1.4.min.js"></script>
<style type="text/css">
/* CSS Document */
body {
font: normal 11px auto "Trebuchet MS", Verdana, Arial, Helvetica,
sans-serif;
color: #4f6b72;
background: #E6EAE9;
}
a {
color: #c75f3e;
}
#mytable {
width: 100%;
padding: 0;
margin: 0;
}
caption {
padding: 0 0 5px 0;
width: 700px;
font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
text-align: right;
}
th {
font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #4f6b72;
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
border-top: 1px solid #C1DAD7;
letter-spacing: 2px;
text-transform: uppercase;
text-align: left;
padding: 6px 6px 6px 12px;
background: #CAE8EA no-repeat;
}
/*power by www.winshell.cn*/
th.nobg {
border-top: 0;
border-left: 0;
border-right: 1px solid #C1DAD7;
background: none;
}
td {
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
background: #fff;
font-size: 11px;
padding: 6px 6px 6px 12px;
color: #4f6b72;
}
/*power by www.winshell.cn*/
td.alt {
background: #F5FAFA;
color: #797268;
}
th.spec {
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #fff no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
}
th.specalt {
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #f5fafa no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #797268;
}
/*---------for IE 5.x bug*/
html>body td {
font-size: 11px;
}
body,td,th {
font-family: 宋体, Arial;
font-size: 12px;
}
.jumpTO{
width:25px;
}
</style>
</head>
<body class="body1">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="28">
<img src="images/index_32.gif" width="28" height="29" />
</td>
<td background="images/index_34.gif" style="padding-left: 10px;"
style="font-size: 12px">
<b>商品管理>>商品列表</b>
</td>
</tr>
</table>
<table width="100%" cellspacing="0" id="mytable">
<tr style="background-color: gray">
<th width="5%" scope="col">
编号
</th>
<th width="15%" scope="col">
商品名称
</th>
<th width="10%" scope="col">
添加者
</th>
<th width="15%" scope="col">
商品货号
</th>
<th width="10%" scope="col">
市场价
</th>
<th width="10%" scope="col">
进货价
</th>
<th width="10%" scope="col">
经销商价
</th>
<th width="10%" scope="col">
商品图片
</th>
<td width="15%" scope="col">
操作
</td>
</tr>
<c:forEach items="${products}" var="product">
<tr>
<td>${product.id}</td>
<td>${product.name }</td>
<td>${user.realName}</td>
<td>${product.number }</td>
<td>${product.marketPrice }</td>
<td>${product.purchasePrice }</td>
<td>${product.salePrice }</td>
<td>查看</td>
<td>
<a href="#">修改</a>
<a href="#">删除</a>
</td>
</tr>
</c:forEach>
</table>
<table width="100%" height="30" border="0" align="center"
cellpadding="0" cellspacing="0" class="rd1">
<tr>
<td nowrap class="rd19">
<DIV class=pagebar>
<DIV id=pager
style="PADDING-RIGHT: 10px; MARGIN-TOP: 10px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px; HEIGHT: auto">
<c:if test="${pageNow !=1}">
<A class=next href="product_list.do?pageNow=${pageNow-1}">上一页</A>
</c:if>
总计
<B>${rowCount}</B> 个记录 当前
<SPAN class=page_now>${pageNow}/${pageCount }</SPAN>页
<c:if test="${pageNow}!=${pageCount}"></c:if>
<A class=next href="product_list.do?pageNow=${pageNow+1}">下一页</A>
<FORM ACTION="product_list.do">
<input class="jumpTO" type="text" name="pageNow"/>
<input type="submit" value="go"/>
</FORM>
</DIV>
</DIV>
</td>
</tr>
</table>
</body>
</html>
当然数据库自己可以建立下!这里就忽略了,主要是方法掌握就行了!
对了还有dao层:
package com.ourchr.shop.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.ourchr.shop.dao.IProductDAO;
import com.ourchr.shop.entity.Product;
import com.ourchr.shop.util.ConnectionProvide;
import com.ourchr.shop.util.JDBC;
public class ProductDAO implements IProductDAO{
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
public void close(){
if(ps !=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps !=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(con !=null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public int findRowCount() {
int rowCount =0;
con = ConnectionProvide.getConnection();
try {
ps = con.prepareStatement("select count(*) from product");
rs = ps.executeQuery();
if(! rs.next()){
return 0;
}
rowCount = rs.getInt(1);
} catch (SQLException e) {
e.printStackTrace();
}
return rowCount;
}
public List<Product> findAllProducts(int pageNow,int pageSize) {
List<Product> products = new ArrayList<Product>();
con =new JDBC().getConnection() ;
String sql ="select * from product limit ?,?";
try {
ps = con.prepareStatement(sql);
ps.setInt(1, pageSize*(pageNow-1));
ps.setInt(2, pageSize);
rs = ps.executeQuery();
while(rs.next()){
Product p = new Product();
p.setId(rs.getInt("pId"));
p.setName(rs.getString("pName"));
p.setNumber(rs.getString("product_no"));
p.setMarketPrice(rs.getFloat("market_price"));
p.setPurchasePrice(rs.getFloat("purchase_price"));
p.setSalePrice(rs.getFloat("sale_price"));
p.setImage(rs.getString("image"));
products.add(p);
}
return products;
} catch (SQLException e) {
e.printStackTrace();
}
return products;
}
// public static void main(String[] args) {
// List<Product> products =new ProductDAO().findAllProducts(3, 2);
// for(Product product:products){
// System.out.println(product.getId());
// }
// }
}
我使用的是连接池,大家可以随意
发表评论
-
oracle 笔记下
2011-07-06 18:17 746建立表空间:建立表空 ... -
oracle 学习笔记上
2011-06-20 19:00 10311.oracle 安装完成后,会 ... -
jquery 对select中的option操作
2011-06-15 16:28 6214Jquery的功能很强大,下面 ... -
servlet cookie jsp
2011-05-19 18:21 883首先是登陆界面,其中有mes_zh等国际化 这个不重要 < ... -
java学习日记(线程)
2011-05-18 18:38 773java学习日记(线程) 一 ... -
Java Servlet和JSP 处理Cookie
2011-05-18 13:28 19149.1 Cookie概述 Cookie是服务器发送给浏 ... -
简单的qq实现
2011-05-17 18:42 676很好用 简洁 -
简单的日历控件
2011-05-17 18:40 749package Exception; import java ... -
完整的JDBC 简单列子
2011-05-17 18:38 648package dao; import java.sql.Co ... -
jsp jstl 标签3
2011-05-13 17:38 674<c:import> 作用:导入一个url的资源, ... -
jsp jstl 标签2
2011-05-13 17:38 714c:forEach 用于循环的<c:forEach&g ... -
jsp jstl 标签1
2011-05-13 17:36 1159一、引入包: jstl.jar (1 ... -
js 中this用发小结
2011-03-09 09:19 668js中this的总结 在面向对 ... -
js 正则表达式
2011-02-24 15:12 603js正则表达式 exec 方法 用正则表达式模式在字符串中运 ... -
WEB innerHTML中div 和span
2011-02-24 13:58 1203使用innerHTML属性来控制DIV和SPAN<$lo ... -
Myeclipse 快捷键打总结
2011-01-08 13:01 690xml、jsp、jsf、js等等,我们没有必要全部都去自动校验 ... -
java基础知识
2011-01-07 17:35 630 -
java文件夹之间的复制
2011-01-06 14:58 628package Exception; import java. ...
相关推荐
基于PHP+MySQL实现分页技术 一、 开发环境 1、环境搭建:Windows 7+Apache 2.4.18+MySQL 5.7.11+PHP 7.1.0。 2、文本编辑器:Sublime 3。 二、主要技术 本案例使用PHP 7中的PDO数据对象对MySQL数据库进行操作,通过...
//url中传入的值 (p=1/2/3...),默认为1(3)根据页码取出数据,传入分页数据 $pre=($page-1)*10;/
mysql+jsp+javabean实现分页技术
一套初学MySql的分页实现代码,不好勿喷啊,我也做的是基本的
java mysql 分页技术 MVC模式 该小系统中有分页类PageUtil
使用Spring的JdbcTemplate实现分页功能
java简单分页技术mysql 内涵.sql文件,直接实现(适合刚结束的 )大神请绕行
分析Java Web中分页的技术,并对各种分页技术进行对比。具体说明了超大数据量的分页在MySQL、Or-acle中的实现方法,编写了针对Oracle数据库分页接口和实现类。
不错的实例代码,拿出来给大家分享、这不仅适合刚学习hibernate的人,也是合开发一段时间的技术人员!
本分页系统采用JSP+JavaBean+Servlet实现。环境:Mysql+Tomcat+MyEclipse
是mysql的数据库分页技术 自己写的代码
各种jsp分页代码,数据库是mysql 简单易用
severlet jsp 分页 ajax等技术的笔记
使用MyBatis的PageHelper插件实现分页查询的功能,主要涉及到的技术Spring+MyBatis+SpringMvc+Mysql+Druid+PageHelper。
本资源运用jsp+mysql+ajax技术实现了登录、注册、分页的功能。
功能: 实现数据分页查询显示 特点: 全是免费工具及开源技术 开发框架: gwt1.4.6 + spring2.5 + mysql5.0 开发工具: Eclipse3.4 Cypal Studio for GWT (Eclipse 的一个插件) 实现原理:通过GWT的RPC来调用Spring...
工具eclipse。数据库 mysql.
MyBatis Plus 的多表联接、分页查询实现方法 http://localhost/common/getAllQuestionByPage/1/10 多表关联、分页查询接口 http://localhost/common/getAllQuestionWithStudentByPage/1/10 多表关联、分页带参数查询...
如为GridView、DataList以及Repeater等数据绑定控件实现分页、呈现自定义的分页数据以及制作图片浏览程序等,因为AspNetPager控件和数据是独立的,因此要分页的数据可以来自任何数据源,如SQL Server、Oracle、...
用jsp和servlet实现的分页技术....有Mysql也有其他数据库的~~~