spring3.1使用JDBC数据源datasource的错误问题
JAR包:
junit-4.10.jar
org.springframework.beans-3.1.1.RELEASE.jar
org.springframework.context-3.1.1.RELEASE.jar
org.springframework.core-3.1.1.RELEASE.jar
org.springframework.asm-3.1.1.RELEASE.jar
org.springframework.expression-3.1.1.RELEASE.jar
org.springframework.jdbc-3.1.1.RELEASE.jar
commons-logging.jar
mysql-connector-java-5.1.18-bin.jar
1、User类
2、UserDAO接口
3、UserDAOImpl实现类
4、UserService类
5、UserServiceTest测试类
junit-4.10.jar
org.springframework.beans-3.1.1.RELEASE.jar
org.springframework.context-3.1.1.RELEASE.jar
org.springframework.core-3.1.1.RELEASE.jar
org.springframework.asm-3.1.1.RELEASE.jar
org.springframework.expression-3.1.1.RELEASE.jar
org.springframework.jdbc-3.1.1.RELEASE.jar
commons-logging.jar
mysql-connector-java-5.1.18-bin.jar
1、User类
package com.model;
public class User {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
2、UserDAO接口
package com.dao;
import com.model.User;
public interface UserDAO {
public void save(User u);
}
3、UserDAOImpl实现类
package com.dao.impl;
import java.sql.Connection;
import java.sql.SQLException;
import javax.annotation.Resource;
import javax.sql.DataSource;
import org.springframework.stereotype.Component;
import com.dao.UserDAO;
import com.model.User;
@Component("userDAO")
public class UserDAOImpl implements UserDAO {
private DataSource dataSource ;
public DataSource getDataSource() {
return dataSource;
}
@Resource(name="dataSource")
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
@Override
public void save(User u) {
try {
Connection conn = dataSource.getConnection();
conn.createStatement().executeUpdate("insert into user values(null,'lisi')");
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("A user saved!");
}
}
4、UserService类
package com.service;
import javax.annotation.Resource;
import org.springframework.stereotype.Component;
import com.dao.UserDAO;
import com.dao.impl.UserDAOImpl;
import com.model.User;
@Component("userService")
public class UserService {
private UserDAO userDAO = new UserDAOImpl();
public UserDAO getUserDAO() {
return userDAO;
}
@Resource(name="userDAO")
public void setUserDAO(UserDAO userDAO) {
this.userDAO = userDAO;
}
public void add(User u) {
userDAO.save(u);
}
}
5、UserServiceTest测试类
package com.test;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.model.User;
import com.service.UserService;
public class UserServiceTest {
@Test
public void testAdd() {
User u = new User();
ApplicationContext context = new ClassPathXmlApplicationContext(new String[]{"beans.xml"});
UserService userService = (UserService)context.getBean("userService");
userService.add(u);
}
}
...全文
相关推荐
spring-jdbcTmplate使用
jdbcTmplate 的常用使用方法,及相关事务关系的简单应用,适合初学者
spring03(使用spring整合jdbc)
这个例子演示了如何使用spring整合jdbc
Spring Boot 关系型数据库多数据源
mysql多数据源基础配置,修改配置文件即可,可以此为基础实现数据同步,数据层读写分离等功能,配置dao层实现Spring boot管理,自动切换底层连接.
开发工具 spring-jdbc-4.3.6.RELEASE.rar
开发工具 spring-jdbc-4.3.6.RELEASE.rar
Spring整合Mybatis使用<context:property-placeholder>时的坑
主要介绍了Spring整合Mybatis使用<context>时的坑 的相关资料,非常不错,具有参考借鉴价值,需要的朋友可以参考下


Web 开发
