吉软_java57_第十五次作业

最新推荐文章于 2024-07-13 13:55:40 发布

chunyancang8075

最新推荐文章于 2024-07-13 13:55:40 发布

阅读量99

点赞数

文章标签： java

原文链接：https://my.oschina.net/u/3716895/blog/1637679

版权

<%@page import="org.jsoft.vo.GoodsVO"%>
<%@page import="java.util.List"%>
<%@page import="org.jsoft.dao.GoodsDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%!
int total_page;//总
int now_page;//当
int up_page;//上
int down_page;//下
int every_page=2;//每页两条数据
%>

<table border="1" cellspacing="0">
<tr>
<td>编号</td>
<td>名称</td>
<td>价格</td>
</tr>
<%
        GoodsDAO gd =new GoodsDAO();
    List<GoodsVO> lg=gd.getGoods();
    int total_size=lg.size();
    total_page=(total_size+every_page-1)/every_page;
    if(total_size==0){
        out.println("商品售窑");
    }else{
        ///当
        String now_p=request.getParameter("now_page");
        if(now_p!=null){
            now_page=Integer.parseInt(now_p);
        }else{
            now_page=1;
        }if(up_page==now_page){
            up_page=1;
        }else{
            up_page=now_page-1;
        }if(down_page==total_page){
            down_page=total_page;
        }else{
            down_page=now_page+1;
        }
        List<GoodsVO> l=gd.getGoods((now_page-1)*every_page,every_page);

    for(GoodsVO gv:l){

    %>
        <tr>
        <td><%=gv.getGid() %></td>
        <td><%=gv.getGname() %></td>
        <td><%=gv.getGprice() %></td>
    </tr>
    <%
    }
    %>
</table>
<caption>
总页为：<%=total_page %>当前页为<%=now_page %><a href="Goods.jsp?now_page=<%=up_page%>">上一页</a><a href="Goods.jsp?now_page=<%=down_page%>">下一页</a>
</caption>
<%
    }
%>
</body>
</html>

************************************************************************************************************

package org.jsoft.dao;

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 org.jsoft.conn.SingleTest;
import org.jsoft.vo.GoodsVO;

public class GoodsDAO {
/*
* 插入数据
*/
   public boolean insertN(GoodsVO gv){
       boolean b=false;
       ///连接
       Connection con=null;
       PreparedStatement pst=null;
       try {
           con=SingleTest.getST().getCon();
           String sql="insert into goods(gid,gname,gprice) values(?,?,?)";
           pst=con.prepareStatement(sql);
           pst.setInt(1, gv.getGid());
           pst.setString(2, gv.getGname());
           pst.setDouble(3,gv.getGprice() );
           int i=pst.executeUpdate();
           if(i>0){
               b=true;
           }
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }finally{
           SingleTest.getST().closeAll(null,pst, con);
       }
       return b;
   }

   ///查询方法
   public List<GoodsVO> getGoods(){
   List<GoodsVO> l=new ArrayList<GoodsVO>();
   //获得链接
   Connection con=null;
   PreparedStatement pst=null;
   ResultSet rs=null;
   try {
       con=SingleTest.getST().getCon();
       String sql="select * from goods";
       //处理sql语句
       pst=con.prepareStatement(sql);
       rs=pst.executeQuery();
       ///遍历rs
       while(rs.next()){
           GoodsVO gv=new GoodsVO();
           gv.setGid(rs.getInt("gid"));
           gv.setGname(rs.getString("gname"));
           gv.setGprice(rs.getDouble("gprice"));
           l.add(gv);
       }
   } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
   }finally{
       SingleTest.getST().closeAll(rs, pst, con);
   }
   System.out.println(l.size());
   return l;
   }
   ///分页查询
   public List<GoodsVO> getGoods(int star,int end){
       List<GoodsVO> l=new ArrayList<GoodsVO>();
       //获得链接
       Connection con=null;
       PreparedStatement pst=null;
       ResultSet rs=null;
       try {
           con=SingleTest.getST().getCon();
           String sql="select * from goods order by gid limit ?,?";
           //处理sql语句
           pst=con.prepareStatement(sql);
           pst.setInt(1, star);
           pst.setInt(2, end);
           rs=pst.executeQuery();
           ///遍历rs
           while(rs.next()){
               GoodsVO gv=new GoodsVO();
               gv.setGid(rs.getInt("gid"));
               gv.setGname(rs.getString("gname"));
               gv.setGprice(rs.getDouble("gprice"));
               l.add(gv);
           }
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }finally{
           SingleTest.getST().closeAll(rs, pst, con);
       }
       System.out.println(l.size());
       return l;
       }
}
************************************************************************************************************

package org.jsoft.vo;

public class GoodsVO {
   private int gid;
   private String gname;
   private double gprice;
   public int getGid() {
       return gid;
   }
   public void setGid(int gid) {
       this.gid = gid;
   }
   public String getGname() {
       return gname;
   }
   public void setGname(String gname) {
       this.gname = gname;
   }
   public double getGprice() {
       return gprice;
   }
   public void setGprice(double gprice) {
       this.gprice = gprice;
   }
}

转载于:https://my.oschina.net/u/3716895/blog/1637679

chunyancang8075

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
吉软_java57_第十五次作业

<%@page import="org.jsoft.vo.GoodsVO"%> <%@page import="java.util.List"%> <%@page import="org.jsoft.dao.GoodsDAO"%> <%...
复制链接

扫一扫