example.zip

package dao; import java.sql.*; import domain.user; import utils.JDBCUtils; public class userDao { public static boolean addUser(user user) throws SQLException { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { //获取连接 conn = JDBCUtils.getConnection(); // 获取statement对象 stmt = conn.createStatement(); // SQL语句 String sql = "INSERT INTO users(id,name,password,email,gender,telephone,role,state) "+ "VALUES(" + user.getId() + ",'" + user.getUsername() + "','" + user.getPassword() + "','" + user.getEmail() + "','" + user.getGender() + "','" + user.getTelephone() + "','" + user.getRole() + "','" + user.getState() + "')"; int num = stmt.executeUpdate(sql); if (num > 0) { return true; } return false; } catch (Exception e) { e.printStackTrace(); } finally { JDBCUtils.release(rs, stmt, conn); } return false; } public static user findUserByUsernameAndPassword(String username, String password) { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { // 获取连接 conn = JDBCUtils.getConnection(); // 获取statement对象 stmt = conn.createStatement(); String sql = "SELECT * FROM users WHERE username='" + username+"' and password='"+password+"';"; System.out.println(sql); rs = stmt.executeQuery(sql); while (rs.next()) { user user = new user(); user.setId(rs.getInt("id")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setEmail(rs.getString("email")); user.setGender(rs.getString("gender")); user.setTelephone(rs.getString("telephone")); user.setRole(rs.getString("role")); user.setState(rs.getInt("state")); return user; } return null; } catch (Exception e) { e.printStackTrace(); } finally { JDBCUtils.release(rs, stmt, conn); } return null; } }