jersey+spring+mybatis+maven框架集成和实现简单的crud

来源:互联网 发布:折叠自行车 知乎 编辑:程序博客网 时间:2024/06/05 05:12

由于近期在学习jsm框架实现webservice 网上也是找了许多例子整合了很久才成功 现在谈谈我的经验 希望对和我一样的初学者有用 可以少走一些弯路
开始:

entity层(pojo类)

package com.eda.entity;import Java.io.Serializable; import javax.xml.bind.annotation.XmlRootElement;@XmlRootElement public class User implements Serializable { private int id; private String username; private String sex; private int age; //由于字数限时get和set自己实现 public User(int id, String username, String sex, int age) { this.id = id; this.username = username; this.sex = sex; this.age = age; } public User() { } }

//注意要实现序列化和无参的构造方法

service层

package com.eda.service;import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Service;import com.eda.entity.User; import com.eda.mapper.UserMapper;@Service public class UserService { @Resource private UserMapper userMapper; public List querryUsers() { return userMapper.selectAllUser(); } public User querryUsersbyID(int id) { return userMapper.selectUserbyID(id); } public void deleteUserbyID(int id){ userMapper.deleteUserbyID(id); }}

//使用@Resource可以减少spring的耦合性

mapper层
//注意mapper层实际上是个接口 用来读取mabits的配置
package com.eda.mapper;

import java.util.List;

import com.eda.entity.User;

public interface UserMapper {
List selectAllUser();
User selectUserbyID(int id);
void deleteUserbyID(int id);
}

实现层 也就是resourpackage com.eda.resource;

import java.io.UnsupportedEncodingException;
import java.util.List;

import javax.annotation.Resource;
import javax.ws.rs.DELETE;
import javax.ws.rs.GET;
import javax.ws.rs.Path;
import javax.ws.rs.PathParam;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;

import org.springframework.stereotype.Component;

import com.eda.entity.User;
import com.eda.service.UserService;
@Component
@Path(“User”)
public class UserResource {
@Resource
private UserService userService;
@GET
@Path(“getUser”)
@Produces(“application/json”)
public List getUsers() throws UnsupportedEncodingException
{
return userService.querryUsers();
}
@GET
@Path(“getUserbyID/{id}”)
@Produces(“application/json”)
public User getUserbyID(@PathParam(“id”)int id) throws UnsupportedEncodingException
{
return userService.querryUsersbyID(id);
}
@DELETE
@Path(“deleteUser/{id}”)
@Produces(MediaType.APPLICATION_JSON)
public void deleteUser(@PathParam(“id”)int id)
{
userService.deleteUserbyID(id);
}
}是配置文件

需要新建一个source folder 名为config
然后新建一个package名为 MapperImpl
UserMapper.xml(在MapperImpl包里面)

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.eda.mapper.UserMapper">    <!-- 作为UserMapper接口的映射 -->    <!-- 查询 -->    <select id="selectAllUser" parameterType="com.eda.entity.User"        resultType="com.eda.entity.User">        select id,username,sex,age        from z_user    </select>    <!-- 根据ID查询 -->    <select id="selectUserbyID" parameterType="com.eda.entity.User"        resultType="com.eda.entity.User">        select id,username,sex,age        from z_user        where id = #{id}    </select>    <!-- 删除 -->    <delete id="deleteUserbyID" parameterType="com.eda.entity.User">        delete        from z_user        where id = #{id}    </delete></mapper>//数据库jdbc.propertiesdriver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&autoReconnect=true&failOverReadOnly=falseusername=rootpassword=rootinitialSize=0maxActive=20maxIdle=20minIdle=1maxWait=60000//spring+mybatis配置文件ApplicationContext.<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: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.0.xsd       http://www.springframework.org/schema/tx       http://www.springframework.org/schema/tx/spring-tx-3.0.xsd       http://www.springframework.org/schema/context          http://www.springframework.org/schema/context/spring-context-3.0.xsd       http://www.springframework.org/schema/aop       http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">       <context:component-scan base-package="com.eda" /><context:annotation-config/><!-- 自动扫描 --><!-- 引入数据库配置文件 --><bean id="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="location" value="classpath:jdbc.properties" /></bean><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close"><property name="driverClassName" value="${driver}" /><property name="url" value="${url}" /><property name="username" value="${username}" /><property name="password" value="${password}" /><!-- 初始化连接大小 --><property name="initialSize" value="${initialSize}"></property><!-- 连接池最大数量 --><property name="maxActive" value="${maxActive}"></property><!-- 连接池最大空闲 --><property name="maxIdle" value="${maxIdle}"></property><!-- 连接池最小空闲 --><property name="minIdle" value="${minIdle}"></property><!-- 获取连接最大等待时间 --><property name="maxWait" value="${maxWait}"></property></bean><!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><!-- 自动扫描mapping.xml文件 --><property name="mapperLocations" value="classpath:MapperImpl/UserMapper.xml"></property></bean><!-- DAO接口所在包名,Spring会自动查找其下的类 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.eda.mapper" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property></bean><!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean></beans>

//web.xml配置

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns="http://java.sun.com/xml/ns/javaee"    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"    id="WebApp_ID" version="3.0">    <display-name>MyJerseyWork</display-name>    <welcome-file-list>        <welcome-file>show.html</welcome-file>    </welcome-file-list>    <!-- Spring和mybatis的配置文件 -->    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:ApplicationContext.xml</param-value>    </context-param>    <!-- 编码过滤器 -->    <filter>        <filter-name>springUtf8Encoding</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>        <init-param>            <param-name>forceEncoding</param-name>            <param-value>true</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>springUtf8Encoding</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>    <!-- Spring监听器 -->    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <!-- Jersey -->    <servlet>        <servlet-name>mobile</servlet-name>        <servlet-class>com.sun.jersey.spi.spring.container.servlet.SpringServlet</servlet-class>    </servlet>    <servlet-mapping>        <servlet-name>mobile</servlet-name>        <url-pattern>/jersey/*</url-pattern>    </servlet-mapping></web-app>

//maven需要的jar包

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>MyJerseyWork</groupId>    <artifactId>MyJerseyWork</artifactId>    <version>0.0.1-SNAPSHOT</version>    <packaging>war</packaging>    <name>MyJerseyWork</name>    <description />    <properties>        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>        <!-- jersey版本号 -->        <jersey.version>2.24.1</jersey.version>        <!-- spring版本号 -->        <spring.version>4.0.2.RELEASE</spring.version>        <!-- mybatis版本号 -->        <mybatis.version>3.4.2</mybatis.version>    </properties>    <dependencies>        <!-- jersey-spring: 包含了jersey-servlet/jersey-server/jersey-core等, 同时还包含了spring相关依赖。             需要剔除,否则会与Spring相关依赖冲突 -->        <dependency>            <groupId>com.sun.jersey.contribs</groupId>            <artifactId>jersey-spring</artifactId>            <version>1.19.3</version>            <exclusions>                <exclusion>                    <artifactId>spring-core</artifactId>                    <groupId>org.springframework</groupId>                </exclusion>                <exclusion>                    <artifactId>spring-beans</artifactId>                    <groupId>org.springframework</groupId>                </exclusion>                <exclusion>                    <artifactId>spring-context</artifactId>                    <groupId>org.springframework</groupId>                </exclusion>                <exclusion>                    <artifactId>spring-web</artifactId>                    <groupId>org.springframework</groupId>                </exclusion>                <exclusion>                    <artifactId>spring-aop</artifactId>                    <groupId>org.springframework</groupId>                </exclusion>            </exclusions>        </dependency>        <dependency>            <groupId>com.sun.jersey</groupId>            <artifactId>jersey-servlet</artifactId>            <version>1.19.3</version>        </dependency>        <dependency>            <groupId>org.glassfish.jersey.containers</groupId>            <artifactId>jersey-container-servlet</artifactId>            <version>${jersey.version}</version>        </dependency>        <dependency>            <groupId>com.sun.jersey</groupId>            <artifactId>jersey-json</artifactId>            <version>1.19.3</version>        </dependency>        <dependency>            <groupId>org.glassfish.jersey.media</groupId>            <artifactId>jersey-media-json-jackson</artifactId>            <version>${jersey.version}</version>        </dependency>        <!--json-lib -->        <dependency>            <groupId>net.sf.json-lib</groupId>            <artifactId>json-lib</artifactId>            <version>2.4</version>            <classifier>jdk15</classifier>        </dependency>        <!-- spring核心包 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-web</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-oxm</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-tx</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-jdbc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-webmvc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-aop</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context-support</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- mybatis核心包 -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>${mybatis.version}</version>        </dependency>        <!-- mybatis-spring包 -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis-spring</artifactId>            <version>1.3.1</version>        </dependency>        <!-- 导入Mysql数据库链接jar包 -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.30</version>        </dependency>        <!--JARS -->        <dependency>            <groupId>org.glassfish.jersey.bundles</groupId>            <artifactId>jaxrs-ri</artifactId>            <version>${jersey.version}</version>        </dependency>        <!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->        <dependency>            <groupId>commons-dbcp</groupId>            <artifactId>commons-dbcp</artifactId>            <version>1.2.2</version>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>bean-validator</artifactId>            <version>3.0-JBoss-4.0.2</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.enterprise.deploy</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.jms</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.management.j2ee</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.eclipse.persistence</groupId>            <artifactId>javax.persistence</artifactId>            <version>2.0.0</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.resource</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.security.auth.message</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.security.jacc</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.servlet</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.servlet.jsp</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish</groupId>            <artifactId>javax.servlet.jsp.jstl</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>javax.xml.bind</groupId>            <artifactId>jaxb-api-osgi</artifactId>            <version>2.2.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>javax.ws.rs</groupId>            <artifactId>jsr311-api</artifactId>            <version>1.1.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish.web</groupId>            <artifactId>jstl-impl</artifactId>            <version>1.2</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>javax.mail</groupId>            <artifactId>mail</artifactId>            <version>1.4.3</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>javax.xml</groupId>            <artifactId>webservices-api-osgi</artifactId>            <version>2.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.jboss.weld</groupId>            <artifactId>weld-osgi-bundle</artifactId>            <version>1.0.1-SP3</version>            <scope>provided</scope>        </dependency>        <dependency>            <groupId>org.glassfish.web</groupId>            <artifactId>javax.servlet.jsp.jstl</artifactId>            <version>1.2.1</version>        </dependency>    </dependencies>    <build>        <sourceDirectory>src</sourceDirectory>        <resources>            <resource>                <directory>src</directory>                <excludes>                    <exclude>**/*.java</exclude>                </excludes>            </resource>        </resources>        <plugins>            <plugin>                <artifactId>maven-compiler-plugin</artifactId>                <version>2.3.2</version>                <configuration>                    <source>1.6</source>                    <target>1.6</target>                </configuration>            </plugin>            <plugin>                <artifactId>maven-war-plugin</artifactId>                <version>2.2</version>                <configuration>                    <warSourceDirectory>${basedir}/WebRoot</warSourceDirectory>                    <version>3.0</version>                    <failOnMissingWebXml>false</failOnMissingWebXml>                </configuration>            </plugin>        </plugins>    </build></project>

至此 整个框架集成结束

具体源码可在http://download.csdn.net/detail/z1760921018/9773022 下载

0 0
原创粉丝点击