spring3.2.4,spring mvc,spring jdbc
采用spring
项目的工程图:
[img]http://dl2.iteye.com/upload/attachment/0090/5514/376b89d6-ff1c-36a2-af43-ca2695554b97.png[/img]
导入jar包:
[img]http://dl2.iteye.com/upload/attachment/0090/5516/47c2c0d2-1562-3827-ad02-ed4deb6a7efa.png[/img]
1.web.xml 设置:
2.applicationContext.xml
3.spring-mvc-servlet.xml
4.spring-context-test.xml
5.vo
6.dao
7.daoimpl
8.service
9.serviceImpl
10.Controller
11.测试:[url]localhost:8080/ProjectTest/controller/test/getUsers[/url]
12.结果:
采用spring
项目的工程图:
[img]http://dl2.iteye.com/upload/attachment/0090/5514/376b89d6-ff1c-36a2-af43-ca2695554b97.png[/img]
导入jar包:
[img]http://dl2.iteye.com/upload/attachment/0090/5516/47c2c0d2-1562-3827-ad02-ed4deb6a7efa.png[/img]
1.web.xml 设置:
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name>bkoef</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:applicationContext.xml
classpath:com/test/test/spring-context-test.xml
</param-value>
</context-param>
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>spring-mvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>4</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>spring-mvc</servlet-name>
<url-pattern>/controller/*</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
</web-app>
2.applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:security="http://www.springframework.org/schema/security"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:util="http://www.springframework.org/schema/util"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.2.xsd">
<context:annotation-config/>
<aop:aspectj-autoproxy/>
<tx:annotation-driven/>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name = "dataSource" ref="dataSource"/>
</bean>
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations" ref="propertyLocations"/>
</bean>
<util:list id="propertyLocations">
<value>classpath:jdbc.properties</value>
</util:list>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
<property name="validationQuery"><value>${jdbc.validationQuery}</value></property>
<property name="testOnBorrow"><value>${jdbc.testOnBorrow}</value></property>
<property name="maxActive"><value>${jdbc.maxActive}</value></property>
<property name="maxIdle"><value>${jdbc.maxIdle}</value></property>
<property name="maxWait"><value>${jdbc.maxWait}</value></property>
</bean>
</beans>
3.spring-mvc-servlet.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<context:annotation-config/>
<mvc:annotation-driven />
<context:component-scan base-package="com.test.test.web.controller"/>
</beans>
4.spring-context-test.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:util="http://www.springframework.org/schema/util"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd">
<bean id="stringGenerator" class="org.overdijk.commons.string.generator.BasicStringGenerator"/>
<bean id="testDao" class="com.test.test.dao.impl.TestDaoImpl">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="testService" class="com.test.test.service.impl.TestServiceImpl">
</bean>
</beans>
5.vo
public class User {
private String username;
private String password;
/**
getter();
setter();
**/
}
6.dao
public interface TestDao {
public List<User> getUserList();
}
7.daoimpl
public class TestDaoImpl extends NamedParameterJdbcDaoSupport implements TestDao{
private final static RowMapper<User> USER_MAPPER = BeanPropertyRowMapper.newInstance(User.class);
private final static String SQL_FINDUSER ="SELECT * from sys_user";
@Override
public List<User> getUserList() {
return this.getNamedParameterJdbcTemplate().query(SQL_FINDUSER, USER_MAPPER);
}
}
8.service
public interface TestService {
public List<User> getUsers();
}
9.serviceImpl
public class TestServiceImpl implements TestService {
@Autowired
private TestDao testDao;
@Override
public List<User> getUsers() {
return testDao.getUserList();
}
}
10.Controller
@Controller
@RequestMapping("/test")
public class TestController {
private static Log log = LogFactory.getLog(TestController.class);
@Autowired
private TestServiceImpl testService;
@RequestMapping(value="getUsers",method = RequestMethod.GET)
public @ResponseBody List<User> getUsers(){
log.info("[TestController.getUsers]");
List<User> users = this.testService.getUsers();
for(User user: users){
System.out.println(user.getUsername());
}
return this.testService.getUsers();
}
}
11.测试:[url]localhost:8080/ProjectTest/controller/test/getUsers[/url]
12.结果:
[{"username":"123123","password":"123123"},{"username":"112233","password":"55"},{"username":"waaa","password":"aa"},{"username":"bb","password":"bb"}]