《JavaWeb开发基础》实验报告

《《JavaWeb开发基础》实验报告》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、参考代码：packagekccx.entity;publicclassStorage{privateintid;//商品编号privateStringname;//商品名privatedoubleprice;//价格privateStringtype;//商品类型privateintnumber;//商品数量privateStringmakeTime;//'匸产RJWprivateintuseDay;//有效期publicintgetld(){returnid;}publicvoidsetld(intid){this.id=id;}publicStringget

2、MakeTime(){returnmakeTime;}publicvoidsetMakeTime(StringmakeTime){this.makeTime=makeTime;}publicStringgetName(){returnname;}publicvoidsetName(Stringname){this,name=name;}publicintgetNumber(){returnnumber;}publicvoidsetNumber(intnumber){this,number=number;}publicdoublegetPrice(){return

3、price;}publicvoidsetPrice(doubleprice){this.price=price;}publicStringgetType(){returntype;}publicvoidsetType(Stringtype){this.type=type;}publicintgetUseDayf){returnuseDay;}publicvoidsetUseDay(intuseDay){this.useDay=useDay;}}1•编写数据访问类：StorageDao,在Dao类中编写常量和方法。a)常量：驱动、URL、用户名、密码、商品类型。b

4、)方法4连接数据库。c)方法2：关闭数据库。d)方法3：按字段排序查询。e)方法4：按商品类型查询。参考代码：packagekccx.dao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.List;importjava.util.ArrayList;importkccx.entity.Storage

5、;publicclassStorageDao{publicstaticfinalStringWIRING="电器";publicstaticfinalStringFOOD='喰品publicstaticfinalStringCLOTHING="服装";publicstaticfinalStringCOMMODITY="日用占publicfinalstaticStringDRIVER"com.microsoft.sqlserver.jdbc.SQLServerDriver";//数据库驱动publicfinalstaticStringURL="jdbc:sqlse

6、rver://localhost:1433;DataBaseName=store";//数据库URLpublicfinalstaticStringDBNAME="sa";//数据库用户名publicfinalstaticStringDBPASS=//数据库密码privateConnectionconn=null;//数据库连接privatePreparedStatementpstmt=null;//PreparedStatement对象privateResultSetrs=null;//结果集对象/***按item字段排序**@paramitem*@return

7、商品对象的List*/publicListlistOrderByltem(Stringitem){Listlist=newArrayList();Stringsql="select*fromTBL_STORAGEorderby"+item;try{conn二this.getConn();pstmt=conn.prepareStatement(sql);rs=pstmt.executeQuery();while(rs.next()){Storagestor=newStorage!);stor.setName(rs.getString(Hname"))；stor.s

8、etType(rs.ge