struts1实现用户登录注册

package com.routon.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.routon.struts.form.LoginForm; import com.routon.struts.form.RegisterForm; public class UserDao { private Connection conn = null; private PreparedStatement ps = null; private ResultSet rs = null; public void save(String username, String password, int age, String sex) { // 增加用户 conn = Conn.getConnection(); System.out.println("UserDao24"); String insert = "insert into userbook(username,password,age,sex) values(?,?,?,?)"; System.out.println("UserDao26"); System.out.println(username+password+age+sex); try { ps = conn.prepareStatement(insert); ps.setString(1, username); ps.setString(2, password); ps.setInt(3, age); ps.setString(4, sex); ps.execute(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { Conn.clear(conn, ps, rs); } } /** *检测用户是否存在 * * @param username * @return */ public boolean usernameIsExit(String username) { boolean flag = false; System.out.println("UserDao49"); conn = Conn.getConnection(); System.out.println("UserDao51"); String sql = "select username from userbook where username =?"; try { ps = conn.prepareStatement(sql); ps.setString(1, username); rs = ps.executeQuery(); if (rs.next()) { flag = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } /** * 根据用户名获得密码 * * @param username * @return */ public String getpasswordByUsername(String username) { String password = null; conn = Conn.getConnection(); String sql = "select * from userbook where username =?"; try { ps = conn.prepareStatement(sql); ps.setString(1, username); rs = ps.executeQuery(); if (rs.next()) { // System.out.println(rs.getString("username")); password = rs.getString("password"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return password; } /** * */ public List getAllUser() { conn = Conn.getConnection(); String sql = "select * from userbook"; List userList = null; try { userList = new ArrayList(); ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { RegisterForm registerForm = new RegisterForm(); registerForm.setUsername(rs.getString("username")); registerForm.setPassword(rs.getString("password")); registerForm.setSex(rs.getString("sex")); registerForm.setAge(rs.getInt("age")); userList.add(registerForm); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return userList; } public void deleteUserByUsername(String username) { conn = Conn.getConnection(); String sql = "delete from userbook where username=?"; try { ps = conn.prepareStatement(sql); ps.setString(1, username); ps.execute(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }