DAO是Data Access Object数据访问接口。
数据访问:顾名思义就是与数据库打交道。夹在业务逻辑与数据库资源中间。 在核心J2EE模式中是这样介绍DAO模式的:为了建立一个健壮的J2EE应用,应该将所有对数据源的访问操作抽象封装在一个公共API中。
用程序设计的语言来说,就是建立一个接口,接口中定义了此应用程序中将会用到的所有事务方法。在这个应用程序中,当需要和数据源进行交互的时候则使用这个接口,并且编写一个单独的类来实现这个接口在逻辑上对应这个特定的数据存储。
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import util.JDBCUtils;
public class UserDao {
//声明JDBCTemplate对象公用
private JdbcTemplate template =new JdbcTemplate(JDBCUtils.getDataSource());
/**
* 登陆方法
* @param loginUser
* @return student 包含用户登陆数据
*/
public User login(User loginUser){
try {
//1.编写sql
String sql ="select * from student where username = ? and password = ?";
//2.调用query
System.out.println(loginUser.getUsername());
User user = template.queryForObject(sql,
new BeanPropertyRowMapper<User>(User.class),
loginUser.getUsername(), loginUser.getPassword());
System.out.println(user.getUsername());
return user;
}catch (DataAccessException e){
e.printStackTrace();
return null;
}
// RowMapper<User> rowMapper=new BeanPropertyRowMapper<User>(User.class);
// User user= template.queryForObject(sql, rowMapper,loginUser.getUsernamae(),loginUser.getPassword());
}
}
User user = template.queryForObject(sql,
new BeanPropertyRowMapper<User>(User.class),
loginUser.getUsername(), loginUser.getPassword());
返回User对象
package servlet;
import domain.User;
import domain.UserDao;
import org.apache.commons.beanutils.BeanUtils;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;
@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// System.out.println("ok1");
//1.设置编码
request.setCharacterEncoding("utf-8");
//2.获取请求参数
// String username = request.getParameter("username");
// String password = request.getParameter("password");
// //3.封装user对象
// User loginUser = new User();
// loginUser.setUsername(username);
// loginUser.setPassword(password);
//
// InsuranceInfo info = new InsuranceInfo();
//2.获取所有请求参数
// Map<String, String[]> map = request.getParameterMap();
//3创建User对象
User loginUser = new User();
//3.2使用BeanUtils封装
try {
BeanUtils.populate(loginUser,request.getParameterMap());//注意是apeach下的beans,有两个beans
System.out.println(loginUser);
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
//4.调用UserDao对象
UserDao dao = new UserDao();
User user = dao.login(loginUser);
System.out.println(user);
//5.判断user
if(user==null){
//登陆失败
request.getRequestDispatcher("/failServlet").forward(request,response);
}else{
//登陆成功
//储存数据
request.setAttribute("user",user);
//转发
request.getRequestDispatcher("/successlServlet").forward(request,response);
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request,response);
}
}