代码：火车票预订系统的设计与实现

目录第一部分功能代码......................................................................................................................... - 1 -1.DBO.JAVA (1)2.L OG.JAVA (4)3.MD5.JAVA (5)4.C OMMON.JAVA (6)5.C HECK C ODE.JAVA (8)6.L OGIN S ERVLET.JAVA (9)7.T RAIN B EAN.JAVA (13)第二部分外部显示代码 ............................................................................................................... - 24 -1.INDEX.JSP (24)2.LOGIN.JSP (27)3.ERROR.JSP (31)4.INDEX.JSP (32)5.INDEX.JSP (35)第一部分内部功能代码1. DBO.javapackage com.util;import java.sql.*;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import javax.activation.DataSource;import java.sql.*;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.naming.Context;import javax.naming.InitialContext;public class DBO {private Connection conn;private Statement stmt;private DataSource ds;public DBO(){}/**打开数据库*/public void open() {try {Class.forName("org.gjt.mm.mysql.Driver");conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/cpyd?user=root&passwor d=siming&useUnicode=true&characterEncoding=GBK");stmt=conn.createStatement();System.out.println("打开数据库连接");}catch (Exception ex) {System.err.println("打开数据库时出错: " + ex.getMessage());}}/**关闭数据库，将连接返还给连接池*/public void close(){try {// connMgr.freeConnection("java", conn);conn.close();System.out.println ("释放连接");}catch (SQLException ex) {System.err.println("返还连接池出错: " + ex.getMessage());}}/**执行查询*/public ResultSet executeQuery(String sql) throws SQLException{ResultSet rs = null;rs = stmt.executeQuery(sql);System.out.println ("执行查询");return rs;}/**执行增删改*/public int executeUpdate(String sql) throws SQLException { int ret = 0;ret = stmt.executeUpdate(sql);System.out.println ("执行增删改");return ret;}/**将SQL语句加入到批处理*/public void addBatch(String sql) throws SQLException { stmt.addBatch(sql);}/**执行批处理*/public int [] executeBatch() throws SQLException{boolean isAuto=conn.getAutoCommit();conn.setAutoCommit(false);int [] updateCounts = stmt.executeBatch();//mit();//conn.setAutoCommit(isAuto);//conn.setAutoCommit(true);return updateCounts;}public boolean getAutoCommit() throws SQLException{ return conn.getAutoCommit();}public void setAutoCommit(boolean auto) throws SQLException { conn.setAutoCommit(auto);}public void commit() throws SQLException {mit();// this.close();}public void rollBack() throws SQLException {conn.rollback();// this.close();}}2. Log.javapackage com.util;/*** 日志*/import java.io.BufferedWriter;import java.io.File;import java.io.FileNotFoundException;import java.io.FileWriter;import java.io.IOException;import java.io.PrintWriter;public class Log {public void addLog(String str){try {File file=new File("c://log.txt");FileWriter fw=new FileWriter(file,true);BufferedWriter bw=new BufferedWriter(fw);PrintWriter pw = new PrintWriter(bw);pw.write(str);bw.newLine();//断行bw.flush();//将数据更新至文件pw.close();fw.close();//关闭文件流} catch (FileNotFoundException e) {System.out.println("警告：日志文件没找到！！！！");e.printStackTrace();} catch (IOException e) {System.out.println("警告：日志文件IO错误！！！！");e.printStackTrace();}}}3. MD5.javapackage com.util;/***MD5密码加密类**/import java.security.*;import java.security.spec.*;public final class MD5 {public final static String MD5(String s){char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd','e', 'f'};try {byte[] strTemp = s.getBytes();MessageDigest mdTemp = MessageDigest.getInstance("MD5");mdTemp.update(strTemp);byte[] md = mdTemp.digest();int j = md.length;char str[] = new char[j * 2];int k = 0;for (int i = 0; i < j; i++) {byte byte0 = md[i];str[k++] = hexDigits[byte0 >>> 4 & 0xf];str[k++] = hexDigits[byte0 & 0xf];}return new String(str);}catch (Exception e){return null;}}}4. Common.javapackage com.util;/*** 常用方法类*/import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;public final class Common {////////////字符串HTML 转换public static String turn(String str) {while (str.indexOf("\n") != -1) {str = str.substring(0, str.indexOf("\n")) + "<br>"+ str.substring(str.indexOf("\n") + 1);}while (str.indexOf(" ") != -1) {str = str.substring(0, str.indexOf(" ")) + "&nbsp;"+ str.substring(str.indexOf(" ") + 1);}return str;}/////////////返回日期当前日期传入0 一年之前传入-1 三年后传入3 public static String getDate(int num){SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");Calendar c = Calendar.getInstance();c.add(Calendar.YEAR, num);return df.format(c.getTime());}/////////////数据库输出字符串的过滤public static String SQLStr(String str){if(str != null && str.length()>1 && str.substring(0,1).equals("?")){ str = str.substring(1);}if(str == null || str.equals("") || str.equals(" ")){str = "&nbsp;";}return str;}/////////////过滤空格public static String PageStr(String str){if(str==null || str.trim().equals("") || str.equals(" ")||str.equals("null")){ str = "";}str = str.trim();return str;}/////////////格式化日期public static String formatRZ(String oldDate){SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");Date Date = new Date(oldDate);return df.format(Date);}////////////汉化public static String toChineseAndTrim(String str){ if(str==null){str="";}try{byte b[]=str.getBytes("iso-8859-1");str=new String(b);str=str.trim();}catch(Exception e){e.printStackTrace();}return str;}}5. CheckCode.javapackage com.util;/*** 验证码生成类*/import java.util.Random;public class CheckCode {public String getCheckCode(){Random random = new Random();String sRand="";for (int i=0;i<4;i++){String rand=String.valueOf(random.nextInt(10));sRand+=rand;}return sRand;}}6. LoginServlet.javapackage com.action;/*** 前台会员登陆退出*/import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.bean.MemberBean;import com.util.Constant;import com.util.Filter;public class LoginServlet extends HttpServlet { /*** Constructor of the object.*/public LoginServlet() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType(Constant.CONTENTTYPE);request.setCharacterEncoding(Constant.CHARACTERENCODING);HttpSession session = request.getSession();MemberBean memberBean = new MemberBean();String method = Filter.escapeHTMLTags(request.getParameter("method").trim());if(method.equals("HEADUSERLOGIN")){//网页头部会员登陆String reg_user = Filter.escapeHTMLTags(request.getParameter("reg_user").trim());String reg_pwd = Filter.escapeHTMLTags(request.getParameter("reg_pwd").trim());String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim());String lastip = request.getRemoteAddr();int flag = memberBean.memberLogin(reg_user, reg_pwd, reg_type);if(flag == Constant.SUCCESS){//登陆成功String info = memberBean.getLastTimeIP(reg_user);int flag2 = memberBean.upmemberLogin(reg_user, lastip);if(flag2 == Constant.SUCCESS){session.setAttribute("member", reg_user);session.setAttribute("type", reg_type);session.setAttribute("info", info);request.getRequestDispatcher("login1.jsp").forward(request, response);}else{session.setAttribute("member", reg_user);session.setAttribute("type", reg_type);session.setAttribute("info", info);session.setAttribute("message", "登陆成功，登陆信息更新失败！");request.getRequestDispatcher("login1.jsp").forward(request, response);}}else if(flag == _ERROR){//用户名错误request.setAttribute("reg_user", reg_user);request.setAttribute("message", "该用户名不存在或者已被管理员冻结！");request.getRequestDispatcher("login1.jsp").forward(request, response);}else if(flag == Constant.PASSWORD_ERROR){//密码错误request.setAttribute("reg_user", reg_user);request.setAttribute("message", "密码错误！");request.getRequestDispatcher("login1.jsp").forward(request, response);}}else if(method.equals("PAGEUSERLOGIN")){//登陆页面会员登陆String username = Filter.escapeHTMLTags(request.getParameter("username").trim());String password = Filter.escapeHTMLTags(request.getParameter("password").trim());String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim());String lastip = request.getRemoteAddr();int flag = memberBean.memberLogin(username, password, reg_type);if(flag == Constant.SUCCESS){//登陆成功String info = memberBean.getLastTimeIP(username);int flag2 = memberBean.upmemberLogin(username, lastip);if(flag2 == Constant.SUCCESS){session.setAttribute("member", username);session.setAttribute("type", reg_type);session.setAttribute("info", info);request.getRequestDispatcher("member/index.jsp").forward(request, response);}else{session.setAttribute("member", username);session.setAttribute("type", reg_type);session.setAttribute("info", info);session.setAttribute("message", "登陆成功，登陆信息更新失败！");request.getRequestDispatcher("member/index.jsp").forward(request, response);}}else if(flag == _ERROR){//用户名错误request.setAttribute("reg_user", username);request.setAttribute("message", "该用户名不存在！");request.getRequestDispatcher("login.jsp").forward(request, response);}else if(flag == Constant.PASSWORD_ERROR){//密码错误request.setAttribute("reg_user", username);request.setAttribute("message", "密码错误！");request.getRequestDispatcher("login.jsp").forward(request, response);}}else if(method.equals("logout")){//从iframe页面退出登陆session.removeAttribute("member");session.removeAttribute("type");request.getRequestDispatcher("login1.jsp").forward(request, response);}else if(method.equals("pagelogout")||method.equals("memberexit")){//从网页退出登陆session.removeAttribute("member");session.removeAttribute("type");request.getRequestDispatcher("index.jsp").forward(request, response);}else{request.getRequestDispatcher("error.jsp").forward(request, response);}}public void init() throws ServletException {// Put your code here}}7. TrainBean.javapackage com.bean;import java.sql.ResultSet;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Calendar;import java.util.List;import com.util.Constant;import com.util.DBO;public class TrainBean {private List list;private ResultSet rs;private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());//车次//增加车次管理times 例如：沈阳-北京2510次时间：xx点xx分发车xx点xx 分到达软座硬座卧铺票价//增加车次管理train例如：id, train, num,stime, etime,soft,softprice,hard, hardprice, sleep, sleepprice, addtimepublic int addTrain(String train,String num,String stime,String etime,String sitetype,String price){String sql = "insert into train (train,num,stime,etime,sitetype,price,addtime) " + "values('"+train+"','"+num+"','"+stime+"','"+etime+"','"+sitetype+"','"+price+"','"+dat e+"')";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 修改public int upTrain(int id,String train,String num,String stime,String etime,Stringsitetype,String price){String sql = "update train set train='"+train+"',num='"+num+"',stime='"+stime+"',etime='"+etime+"',sitetype='"+sitety pe+"'," +"price='"+price+"' where id='"+id+"'";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 删除public int delTrain(int id){String sql = "delete from train where id='"+id+"'";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 所有public List getAllTrain(){String sql = "select * from train order by id desc ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){List list2=new ArrayList();list2.add(rs.getString(1));list2.add(rs.getString(2));list2.add(rs.getString(3));list2.add(rs.getString(4));list2.add(rs.getString(5));list2.add(rs.getString(6));list2.add(rs.getString(7));list2.add(rs.getString(8));list.add(list2);}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}}public List getTrain(String train){String sql = "select * from train where train like '%"+train+"%' order by id desc ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){List list2=new ArrayList();list2.add(rs.getString(1));list2.add(rs.getString(2));list2.add(rs.getString(3));list2.add(rs.getString(4));list2.add(rs.getString(5));list2.add(rs.getString(6));list2.add(rs.getString(7));list2.add(rs.getString(8));list.add(list2);}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}}public List getOneTrain(String id){String sql = "select * from train where id='"+id+"' ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){list.add(rs.getString(1));list.add(rs.getString(2));list.add(rs.getString(3));list.add(rs.getString(4));list.add(rs.getString(5));list.add(rs.getString(6));list.add(rs.getString(7));list.add(rs.getString(8));}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}}//订票管理// 增加车次管理times 例如：沈阳-北京2510次时间：xx点xx分发车xx点xx 分到达软座硬座卧铺票价flag:是送票pay:付款方式//增加车次管理train 例如：id,train,num,stime,etime,soft,softprice,hard,hardprice,sleep,sleepprice,addtime public int addPrep(String train,String num,String stime,String etime,String sitetype,String price,int numb,String pay,String member){String sql = "insert into prep (train,num,stime,etime,sitetype,price,numb,pay,member,addtime) " +"values('"+train+"','"+num+"','"+stime+"','"+etime+"','"+sitetype+"','"+price+"','"+nu mb+"','"+pay+"','"+member+"','"+date+"')";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 修改public int upPrep(int id,int numb,String pay){String sql = "update prep set numb='"+numb+"',pay='"+pay+"' where id='"+id+"'";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}//送票public int sendPrep(int id){String sql ="update prep set flag='已送票'";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 删除public int delPrep(int id){String sql = "delete from prep where id='"+id+"'";DBO dbo = new DBO();dbo.open();try{int i = dbo.executeUpdate(sql);if(i == 1)return Constant.SUCCESS;elsereturn Constant.SYSTEM_ERROR;}catch(Exception e){e.printStackTrace();return Constant.SYSTEM_ERROR;}finally{dbo.close();}}// 所有订票信息public List getAllPrep(){String sql = "select * from prep order by id desc ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){List list2=new ArrayList();list2.add(rs.getString(1));list2.add(rs.getString(2));list2.add(rs.getString(3));list2.add(rs.getString(4));list2.add(rs.getString(5));list2.add(rs.getString(6));list2.add(rs.getString(7));list2.add(rs.getString(8));list2.add(rs.getString(9));list2.add(rs.getString(10));list2.add(rs.getString(11));list.add(list2);}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}}public List getOnePrep(String id){String sql = "select * from prep where id='"+id+"' ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){list.add(rs.getString(1));list.add(rs.getString(2));list.add(rs.getString(3));list.add(rs.getString(4));list.add(rs.getString(5));list.add(rs.getString(6));list.add(rs.getString(7));list.add(rs.getString(8));list.add(rs.getString(9));list.add(rs.getString(10));list.add(rs.getString(11));}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}public List getPrep(String member){String sql = "select * from prep where member='"+member+"' ";DBO dbo=new DBO();list = new ArrayList();dbo.open();try{rs = dbo.executeQuery(sql);while(rs.next()){List list2=new ArrayList();list2.add(rs.getString(1));list2.add(rs.getString(2));list2.add(rs.getString(3));list2.add(rs.getString(4));list2.add(rs.getString(5));list2.add(rs.getString(6));list2.add(rs.getString(7));list2.add(rs.getString(8));list2.add(rs.getString(9));list2.add(rs.getString(10));list2.add(rs.getString(11));list.add(list2);}return list;}catch(Exception e){e.printStackTrace();return null;}finally{dbo.close();}}第二部分外部显示代码1. index.jsp<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312" %><%@ include file="iframe/head.jsp" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/1999/REC-html401-19991224/loose.dtd"><HTML xmlns="/1999/xhtml"><HEAD><LINK href="images/default.css" type=text/css rel=stylesheet><LINK href="images/css.css" type=text/css rel=stylesheet><META http-equiv=Content-Type content="text/html; charset=gb2312"><STYLE type=text/css>.ycbt {BORDER-RIGHT: #fff 1px solid; BORDER-TOP: #fff 1px solid; PADDING-LEFT: 1.8em; BACKGROUND-COLOR: #EAF2EF; BORDER-LEFT: #fff 1px solid; PADDING-TOP: 7px; BORDER-BOTTOM: #fff 1px solid; HEIGHT: 20px}.xsbt {BORDER-RIGHT: #fff 1px solid; BORDER-TOP: #fff 1px solid; PADDING-LEFT: 1.8em; BACKGROUND-IMAGE: url(images/head1.gif); BORDER-LEFT: #fff 1px solid; PADDING-TOP: 7px; BORDER-BOTTOM: #fff 1px solid; HEIGHT: 20px}.xsnr {DISPLAY: block}.ycnr {DISPLAY: none}</STYLE><SCRIPT type=text/javascript>function tb_xs(t,m,n){for(var i=1;i<=m;i++){if (i != n){document.getElementById("tb"+t+ "_bt" + i).className= "ycbt"; document.getElementById("tb"+t+ "_nr" + i).className= "ycnr";}else{document.getElementById("tb"+t+ "_bt" + i).className= "xsbt"; document.getElementById("tb"+t+ "_nr" + i).className= "xsnr";}}}</SCRIPT><SCRIPT language=JavaScript><!--//屏蔽出错代码function killErr(){return true;}window.onerror=killErr;//--></SCRIPT><SCRIPT language=JavaScript><!--//处理大分类一行两个小分类function autoTable(div){fs=document.getElementById(div).getElementsByTagName("TABLE");for(var i=0;i<fs.length;i++){fs[i].style.width='49.5%';if(i%2==1){if (document.all) {fs[i].style.styleFloat="right";}else{fs[i].style.cssFloat="right;";}}else{if (document.all) {fs[i].style.styleFloat="left";}else{fs[i].style.cssFloat="left;";}}}}//--></SCRIPT><SCRIPT language=JavaScript src="images/inc.js"></SCRIPT><SCRIPT language=JavaScript src="images/default.js"></SCRIPT><SCRIPT language=JavaScript src="images/swfobject.js"></SCRIPT><META content="MSHTML 6.00.2900.3268" name=GENERATOR></HEAD><%String message = (String)request.getAttribute("message");if(message == null){message = "";}if (!message.trim().equals("")){out.println("<script language='javascript'>");out.println("alert('"+message+"');");out.println("</script>");}request.removeAttribute("message");%><BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0><SCRIPT language=JavaScript><!--//目的是为了做风格方便document.write('<div class="wrap">');//--></SCRIPT><TABLE height=300 class=MainTable cellSpacing=0 cellPadding=0 width="100%"align=center border=0><TBODY><TR><TD align=center><br><br><br><br><br><h1>欢迎使用火车票网上预定系统</h1></TD></TR></TBODY></TABLE><SCRIPT language=JavaScript><!--//目的是为了做风格方便document.write('</div>');//--></SCRIPT><SCRIPT language=JavaScript><!--clickEdit.init();//--></SCRIPT></BODY></HTML><%@ include file="iframe/foot.jsp"%>2. login.jsp<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312" %><%@ include file="../../iframe/head.jsp" %><jsp:useBean id="code" scope="page" class="com.util.CheckCode" /><SCRIPT language=javascript>//检验表单的合法性function checklogin() {if (ername.value.replace(/\s+$|^\s+/g,"").length<=0) {alert("\请输入您的用户名！");ername.focus();}else if (document.form1.password.value.replace(/\s+$|^\s+/g,"").length<=0) { alert("\请输入您的密码！");document.form1.password.focus();}else if(document.form1.checkcode.value.replace(/\s+$|^\s+/g,"").length<=0) { alert("\请输入验证码！");document.form1.checkcode.focus();}else if (document.form1.checkcode.value != document.form1.yzm.value) { alert("\验证码错误！");document.form1.checkcode.focus();}else{form1.submit();}}</SCRIPT><%String message = (String)request.getAttribute("message");if(message == null){message = "";}if (!message.trim().equals("")){out.println("<script language='javascript'>");out.println("alert('"+message+"');");out.println("</script>");}request.removeAttribute("message");String yzm=code.getCheckCode();%><FORM id=form1 name = form1 action = <%=basePath %> Login.shtml? method = PAGEUSERLOGIN method=post><TABLE width=600 border=0 align="center" id=Table7><TBODY><TR height=40><TD vAlign=center align=middle colSpan=3><FONT face=宋体></FONT><BR><FONT color=#ff7700><STRONG>欢迎登陆<%=sysList.get(0).toString() %></STRONG></FONT></TD></TR><TR><TD colSpan=3><HR class=hui align=center width="98%" SIZE=1></TD></TR><TR height=60><TD align=right width=84 height=110></TD><TD noWrap align=middle width=171><TABLE width="100%" border=0><TBODY><TR><TD width="35%" height=24>用户名：</TD><TD><INPUT class=input_new id=username style="WIDTH: 110px" size=15 maxLength=10 name =username onbeforepaste= "clipboardData.setData ('text',clipboardData.getData('text').replace(/[^\d]/g,''))"onkeyup="value=value.replace(/[\W]/g,'')"value=<%=request.getAttribute("reg_user")==null?"":request.getAttribute("reg_user") %>></TD></TR><TR>。