tracy婷婷
- 浏览: 24343 次
- 性别:
-
文章分类
create database demodb_info
go
USE demodb_info
GO
--drop database demodb_info
/****** Object: Table [dbo].[t_book] Script Date: 12/13/2012 17:28:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
--drop table [dbo].[t_book]
CREATE TABLE [dbo].[t_book](
[id] [int] NOT NULL,
[name] [varchar](20) NULL,
[auther] [varchar](20) NULL,
[press] [varchar](20) NULL,
[price] [money] NULL,
CONSTRAINT [PK_t_book] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [id]
,[name]
,[auther]
,[press]
,[price]
FROM demodb_info.[dbo].[t_book]
go
--delete FROM demodb_info.[dbo].[t_book]
go
insert into demodb_info.[dbo].[t_book] values(1,'秘密','拜恩','中国城市出版社',17.3);
insert into demodb_info.[dbo].[t_book] values(2,'白鹿原','陈忠实','北京十月文艺出版社',22);
insert into demodb_info.[dbo].[t_book] values(3,'青春','韩寒','湖南人民出版社',20.3);
insert into demodb_info.[dbo].[t_book] values(4,'追风筝的人','胡赛尼','上海人民出版社',16.3);
insert into demodb_info.[dbo].[t_book] values(5,'狼图腾','姜戎','长江文艺出版社',21.1);
insert into demodb_info.[dbo].[t_book] values(6,'正能量','理查德 怀斯曼民','湖南文艺出版社',18.5);
insert into demodb_info.[dbo].[t_book] values(7,'好妈妈胜过好老师','尹建莉','作家出版社',14.3);
insert into demodb_info.[dbo].[t_book] values(8,'你若安好便是晴天','白落梅','中国华侨出版社',17.4);
insert into demodb_info.[dbo].[t_book] values(9,'不一样的卡梅拉','克利斯提昂','二十一世纪出版社',26.5);
insert into demodb_info.[dbo].[t_book] values(10,'因为痛 所以叫青春','金兰都','广西科学技术出版社',19.7);
package com.Bookinfo.web.util;
public class Book {
private int id;
private String name;
private String author;
private String press;
private double price;
public Book(int id, String name, String author, String press, double price) {
super();
this.id = id;
this.name = name;
this.author = author;
this.press = press;
this.price = price;
}
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 getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getPress() {
return press;
}
public void setPress(String press) {
this.press = press;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
}
//登陆的servlet 没有和数据库连接
package com.Bookinfo.Servlet.util;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet {
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
PrintWriter out=response.getWriter();
// response.setContentType("text/html;charset=UTF-8");
String name=request.getParameter("loginName");
String pwd=request.getParameter("loginPwd");
//初始化购物车
List<Integer> cart=new ArrayList<Integer>();
if(name.equals("admin") && pwd.equals("123")){
HttpSession sess=request.getSession();
//将购物车放到session对象中
name=new String(name.getBytes("ISO-8859-1"),"UTF-8");
sess.setAttribute("userName", name);
sess.setAttribute("cartFrist",cart);
//request.getRequestDispatcher("index.jsp").forward(request, response);
response.sendRedirect("index.jsp");
}else{
out.println("登录失败！");
}
out.flush();
out.close();
}
}
package com.Bookinfo.BFace.util;
import java.util.List;
import com.Bookinfo.web.util.Book;
//接口 返回List集合
public interface BookInter {
public List<Book> getBook();
}
package com.Bookinfo.BImple.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.Bookinfo.BFace.util.BookInter;
import com.Bookinfo.web.util.Book;
public class Bimple implements BookInter {
public Connection conn=null;
public Statement stm=null;
public ResultSet rs=null;
public List<Book> getBook() {
// TODO Auto-generated method stub
List<Book> books=new ArrayList<Book>();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=demodb_info","sa","svse");
stm=conn.createStatement();
rs=stm.executeQuery("select * from [dbo].[t_book]");
while(rs.next()){
int id=rs.getInt(1);
String name=rs.getString(2);
String author=rs.getString(3);
String press=rs.getString(4);
double price=rs.getDouble(5);
Book b=new Book(id,name,author,press,price);
books.add(b);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return books;
}
}
package com.Bookinfo.Servlet.util;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.Bookinfo.BFace.util.BookInter;
import com.Bookinfo.BImple.util.Bimple;
import com.Bookinfo.web.util.Book;
public class GetServlet extends HttpServlet {
private ServletConfig config;
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
config=this.getServletConfig();
String school=config.getInitParameter("school");
System.out.println(school);
response.setContentType("text/html;charset=UTF-8");
HttpSession sess=request.getSession();
BookInter bt=new Bimple();
List<Book> listbobo=bt.getBook();
System.out.println(bt.getBook().size());
sess.setAttribute("book",listbobo);
//request.getRequestDispatcher("BookTable.jsp").forward(request, response);
response.sendRedirect("BookTable.jsp");
}
}
package com.Bookinfo.BFace.util;
import java.util.List;
import com.Bookinfo.web.util.Book;
public interface CartIface {
//根据图书ID查血图书信息
public Book getBookById(int id);
}
package com.Bookinfo.BImple.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.Bookinfo.BFace.util.BookInter;
import com.Bookinfo.BFace.util.CartIface;
import com.Bookinfo.web.util.Book;
public class CartImple implements CartIface {
public Connection conn=null;
public Statement stm=null;
public ResultSet rs=null;
public Book getBookById(int id) {
// TODO Auto-generated method stub
List<Book> books=new ArrayList<Book>();
Book book_cart=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=demodb_info","sa","svse");
stm=conn.createStatement();
rs=stm.executeQuery("select * from t_book where id='"+id+"'");
while(rs.next()){
Integer bookId=rs.getInt(1);
String name=rs.getString(2);
String author=rs.getString(3);
String press=rs.getString(4);
double price=rs.getDouble(5);
Book b=new Book(bookId,name,author,press,price);
books.add(b);
}
book_cart=books.get(0);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
try {
//关闭ResultSet
if(rs!=null){rs.close();}
//关闭PreparedStatement
if(stm!=null){stm.close();}
//关闭Connection
if(conn!=null){conn.close();}
} catch (Exception e) {
e.printStackTrace();
}
}
return book_cart;
}
package com.Bookinfo.Servlet.util;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class CartServlet extends HttpServlet {
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
HttpSession sess=request.getSession();
String bookId=request.getParameter("bookId");//得到用户购买的图书的id
//将用户的图书的id存放到购物车中去中
List<Integer> cart=(List<Integer>)sess.getAttribute("cartFrist");
//将图书id添加进去
cart.add(Integer.parseInt(bookId));
}
}
package com.Bookinfo.Servlet.util;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.Bookinfo.BFace.util.CartIface;
import com.Bookinfo.BImple.util.CartImple;
import com.Bookinfo.web.util.Book;
public class CartMessageServlet extends HttpServlet {
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
CartIface ciface=new CartImple();
HttpSession sess=request.getSession();
List<Integer> listCartID=(List<Integer>) sess.getAttribute("cartFrist");
List<Book> listbook=new ArrayList<Book>();
for (int i = 0; i <listCartID.size(); i++) {
Book bo=ciface.getBookById(listCartID.get(i));
listbook.add(bo);
}
sess.setAttribute("CartMessage",listbook);
response.sendRedirect("cartMessage.jsp");
}
}
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
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>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<a href="Login.jsp">登陆</a>
<%=session.getAttribute("userName") %>
<a href="bookTable">查看信息</a>
<a href="CartMessageServlet">查看购物车</a>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
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>
<base href="<%=basePath%>">
<title>My JSP 'Login.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<div align="center"><form action="loginUser" method="post">
用户名：
<input type="text" name="loginName">
<br/>
密码：
<input type="text" name="loginPwd">
<br/>
<input type="submit" value="确定"/>
</form></div>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="com.Bookinfo.web.util.Book" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'BookTable.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my table page. <br>
<hr/>
<center>
<table>
<tr>
<td>图书Id</td>
<td>图书名称</td>
<td>图书作者</td>
<td>图书出版社</td>
<td>图书价格</td>
<td>操作</td>
</tr>
<%
List<Book> listBook=(ArrayList)session.getAttribute("book");
for(int i=0;i<listBook.size();i++){
Book b=listBook.get(i);
%>
<tr>
<td><%=b.getId() %></td>
<td><%=b.getName() %></td>
<td><%=b.getAuthor() %></td>
<td><%=b.getPress() %></td>
<td><%=b.getPrice() %></td>
<td><a href="CartServlet?bookId=<%=b.getId() %>">购买</a></td>
</tr>
<%
}
%>
</table>
</center>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="com.Bookinfo.web.util.Book" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'cartMessage.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<center>
<table>
<%! double sum=0; %>
<tr>
<td>图书Id</td>
<td>图书名称</td>
<td>图书作者</td>
<td>图书出版社</td>
<td>图书价格</td>
<td>操作</td>
</tr>
<%
List<Book> listBook=(ArrayList)session.getAttribute("CartMessage");
sum=0;
for(int i=0;i<listBook.size();i++){
Book b=listBook.get(i);
sum=sum+b.getPrice();
%>
<tr>
<td><%=b.getId() %></td>
<td><%=b.getName() %></td>
<td><%=b.getAuthor() %></td>
<td><%=b.getPress() %></td>
<td><%=b.getPrice() %></td>
<td><a href="#">删除</a></td>
</tr>
<%
}
%>
<tr>
<td clospan="6">总价格：<%=sum %></td>
</tr>
</table>
</center>
</body>
</html>
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>booktable</servlet-name>
<servlet-class>com.Bookinfo.Servlet.util.GetServlet</servlet-class>
<init-param>
<param-name>school</param-name>
<param-value>国资</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>booktable</servlet-name>
<url-pattern>/bookTable</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>loginuser</servlet-name>
<servlet-class>com.Bookinfo.Servlet.util.LoginServlet</servlet-class>
</servlet>
<servlet>
<description>将图书ID添加到购物车里面</description>
<display-name>将图书添加到购物车</display-name>
<servlet-name>CartServlet</servlet-name>
<servlet-class>com.Bookinfo.Servlet.util.CartServlet</servlet-class>
</servlet>
<servlet>
<description>根据图书ID将图书信息添加到购物车里面</description>
<display-name>将图书全部信息添加到购物车</display-name>
<servlet-name>CartMessageServlet</servlet-name>
<servlet-class>com.Bookinfo.Servlet.util.CartMessageServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>loginuser</servlet-name>
<url-pattern>/loginUser</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>CartServlet</servlet-name>
<url-pattern>/CartServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>CartMessageServlet</servlet-name>
<url-pattern>/CartMessageServlet</url-pattern>
</servlet-mapping>
</web-app>
分享到：
发表评论
相关推荐
6. Protection Features：JW5033T 具有多种保护功能，包括短路保护、热保护、电流逃逸保护和输入欠压锁定保护等，这使其能够确保系统的安全和可靠性。 7. Package：JW5033T 采用 TSOT23-6 封装，提供紧凑的解决方案...
杰华特 JW5306的规格书JW5352&JW5352M_Datasheet_R0.21_EN_20211213 for 九联.pdf
在使用Jw_win时，用户可以利用其内置的图形用户界面（GUI）进行直观操作，包括直线、曲线、弧形等基本几何对象的绘制，以及尺寸标注、文本注释等功能。此外，软件可能还支持图层管理、对象捕捉、块和外部参照，这些...
短路保护功能可以在输出端出现异常时防止设备损坏，热保护机制则可避免因过热导致的故障。此外，还有电流失控保护和输入欠压锁定，进一步确保了在各种工作条件下的安全运行。这些特性使得JW5033S成为需要稳定电源...
官方JW Player通常需要购买许可证才能用于商业项目。使用已去水印和右键禁用的版本可能违反JW Player的条款和条件。因此，在实际应用中，应确保遵循合法途径，尊重软件开发者的工作并遵守相关法律法规，以免引起法律...
JW Player 3.2具备智能的自适应流功能，可根据网络状况动态调整视频质量。源码中展示了如何监控网络状态，优化缓冲策略，提高播放体验。 9. **错误处理与调试** 源码中包含了详细的错误处理机制，确保在遇到问题...
这个脚本可能包含了处理用户输入、数据库交互、页面逻辑等功能，是JW页面工厂实现功能的关键部分。 "site" 目录可能包含了预设的网站模板或者样例页面，用户可以直接使用或作为自定义设计的基础。这些模板可能包含...
标题“JW1991C pdf文档整理.zip”表明这是一个包含PDF文档的压缩文件，其中的内容可能与编号为“JW1991C”的某个项目、课程或者研究有关。这种类型的文件通常用于组织和共享大量的文本资料，比如教程、研究报告、...
总结来说，JW FLV Player是在线视频播放领域的经典工具，其易用性和强大的功能使其在一段时间内成为了许多网站的首选。然而，随着技术的进步，开发者需要关注并考虑过渡到支持HTML5的播放解决方案，以保持与现代...
本文将深入探讨JW Player JavaScript API的核心概念、主要功能以及常见用法。 1. **核心概念** - **JW Player实例**：在网页中，首先需要创建一个JW Player实例。这通常是通过调用`jwplayer(id)`函数完成的，其中`...
**JW Player功能特性** 1. **跨平台兼容性**：JW Player不仅支持各种现代浏览器，如Chrome、Firefox、Safari、Edge，还能够兼容不同的操作系统，包括Windows、Mac和Linux。 2. **多格式支持**：除了FLV，JW Player还...
此外，JW5026还有集成内部补偿、软启动和输出短路保护等附加功能。 JW5026的典型应用电路设计中，需要特别注意其外围电路的布局，从而确保电路板的性能。测试结果表明，基于JW5026的电源设计电路在不同工况下，例如...
JW3651 保证了鲁棒性，具有欠压锁定、短路保护和热保护功能。 JW3651 的特点包括： * 集成低 RDS (on) 电源 MOSFET * 宽输入电压范围：3.0V-21V * 宽输出电压范围：0.9V-20V * 兼容 4-开关 Buck-Boost 模式和 2-...
JW FLV Media Player是一款广泛应用的开源FLV媒体播放器，它以其强大的功能和灵活的自定义性深受开发者喜爱。本篇文章将深入探讨该播放器的核心特性，以及如何通过提供的FLA文件进行界面定制，以满足不同项目的需求...
**jw_flv_player 3.12**是一款强大的Flash FLV视频播放器，它以其易用性和功能丰富性在Web开发中广受欢迎。这款播放器版本3.12是其发展过程中的一个重要里程碑，提供了许多改进和优化，旨在提升用户体验和开发者的...
JW7700A是一种专为反激式变换器设计的同步整流芯片，具有以下特点和应用： 1. 集成40V耐压、16mΩ导通电阻的功率MOSFET，可替代肖特基二极管以实现更高效率。其整流效率的提升主要得益于MOSFET的低导通电阻特性。 ...
同时，该芯片具有过流保护、热保护、启动电流run-away保护和输入低电压锁定等功能。 评估板 该评估板提供了一个完整的解决方案，仅需要最少的外部组件。该板可以在VIN=5V、VIN=12V和VIN=18V三个输入电压条件下工作...
很抱歉，根据您提供的信息，"jw000000.rar" 和 "jw.rar" 是两个压缩文件的名称，而"jw"是它们的标签，但没有提供具体的压缩包内容或相关的IT知识点。文件名称列表中只给出了"11479"，这似乎是一个数字或者错误的...
3.0V to 42V Operating Input Range 1.4A, 65V Internal DMOS Power Switch Up to 430KHz Operating Frequency Low Quiescent Current Boundary Mode Operation at Heavy Load Burst Mode Operation at Light ...