java调用druid_使用Druid连接池实现用户的登录

使用Druid连接池实现用户登录：

工程结构：

dao：UserDao

package cn.itcast.dao;

import cn.itcast.domain.User;

import cn.itcast.util.JDBCUtils;

import org.springframework.dao.DataAccessException;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;

/**

* 操作数据库中User表的类

*/

public class UserDao {

//声明JDBCTemplate对象共用

private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

/**

* 登录方法

*

* @param loginUser 只有用户名和密码

* @return user 包含用户全部数据

*/

public User login(User loginUser) {

try {

//1. 编写sql

String sql = "select * from user where username = ? and password = ? ";

//2.执行

User user = template.queryForObject(sql, new BeanPropertyRowMapper(User.class),

loginUser.getUsername(), loginUser.getPassword());

return user;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}

}

domain : User

package cn.itcast.domain;

public class User {

private Integer id; //用户id

private String username; //账号

private String password; //密码

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {