实现dao模块
1、 编写实体类
2、 在配置文件中bean.xml添加配置信息。
3、 添加数据库驱动jar包
4、 编写dao类
5、 将jdbcTemplate注入到dao中即配置bean.xml
6、 编写测试类
public class AdminUser {
private int uid;
private String username;
private String password;
public AdminUser() {
}
public AdminUser(int uid, String username, String password) {
this.uid = uid;
this.username = username;
this.password = password;
}
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "AdminUser{" + "uid=" + uid + ", username=" + username + ", password=" + password + '}';
}
}
添加配置
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://node1:3306/temp" />
<property name="username" value="hive" />
<property name="password" value="hive" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
DAO类
public class AdminUserDAO {
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public AdminUser findAdminUserNameAndPassword(String username, String password) {
AdminUser adminUser = null;
String sql = "select uid, username, password from adminuser where username = ? and password = ?";
Object[] obs = new Object[]{username, password};
List<Map<String, Object>> list = jdbcTemplate.queryForList(sql, obs);
if(!list.isEmpty()) {
Map<String, Object> map = list.get(0);
adminUser= new AdminUser((Integer)map.get("uid"), username, password);
}
return adminUser;
}
}
添加配置
<bean id="adminUserDAO" class="dao.AdminUserDAO">
<property name="jdbcTemplate" ref="jdbcTemplate" />
</bean>
测试类
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext("/config/beans.xml");
AdminUserDAO adminUserDAO = (AdminUserDAO)context.getBean("adminUserDAO");
AdminUser user = adminUserDAO.findAdminUserNameAndPassword("q", "123");
System.out.println(user);
}
结果
AdminUser{uid=1, username=xiaoming, password=123}