- 创建maven工程导入依赖
4.0.0 com.wgm springjava 0.0.1-SNAPSHOT war org.springframework spring-webmvc 4.3.7.RELEASE com.jolbox bonecp-spring 0.8.0.RELEASE ${project.artifactId} org.apache.maven.plugins maven-resources-plugin UTF-8 org.apache.maven.plugins maven-compiler-plugin org.apache.tomcat.maven tomcat7-maven-plugin 2.2
2,编写User对象
public class User { private String username; private String password; private Integer age; public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; }}
3,编写UserDao
public class UserDAO { public ListqueryUserList(){ List result = new ArrayList (); // 模拟数据库的查询 for (int i = 0; i < 10; i++) { User user = new User(); user.setUsername("username_" + i); user.setPassword("password_" + i); user.setAge(i + 1); result.add(user); } return result; }}
4,编写UserService
@Servicepublic class UserService { @Autowired // 注入Spring容器中的bean对象 private UserDAO userDAO; public ListqueryUserList() { // 调用userDAO中的方法进行查询 return this.userDAO.queryUserList(); }}
5,编写SpringConfig 用于实例化Spring容器
@Configuration // 通过该注解来表明该类是一个Spring的配置,相当于一个xml文件@ComponentScan(basePackages = "com.wgm") // 配置扫描包@PropertySource(value = { "classpath:db.properties" })public class SpringConfig { @Bean // 通过该注解来表明是一个Bean对象,相当于xml中的public UserDAO getUserDAO() { return new UserDAO(); // 直接new对象做演示 } @Value("${jdbc.url}") private String jdbcUrl; @Value("${jdbc.driverClassName}") private String jdbcDriverClassName; @Value("${jdbc.username}") private String jdbcUsername; @Value("${jdbc.password}") private String jdbcPassword; @Bean(destroyMethod = "close") public DataSource dataSource() { BoneCPDataSource boneCPDataSource = new BoneCPDataSource(); // 数据库驱动 boneCPDataSource.setDriverClass(jdbcDriverClassName); // 相应驱动的jdbcUrl boneCPDataSource.setJdbcUrl(jdbcUrl); // 数据库的用户名 boneCPDataSource.setUsername(jdbcUsername); // 数据库的密码 boneCPDataSource.setPassword(jdbcUsername); // 检查数据库连接池中空闲连接的间隔时间,单位是分,默认值:240,如果要取消则设置为0 boneCPDataSource.setIdleConnectionTestPeriodInMinutes(60); // 连接池中未使用的链接最大存活时间,单位是分,默认值:60,如果要永远存活设置为0 boneCPDataSource.setIdleMaxAgeInMinutes(30); // 每个分区最大的连接数 boneCPDataSource.setMaxConnectionsPerPartition(100); // 每个分区最小的连接数 boneCPDataSource.setMinConnectionsPerPartition(5); return boneCPDataSource; }}
6,编写测试方法
public class Main { public static void main(String[] args) { // 通过Java配置来实例化Spring容器 AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(SpringConfig.class); // 在Spring容器中获取Bean对象 UserService userService = context.getBean(UserService.class); // 调用对象中的方法 Listlist = userService.queryUserList(); for (User user : list) { System.out.println(user.getUsername() + ", " + user.getPassword() + ", " + user.getPassword()); } // 销毁该容器 context.destroy(); }}