`
jun2015
  • 浏览: 1473 次
  • 性别: Icon_minigender_1
  • 来自: 武汉
最近访客 更多访客>>
社区版块
存档分类
最新评论

java project使用spring jdbctemplate

阅读更多
package com.inzy.framework.tools;

import java.sql.Types;
import java.util.Date;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class SpringJdbcTemplate {
    private static final String driverClassName = "com.mysql.jdbc.Driver";
    private static final String url = "jdbc:mysql://localhost:3306/db"; 
    private static final String dbUsername = "root";
    private static final String dbPassword = "password";

    private static DataSource dataSource;
   
    public static JdbcTemplate getJdbcTemplate(){
    dataSource = getDataSource();
    JdbcTemplate template = new JdbcTemplate(dataSource);
    return template;
    }

    public static DriverManagerDataSource getDataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(driverClassName);
        dataSource.setUrl(url);
        dataSource.setUsername(dbUsername);
        dataSource.setPassword(dbPassword);
        return dataSource;
    }
}
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics