2
用spring 创建ComboPooledDataSource和JdbcTemplate对象
source link: https://blog.51cto.com/u_15707781/5724417
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
用spring 创建ComboPooledDataSource和JdbcTemplate对象
精选 原创用spring 创建ComboPooledDataSource和JdbcTemplate对象
3.1添加ioc相关jar包
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
3.2创建db.properties文件
driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssm
user=root
password=123
url=jdbc:mysql://localhost:3306/ssm
user=root
password=123
3.3在applicationContext.xml文件中创建对象
<context:property-placeholder location="db.properties"></context:property-placeholder>
<!-- 创建一个连接池对象 -->
<bean id="comboPooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driverClass}" />
<property name="jdbcUrl" value="${url}"/>
<property name="user" value="${user}" />
<property name="password" value="${password}" />
</bean>
<!-- 创建一个jdbcTemplate对象 并且通过构造函数 将连接池对象 注入到jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
<constructor-arg name="dataSource" ref="comboPooledDataSource" />
</bean>
<!-- 创建一个连接池对象 -->
<bean id="comboPooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driverClass}" />
<property name="jdbcUrl" value="${url}"/>
<property name="user" value="${user}" />
<property name="password" value="${password}" />
</bean>
<!-- 创建一个jdbcTemplate对象 并且通过构造函数 将连接池对象 注入到jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
<constructor-arg name="dataSource" ref="comboPooledDataSource" />
</bean>
3.4 修改dao 层
@Component
public class UsersDao implements IUsersDao {
//注入jdbcTemplate对象
@Autowired
private JdbcTemplate jdbcTemplate;
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
//update方法 (增 删 改)
@Override
public void add(Users user) {
String sql = "insert into users values(null,?,?)";
jdbcTemplate.update(sql, user.getUname(), user.getPassword());
}
public class UsersDao implements IUsersDao {
//注入jdbcTemplate对象
@Autowired
private JdbcTemplate jdbcTemplate;
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
//update方法 (增 删 改)
@Override
public void add(Users user) {
String sql = "insert into users values(null,?,?)";
jdbcTemplate.update(sql, user.getUname(), user.getPassword());
}
3.5测试
@Test
public void test()
{
ClassPathXmlApplicationContext applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");
IUsersDao usersDao= applicationContext.getBean("usersDao",IUsersDao.class);
Users user=new Users("xiaowanglaoshi","123");
usersDao.add(user);
}
public void test()
{
ClassPathXmlApplicationContext applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");
IUsersDao usersDao= applicationContext.getBean("usersDao",IUsersDao.class);
Users user=new Users("xiaowanglaoshi","123");
usersDao.add(user);
}
- 赞
- 收藏
- 评论
- 分享
- 举报
上一篇:Spring JDBC 数据访问
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK