eclipse + MySQL+struts 实现登录注册

package struts2.com; import java.io.PrintStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Map; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; public class RegisterAction extends ActionSupport { private String username = null; private String password = null; private String password2 = null; private Integer age = 0; private String sex = null; ActionContext context; private Connection conn = null; @Override public String execute() throws Exception { context = ActionContext.getContext(); Map<String, Object> session = context.getSession(); if(ExistUser(username)) { session.put("message", "该用户已存在"); return "failed"; } if(AddUser(username, password, age, sex) == true) return "success"; else return "failed"; } private boolean AddUser(String username, String password, Integer age, String sex) { // TODO Auto-generated method stub try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookStore","root","MySQL"); System.out.println("连接成功"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } Statement sta = null; if(conn == null) System.out.append("未连接"); try { sta = conn.createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { int result = sta.executeUpdate("insert into user (username,password,age,sex) values ('"+username+"','"+password+"',"+age+",'"+sex+"')"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(conn != null) { try { conn.close(); System.out.println("断开连接"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return true; } private boolean ExistUser(String username) { // TODO Auto-generated method stub try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookStore","root","MySQL"); System.out.println("已连接"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } Statement sta = null; if(conn == null) System.out.append("数据库未连接"); try { sta = conn.createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } ResultSet result = null; try { result = sta.executeQuery("select * from user where username='"+username+"'"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if(result.next()) { return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(conn != null) { try { conn.close(); System.out.println("断开连接"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return false; } public RegisterAction() { // TODO Auto-generated constructor stub } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getPassword2() { return password2; } public void setPassword2(String password2) { this.password2 = password2; } public Integer getAge() { return age; } public void setAge(String age) { this.age = Integer.parseInt(age); if(this.age < 0) this.age = 0; if(this.age>100) this.age = 100; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } }