Java EEWord格式.docx

Java EEWord格式.docx

《Java EEWord格式.docx》由会员分享，可在线阅读，更多相关《Java EEWord格式.docx（21页珍藏版）》请在冰豆网上搜索。

publicvoidcloseAll（ResultSetrs,Statementstmt,Connectionconn）{

if（rs!

=null）{

try{

rs.close（）;

}catch（SQLExceptione）{

//TODOAuto-generatedcatchblock

e.printStackTrace（）;

}

if（stmt!

stmt.close（）;

if（conn!

conn.close（）;

publicintupdate（Stringsql,String[]params）{

introw=0;

conn=this.getConn（）;

pstmt=conn.prepareStatement（sql）;

for（inti=0;

i<

params.length;

i++）{

pstmt.setString（i+1,params[i]）;

row=pstmt.executeUpdate（sql）;

}finally{

this.closeAll（null,pstmt,conn）;

returnrow;

publicstaticvoidmain（String[]args）{

BaseDaobd=newBaseDao（）;

System.out.println（bd.getConn（））;

}

2、

importjava.util.List;

importentity.Goods;

publicinterfaceGoodsDao{

publicList<

Goods>

findList（）;

//获得商品列表

publicintgetPageCount（intpagesize）;

//根据一页显示的记录数，获取结果集中能分的总页数

publicGoodsgetGoods（intid）;

//根据商品Id获得商品信息

publicintdelGoods（intid）;

//根据商品Id删除商品

publicintaddGoods（Goodsgoods）;

//添加商品信息

publicintupdateGoods（Goodsgoods）;

//更新商品信息

3、

packagedao.impl;

importjava.sql.PreparedStatement;

importjava.util.ArrayList;

importdao.BaseDao;

importdao.GoodsDao;

publicclassGoodsDaoImplextendsBaseDaoimplementsGoodsDao{

publicintdelGoods（intid）{

introw=0;

Stringsql="

deletefromgoodswhereid=?

"

Connectionconn=null;

PreparedStatementpstmt=null;

conn=super.getConn（）;

pstmt.setInt（1,id）;

row=pstmt.executeUpdate（）;

super.closeAll（null,pstmt,conn）;

findList（）{

List<

listGoods=newArrayList<

（）;

select*fromgoodsorderbynameasc"

ResultSetrs=null;

rs=pstmt.executeQuery（）;

while（rs.next（））{

Goodsgoods=newGoods（）;

goods.setId（rs.getInt（"

id"

））;

goods.setName（rs.getString（"

name"

goods.setProvider（rs.getString（"

provider"

goods.setPrice（rs.getString（"

price"

goods.setQuantity（rs.getInt（"

quantity"

listGoods.add（goods）;

}

rs.last（）;

super.closeAll（rs,pstmt,conn）;

returnlistGoods;

publicGoodsgetGoods（intid）{

//根据商品Id获得商品信息

select*fromgoodswhereid=?

Goodsgoods=null;

if（rs.next（））{

goods=newGoods（）;

goods.setId（id）;

returngoods;

publicintaddGoods（Goodsgoods）{

//添加商品信息

insertintogoods（name,provider,price,quantity）values（?

?

）"

pstmt.setString（1,goods.getName（））;

pstmt.setString（2,goods.getProvider（））;

pstmt.setString（3,goods.getPrice（））;

pstmt.setInt（4,goods.getQuantity（））;

publicintupdateGoods（Goodsgoods）{

updategoodssetname=?

provider=?

price=?

quantity=?

whereid=?

pstmt.setInt（5,goods.getId（））;

GoodsDaogoodsDao=newGoodsDaoImpl（）;

introw=goodsDao.updateGoods（11,"

aa"

"

ff"

1222"

121）;

if（row>

0）{

System.out.println（"

gengxin成功！

）;

4、

packageservelet;

importjava.io.IOException;

importjavax.servlet.ServletException;

importjavax.servlet.http.HttpServlet;

importjavax.servlet.http.HttpServletRequest;

importjavax.servlet.http.HttpServletResponse;

importjavax.servlet.http.HttpSession;

importdao.impl.GoodsDaoImpl;

publicclassGoodsListextendsHttpServlet{

publicvoiddoGet（HttpServletRequestreq,HttpServletResponseresp）

throwsServletException,IOException{

this.doPost（req,resp）;

//super.doGet（req,resp）;

publicvoiddoPost（HttpServletRequestreq,HttpServletResponseresp）

list=goodsDao.findList（）;

HttpSessionsession=req.getSession（）;

session.setAttribute（"

Goodslist"

list）;

resp.sendRedirect（"

/goods/listServlet.jsp"

//super.doPost（req,resp）;

5、listServlet.jsp

<

%@pagelanguage="

java"

contentType="

text/html;

charset=utf-8"

pageEncoding="

utf-8"

%>

<

%@taglibprefix="

c"

uri="

!

DOCTYPEhtmlPUBLIC"

-//W3C//DTDXHTML1.0Transitional//EN"

"

http:

//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"

>

%@pageimport="

dao.impl.*,dao.*,java.util.*"

entity.Goods"

htmlxmlns="

//www.w3.org/1999/xhtml"

head>

metahttp-equiv="

Content-Type"

content="

/>

title>

商品信息列表<

/title>

/head>

body>

h1align="

center"

>

/h1>

tablewidth="

99%"

border="

1"

bgcolor="

#0099FF"

tr>

tdwidth="

9%"

编号<

/td>

17%"

商品名<

13%"

供货商<

19%"

售出价格（元）<

商品数量（台）<

23%"

操作<

/tr>

c:

setvar="

i"

scope="

request"

value="

0"

/c:

set>

forEachvar="

items="

${sessionScope.Goodslist}"

varStatus="

status"

${i+1}"

td>

${i}&

${goods.id}&

${status.index+1}<

${goods.name}<

${goods.provider}<

${goods.price}<

${goods.quantity}<

ahref="

doDelete?

id=${goods.id}"

删除<

/a>

&

nbsp;

showUpdateListServlet?

更新<

forEach>

tdcolspan="

6"

align="

/goods/addGoods.jsp"

添加商品<

/table>

/body>

/html>

6、

publicclassDodeleteextendsHttpServlet{

intid=Integer.parseInt（req.getParameter（"

introw=goodsDao.delGoods（id）;

resp.sendRedirect（"

results.html"

//System.out.println（id）;

@Override

//TODOAuto-generatedmethodstub

7、results.html

操作成功<

操作成功！

h3align="

goodslist"

返回<

/h3>

8、更新

importjava.io.IOExc