《Java课程设计报告-注册会员的网上交易.docx》由会员分享，可在线阅读，更多相关《Java课程设计报告-注册会员的网上交易.docx（55页珍藏版）》请在课桌文档上搜索。
1、课程设计任务1二.计项目需求分析1L功能要求12.开发环境及开发工具1三 .总体设计1L软件结构（各模块名称及功能）12 .系统模块结构（软件结构图）23 .数据库结构2四 .详细设计31 .模块列表32 .各模块代码3Java课程设计报告姓名：*班级：计算机04（本科）一.课程设计任务JSP电子商务网站开发。二.计项目需求分析1 .功能要求实现注册会员的网上交易。2 .开发环境及开发工具Tomcat5.0;JDK1.4.三.总体设计1.软件结构（各模块名称及功能）1. bookmain.jsp网站的首页。提供会员的注册，会员的登录及商品的浏览。2. UserLoginjsp会员的登录，在以后
2、的各个页面中若未登录的用户都将转到本页。3. UserRegisterjsp会员的注册，在此页面中用户可以注册为本站的会员。4. buybook.jsp会员可以通过此页查找用户指定的商品并购买。5. ChangeFormjsp用户在modifyForm.jsp提出订单修改的要求后在此页根据用户要求进行订单的修改。6. deleteForm.jsp实现用户的订单删除操作。7. modifyForm.jsp用户的订单修改页面。8. modifyMessage.jsp用户的个人信息修改。9. modifyPassword.jsp用户的密码修改。10. ShowBookListjsp商品浏览页面，用户
3、可以购买。11. ShowOrderFormjsp用户订单查询。2 .系统模块结构（软件结构图）3 .数据库结构用户信息表：字段名称数据类型说明logname文本用户登录名称realname文本用户的真正姓名password文本密码email文本电子邮件地址phone文本电话address文本邮寄地址商品表:字段名称数据类型说明id自动编号Order_number文本订阅号book_name文本手机型号author文本品牌publisher文本所属系列time文本哪年的款式price文本单价category文本特价机否订单表:字段名称数据类型说明logname文本已注册的用户名称realnam
4、e文本真实姓名order_number文本图书订购号bookname文本订购的图书的名字mount文本订购的数量phone文本联系电话address文本邮寄地址四.详细设计1 .模块列表序号模块名称功能1bookmain.jsp网站的首页2UserLoginjsp会员的登录3UserRegisterjsp会员的注册4buybook.jsp查找指定的商品并购买5ChangeFormjsp订单修改6deleteForm.jsp订单删除7InodifyFormjsp订单修改8modifyMessage.jsp用户个人信息修改9modifyPassword.jsp密码修改10ShowBookListj
5、sp商品浏览，购买11ShowOrderFormjsp订单查询2 .各模块代码程序当中需要使用的beans:1.Loginjava:packagejialiang;importjava.sql.*;publicclassLoginStringlogname,realname,password,phone,address;Stringsuccess=false,message=;Connectioncon;Statementsql;ResultSetrs;publicLogin()(加载桥接器：tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);Icat
6、ch(ClassNotFoundExceptione)/设置属性值、获取属性值的方法：publicvoidsetLogname(Stringname)logname=name;)publicStringgetLogname()(returnlogname;)publicvoidsetPassword(Stringpw)(password=pw;)publicStringgetPassword()(returnpassword;)publicvoidsetRealname(Stringname)(realname=name;)publicStringgetRealname()(returnrea
7、lname;)publicvoidsetPhone(Stringph)(phone=ph;)publicStringgetPhone()(returnphone;)publicvoidsetAddress(Stringad)(address=ad;)publicStringgetAddress()(returnaddress;)publicStringgetSuccess()returnsuccess;/查询数据库的USer表:publicStringgetMessage()try(con=DriverManager.getConnection(,jdbczodbcshop,u);sql=co
8、n.createStatement();Stringcondition=SELECT*FROMuserWHERElogname=+logname+;rs=sql.executeQuery(condition);introwcount=0;Stringps=null;while(rs.next()(rowcount+;IOgname=rs.getString(logname);realname=rs.getString(realname);ps=rs.getString(,password,);phone=rs.getString(phone,);address=rs.getString(add
9、ress);)if(rowcount=1)&(password.equals(ps)(message=ok;SUCCeSS=ok;)elsemessage=输入的用户名或密码不正确；success=false;)con.close();returnmessage;)catch(SQLExceptione)message=输入的用户名或密码不正确；SUCCeSS=false;returnmessage;2. Registersjavapackagejialiang;importjava.sql.*;publicclassRegistersStringlogname=,;Stringrealnam
10、e=,M,;Stringpassword=n;Stringemail=;Stringphone=*;Stringaddress=;Stringmessage=1;Connectioncon;Statementsql;ResuItSetrs;publicRegistersO(加载桥接器：tryClass.forName(,sun.jdbc.odbc.JdbcOdbcDriverH);)catch(ClassNotFoundExceptione)设置属性值、获取属性值的方法：publicvoidsetLogname(Stringname)(logname=name;)publicStringget
11、Logname()(returnlogname;)publicvoidsetRealname(Stringname)(realname=name;)publicStringgetRealname()(returnrealname;)publicvoidsetPassword(Stringpw)(password=pw;)publicStringgetPassword()returnpassword;)publicvoidsetEmail(Stringem)(email=em;)publicStringgetEmail()(returnemail;)publicvoidsetPhone(Stri
12、ngph)(phone=ph;)publicStringgetPhone()returnphone;publicvoidsetAddress(Stringad)(address=ad;)publicStringgetAddress()(returnaddress;)publicStringgetMessage()(returnmessage;)添加记录到数据库的user表：publicvoidaddltem()trycon=DriverManager.getConnection(jdbc:odbc:shop7，/M,);sql=con.createStatement();Strings=+lo
13、gname+；+realname+password+email+phone+；+address+;StringCondition=nINSERTINTOuserVALUES+,(+s+11)h;sql.executeUpdate(condition);message=注册成功了”；con.close();)catch(SQLExceptione)message=该用户己经存在，请你更换一个名字；3. BuyBookjavaPackagejialiang;importjava.sql.*;publicclassBuyBook(longid=O;Stringorder_number,book_na
14、me;Connectioncon;Statementsql;ResuItSetrs;publicBuyBook()(/加载桥接器：tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriverr);Icatch(ClassNotFoundExceptione)设置属性值、获取属性值的方法:publicvoidsetld(longn)id=n;)publiclonggetld()returnid;)publicvoidSetBOok_name(Stringname)(book_name=name;)publicStringgetBook_name()(returnbk
15、-name;)publicvoidsetOrder_number(Stringnumber)(OrdeJnUmber=number;)publicStringgetrder-number()(returnorder_number;)通过书的id号查询数据库的book表：publicStringBuffergetMessageBybook_id()(StringBufferbuffer=newStringBufferO;try(Con=DriverManagengetConnectionCjdbczodbcshop,n);Sql=ConxreateStatementO;StringConditi
16、on=nSELECT*FROMbookWHEREid=,+id;rs=sql.executeQuery(condition);buffer.append(,);huffer.append(n);buffer.append(+id+);buffer.append(+订购号+);buffer.append(+,+书名,+,);buffer.append(+“作者+“);buffer.append(+”出版社+”)；buffr.append(+”出版时间+”);buffer.append(+价钱+“);buffer.append(+,+分类+”);buffer.append();while(rs.n
17、ext()(order_number=rs.getString(2);book_name=rs.getString(3);String作者=rs.getString(4);String出版社=rs.getString(5);Date时间=rs.getDate(6);String价格=rs.getString(price);String分类=rs.getString(category);buffer.append(,);buffer.append(,+,+rs.getLong(1)+*);buffer.append(+order-number+);buffer.append(+,+book-na
18、me+);buffer.append(,+作者+”);buffer.append(+出版社+vFONT);buffer.append(,+,+时间+/FONT”)；buffer.append(+价格+”);bufifer.append(,+分类+);buffer.append(*);Ibuffer.append(,);buffer.append(,);con.close();returnbuffer;)catch(SQLExceptione)(returnbuffer;4. OrderFormjavapackagejialiang;importjava.sql.*;publicclassOrd
19、erForm(Stringlogname,用户名。realname,/真实姓名。order_number,/图书订购号phone,address,book_name,书名。mount;数量。Connectioncon;Statementsql;ResuItSetrs;publicOrderFormO(加载桥接器：tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);)catch(ClassNotFoundExceptione)设置属性值、获取属性值的方法：publicvoidsetLogname(Stringname)(logname=name;)pub
20、licStringgetLogname()(returnlogname;)publicvoidsetRealname(Stringname)(realname=name;)publicStringgetRealname()(returnrealname;)publicvoidsetOrder_number(Stringnumber)(OrdeJnUmber=number;)publicStringgetrder-number()(returnOrdejnUmber;)publicvoidsetBook_name(Stringname)(book_name=name;)publicStringg
21、etBook_name()(returnbook_name;)publicvoidsetPhone(Stringph)(phone=ph;)publicStringgetPhone()returnphone;)publicvoidsetAddress(Stringad)(address=ad;)publicStringgetAddress()(returnaddress;)publicvoidsetMount(Stringn)(mount=n;)publicStringgetMount()returnmount;向数据库的Orderform订单表添加订购记录:publicStringsetOr
22、derBook()trycon=DriverManager.getConnection(jdbc:Odbc:ShoPsql=con.createStatement();Strings=+logname+realname+order.number+book_name+mount+phone+address+;StringCondition=uINSERTINTOorderformVALUES+(+s,);sql.executeUpdate(condition);con.dose();return”该书被添加到你的订单；)catch(SQLExceptione)return你已经订购了该书，请去修
23、改订单后再订购”；5. PageNumberjavaPackagejialiang;publicclassPageNumberintrowCount=I,总的记录数。pageSize=1,每页显示的记录数。ShowPage=I,设置欲显示的页码数。pageCount=I;/分页之后的总页数。publicvoidsetRowCount(intn)(rowCount=n;)publicintgetRowCount()returnrowCount;JpublicvoidsetPageCount(intr,int)rowCount=r;pageSize=p;intn=(rowCount%pageSiz
24、e)=0?(rowCount/pageSize):(rowCount/pageSize+1);pageCount=n;)publicintgetPageCount()returnpageCount;)publicvoidsetShowPage(intn)(showPage=n;publicintgetShowPage()returnshowPage;)publicvoidsetPageSize(intn)(pageSize=n;)publicintgetPageSize()returnpageSize;)网页文件：1. bookmain.jspv%!处理字符串的方法：publicStringc
25、odeString(Strings)Stringstr=s;trybyteb=str.getBytes(ISO-8859-1);str=newString(b);returnstr;)catch(Exceptione)returnstr;)%areashape=rectcoords=111,18,140,33href=”areashape=,rectcoords=148,18,209,32href=areashape=rectcoords=,217,19,278,32href=areashape=,rectcoords=286,20,344,3,href=areashape=rectcoord
26、s=,357,19,418,34href=,areashape=rectcoords=432,18,492,33href=areashape=rectcoords=508,17,567,33href=areashape=,rectcoords=579,19,640,32href=,areashape=rectcoords=,655,18,739,34href=FORMaction=Method=post用户名：密码：FORMaction=,Method=postv%提交信息后，验证信息是否正确：Stringmessage=,logname=,password=,;if(!(session.is
27、New()(Iogname=request.getParameter(Iognamen);if(Iogname=null)logname=u,;)Iogname=CodeString(Iogname);password=request.getParameter(password);if(password=null)password=;)password=codeString(password);)if(!(Iogname.equals(,)(%jsp:SetPropertyname=loginproperty=lognamevalue=,jsp:SetPropertyname=loginpro
28、perty=passwordvalue=制作人：贾技术支持：姜广坤采用技术：JSP诺基亚7610市场价:4999元:4499元添加到购物๗O诺基亚6600市场价:4999元:4499元添加到购:物๗OTCL787
29、4066;场价:4999元:4499元添加到购物车 诺基亚7610市场价:4999元:4499元添加到购物车摩托罗拉/strongv690市场价:1860元:1199元添加到购物车摩托罗拉vstrongE680i市场价:3880元3499(fe20803z palign=centerclass=style2style3
