-
- 丁钰航 2018-06-18
/*DBHelper类*/ package util; import java.sql.Connection; import java.sql.DriverManager; public class DBHelper { private static final String driver = "com.mysql.jdbc.Driver";
- 0赞 · 1采集
-
- 大阳Leo 2017-08-08
- 练习
-
截图0赞 · 0采集
-
- KingStar1 2017-05-20
- 静态页面(相当于死的，写死的)，不是从数据里动态获取的！
-
截图0赞 · 1采集
-
- nico11 2015-02-21
- /*details.jsp③*/ <!-- 浏览过的商品 --> <td width="30%" bgcolor="#eee" align="center"> <br> <b>您浏览过的商品</b><br> <% ArrayList<Items> itemlist = itemsDao.getViewList(list); if(itemlist!=null && itemlist.size()>0){ for(Items i:itemlist){ %> <div> <dl> <dt> <a href="details.jsp?id=<%=i.getId()%>"><img width="120" height="90" border="1" src="images/<%=i.getPicture()%>"></a> </dt> <dd class="dd_name"><%=i.getName()%></dd> <dd class="dd_city">产地：<%=i.getCity()%> 价格：<%=i.getPrice()%></dd> </dl> </div> <% } } %> </td> </tr> </table> </body> </html>
- 0赞 · 5采集
-
- nico11 2015-02-21
- /*details.jsp②*/ <tr> <td>产地：<%=item.getCity() %></td> </tr> <tr> <td>价格<%=item.getPrice() %></td> </tr> </table> </td> <% }%> <% String list = ""; Cookie[] cookies = request.getCookies(); if(cookies!=null&&cookies.length>0){ for(Cookie c:cookies){ if(c.getName().equals("ListViewCookie")){ list = c.getValue(); } } } //若记录数超过1000清零 String[] arr = list.split(","); if(arr!=null && arr.length>0) if(arr.length>1000) list=""; list+=request.getParameter("id")+","; Cookie cookie = new Cookie("ListViewCookie",list); response.addCookie(cookie); %>
- 0赞 · 0采集
-
- nico11 2015-02-21
- /*details.jsp①*/ <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ page import="dao.ItemsDAO" %> <%@ page import="entity.Items" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <style type="text/css"> div{float:left;margin-left:30px;margin-right:5px;margin-bottom:5px;} div dd{margin:0px;font-size:10pt;} div dd .dd_name{color:#blue;} </style> </head> <body> <table width="750" height="60" cellpadding="0" cellspacing="0" border="0"> <tr> <% ItemsDAO itemsDao = new ItemsDAO(); Items item = itemsDao.getItemsById(Integer.parseInt(request.getParameter("id"))); if(item!=null){ %> <!-- 商品详情 --> <td width="70%" valign="top"> <table> <tr> <td rowspan="4"><img width="200" height="160" src="images/<%=item.getPicture()%>"></td> </tr> <tr> <td><b><%=item.getName() %></b></td> </tr>
- 0赞 · 1采集
-
- nico11 2015-02-21
- /*index.jsp②*/ <div> <dl> <dt> <a href="details.jsp?id=<%=item.getId()%>"><img width="120" height="90" border="1" src="images/<%=item.getPicture()%>"></a> </dt> <dd class="dd_name"><%=item.getName()%></dd> <dd class="dd_city">产地：<%=item.getCity()%> 价格：<%=item.getPrice()%></dd> </dl> </div> <% } } %> </td> </tr> </table> </center> </body> </html>
- 0赞 · 0采集
-
- nico11 2015-02-21
- /*index.jsp①*/ <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ page import="dao.ItemsDAO" %> <%@ page import="entity.Items" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <style type="text/css"> div{float:left;margin-left:30px;margin-right:5px;margin-bottom:5px;} div dd{margin:0px;font-size:10pt;} div dd .dd_name{color:#blue;} </style> </head> <body> <h1>商品展示</h1> <hr> <center> <table width="750" height="60" cellpadding="0" cellspacing="0" border="0"> <tr> <td> <% ItemsDAO itemsDao = new ItemsDAO(); ArrayList<Items> list = itemsDao.getAllItems(); if(list!=null && list.size()>0){ for(Items item:list) { %>
- 1赞 · 1采集
-
- nico11 2015-02-21
- /*ItemsDAO类③*/ } catch (Exception e) { e.printStackTrace(); return null; } finally{ if(rs!=null){ rs.close(); rs=null; } if(stmt!=null){ stmt.close(); stmt=null; } } } //获取最近浏览的5条记录 public ArrayList<Items> getViewList(String list) throws SQLException{ ArrayList<Items> itemlist = new ArrayList<Items>(); int iCount = 5; if(list!=null && list.length()>0){ String[] arr = list.split(","); //如果商品记录大于5 if(arr.length>5){ for(int i=arr.length-1;i>=arr.length-iCount;i--){ itemlist.add(getItemsById(Integer.parseInt(arr[i]))); } }else{ for(int i=arr.length-1;i>=0;i--){ itemlist.add(getItemsById(Integer.parseInt(arr[i]))); } } return itemlist; }else{ return null; } } }
- 2赞 · 0采集
-
- nico11 2015-02-21
- /*ItemsDAO类②*/ } catch (Exception e) { e.printStackTrace(); return null; } finally{ if(rs!=null){ rs.close(); rs=null; } if(stmt!=null){ stmt.close(); stmt=null; } } } //根据商品编号获得商品资料 public Items getItemsById(int id) throws SQLException{ Connection conn =null; PreparedStatement stmt = null; ResultSet rs = null; try { conn = DBHelper.getConnection(); String sql = "select * from items where id=?;"; stmt = conn.prepareStatement(sql); stmt.setInt(1, id); rs = stmt.executeQuery(); if(rs.next()){ Items item = new Items(); item.setId(rs.getInt("id")); item.setName(rs.getString("name")); item.setCity(rs.getString("city")); item.setNumber(rs.getInt("number")); item.setPrice(rs.getInt("price")); item.setPicture(rs.getString("picture")); return item; }else{ return null; }
- 0赞 · 0采集
-
- nico11 2015-02-21
- /*ItemsDAO类①*/ package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import util.DBHelper; import entity.Items; //商品业务逻辑类 public class ItemsDAO { public ArrayList<Items> getAllItems() throws SQLException{ Connection conn =null; PreparedStatement stmt = null; ResultSet rs = null; ArrayList<Items> list = new ArrayList<Items>(); try { conn = DBHelper.getConnection(); String sql = "select * from items;"; stmt = conn.prepareStatement(sql); rs = stmt.executeQuery(); while(rs.next()){ Items item = new Items(); item.setId(rs.getInt("id")); item.setName(rs.getString("name")); item.setCity(rs.getString("city")); item.setNumber(rs.getInt("number")); item.setPrice(rs.getInt("price")); item.setPicture(rs.getString("picture")); list.add(item); } return list;
- 0赞 · 0采集
-
- nico11 2015-02-21
- /*Items类*/ package entity; //商品实体类 public class Items { private int id; private String name; private String city; private int price; private int number; private String picture; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public int getPrice() { return price; } public void setPrice(int price) { this.price = price; } public int getNumber() { return number; } public void setNumber(int number) { this.number = number; } public String getPicture() { return picture; } public void setPicture(String picture) { this.picture = picture; } }
- 0赞 · 0采集
-
- nico11 2015-02-21
- /*DBHelper类*/ package util; import java.sql.Connection; import java.sql.DriverManager; public class DBHelper { private static final String driver = "com.mysql.jdbc.Driver"; private static final String url="jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=utf-8"; private static final String username = "root"; private static final String password = ""; private static Connection conn = null; //静态代码块负责加载驱动 static{ try { Class.forName(driver); } catch (Exception e) { e.printStackTrace(); } } //返回数据库连接对象 public static Connection getConnection() throws Exception{ if(conn==null){ conn = DriverManager.getConnection(url,username,password); return conn; } return conn; }//end getConnection method public static void main(String[] args){ try { Connection conn = DBHelper.getConnection(); if(conn!=null) System.out.println("连接正常"); else System.out.println("连接失败"); } catch (Exception e) { e.printStackTrace(); } } }
- 0赞 · 0采集
数据加载中...