SpringJDBC

public static void main(String[] args) throws PropertyVetoException {
        //创建数据源
        ComboPooledDataSource cpds = new ComboPooledDataSource();
        cpds.setDriverClass("com.mysql.cj.jdbc.Driver");
        cpds.setJdbcUrl("jdbc:mysql://localhost:3306/student?&serverTimezone=UTC");
        cpds.setUser("root");
        cpds.setPassword("root");

        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(cpds);
        String sql = "insert into test (name,sex,age) values(?,?,?)";
        int result = temp.update(sql,"曹操","男",28);
        System.out.println(result>0?"添加成功":"添加失败");

    }

xml形式如下:

<!--引入properties文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    
    <!--注册DataSource数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!--注册JDBCTemplate类-->
    <bean id="temp" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
public static void main(String[] args) {
        ApplicationContext ac = new ClassPathXmlApplicationContext("springJdbc2.xml");
        JdbcTemplate temp = ac.getBean("temp",JdbcTemplate.class);

        String sql = "insert into test (name,sex,age) values(?,?,?)";
        int result = temp.update(sql,"周瑜","男",25);
        System.out.println(result>0?"添加成功":"添加失败");
    }
匿名

发表评论

匿名网友