![dfaf45c85f93d5fe722aa2b101291fc7.png](https://i-blog.csdnimg.cn/blog_migrate/61d99e29f5a1e68aa98bb93a06118d18.jpeg)
web.xml:(web.xml)
contextConfigLocationclasspath:spring.xml,classpath:spring-mybatis.xml,classpath:spring-shiro.xml
mybatis.xml:(spring-mybatis.xml)
<?xml version="1.0" encoding="UTF-8"?>
UserDao.java
@Repositorypublic class UserDao { public User findUserByLoginName(String loginName) { String sql = "select * from user where loginName = :loginName"; User user = new User(); user.setLoginName(loginName); //user.setPassWord(passWord); SqlParameterSource parameterSource = new BeanPropertySqlParameterSource(user); BeanPropertyRowMapper rowMapper = new BeanPropertyRowMapper(User.class); new JDBCMySql(); NamedParameterJdbcTemplate namedParameterJdbcTemplate = JDBCMySql.namedParameterJdbcTemplate; try { user = namedParameterJdbcTemplate.queryForObject(sql,parameterSource,rowMapper); } catch (DataAccessException e) { return null; } return user; }}
JDBCMySql.java
public class JDBCMySql { private static ApplicationContext ctx = null; public static NamedParameterJdbcTemplate namedParameterJdbcTemplate; { try { if (ctx == null) { ctx = new ClassPathXmlApplicationContext("spring-mybatis.xml"); } namedParameterJdbcTemplate = (NamedParameterJdbcTemplate)ctx.getBean(NamedParameterJdbcTemplate.class); /*ComboPooledDataSource pool= (ComboPooledDataSource) ctx.getBean("dataSource"); jdbcUser = pool.getUser(); jdbcPassword = pool.getPassword(); jdbcUrl = pool.getJdbcUrl(); driverClass = pool.getDriverClass(); initialPoolSize = pool.getInitialPoolSize(); maxPoolSize = pool.getMaxPoolSize();*/ } catch (Exception e) { System.out.println("错误:" +e.getMessage()+ e.getStackTrace()); } }}