所需jar包
1.web.xml
<display-name>rest-spring</display-name>
<filter>
<filter-name>CharacterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>GBK</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/</url-pattern>
</filter-mapping>
<servlet>
<servlet-name>mvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>mvc</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
2.spring.xml
<context:component-scan base-package="com.ls"/>
<!--配置基于注解的声明式事务,默认使用注解来管理事务行为-->
<tx:annotation-driven transaction-manager="transactionManager"/>
<!-- 配置数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@192.168.122.122:2222:e"/>
<property name="username" value="1"/>
<property name="password" value="1"/>
</bean>
<!-- 配置sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--注入数据库连接池-->
<property name="dataSource" ref="dataSource"/>
<!--配置mybatis全局配置文件:mybatis-config.xml-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!--扫描sql配置文件:mapper需要的xml文件-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- 配置产生Mapper接口对象的工厂 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--注入SqlSessionFactory-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!-- 给出需要扫描的Dao接口-->
<property name="basePackage" value="com.ls.dao"/>
</bean>
<!--配置事务管理器(mybatis采用的是JDBC的事务管理器)-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
3.mvc.xml
<context:component-scan base-package="com.ls"/>
<!-- 默认视图位置 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 此乃视图资源的前缀 -->
<property name="prefix" value="/WEB-INF/jsp"/>
<!-- 此乃视图资源的后缀 -->
<property name="suffix" value=".jsp"/>
</bean>
<!-- -->
<mvc:annotation-driven>
<!-- 返回json,spring4.0以后采用这种配置 -->
<mvc:message-converters>
<bean class="org.springframework.http.converter.StringHttpMessageConverter" />
<bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" />
</mvc:message-converters>
</mvc:annotation-driven>
4.mybaits-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<!-- 部门表 -->
<typeAlias type="com.ls.entity.AU_ORGINFO" alias="dept"/>
<!-- 用户表 -->
<typeAlias type="com.ls.entity.AU_USERINFO" alias="user"/>
</typeAliases>
</configuration>
5.user.xml
<mapper namespace="com.ls.dao.Usermapper">
<!-- 获得所有企业唯一标识 -->
<select id="selectDept" resultType="dept" parameterType="string">
SELECT orgid,
orgname,
f_industry_shortname
FROM a
WHERE isdelete =0
START WITH orgid = #{value}
CONNECT BY PRIOR orgid = suporgid
</select>
</mapper>
6.UserController.java
//访问使用.do 后缀
@Controller
@RequestMapping("/kc")
public class UserController {
@Autowired
private UserService userservice;
@RequestMapping(value="/seldept/{fid}", method = RequestMethod.GET)
public @ResponseBody List<AU_ORGINFO> selectDept(@PathVariable String fid){
return userservice.selectDept(fid);
}
}
7.UserService.java
@Service
@Transactional
public class UserService {
@Autowired
private Usermapper usermapper;
...
}
8.Usermapper.java
@Repository
public interface Usermapper {
public List<AU_ORGINFO> selectDept(String fid);
}
9.实体类