package com.github.zhangkaitao.shiro.chapter6;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.jdbc.core.JdbcTemplate;
/**
* <p>User: Zhang Kaitao
* <p>Date: 14-1-28
* <p>Version: 1.0
*/
public class JdbcTemplateUtils {
private static JdbcTemplate jdbcTemplate;
public static JdbcTemplate jdbcTemplate() {
if(jdbcTemplate == null) {
jdbcTemplate = createJdbcTemplate();
}
return jdbcTemplate;
}
private static JdbcTemplate createJdbcTemplate() {
DruidDataSource ds = new DruidDataSource();
ds.setDriverClassName("com.mysql.jdbc.Driver");
ds.setUrl("jdbc:mysql://localhost:3306/shiro");
ds.setUsername("root");
ds.setPassword("");
return new JdbcTemplate(ds);
}
}