机票)预订系统(附源码+调试)"/>
JSP课设:酒店(车票、机票)预订系统(附源码+调试)
JSP酒店预订系统
JSP酒店预订系统功能概述
(1)登录模块:酒店预订系统登录模块分为用户登录和系统管理者登录,两者信息存储在数据库中。
(2)用户模块:用户模块主要分为用户注册、登录功能,酒店信息查看功能,网站新闻查看功能,酒店预订功能,留言板功能。
(3)系统管理者模块:系统管理者模块主要分为管理者登录功能、用户维护功能,会员管理功能,酒店管理(酒店信息管理、酒店预订管理),新闻管理,留言管理等功能。
本系统也可以在此基础上修改为车票预订管理系统和机票预订管理系统等众多预订系统。
代码链接:
提取码:3pxo
代码截图
系统首页
游客注册界面
订单查询
后台管理界面
酒店信息管理界面
部分核心代码
主界面
<%@ page language="java" import="java.util.*,java.sql.*,com.biyeseng.db.*"pageEncoding="UTF-8"%>
<%String path = request.getContextPath();String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";
%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ".dtd">
<html xmlns=""><head><base href="<%=basePath%>"><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>酒店预订系统</title><link href="css/style.css" rel="stylesheet" type="text/css" /><link href="css/commons.css" rel="stylesheet" type="text/css"><script type="text/javascript" src="js/tab.js">
</script></head><body style="background:url(upload/newbg.jpg)"><div class="page"><div class="page_con"><jsp:include flush="true" page="/inc/top.jsp"></jsp:include><%DBManager dbm = new DBManager();Connection conn = dbm.getConnection();String sql;PreparedStatement pstmt;ResultSet rs;%><div id="wrapper"><!--body start--><div id="body"><!--ProductShow start--><div class="MainBlock"><div class="Solutions"><div class="topic"><div id="Solutionsdemo"><div id="Solutionsindemo"><%sql = "select * from jiudian";pstmt = conn.prepareStatement(sql);rs = pstmt.executeQuery();while (rs.next()) {String id = rs.getString("id");%><a href="jiu_detail.jsp?id=<%=id%>"title="<%=rs.getString("name")%>"><imgsrc="<%=rs.getString("pic")%>" width="200" height="124"alt="<%=rs.getString("name")%>"></a><%}%><div class="clearfix"></div><div id="Solutionsdemo2"><div class="clearfix"></div></div></div></div></div></div></div></div></div><div class="main"><div class="main_con"><div class="main_box clearfix"><div class="main_center"><div class="m_border"><div class="m_title2"><h3>最新新闻</h3></div><div class="article_listbox"><ul><%sql = "select * from news order by date desc limit 10";pstmt = conn.prepareStatement(sql);rs = pstmt.executeQuery();while (rs.next()) {String id = rs.getString("id");%><li><span class="time"><%=rs.getString("appuser") %> <%=rs.getString("date") %></span><a href="news_detail.jsp?id=<%=id %>"><%=rs.getString("title") %></a></li><%}%></ul></div></div><div class="m_border"><div class="m_title2"><h3>留言</h3></div><div class="m_content"><%sql = "select * from message";pstmt = conn.prepareStatement(sql);rs = pstmt.executeQuery();while (rs.next()) {String id = rs.getString("id");%><div class="leave_mes"><p class="mes_info"><span class="reply"><a href="#"></a> </span><span>留言人:<%=rs.getString("appuser")%></span><span>时间:<%=rs.getString("date")%></span></p><div class="mes_con"><%=rs.getString("msg")%></div></div><%}if (rs != null)rs.close();if (pstmt != null)pstmt.close();if (conn != null)conn.close();%><div class="message_con"></div></div></div></div></div></div></div><!----------------内容区结束--------------------><!---------------页脚开始----------------><div class="bottom"><p><a style="color:white">佛山科学技术学院</a></p></div><!---------------页脚结束----------------></div></div><script>
<!--
var speed=10;
var tab=document.getElementById("Solutionsdemo");
var tab1=document.getElementById("Solutionsdemo1");
var tab2=document.getElementById("Solutionsdemo2");
tab2.innerHTML=tab1.innerHTML;
function Marquee(){
if(tab2.offsetWidth-tab.scrollLeft<=0)
tab.scrollLeft-=tab1.offsetWidth
else{
tab.scrollLeft++;
}
}
var MyMar=setInterval(Marquee,speed);
tab.onmouseover=function() {clearInterval(MyMar)};
tab.onmouseout=function() {MyMar=setInterval(Marquee,speed)};
--></script></body>
</html>
数据库链接
package com.biyeseng.db;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;/*** 数据库管理类* * @author win7* */
public class DBManager {public static final String DEFAULT_DRIVER_NAME = "com.mysql.jdbc.Driver";public static final String DEFAULT_DB_URL = "jdbc:mysql://localhost:3306/jdydxt?useUnicode=true&characterEncoding=UTF-8";public static String DB_URL = null;public static Properties prop = null;//获取数据连接public Connection getConnection() {Connection coon = null;try {Class.forName(DEFAULT_DRIVER_NAME);coon = DriverManager.getConnection(DEFAULT_DB_URL, "root", "123456");} catch (Exception e) {e.printStackTrace();}return coon;}public static void main(String[] args) {DBManager manager = new DBManager();manager.getConnection();}public boolean login(String username, String pwd) {Connection coon = getConnection();ResultSet rs = null;PreparedStatement pstmt = null;try {pstmt = coon.prepareStatement("select * from admin where userName='"+ username + "' and userPw='" + pwd + "'");rs = pstmt.executeQuery();while (rs.next()) {return true;}} catch (SQLException e) {e.printStackTrace();} finally {try {if (pstmt != null)pstmt.close();if (coon != null)coon.close();} catch (Exception e) {e.printStackTrace();}}return false;}public boolean loginUser(String username, String pwd) {Connection coon = getConnection();ResultSet rs = null;PreparedStatement pstmt = null;try {pstmt = coon.prepareStatement("select * from userinfo where tel='"+ username + "' and pwd='" + pwd + "'");rs = pstmt.executeQuery();while (rs.next()) {return true;}} catch (SQLException e) {e.printStackTrace();} finally {try {if (pstmt != null)pstmt.close();if (coon != null)coon.close();} catch (Exception e) {e.printStackTrace();}}return false;}public String getUserType(String tel) {Connection coon = getConnection();ResultSet rs = null;PreparedStatement pstmt = null;try {pstmt = coon.prepareStatement("select * from userinfo where tel='"+ tel +"'");rs = pstmt.executeQuery();while (rs.next()) {return rs.getString("type");}} catch (SQLException e) {e.printStackTrace();} finally {try {if (pstmt != null)pstmt.close();if (coon != null)coon.close();} catch (Exception e) {e.printStackTrace();}}return "";}public static String TextToHtml(String sourcestr) {int strlen;String restring = "", destr = "";strlen = sourcestr.length();for (int i = 0; i < strlen; i++) {char ch = sourcestr.charAt(i);switch (ch) {case '<':destr = "<";break;case '>':destr = ">";break;case '\"':destr = "\"";break;case '&':destr = "&";break;case 13:destr = "<br>";break;case 32:destr = " ";break;default:destr = "" + ch;break;}restring = restring + destr;}return "" + restring;}
}
系统管理者菜单界面
<%@ page language="java"import="java.util.*,java.sql.*,com.biyeseng.db.*"pageEncoding="UTF-8"%>
<%String path = request.getContextPath();String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><base href="<%=basePath%>"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>用户管理</title><LINK href="css/admin.css" type="text/css" rel="stylesheet"></head><body leftmargin="8" topmargin="8"'><!-- 快速转换位置按钮 --><!-- 内容列表 --><form name="form2"><div id="printTable"><table width="98%" border="0" cellpadding="2" cellspacing="1"bgcolor="#3333FF" align="center" style="margin-top: 8px"><tr bgcolor="#E7E7E7"><td height="24" colspan="10" background="admin/images/tbg.gif"> 用户信息列表 </td></tr><tr align="center" bgcolor="#FAFAF1" height="22"><td width="6%">ID</td><td width="14%">登录名</td><td width="20%">密码 </td><td width="10%">职务 </td><td width="10%">电话 </td><td width="10%">年龄 </td><td width="10%">操作</td></tr><%DBManager dbm = new DBManager();Connection conn = dbm.getConnection();String queryName = request.getParameter("queryName");String sql = "select * from admin";if (queryName != null) {sql = "select * from admin where userName like '%" + queryName+ "%'";}PreparedStatement pstmt = conn.prepareStatement(sql);ResultSet rs = pstmt.executeQuery();while (rs.next()) {String id = rs.getString("id");%><tr align='center' bgcolor="#FFFFFF"onMouseMove="javascript:this.bgColor='#FCFDEE';"onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22"><td><%=id%></td><td><%=rs.getString("userName")%></td><td align="left"><div align="center"><%=rs.getString("userPw")%></div></td><td align="left"><div align="center"><%=rs.getString("zhi")%></div></td><td align="left"><div align="center"><%=rs.getString("tel")%></div></td><td align="left"><div align="center"><%=rs.getString("age")%></div></td><td><a href="admin/admin/modAdmin.jsp?id=<%=id %>">编辑</a> |<a href="DelAdminAction?id=<%=id %>">删除</a></td></tr><%}if (rs != null)rs.close();if (pstmt != null)pstmt.close();if (conn != null)conn.close();%><tr bgcolor="#FAFAF1"><td height="28" colspan="10"> <a href="admin/admin/addAdmin.jsp"><strong>添加用户</strong></a> </td></tr></table></div></form><!-- 搜索表单 --><form action="admin/admin/list.jsp" method="post"><table width='98%' border='0' cellpadding='1' cellspacing='1'bgcolor='#CBD8AC' align="center" style="margin-top: 8px"><tr bgcolor='#EEF4EA'><td align='center'><table width="469" border='0' cellpadding='0' cellspacing='0'><tr><td width='129'>请输入员工名称:</td><td width='170'><input type='text' name='queryName' value=''style='width: 150px' /></td><td width='86'><input name="imageField" type="submit" border="0" class="np"value='查询' /></td><td width="84"> </td></tr></table></td></tr></table></form></body>
</html>
更多推荐
JSP课设:酒店(车票、机票)预订系统(附源码+调试)
发布评论