开发中实用的JDBC连接数据库做操作

package com.travelsky.pss.bkg.asom.jdbc;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.sql.DataSource;

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

public class JdbcUtils {
    private static String DRIVERNAME;
    private static String URL;
    private static String USER;
    private static String PASSWORD;
    static {

        java.util.Properties p = new java.util.Properties();
        try {
            p.load(new FileInputStream("config/jdbc.properties"));
        } catch (FileNotFoundException e) {
            throw new RuntimeException(e);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        DRIVERNAME = p.getProperty("jdbc.driverClassName");
        URL = p.getProperty("jdbc.url.d2");
        USER = p.getProperty("jdbc.username.d2");
        PASSWORD = p.getProperty("jdbc.password.d2");

        DriverManagerDataSource ds = new DriverManagerDataSource(URL, USER,
                PASSWORD);
        jdbcTemplate = new JdbcTemplate(ds);
        datasource = ds;
    }

    static DataSource datasource;

    static JdbcTemplate jdbcTemplate;

    public static Connection getConnection() throws Exception {
        Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
        return con;
    }

    public static DataSource getDataSource() {
        return datasource;
    }

    public static JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    public static void closeResourse(ResultSet rs, Statement sta,
            Connection con) {
        org.springframework.jdbc.support.JdbcUtils.closeResultSet(rs);
        org.springframework.jdbc.support.JdbcUtils.closeStatement(sta);
        org.springframework.jdbc.support.JdbcUtils.closeConnection(con);
    }

}

package com.travelsky.pss.bkg.asom;

import static org.junit.Assert.*;


import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;

public class ShowCase {

    @Test
    public void 使用spring_jdbc_template简化sql异常() throws Exception {
        JdbcTemplate jdbcTemplate = com.travelsky.pss.bkg.asom.jdbc.JdbcUtils
                .getJdbcTemplate();

        long pnr = -1;

        int update = jdbcTemplate.update("delete ctr where pnrb_key = ?", pnr);
        assertEquals(0, update);
    }

}