使用jsp+servlet+dao 设计模式
接口:UserDao.java
public interface UserDao {
public boolean getUser(User user);
public void changePassword(User user,int id);
}
接口的实现:UserDaoJdbcImpl.java
public class UserDaoJdbcImpl implements UserDao {
@Override
public boolean getUser(User user) {
boolean flag = false;
List list=null;
String sql="select id,username,password from users where username=? and password=?";
String params[] = { user.getUsername(),user.getPassword()};
try {
QueryRunner qr = Dbc.getQueryRunner();
list = (List) qr.query(sql, new BeanListHandler(User.class),params);
if(list.size()>0){
flag=true;
user = (User) list.get(0);
}
} catch (SQLException e) {
throw new DaoException(e.getMessage(), e);
}
return flag;
}
@Override
public void changePassword(User u,int id) {
String sql="update users set password=? where id="+id;
try {
System.out.println("id是"+id);
System.out.println(u.getPassword());
QueryRunner qr = Dbc.getQueryRunner();
qr.update(sql, u.getPassword());
System.out.println("555555");
} catch (SQLException e) {
throw new DaoException(e.getMessage(), e);
}
}
}