1 package org.lxh.mvcdemo.dao.impl;
2
3 import java.sql.Connection;
4 import java.sql.PreparedStatement;
5 import java.sql.ResultSet;
6
7 import org.lxh.mvcdemo.dao.IUserDAO;
8 import org.lxh.mvcdemo.vo.User;
9
10 public class UserDAOImpl implements IUserDAO{
11 private Connection conn = null;
12 private PreparedStatement pstmt = null;
13 public UserDAOImpl(Connection conn){
14 this.conn = conn;
15 }
16
17 public boolean findLogin(User user) throws Exception {
18 boolean flag = false;
19 try{
20 String sql = "SELECT name FROM user WHERE userid=? AND password=?";
21 this.pstmt = this.conn.prepareStatement(sql);
22 this.pstmt.setString(1, user.getUserid());
23 this.pstmt.setString(2, user.getPassword());
24 ResultSet rs = this.pstmt.executeQuery();
25 if(rs.next()){
26 user.setName(rs.getString(1));
27 flag = true;
28 }
29 }catch(Exception e){
30 throw e;
31 }finally{
32 if(this.pstmt != null){
33 try{
34 this.pstmt.close();
35 }catch(Exception e){
36 throw e;
37 }
38 }
39 }
40 return flag;
41 }
42
43 public boolean resetPassword(String password) throws Exception {
44
45 boolean flag01 = true;
46 String sql = "update user set password='jjjj' where userid='admin'";
47 this.pstmt = this.conn.prepareStatement(sql);
48 if(this.pstmt.executeUpdate()>0){
49 flag01 = true;
50 }
51 this.pstmt.close();
52 return flag01;
53 }
54 }