Java EEWord格式.docx
- 文档编号:20363855
- 上传时间:2023-01-22
- 格式:DOCX
- 页数:21
- 大小:19.33KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Java EE
![提示](https://static.bdocx.com/images/bang_tan.gif)