软件工程毕设基于Java web的旅游网站设计【源码+论文】

深藏阁楼爱情的钟 2024-03-22 22:20 60阅读 0赞

#### 文章目录 ####

*  前言
 *  一、项目设计
 *   *  1. 模块设计
     *  2. 实现效果
 *  二、部分源码
 *  项目源码

--------------------

## 前言 ##

今天学长向大家分享一个 Java web 毕业设计设计项目:

**基于Java web的旅游网站设计**

**项目获取：**  
[https://gitee.com/sinonfin/L-javaWebSha][https_gitee.com_sinonfin_L-javaWebSha]

## 一、项目设计 ##

### 1. 模块设计 ###

该系统功能设计相对比较全面，能够满足大部分用户的需求。但是，做到满足每一个客户要求也是不可能的，只能是争取尽可能完善网站功能，到达更好的效果。塞北村镇旅游网站主要是通过各功能模块的介绍，对塞北村镇旅游进行宣传，包括首页，塞北人文，塞北故事等部分。具体前后台各部分实现如图1网站前台结构、图2网站后台结构所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 1]

### 2. 实现效果 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 2]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 3]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 6]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 8]

**功能较多，这里就不一 一展示了**

## 二、部分源码 ##

源码较多，文章篇幅有限，这里就不放上来了，仅展示小部分关键代码

部分代码示例：

