JSP课程设计(数据库添删改查)毕业论文

1、 . . . 实 验 报 告 书实验报告具体容一般应包括：一、实验目的和要求;二、主要仪器设备(软件);三、实验容与实验数据记录;四、问题与建议实验名称 对数据表的添、删、改、查操作一.实验目的和要求本实验目的在于让学生：掌握连接数据库的常用方式；掌握对数据库的查询操作；掌握对数据库的更新、添加和删除操作；掌握分页显示记录的操作；掌握MVC编程模式。二.主要仪器设备（软件）实验硬件：PC机实验软件：JDK、TOMCAT、JCreator和Dreamveaver。三.实验容与数据记录 实验容新建一个数据库，自定义一表。具体表中的字段根据情况进进行设定。要求：编写信息浏览（列表）的页面；编写信息管

2、理的页面：数据的添加、删除和修改等。实验数据记录明珠玮玉博文系统V1.0本博文系统采用TOMCAT6.0+MYSQL5.0做出来的，可实现对用户的添加修改，以与对博文的添、删、改、查，并支持分页，每显示15条数据项，登录：admin密码admin：可登录后再添加用户<1>目录树结构：TREE E:DEFAULT WEB SITEAPACHE-TOMCAT-6.0.35WEBAPPSUSE9 > tree.txt文件夹 PATH 列表卷序列号为 00000002 3066:996EE:DEFAULT WEB SITEAPACHE-TOMCAT-6.0.35WEBAPPSUSE9

3、filesUpLoadFilesCpImgItemImgLogoImgNewsImguse9_admineWebEditorbuttonimagebluegraycssbluecoolbluegreenlightmxofficeoffice3dredyellowdialogjsstylesysimagebgemotfilefilesincWEB-INFclasseslib<2>主目录结构：-index.jsp -user_LOGIN.jsp 登录界面-files 图片文件和css文件-files 图片文件和css文件-WEB-INF |-classes|-hibernate.cfg

4、 数据连接config文件|-lib|-struts_cofig.xml|-web.xmlWeb.mxl<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="java.sun./xml/ns/javaee" xmlns:xsi="./2001/XMLSchema-instance"version="2.5"xsi:schemaLocation="java.sun./xml/ns/javaee java.

5、sun./xml/ns/javaee/web-app_2_5.xsd"><servlet><servlet-name>do</servlet-name><servlet-class>org.apache.struts.action.ActionServlet</servlet-class><init-param><param-name>config</param-name><param-value>/WEB-INF/struts-config.xml</param-

6、value></init-param><init-param><param-name>debug</param-name><param-value>3</param-value></init-param><init-param><param-name>detail</param-name><param-value>3</param-value></init-param><load-on-startup>0</load

7、-on-startup></servlet><servlet-mapping><servlet-name>do</servlet-name><url-pattern>*.do</url-pattern></servlet-mapping><filter><filter-name>setCharEncoding</filter-name><filter-class>.use9.log.filter.SetCharacterEncodingFilter</

8、filter-class><init-param><param-name>encoding</param-name><param-value>utf-8</param-value></init-param><init-param><param-name>enable</param-name><param-value>true</param-value></init-param></filter><filter-mapping&g

9、t;<filter-name>setCharEncoding</filter-name><url-pattern>/*</url-pattern></filter-mapping><filter><filter-name>login_Filter</filter-name><filter-class>.use9.log.filter.CheckAdmin</filter-class></filter><filter-mapping><filter

10、-name>login_Filter</filter-name><url-pattern>/use9_admin/*</url-pattern></filter-mapping><filter><filter-name>login_Filter1</filter-name><filter-class>.use9.log.filter.CheckAdmin</filter-class></filter><filter-mapping><filter-na

11、me>login_Filter1</filter-name><url-pattern>/admin/*</url-pattern></filter-mapping><session-config><session-timeout>30</session-timeout></session-config><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list

12、></web-app><3> struts_cofig.xml<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts-config PUBLIC "-/Apache Software Foundation/DTD Struts Configuration 1.2/EN" "/dtds/struts-config_1_2.dtd"><struts-config>&l

13、t;data-sources /><form-beans><form-bean name="myForm" type=".use9.frame.struts.MyForm" /></form-beans><global-exceptions /><global-forwards /><action-mappings><action attribute="myForm" name="myForm" parameter="us

14、e9" path="/admin/ad"scope="request" type=".use9.frame.struts.admin.action.Use9_AdminAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/ab"scope="request" type=".

15、use9.frame.struts.admin.action.Use9_AboutAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/conf"scope="request" type=".use9.frame.struts.admin.action.Use9_ConfigAction"></action&g

16、t;<action attribute="myForm" name="myForm" parameter="use9" path="/admin/abt"scope="request" type=".use9.frame.struts.admin.action.Use9_AboutTypeAction"></action><action attribute="myForm" name="myForm" pa

17、rameter="use9" path="/admin/cont"scope="request" type=".use9.frame.struts.admin.action.Use9_ContactAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/j"scope="request

18、" type=".use9.frame.struts.admin.action.Use9_JobAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/l"scope="request" type=".use9.frame.struts.admin.action.Use9_LinkAction">&

19、lt;/action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/m"scope="request" type=".use9.frame.struts.admin.action.Use9_MassAction"></action><action attribute="myForm" name="myForm&quo

20、t; parameter="use9" path="/admin/n"scope="request" type=".use9.frame.struts.admin.action.Use9_NewsAction"><forward name="success" path="/use9_admin/Use9_News.jsp" redirect="true" /></action><action attribute=&quo

21、t;myForm" name="myForm" parameter="use9" path="/admin/nt"scope="request" type=".use9.frame.struts.admin.action.Use9_NewTypeAction"></action><action attribute="myForm" name="myForm" parameter="use9" path=

22、"/admin/o"scope="request" type=".use9.frame.struts.admin.action.Use9_ObjectAction"><forward name="success" path="/use9_admin/Use9_Items.jsp" redirect="true" /></action><action attribute="myForm" name="myForm

23、" parameter="use9" path="/admin/ot"scope="request" type=".use9.frame.struts.admin.action.Use9_ObjectTypeAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/p"scope=&qu

24、ot;request" type=".use9.frame.struts.admin.action.Use9_ProductAction"><forward name="success" path="/use9_admin/Use9_Cp.jsp" redirect="true" /></action><action attribute="myForm" name="myForm" parameter="use9&quo

25、t; path="/admin/pt"scope="request" type=".use9.frame.struts.admin.action.Use9_ProductTypeAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/admin/v"scope="request" type=".u

26、se9.frame.struts.admin.action.Use9_VipAction"></action><action attribute="myForm" name="myForm" parameter="use9" path="/lo"scope="request" type=".use9.log.filter.CheckLogin"><forward name="success" path=&quo

27、t;/use9_admin/Use9_Index.jsp" redirect="true" /><forward name="filed" path="/use9_LOGIN.jsp" redirect="true" /></action></action-mappings><message-resources parameter=".use9.frame.struts.ApplicationResources" /></st

28、ruts-config><4>hibernate.cfg.xml数据库连接配置文件<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE hibernate-configuration PUBLIC "-/Hibernate/Hibernate Configuration DTD 3.0/EN" "<hibernate-configuration><session-factory><property name="con

29、nection.url">jdbc:mysql:/localhost:3306/use9</property><property name="dialect">org.hibernate.dialect.DerbyDialect</property><property name="file">MyEclipse Derby</property><property name="connection.username&q

30、uot;>root</property><property name="connection.password">123456</property><property name="connection.driver_class">.mysql.jdbc.Driver</property><property name="c3p0.max_size">10</property><property name="c3p0.min_size

31、">2</property><property name="c3p0.timeout">90</property><property name="c3p0.idle_test_period">600</property><mapping resource="/use9/frame/hibernate/pojo/Use9Aboutus.hbm.xml" /><mapping resource="/use9/frame/hibernat

32、e/pojo/Use9Aboutustype.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Admin.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Config.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Contactus.hbm.xml" /><

33、mapping resource="/use9/frame/hibernate/pojo/Use9Job.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Link.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Mass.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9N

34、ews.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Newtype.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Object.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Objecttype.hbm.xml" /><mapping resource

35、="/use9/frame/hibernate/pojo/Use9Product.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Producttype.hbm.xml" /><mapping resource="/use9/frame/hibernate/pojo/Use9Vip.hbm.xml" /></session-factory></hibernate-configuration><6>

36、 Use9_LeftTree.jsp使用框架结构，左边的目录界面代码如下，使用了JS实现动态滚动，并设置了有关信息<TBODY><TR> <TD class=t5 align=center bgColor=#d6dff7>所有：<BR>Copyright&copy;2011-2012 minjavaya.All Right Reserved <BR> 联系 :939057120 </TD></TR></TBODY><% page language="java" im

37、port="java.util.*" pageEncoding="utf-8"%><% page import=".use9.frame.model.*"%><HTML><HEAD><META -equiv=Content-Type content=text/html;charset=gb2312><LINK href="./files/use9.css" type=text/css rel=stylesheet><STYLE type=tex

38、t/css>BODY BACKGROUND: #799ae1;MARGIN: 0px.sec_menu BORDER-RIGHT: white 1px solid;BACKGROUND: #d6dff7;OVERFLOW: hidden;BORDER-LEFT: white 1px solid;BORDER-BOTTOM: white 1px solid.menu_title SPAN FONT-WEIGHT: bold;LEFT: 10px;COLOR: #215dc6;POSITION: relative;TOP: 2px.menu_title2 SPAN FONT-WEIGHT:

39、bold;LEFT: 10px;COLOR: #428eff;POSITION: relative;TOP: 2px</STYLE><SCRIPT>function aa(Dir) tt.doScroll(Dir);Timer = setTimeout('aa("' + Dir + '")', 100)/这里100为滚动速度function StopScroll() if (Timer != null)clearTimeout(Timer)function initIt() divColl = document.all

40、.tags("DIV");for (i = 0; i < divColl.length; i+) whichEl = divColl(i);if (whichEl.className = "child")whichEl.style.display = "none"function expands(el) whichEl1 = eval(el + "Child");if (whichEl1.style.display = "none") initIt();whichEl1.style.dis

41、play = "block" else whichEl1.style.display = "none"var tree = 0;function loadThreadFollow() if (tree = 0) document.frames"hiddenframe".location.replace("Use9_LeftTree.jsp");tree = 1function showsubmenu(sid) whichEl = eval("submenu" + sid);imgmenu = e

42、val("imgmenu" + sid);if (whichEl.style.display = "none") eval("submenu" + sid + ".style.display=""");imgmenu.background = "./files/menuup.gif" else eval("submenu" + sid + ".style.display="none"");imgmenu.backgr

43、ound = "./files/menudown.gif"function loadingmenu(id) var loadmenu = eval("menu" + id);if (loadmenu.innerText = "Loading.") document.frames"hiddenframe".location.replace("LeftTree.asp?menu=menu&id=" + id + "");top.document.title = "

44、;<%=USE9.web_name%>"</SCRIPT><META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD><BODY><TABLE cellSpacing=0 cellPadding=0 width=158 align=center><TBODY><TR><TD vAlign=bottom height=42><IMG height=38 src="./files/tit

45、le.gif" width=158 border=0></TD></TR><TR><TD class=menu_title onmouseover=this.className = 'menu_title2'onmouseout=this.className = 'menu_title'background=./files/title_bg_quit.gif height=25><SPAN><B><A href="localhost:8080/use9/use

46、9_admin/Use9_Index.jsp" target=_top><FONTcolor=#215dc6>回到首页</FONT> </A> </B> |<B> <A href="./logout.jsp" target=_top><FONTcolor=#215dc6>退出 </FONT> </A></B> </SPAN></TD></TR><TR><TD>&nbsp;&

47、lt;/TD></TR></TBODY></TABLE><SCRIPT>var he = document.body.clientHeight - 105document.write("<div id=tt style=height:" + he + "overflow:hidden>")</SCRIPT><TABLE cellSpacing=0 cellPadding=0 width=158 align=center><TBODY><TR>

48、<TD class=menu_title id=imgmenu1 onmouseover=this.className;= 'menu_title2'style="CURSOR: hand" onclick=showsubmenu(1);onmouseout=this.className;= 'menu_title'background=./files/menudown.gif height=25><SPAN>系统管理 </SPAN></TD></TR><TR><T

49、D id=submenu1 style="DISPLAY: none"><DIV class=sec_menu style="WIDTH: 158px"><TABLE cellSpacing=3 cellPadding=0 width=130 align=center><TBODY><TR><TD><A href="./Use9_Admin.jsp" target=main>管理员管理</A></TD></TR><T

50、R><TD><A href="./Use9_SiteConfig.jsp" target=main>配置</A></TD></TR></TBODY></TABLE></DIV><BR></TD></TR><TR><TD class=menu_title id=imgmenu6 onmouseover=this.className;= 'menu_title2'style="CURSOR: han

51、d" onclick=showsubmenu(6);onmouseout=this.className;= 'menu_title'background=./files/menudown.gif height=25><SPAN>博文管理 </SPAN></TD></TR><TR><TD id=submenu6 style="DISPLAY: none"><DIV class=sec_menu style="WIDTH: 158px"><

52、;TABLE cellSpacing=3 cellPadding=0 width=130 align=center><TBODY><TR><TD><A href="./Use9_NewType.jsp" target=main>管理博文类别</A></TD></TR><TR><TD><A href="./Use9_NewsAdd.jsp" target=main>添加博文容</A></TD></TR&

53、gt;<TR><TD><A href="./Use9_News.jsp" target=main>管理全部博文</A></TD></TR></TBODY></TABLE></DIV><BR></TD></TR></TBODY></TABLE><TABLE height=43 cellSpacing=0 cellPadding=0 width=158 align=centerborder=0><

54、;TBODY><TR> <TD class=t5 align=center bgColor=#d6dff7>所有：<BR>Copyright&copy;2011-2012 minjavaya.All Right Reserved <BR> 联系 :939057120</TD></TR></TBODY></TABLE></BODY></HTML><5>数据库名为：use9库容如下:CREATE DATABASE IF NOT EXISTS use9;U

55、SE use9;DROP TABLE IF EXISTS use9_aboutus;CREATE TABLE use9_aboutus ( Id int(11) NOT NULL auto_increment, name varchar(45) NOT NULL, content longtext, mark_id int(11) default NULL, PRIMARY KEY (Id), KEY FK_use9_aboutus_1 (mark_id), CONSTRAINT FK_use9_aboutus_1 FOREIGN KEY (mark_id) REFERENCES use9_a

56、boutustype (Id) ENGINE=InnoDB DEFAULT CHARSET=gb2312;DROP TABLE IF EXISTS use9_aboutustype;CREATE TABLE use9_aboutustype ( Id int(11) NOT NULL auto_increment, type varchar(45) default NULL, PRIMARY KEY (Id) ENGINE=InnoDB DEFAULT CHARSET=gb2312;DROP TABLE IF EXISTS use9_admin;CREATE TABLE use9_admin

57、( Id int(11) NOT NULL auto_increment, login_name varchar(45) collate gb2312_bin default NULL, login_pwd varchar(45) collate gb2312_bin default NULL, PRIMARY KEY (Id) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin;/*!40000 ALTER TABLE use9_admin DISABLE KEYS */;INSERT INTO use9_admin (Id,log

58、in_name,login_pwd) VALUES (2,0x75736539,0x75736539), (4,0x73030,0x75736539);DROP TABLE IF EXISTS use9_config;CREATE TABLE use9_config ( Id int(11) NOT NULL auto_increment, web_name varchar(45) default NULL, web_link varchar(45) default NULL, web_logo varchar(45) default NULL, web_banner varchar(45)

59、default NULL, web_right varchar(255) default NULL, web_keyword varchar(255) NOT NULL, web_page int(10) unsigned NOT NULL, web_ename varchar(45) NOT NULL, web_title varchar(45) NOT NULL, web_etitle varchar(45) NOT NULL, web_owner varchar(45) NOT NULL, web_ varchar(45) NOT NULL, web_email varchar(45)

60、NOT NULL, PRIMARY KEY (Id) ENGINE=InnoDB DEFAULT CHARSET=gb2312;DROP TABLE IF EXISTS use9_contactus;CREATE TABLE use9_contactus ( Id int(11) NOT NULL auto_increment, map varchar(45) default NULL, content longtext, PRIMARY KEY (Id) ENGINE=InnoDB DEFAULT CHARSET=gb2312;DROP TABLE IF EXISTS use9_job;CR

61、EATE TABLE use9_job ( Id int(11) NOT NULL auto_increment, person varchar(45) default NULL, number int(11) default NULL, work_where varchar(255) default NULL, pay varchar(45) default NULL, times varchar(45) default NULL, day_limit int(11) default NULL, job_require longtext, PRIMARY KEY (Id) ENGINE=In

62、noDB DEFAULT CHARSET=gb2312;DROP TABLE IF EXISTS use9_mass;CREATE TABLE use9_mass ( Id int(11) NOT NULL auto_increment, login_name varchar(45) default NULL, company varchar(45) default NULL, name varchar(45) default NULL, tel varchar(45) default NULL, email varchar(45) default NULL, mobile varchar(45) default NULL, times varchar(45) default NULL, title varchar(45) default NULL, content longtext, remark int(11) default NULL, recontent longtext, PRIMARY KE