1. 首先在容器内配置数据源
[html]
2.拿到注入数据源并且编写对数据库的操作
[java]
@Component("userService")
public class UserServiceImpl implements UserService{
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Resource //resource注入
private DataSource myDataSource;
public DataSource getMyDataSource() {
return myDataSource;
}
public void setMyDataSource(DataSource myDataSource) {
this.myDataSource = myDataSource;
}
//在下面方法前面加逻辑
public void save(){
try{
//拿到连接执行操作
Connection conn = myDataSource.getConnection();
conn.createStatement().execute("insert into dept values('6','bumen2')");
}catch(Exception e){
e.printStackTrace();
}
}
}
3.测试运行
[java]
@Test
public void test01() {
BeanFactory applicationContext = new ClassPathXmlApplicationContext(
"beans.xml");
UserService user = (UserService) applicationContext.getBean("userService");
user.save();
}
----------------------------------------------------------------------------------------------------------------------------------通过Properties的方式配置xml的datasource：
1、 编写properties文件：
[html]
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/sms
jdbc.username=root
jdbc.password=root
2、编写xml容器配置：
[html] view plaincopy
作者：zhang6622056