以JavaWeb实现订票.docx

JavaWeb附录一 数据库展示User数据库Plane数据库Book数据库二 代码展示数据库User部分package user;public class UserVO private String username; /用户注册姓名private String usertruename; /用户真实姓名private String userpass; /登录密码private String usergender; /性别private String userIDCard; /用户身份证号private String userphonenum; /用户电话号码private String useremail; /电子邮件public String getUserpass() return userpass;public void setUserpass(String userpass) this.userpass = userpass;public String getUsername() return username;public void setUsername(String username) this.username = username;public String getUsertruename() return usertruename;public void setUsertruename(String usertruename) this.usertruename = usertruename;public String getUserIDCard() return userIDCard;public void setUserIDCard(String userIDCard) this.userIDCard = userIDCard;public String getUserphonenum() return userphonenum;public void setUserphonenum(String userphonenum) this.userphonenum = userphonenum;public String getUsergender() return usergender;public void setUsergender(String usergender) this.usergender = usergender;public String getUseremail() return useremail;public void setUseremail(String useremail) this.useremail = useremail;package user;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;public class userAction String sDbDriver = sun.jdbc.odbc.JdbcOdbcDriver;String sConneStr = jdbc:odbc:user;Connection con;private UserVO use;public UserVO getUse() return use;public void setUse(UserVO use) this.use = use;public userAction()tryClass.forName(sDbDriver); /加载驱动程序con = DriverManager.getConnection(sConneStr); /数据库连接catch(Exception e)System.err.print(e.getMessage();public Connection getConn() throws SQLExceptionreturn DriverManager.getConnection(sConneStr);/查询所有用户public ArrayList getAllUsers()ArrayList users = new ArrayList();tryStatement stm = con.createStatement(); /获得statement对象ResultSet result = stm.executeQuery(select * from user); /利用statement对象查询结果while(result.next()String username = result.getString(用户名);String usertruename = result.getString(真实姓名);String userpass = result.getString(密码);String usergender = result.getString(性别);String userIDCard = result.getString(用户身份证号);String userphonenum = result.getString(用户电话号码);String useremail = result.getString(电子邮件);UserVO user = new UserVO();user.setUsername(username);user.setUsertruename(usertruename);user.setUserpass(userpass);user.setUsergender(usergender);user.setUserIDCard(userIDCard);user.setUserphonenum(userphonenum);user.setUseremail(useremail);users.add(user);result.close();stm.close();/con.close();catch(Exception e)return users;/增加用户public void addUsers()tryPreparedStatement pstmt = getConn().prepareStatement(insert into user values(?,?,?,?,?,?,?);pstmt.setString(1, use.getUsername();pstmt.setString(2, use.getUsertruename();pstmt.setString(3, use.getUserpass();pstmt.setString(4, use.getUsergender();pstmt.setString(5, use.getUserIDCard();pstmt.setString(6, use.getUserphonenum();pstmt.setString(7, use.getUseremail();trypstmt.executeUpdate();catch(Exception e)System.out.println(插入出错了！);con.close();catch(Exception e)e.printStackTrace();/修改用户信息public void updateUsers(String username,String modify,String content)/tryPreparedStatement stm = null;if(modify.equals(电话号码)stm = getConn().prepareStatement(update user set 用户电话号码= +content+ where 用户名= +username+);else if(modify.equals(密码)stm = getConn().prepareStatement(update user set 密码 = +content+ where 用户名 = +username+);else if(modify.equals(电子邮件)stm = getConn().prepareStatement(update user set 电子邮件 = +content+ where 用户名 = +username+);stm.executeUpdate();con.close();stm.close();catch(Exception e)e.printStackTrace();数据库plane部分package plane;public class PlaneVO private String planeID; /航班IDprivate String planefrom; /出发地private String planeto; /目的地private String planestarttime;/起始时间private String planeflytime; /飞行时间private int planeprice; /机票价格private int planeinsurrance; /飞机保险public String getPlaneID() return planeID;public void setPlaneID(String planeID) this.planeID = planeID;public String getPlanefrom() return planefrom;public void setPlanefrom(String planefrom) this.planefrom = planefrom;public String getPlaneto() return planeto;public void setPlaneto(String planeto) this.planeto = planeto;public String getPlanestarttime() return planestarttime;public void setPlanestarttime(String planestarttime) this.planestarttime = planestarttime;public String getPlaneflytime() return planeflytime;public void setPlaneflytime(String planeflytime) this.planeflytime = planeflytime;public int getPlaneprice() return planeprice;public void setPlaneprice(int planeprice) this.planeprice = planeprice;public int getPlaneinsurrance() return planeinsurrance;public void setPlaneinsurrance(int planeinsurrance) this.planeinsurrance = planeinsurrance;package plane;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;public class planeAction String sDBDriver = sun.jdbc.odbc.JdbcOdbcDriver;String sConnestr = jdbc:odbc:plane;Connection con;private PlaneVO plan;public PlaneVO getPlan() return plan;public void setPlan(PlaneVO plan) this.plan = plan;public planeAction()tryClass.forName(sDBDriver);con = DriverManager.getConnection(sConnestr);catch(Exception e)System.err.print(e.getMessage();/查询所有航班public ArrayList getAllplanes()ArrayList planes = new ArrayList();tryStatement stm = con.createStatement();ResultSet result = stm.executeQuery(select * from plane);while(result.next()String planeID = result.getString(航班ID);String planefrom = result.getString(出发地);String planeto = result.getString(目的地);String planestarttime = result.getString(出发时间);String planeflytime = result.getString(运行时间);int planeprice = result.getInt(价格);int planeinsurrance = result.getInt(保险);PlaneVO plane = new PlaneVO();plane.setPlaneID(planeID);plane.setPlanefrom(planefrom);plane.setPlaneto(planeto);plane.setPlanestarttime(planestarttime);plane.setPlaneflytime(planeflytime);plane.setPlaneprice(planeprice);plane.setPlaneinsurrance(planeinsurrance);planes.add(plane);result.close();stm.close();con.close();catch(Exception e)e.printStackTrace();return planes;数据库book部分package book;public class BookVO private String username; /用户IDprivate String planeID; /航班IDprivate int ordernum; /票数private int orderprice; /价格private String insurrance;/保险public String getUsername() return username;public void setUsername(String username) this.username = username;public String getPlaneID() return planeID;public void setPlaneID(String planeID) this.planeID = planeID;public int getOrdernum() return ordernum;public void setOrdernum(int ordernum) this.ordernum = ordernum;public int getOrderprice() return orderprice;public void setOrderprice(int orderprice) this.orderprice = orderprice;public String getInsurrance() return insurrance;public void setInsurrance(String insurrance) this.insurrance = insurrance;package book;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;public class bookAction String sDBDriver = sun.jdbc.odbc.JdbcOdbcDriver;String sConnestr = jdbc:odbc:book;Connection con;private BookVO ord;public BookVO getOrd() return ord;public void setOrd(BookVO ord) this.ord = ord;public bookAction()tryClass.forName(sDBDriver);con = DriverManager.getConnection(sConnestr);catch(Exception e)System.err.print(e.getMessage();/查询所有订单public ArrayList getAllorders()ArrayList orders = new ArrayList();tryStatement stm = con.createStatement();ResultSet result = stm.executeQuery(select * from book );while(result.next()String username = result.getString(用户名);String planeID = result.getString(航班ID);int ordernum = result.getInt(票数);int orderprice = result.getInt(价格);String insurrance = result.getString(保险);BookVO order = new BookVO();order.setUsername(username);order.setPlaneID(planeID);order.setOrdernum(ordernum);order.setOrderprice(orderprice);order.setInsurrance(insurrance);orders.add(order);result.close();stm.close();/con.close();catch(Exception e)e.printStackTrace();return orders;/查询某一乘客的订单public ArrayList getOneorders(String name)ArrayList orders = new ArrayList();tryStatement stm = con.createStatement();ResultSet result = stm.executeQuery(select * from book where 用户ID=+name);while(result.next()String username = result.getString(用户名);String planeID = result.getString(航班ID);int ordernum = result.getInt(票数);int orderprice = result.getInt(价格);String insurrance = result.getString(保险);BookVO order = new BookVO();order.setUsername(username);order.setPlaneID(planeID);order.setOrdernum(ordernum);order.setOrderprice(orderprice);order.setInsurrance(insurrance);orders.add(order);result.close();stm.close();/con.close();catch(Exception e)e.printStackTrace();return orders;/删除订单public void deleteorder(String name,String planeid)tryStatement stm = con.createStatement();stm.executeUpdate(delete from book where 航班id=+planeid+);/用户名=+name+catch(Exception e)e.printStackTrace();/增加订单public void addorders()tryPreparedStatement pstmt = con.prepareStatement(insert into book values(?,?,?,?,?);pstmt.setString(1, ord.getUsername();pstmt.setString(2, ord.getPlaneID();pstmt.setInt(3, ord.getOrdernum();pstmt.setInt(4, ord.getOrderprice();pstmt.setString(5, ord.getInsurrance();trypstmt.executeUpdate();catch(Exception e)e.printStackTrace();System.out.println(插入出错了！);/con.close();catch(Exception e)e.printStackTrace();/更新订单public void updateorders(String planeid,int ordernum)tryStatement stm=con.createStatement();stm.executeUpdate(update book set 票数=+ordernum+ where 航班ID=+planeid+);/con.close();stm.close();catch(Exception e)e.printStackTrace();JSP页面部分登陆界面 欢迎登陆航班预订系统 请输入用户名: 请输入密码:        已注册用户请直接登陆 无注册用户请注册后登陆 处理登陆界面% String username = request.getParameter(username); session.setAttribute(username, username); String userpass = request.getParameter(userpass); session.setAttribute(userpass, userpass); int count=0; ArrayList users =user.getAllUsers(); out.print(users.size(); for(int i=0;i 返回登陆界面 注册界面会员注册 用户名:     (不能为空) 用户真名:     (请使用用户真实姓名) 密码:       (之多含有6个a-z,或A-Z,或 0-9的组合，不能为空) 再次输入密码:       (与上面密码值一致) 性别: 男    女    请输入身份证号:     (只能包含数字，不能为空) 请输入联系电话:     (只能包含数字，不能为空) 请输入电子邮件:     (不能为空) 阅读航班预订系统网络服务协议 本服务协议内容包括协议正文及所有航班预定系统已经发布的或将来可能发布的各类规则。所有规则为协议不可分割的一部分，与协议正文具有同等法律效力。 在本服务协议中没有以规则字样表示的链接文字所指示的文件不属于本服务