jdbcTemplate和Druid实现数据库连接以及操作

 1导入架包，如图所示。

2.写DruidUtil工具类，实现数据库连接。代码如下：

package sour.JdbcUtil;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DruidUtils {
    private static DataSource ds;

    static {
        try {
            Properties p = new Properties();
            p.load(DruidUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
            ds = DruidDataSourceFactory.createDataSource(p);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    public static Connection getConnection() throws SQLException {
        return ds.getConnection();
    }

    public static DataSource getDataSource() {
        return ds;
    }
    
    public static void close(Statement st, Connection con) {
        close(null, st, con);
    }
    
    public static void close(ResultSet rs, Statement st, Connection con) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (st != null) {
            try {
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (con != null) {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

3：写测试类，进行数据库操作测试（使用了Junit单元测试，导包加注解 @Test即可使用）

package sour.jdbcTemplate;

import org.junit.Test;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import sour.JdbcUtil.DruidUtils;

import java.util.List;
import java.util.Map;

public class jdbcTempDemo1 {
    @Test
    public void test1() {
        JdbcTemplate jt = new JdbcTemplate(DruidUtils.getDataSource());
       /* String sql="update account set money=10000 where id=?";
        int i = jt.update(sql, 1);
        System.out.println(i);*/

        String sqlDelete = "delete from account where id =?";
        int i1 = jt.update(sqlDelete, 5);
        System.out.println(i1);
    }

    @Test
    public void test2() {
        JdbcTemplate jt = new JdbcTemplate(DruidUtils.getDataSource());
        String sql = "select * from account where id=? or id=?";
        //   Map<String, Object> map = jt.queryForMap(sql, 4,2);
        List<Map<String, Object>> maps = jt.queryForList(sql, 4, 3);
        System.out.println(maps);
    }

    @Test
    public void test3() {
        JdbcTemplate jt = new JdbcTemplate(DruidUtils.getDataSource());
        String sql="select * from stu";
        List<Student> query = jt.query(sql, new BeanPropertyRowMapper<Student>(Student.class));
        for(Student s:query){
            System.out.println(s.getName1()+"---"+s.getInserttime());
        }

    }
}