获取jdbctemplate的一种方法

来源：互联网发布：mac 压感编辑：程序博客网时间：2024/04/30 04:16

package cn.outofmemory.snippets.enterprise;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 InsertRecordInDatabaseWithJdbcTemplate {    private static final String driverClassName = "com.mysql.jdbc.Driver";    private static final String url = "jdbc:mysql://localhost/companydb";    private static final String dbUsername = "jcg";    private static final String dbPassword = "jcg";    private static final String insertSql =        "INSERT INTO employee (" +        "   name, " +        "   surname, " +        "   title, " +        "   created) " +        "VALUES (?, ?, ?, ?)";    private static DataSource dataSource;    public static void main(String[] args) throws Exception {        dataSource = getDataSource();        saveRecord("John", "Black", "Software developer", new Date());        saveRecord("Tom", "Green", "Project Manager", new Date());    }    public static void saveRecord(String name, String surname, String title, Date created) {        JdbcTemplate template = new JdbcTemplate(dataSource);        // define query arguments        Object[] params = new Object[] { name, surname, title, new Date() };        // define SQL types of the arguments        int[] types = new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP };        // execute insert query to insert the data        // return number of row / rows processed by the executed query        int row = template.update(insertSql, params, types);        System.out.println(row + " row inserted.");    }    public static DriverManagerDataSource getDataSource() {        DriverManagerDataSource dataSource = new DriverManagerDataSource();        dataSource.setDriverClassName(driverClassName);        dataSource.setUrl(url);        dataSource.setUsername(dbUsername);        dataSource.setPassword(dbPassword);        return dataSource;    }}

CREATE TABLE `companydb`.`employee` (  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,  `name` VARCHAR(45) NOT NULL,  `surname` VARCHAR(45) NOT NULL,  `title` VARCHAR(45) NOT NULL,  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,  PRIMARY KEY (`id`));

输出：

1 row inserted.1 row inserted.

0 0