以JavaWeb实现订票.docx

JavaWeb附录数据库展示User数据库Plane数据库Book数据库代码展示数据库User部分package user;publicclass 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() {returnuserpass;}publicvoid setUserpass(String userpass) {this.userpass = userpass;}public String getUsername() {returnusername;}publicvoid setUsername(String username) {this.username = username;}public String getUsertruename() {returnusertruename;}publicvoid setUsertruename(String usertruename) {this.usertruename = usertruename;}public String getUserIDCard() {returnuserIDCard;}publicvoid setUserIDCard(String userIDCard) {this.userIDCard = userIDCard;}public String getUserphonenum() {returnuserphonenum;}publicvoid setUserphonenum(String userphonenum) {this.userphonenum = userphonenum;}public String getUsergender() {returnusergender;}publicvoid setUsergender(String usergender) {this.usergender = usergender;}public String getUseremail() {returnuseremail;}publicvoid 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(){try{Class.forName(sDbDriver); //加载驱动程序con = DriverManager.getConnection(sConneStr); //数据库连接}catch(Exception e){System.err.print(e.getMessage());}}public Connection getConn() throws SQLException{return DriverManager.getConnection(sConneStr);}//查询所有用户public ArrayListUserVO getAllUsers(){ArrayListUserVO users = new ArrayListUserVO();try{Statement stm = con.creat