资源描述：
《javaweb期中》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、Web期中作业——超市管理系统姓名：刘先亮学号：21114160106班级：信1131一、期中题目根据JavaWeb课上的实例，运用所学的Web开发技术设计完成一个超市管理系统。二、功能要求实现超市货物的增删改查展示功能，实现简易的构建和界面设计。基于xampp中的MySQL数据库，以MyEclipse软件为开发工具。1．数据库的建立（1）.代码如下：CREATETABLEMerchInfo(MerchIDint,MerchNamevarchar(50),importPriceint,warehouseprice
2、int,categoriesvarchar(50),MerchNumint,porfferNamevarchar(50),primarykey(MerchID),);(2).数据的插入insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values("112031","牛奶","3","3.5","饮料","120","蒙牛");insertintoMerchInfo(MerchI
3、D,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values("112032","酸酸乳","2.5","3.5","饮料","110","伊利");insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values("112052","方便面","2","4","生活类","123","康
4、师傅");insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values("112055","面包","7","12","甜品","123","盼盼");效果图：2.搭建数据库连接环境，在工作项目下的src文件夹中，创建包名为cn.edu.jiu.db的包，在包内新建DBUtil.Java文件代码如下：packagecn.edu.jiu.db;importjava.sql.*;i
5、mportjava.util.*;publicclassDBUtil{privateConnectionconn;privateStatementstmt;privateResultSetrs;publicbooleangetConnection(){booleanret=false;try{Class.forName("com.mysql.jdbc.Driver");Stringurl="jdbc:mysql://127.0.0.1:3306/supermarket?"+"&useUnicode=true&charac
6、terEncoding=gb2312";Stringuser="root";Stringpassword="";conn=DriverManager.getConnection(url,user,password);}catch(Exceptione){e.printStackTrace();}returnret;}publicintexecuteUpdate(Stringsql){intret=0;try{getConnection();stmt=conn.createStatement();ret=stmt.exec
7、uteUpdate(sql);close();}catch(Exceptione){e.printStackTrace();}returnret;}publicResultSetexecuteQuery(Stringsql){try{getConnection();stmt=conn.createStatement();rs=stmt.executeQuery(sql);}catch(Exceptione){e.printStackTrace();}returnrs;}publicvoidclose(){try{if(r
8、s!=null)rs.close();if(stmt!=null)stmt.close();if(conn!=null&&!conn.isClosed())conn.close();}catch(Exceptione){e.printStackTrace();}}publicstaticvoidmain(String
