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

《代码：火车票预订系统的设计与实现.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、目录第一部分功能代码-1-1.DBO.java-1-2.Log.java-4-3.MD5.java-5-4.Common.java-6-5.CheckCode.java-8-6.LoginServlet.java-9-7.TrainBean.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.javapackagecom.util;importjava.sql.*;importjava.sql.DriverManager;

2、importjava.sql.ResultSet;importjava.sql.SQLException;importjavax.activation.DataSource;importjava.sql.*;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.naming.Context;importjavax.naming.InitialContext;publicclassDBO{privateConnec

3、tionconn;privateStatementstmt;privateDataSourceds;publicDBO(){}/**打开数据库*/publicvoidopen(){try{Class.forName("org.gjt.mm.mysql.Driver");conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/cpyd?user=root&password=siming&useUnicode=true&characterEncoding=GBK");stmt=conn.createStatement();Syst

4、em.out.println("打开数据库连接");}catch(Exceptionex){System.err.println("打开数据库时出错:"+ex.getMessage());}}/**关闭数据库，将连接返还给连接池*/publicvoidclose(){try{//connMgr.freeConnection("java",conn);conn.close();System.out.println("释放连接");}catch(SQLExceptionex){System.err.println("返还连接池出错:"+ex.getMessage());}}/**执行查询*/pub

5、licResultSetexecuteQuery(Stringsql)throwsSQLException{ResultSetrs=null;rs=stmt.executeQuery(sql);System.out.println("执行查询");returnrs;}/**执行增删改*/publicintexecuteUpdate(Stringsql)throwsSQLException{intret=0;ret=stmt.executeUpdate(sql);System.out.println("执行增删改");returnret;}/**将SQL语句加入到批处理*/publicvoida

6、ddBatch(Stringsql)throwsSQLException{stmt.addBatch(sql);}/**执行批处理*/publicint[]executeBatch()throwsSQLException{booleanisAuto=conn.getAutoCommit();conn.setAutoCommit(false);int[]updateCounts=stmt.executeBatch();//conn.commit();//conn.setAutoCommit(isAuto);//conn.setAutoCommit(true);returnupdateCounts

7、;}publicbooleangetAutoCommit()throwsSQLException{returnconn.getAutoCommit();}publicvoidsetAutoCommit(booleanauto)throwsSQLException{conn.setAutoCommit(auto);}publicvoidcommit()throwsSQLException{conn.