login登陆页面java

package com.etc.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.etc.dao.DBConnectionFactory; import com.etc.model.User; public class UserDaoImpl { Connection conn = DBConnectionFactory.getConnection(); public User getUserByUname(String uname) { User u = null; String sql = "select * from users where username=?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, uname); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { u = new User(rs.getString(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5), rs.getString(6)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return u; } public void insert(User user) { String sql = "insert into users values(?,?,?,?,?,?)"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, user.getUsername()); pstmt.setString(2, user.getPassword()); pstmt.setString(3, user.getSex()); pstmt.setInt(4, user.getAge()); pstmt.setString(5, user.getAddress()); pstmt.setString(6, user.getPhone()); pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public User getUserByUnamePwd(String uname, String upwd) { User u = null; String sql = "select * from users where username=? and password = ?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, uname); pstmt.setString(2, upwd); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { u = new User(rs.getString(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5), rs.getString(6)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return u; } }