该代码实现了塞北村镇旅游网站的主界面设计，现附录关键程序代码如下:
    </style>
    </head>
    <script language="javascript">
    function check()
    {
        
    	if(document.form1.yonghuming.value==""){
        alert("请输入用户名");document.form1.yonghuming.focus();return false;}if(document.form1.mima.value=="")
    {
        alert("请输入密码");document.form1.mima.focus();return false;}if(document.form1.xingming.value=="")
    {
        alert("请输入姓名");document.form1.xingming.focus();return false;}
    }
    functiongow()
    {
        
    document.location.href="yonghuzhuce_add.jsp?jihuabifffanhao="+document.form1.jihuabifffanhao.value;
    }
    </script>
    对于景点信息界面，可以进行景点的选择与查看功能，管理员还可以在后台进行对该模块操作，实现对景点信息的添加删除和修改。实现该模块的核心代码如下所示：
    <link rel="stylesheet" type="text/css" href="<%=path %>/css/base.css" />
    curpage=1;
    }
    if (curpage==0)
    {
        
    curpage=1;
    }
    if(curpage>zys)
    {
        
    curpage=zys;
    }
    //out.print(curpage);
    	
    String sql="select top "+page_record+" * from shangpinxinxi where id not in (select top "+((curpage-1)*page_record)+" id from shangpinxinxi order by id desc) ";				
    if(sc.equals(""))
    {
        }
    else
    {
        
    sql=sql+" and "+ltt+" like '%"+qd+"%'";
    }
    sql=sql+" order by id desc";				
    ResultSetRS_result=connDbBean.executeQuery(sql);
    while(RS_result.next()){
        
    i=i+1;
    j=j+1;
    id=RS_result.getString("id");
    bianhao=RS_result.getString("bianhao");
    mingcheng=RS_result.getString("mingcheng");
    tupian=RS_result.getString("tupian"); %>
    实现酒店预订的核心代码如下所示：
    <%
    String jiudianmingcheng=request.getParameter("jiudianmingcheng");String kefangbianhao=request.getParameter("kefangbianhao");String jiage=request.getParameter("jiage");String yudingshijian=request.getParameter("yudingshijian");String yudingtianshu=request.getParameter("yudingtianshu");String nindexingming=request.getParameter("nindexingming");String nindedianhua=request.getParameter("nindedianhua");String nindeshenfenzheng=request.getParameter("nindeshenfenzheng");String beizhu=request.getParameter("beizhu");String yonghuming=request.getParameter("yonghuming");
    String id=request.getParameter("id");
    String sql="update jiudianyuding set jiudianmingcheng='"+jiudianmingcheng+"',kefangbianhao='"+kefangbianhao+"',jiage='"+jiage+"',yudingshijian='"+yudingshijian+"',yudingtianshu='"+yudingtianshu+"',nindexingming='"+nindexingming+"',nindedianhua='"+nindedianhua+"',nindeshenfenzheng='"+nindeshenfenzheng+"',beizhu='"+beizhu+"',yonghuming='"+yonghuming+"' where id= "+id;
    connDbBean.executeUpdate(sql);
    out.print("<script>alert('修改成功!!');
    location.href='jiudianyuding_updt.jsp?id="+id+"';</script>"); %>
    在后台登录模块中，权限为管理员的用户方可登录成功，进行一系列的后台管理操作，核心程序代码如下：
    String uid=request.getParameter("username");
    String pwd=request.getParameter("pwd");
    String cx=new String(request.getParameter("cx").getBytes("8859_1"));
    String sql="";
    if(cx.equals("员工"))
    {
        
    sql="select * from [yuangongxinxi] where yonghuming='"+uid+"' and mima='"+pwd+"'";
    }
    else
    {
        
    sql="select * from [allusers] where username='"+uid+"' and pwd='"+pwd+"'";
    }
    ResultSetRS_result=connDbBean.executeQuery(sql);
    if(!RS_result.next())
    {
        
    out.print("<script>alert('你输入的用户不存在或密码错误,请重新登录!');
    window.history.go(-1);</script>");
    }
    else{
        
    session.setAttribute("username",uid);
    if(cx.equals("员工"))
    {
        
    session.setAttribute("cx","员工");
    }
    else
    {
        
    session.setAttribute("cx",RS_result.getString("cx"));
    }
    response.sendRedirect("main.jsp");
    }
    RS_result.close();
    %>
    景点后台管理可以对景点信息进行添加和查询修改操作，实现其关键程序代码如下所示：
    String sql="insert into xinwentongzhi(biaoti,leibie,neirong,tianjiaren,shouyetupian,dianjilv) values('"+biaoti+"','"+leibie+"','"+neirong+"','"+tianjiaren+"','"+shouyetupian+"','"+dianjilv+"') ";
    connDbBean.executeUpdate(sql);
    out.print("<script>alert('添加成功!!')
    ;location.href='xinwentongzhi_add.jsp?lb="+leibie+"';</script>");
    在实现自驾游路线管理模块中，管理员可以对路线进行实时修改和更新，以方便广大用户进行路线的选择。实现该功能的核心代码如下：
    <%
    intcurpage=1;//当前页
    intpage_record=10;//每页显示的记录数
    intzgs=0;
    intzys=0;
    //用下面的方法（sql查询完成，速度快）
    String hsgnpage=request.getParameter("page");
    String fysql="select count(id) as ss from shangpinxinxi";
    ResultSetRS_resultfy=connDbBean.executeQuery(fysql);
    while(RS_resultfy.next()){
        
    zgs=Integer.parseInt(RS_resultfy.getString("ss"));
    zys=zgs/page_record+1;
    }
    if (hsgnpage!=null)
    {
        
    curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页
    }
    else
    {
        
    curpage=1;
    }

## 项目源码 ##

**项目获取：**  
[https://gitee.com/sinonfin/L-javaWebSha][https_gitee.com_sinonfin_L-javaWebSha]

[https_gitee.com_sinonfin_L-javaWebSha]: https://gitee.com/sinonfin/L-javaWebSha
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/0f3d43ea9ad44eeb85e1c34ce0c7b3ee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/32b462411fd64f70be87c3c9ea596b6f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1039ffd25e55464b80b3dc0573322886.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2808cdc54b2a412da1d7d60f91cda50a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/8096e8fd06ab4b3298fa6f4c32224250.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2da722eeabde444cbdb7299fb36ec11f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/9baa6965b88743d3a0b107138f3937ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/f925a4ac5d8e48a5962dd5e3851d6a8b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hdGhvcl9zaW5vcg_size_36_color_FAFF2F_t_70 8]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/249bf38aa93d44a09e86f76c740ba1b6.png