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?"添加成功":"添加失败");
}