JAVA JDBC(JdbcTemplate版) 最终版

\src\JDBCUtils.ini

url=jdbc:mysql://localhost:3306/data?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
username=root
password=123456

\src\com\data\entity\Mysql_Template_conn.java

package com.data.entity;

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

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import java.util.Properties;

/*
JDBC  Mysql_Template 封装增删改查
*QQ 7650371
* */
public class Mysql_Template_conn {
    public static final DataSource dataSource;

    static {  //静态代码块
        Properties props = new Properties();  //jdbc.properties"
        try(InputStream in = JdbcTemplate.class.getResourceAsStream("/JDBCUtils.ini")){
            props.load(in);
        }  catch (IOException e) {
            throw new RuntimeException(e);
        }
        String url = props.getProperty("url");
        String username = props.getProperty("username");
        String password = props.getProperty("password");
         dataSource = new DriverManagerDataSource(url,username,password);
    }

    public Mysql_Template_conn() {}

    public static DataSource getCon() {
        return dataSource;
    }

    public static JdbcTemplate newJdbcTemplate() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate;
    }

    public static int update(String sql,Object... args){   //动态参数  可以增删改，但是不能查询
        try {
            JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
            return jdbcTemplate.update(sql,args);  //添加
        } catch (Exception e) {
            System.out.println(e.toString());
            return 0;
        }
    }

//public void executeQuery(String sql) {
//    try {
//        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
//        List<jobs> resultList = jdbcTemplate.query("SELECT * FROM jobs", new BeanPropertyRowMapper<>(jobs.class));
//        // 打印查询结果
//        System.out.println("查询结果为：");
//        resultList.forEach(person -> System.out.println(person));
//
//    } catch (Exception e) {
//        System.out.println(e.toString());
//    }
//}



    public static void main(String[] args) {
        //Mysql_Template_conn conn=new Mysql_Template_conn();

            try {
                JdbcTemplate jdbcTemplate = new JdbcTemplate(Mysql_Template_conn.getCon());
                List<jobs> resultList = jdbcTemplate.query("SELECT * FROM jobs", new BeanPropertyRowMapper<>(jobs.class));
                // 打印查询结果
                System.out.println("查询结果为：");
                resultList.forEach(person -> System.out.println(person));
            } catch (Exception e) {
                System.out.println(e.toString());
            }

            try {  //动态参数
                JdbcTemplate jdbcTemplate = new JdbcTemplate(Mysql_Template_conn.getCon());
                String id="xcc222";
                List<jobs> resultList = jdbcTemplate.query("SELECT * FROM jobs WHERE job_id=?", new BeanPropertyRowMapper<>(jobs.class),id);
                // 打印查询结果
                System.out.println("查询结果为：");
                resultList.forEach(person -> System.out.println(person));
            } catch (Exception e) {
                System.out.println(e.toString());
            }


        String insertData = "INSERT into jobs(job_id,job_title) values('xcc222','22ffccfffffff')";
        System.out.println(Mysql_Template_conn.update(insertData));

        String UPDATEData = "UPDATE jobs set job_title='aaaaaa' WHERE job_id='xcc222'";
        System.out.println(Mysql_Template_conn.update(UPDATEData));

        String insertDataxx = "INSERT into jobs(job_id,job_title) values(?,?)";
        String s1="xcc222xx";
        String s2="22ffccfffffffxx";
        System.out.println(Mysql_Template_conn.update(insertDataxx,s1,s2));    //动态参数


    }







}