java jdbc连接_java-jdbc数据库连接

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());        }    }}