Java EE.docx
- 文档编号:7257068
- 上传时间:2023-01-22
- 格式:DOCX
- 页数:21
- 大小:19.33KB
Java EE.docx
《Java EE.docx》由会员分享,可在线阅读,更多相关《Java EE.docx(21页珍藏版)》请在冰豆网上搜索。
JavaEE
1、
packagedao;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassBaseDao{
privatestaticfinalStringDRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
privatestaticfinalStringURL="jdbc:
odbc:
goods";
privateConnectionconn=null;
publicConnectiongetConn(){
try{
Class.forName(DRIVER);
}catch(ClassNotFoundExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
try{
conn=DriverManager.getConnection(URL);
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
returnconn;
}
publicvoidcloseAll(ResultSetrs,Statementstmt,Connectionconn){
if(rs!
=null){
try{
rs.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
if(stmt!
=null){
try{
stmt.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
if(conn!
=null){
try{
conn.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
}
publicintupdate(Stringsql,String[]params){
introw=0;
conn=this.getConn();
try{
pstmt=conn.prepareStatement(sql);
for(inti=0;i pstmt.setString(i+1,params[i]); } row=pstmt.executeUpdate(sql); }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ this.closeAll(null,pstmt,conn); } returnrow; } publicstaticvoidmain(String[]args){ BaseDaobd=newBaseDao(); System.out.println(bd.getConn()); } } 2、 packagedao; importjava.util.List; importentity.Goods; publicinterfaceGoodsDao{ publicList publicintgetPageCount(intpagesize);//根据一页显示的记录数,获取结果集中能分的总页数 publicGoodsgetGoods(intid);//根据商品Id获得商品信息 publicintdelGoods(intid);//根据商品Id删除商品 publicintaddGoods(Goodsgoods);//添加商品信息 publicintupdateGoods(Goodsgoods);//更新商品信息 } 3、 packagedao.impl; importjava.sql.Connection; importjava.sql.PreparedStatement; importjava.sql.ResultSet; importjava.sql.SQLException; importjava.sql.Statement; importjava.util.ArrayList; importjava.util.List; importdao.BaseDao; importdao.GoodsDao; importentity.Goods; publicclassGoodsDaoImplextendsBaseDaoimplementsGoodsDao{ publicintdelGoods(intid){ introw=0; Stringsql="deletefromgoodswhereid=? "; Connectionconn=null; PreparedStatementpstmt=null; try{ conn=super.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); row=pstmt.executeUpdate(); }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ super.closeAll(null,pstmt,conn); } returnrow; } publicList List Stringsql="select*fromgoodsorderbynameasc"; Connectionconn=null; PreparedStatementpstmt=null; ResultSetrs=null; try{ conn=super.getConn(); pstmt=conn.prepareStatement(sql); 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(); }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ super.closeAll(rs,pstmt,conn); } returnlistGoods; } publicGoodsgetGoods(intid){ //根据商品Id获得商品信息 Stringsql="select*fromgoodswhereid=? "; Connectionconn=null; PreparedStatementpstmt=null; ResultSetrs=null; Goodsgoods=null; try{ conn=super.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); rs=pstmt.executeQuery(); if(rs.next()){ goods=newGoods(); goods.setId(id); goods.setName(rs.getString("name")); goods.setProvider(rs.getString("provider")); goods.setPrice(rs.getString("price")); goods.setQuantity(rs.getInt("quantity")); } }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ super.closeAll(rs,pstmt,conn); } returngoods; } publicintaddGoods(Goodsgoods){ //添加商品信息 introw=0; Stringsql="insertintogoods(name,provider,price,quantity)values(? ? ? ? )"; Connectionconn=null; PreparedStatementpstmt=null; try{ conn=super.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setString(1,goods.getName()); pstmt.setString(2,goods.getProvider()); pstmt.setString(3,goods.getPrice()); pstmt.setInt(4,goods.getQuantity()); row=pstmt.executeUpdate(); }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ super.closeAll(null,pstmt,conn); } returnrow; } publicintupdateGoods(Goodsgoods){ introw=0; Stringsql="updategoodssetname=? provider=? price=? quantity=? whereid=? "; Connectionconn=null; PreparedStatementpstmt=null; try{ conn=super.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setString(1,goods.getName()); pstmt.setString(2,goods.getProvider()); pstmt.setString(3,goods.getPrice()); pstmt.setInt(4,goods.getQuantity()); pstmt.setInt(5,goods.getId()); row=pstmt.executeUpdate(); }catch(SQLExceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); }finally{ super.closeAll(null,pstmt,conn); } returnrow; } publicstaticvoidmain(String[]args){ GoodsDaogoodsDao=newGoodsDaoImpl(); introw=goodsDao.updateGoods(11,"aa","ff","1222",121); if(row>0){ System.out.println("gengxin成功! "); } } 4、 packageservelet; importjava.io.IOException; importjava.util.List; importjavax.servlet.ServletException; importjavax.servlet.http.HttpServlet; importjavax.servlet.http.HttpServletRequest; importjavax.servlet.http.HttpServletResponse; importjavax.servlet.http.HttpSession; importdao.GoodsDao; importdao.impl.GoodsDaoImpl; importentity.Goods; publicclassGoodsListextendsHttpServlet{ publicvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletException,IOException{ this.doPost(req,resp); //super.doGet(req,resp); } publicvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletException,IOException{ GoodsDaogoodsDao=newGoodsDaoImpl(); List 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.*"%> <%@pageimport="entity.Goods"%> //www.w3.org/1999/xhtml">
setvar="i"scope="request"value="0">
set>
forEachvar="goods"items="${sessionScope.Goodslist}"varStatus="status"> setvar="i"scope="request"value="${i+1}"> set> id=${goods.id}">删除 id=${goods.id}">更新${i}&${goods.id}&${status.index+1} ${goods.name} ${goods.provider} ${goods.price} ${goods.quantity}
forEach>