ssm与MongoDB的整合

最新推荐文章于 2021-10-11 10:58:30 发布

柠檬味的可乐

最新推荐文章于 2021-10-11 10:58:30 发布

阅读量2k

点赞数 2

本文链接：https://blog.csdn.net/weixin_43923112/article/details/86676643

版权

1.新建一个项目，大框如下：
在这里插入图片描述
2.新建applicationContext-dao.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cache="http://www.springframework.org/schema/cache"
	xmlns:mongo="http://www.springframework.org/schema/data/mongo" xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  
    http://www.springframework.org/schema/data/mongo   
    http://www.springframework.org/schema/data/mongo/spring-mongo.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx.xsd 
    http://www.springframework.org/schema/context  
    http://www.springframework.org/schema/context/spring-context-4.0.xsd  
    http://www.springframework.org/schema/aop 
    http://www.springframework.org/schema/aop/spring-aop-4.0.xsd 
    http://www.springframework.org/schema/mvc   
    http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 
	<!-- 加载mongodb的属性配置文件 -->
	<context:property-placeholder location="classpath:conf/mongodb.properties"/>
 
	<!-- 我们使用的mongodb的版本是3.X,所以在构造这段话的时候要根据 Mongo 类的构造函数来构造，不同版本可能会造成构造函数的不同 -->
	<mongo:mongo-client id="mongo" host="${mongo.host}" port="${mongo.port}">
		<mongo:client-options connections-per-host="${mongo.connectionsPerHost}"
			threads-allowed-to-block-for-connection-multiplier="${mongo.threadsAllowedToBlockForConnectionMultiplier}"
			connect-timeout="${mongo.connectTimeout}" max-wait-time="${mongo.maxWaitTime}"
			socket-keep-alive="${mongo.socketKeepAlive}" socket-timeout="${mongo.socketTimeout}" />
	</mongo:mongo-client>
	<!-- 用户验证 -->
	<bean id="userCredentials" class="org.springframework.data.authentication.UserCredentials">
		<constructor-arg name="username" value="${mongo.username}" />
		<constructor-arg name="password" value="${mongo.password}" />
	</bean>
	<!-- mongo的工厂，通过它来取得mongo实例,dbname为mongodb的数据库名，没有的话会自动创建 -->
	<bean id="mongoDbFactory"
		class="org.springframework.data.mongodb.core.SimpleMongoDbFactory">
		<constructor-arg ref="mongo" />
		<constructor-arg value="${mongo.dbname}" />
	</bean>
 
	<bean id="mappingContext"
		class="org.springframework.data.mongodb.core.mapping.MongoMappingContext" />
 
	<bean id="defaultMongoTypeMapper"
		class="org.springframework.data.mongodb.core.convert.DefaultMongoTypeMapper">
		<constructor-arg name="typeKey">
			<null />
		</constructor-arg>
	</bean>
 
	<!-- collection的映射 -->
	<bean id="mappingMongoConverter"
		class="org.springframework.data.mongodb.core.convert.MappingMongoConverter">
		<constructor-arg name="mongoDbFactory" ref="mongoDbFactory" />
		<constructor-arg name="mappingContext" ref="mappingContext" />
		<property name="typeMapper" ref="defaultMongoTypeMapper" />
	</bean>
 
	<!-- mongodb的主要操作对象，所有对mongodb的增删改查的操作都是通过它完成 -->
	<bean id="mongoTemplate" class="org.springframework.data.mongodb.core.MongoTemplate">
		<constructor-arg name="mongoDbFactory" ref="mongoDbFactory" />
		<constructor-arg name="mongoConverter" ref="mappingMongoConverter" />
	</bean>
 
 
 
</beans>

3.新建applicationContext-service.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:aop="http://www.springframework.org/schema/aop" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    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/aop
    http://www.springframework.org/schema/aop/spring-aop.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx.xsd 
     http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd ">
    
     <!-- 开启spring的注解支持 -->
    <context:annotation-config></context:annotation-config>
    
    <!-- 指明注解的包名 -->
	<context:component-scan base-package="com.hc">
    <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    
    

</beans>

4.新建mongodb.properties文件

#DB name
mongo.dbname = sms
#username
mongo.username =
#password
mongo.password =
#host
mongo.host = localhost
#port
mongo.port= 27017
#xiancheng zui da zu se shu
mongo.connectionsPerHost= 8
#xiancheng dui lie shu
mongo.threadsAllowedToBlockForConnectionMultiplier= 4
#connectTimeout ms
mongo.connectTimeout= 1500
#maxWaitTime
mongo.maxWaitTime= 1500
#autoConnect
mongo.autoConnectRetry= true
#socketKeepAlive
mongo.socketKeepAlive= true
#socketTimeout
mongo.socketTimeout=1500
#du xie fen li
mongo.slaveOk=true

5.pom依赖

<!--整合MongoDB -->
		<dependency>
			<groupId>org.springframework.data</groupId>
			<artifactId>spring-data-mongodb</artifactId>
			<version>1.9.8.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.mongodb</groupId>
			<artifactId>mongo-java-driver</artifactId>
			<version>2.14.2</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-validator</artifactId>
			<version>5.2.4.Final</version>
		</dependency>

6.新建springmvc.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:mvc="http://www.springframework.org/schema/mvc"
	xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:util="http://www.springframework.org/schema/util"
	xmlns:task="http://www.springframework.org/schema/task"
	xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/util   
        http://www.springframework.org/schema/util/spring-util-3.0.xsd  
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://www.springframework.org/schema/task 
		http://www.springframework.org/schema/task/spring-task-4.1.xsd">

	<!-- 引入mongodb的相关配置 -->
	<import resource="classpath:spring/applicationContext-*.xml" />

	<!-- 指明注解的包名 -->
	<context:component-scan
		base-package="com.hc" />

	 <mvc:annotation-driven /> <!-- 基于注解的处理器 --> <!-- 一键式配置，通过注解的方式进行Spring MVC开发 -->

	<!-- <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" 
		/> 配置资源映射 <mvc:resources location="/static/easyui/" mapping="/easyui/**"></mvc:resources> 
		<mvc:resources location="/static/css/" mapping="/css/**"></mvc:resources> 
		<mvc:resources location="/static/js/" mapping="/js/**"></mvc:resources> <mvc:resources 
		location="/static/images/" mapping="/images/**"></mvc:resources> <mvc:resources 
		location="/static/layui/" mapping="/layui/**"></mvc:resources> <mvc:resources 
		location="/static/highcharts/" mapping="/highcharts/**"></mvc:resources> -->
	<!-- <mvc:interceptors> 管理员权限拦截器 <mvc:interceptor> <mvc:mapping path="/home/**" 
		/> <mvc:mapping path="/user/**" /> <mvc:mapping path="/page/**" /> <mvc:exclude-mapping 
		path="/user/login"/> <mvc:exclude-mapping path="/front/**"/> <mvc:exclude-mapping 
		path="/user/save"/> <mvc:exclude-mapping path="/user/up"/> <mvc:exclude-mapping 
		path="/user/queryByName"/> <mvc:exclude-mapping path="/page/admin/user/login"/> 
		<mvc:exclude-mapping path="/page/admin/user/reg"/> <mvc:exclude-mapping path="/page/admin/front/*"/> 
		<bean class="cn.jbit.wen.Interceptor.LoginInterceptor" /> </mvc:interceptor> 
		</mvc:interceptors> -->

	<!-- 匹配对应的页面 -->
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/content/" />
		<property name="suffix" value=".jsp" />
	</bean>



</beans>

7.新建SqlMapConfig.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">

<!-- 通过这个配置文件完成mybatis与数据库的连接 -->
<configuration>
	<plugins>
	  <plugin interceptor="com.github.pagehelper.PageHelper">
	  <!--  设置数据库类型 -->
	  <property name="dialect" value="mongodb"/>
	  </plugin>
	</plugins>
</configuration>

8.配置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_2_5.xsd" version="2.5">
  <display-name>demo</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  
  <!-- post提交过滤器 utf-8 -->
	<filter>
		<filter-name>encoding</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>encoding</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

	<!-- 加载applicationContext.xml文件 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:spring/applicationContext-*.xml</param-value>
	</context-param>

	<!-- 加载springMVC.xml文件 -->
	<servlet>
		<servlet-name>springMVC</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:spring/springmvc.xml</param-value>
		</init-param>
	</servlet>
	<servlet-mapping>
		<servlet-name>springMVC</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>

	<!-- 监听器 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
</web-app>

9.新建实体类User.java

package com.hc.entity;

import org.springframework.data.mongodb.core.mapping.Document;

@Document(collection = "sms")
public class User {
	
	private String userid;
	
	private String name;
	
	private int age;
	

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getUserid() {
		return userid;
	}

	public void setUserid(String userid) {
		this.userid = userid;
	}


}

10.新建IUserService 接口

package com.hc.service;

import java.util.List;

import com.hc.entity.User;

public interface IUserService {

	public void save(User user);
	
	public void insert(User user);
	
	public void remove(String uid);
	
	public int update(User user);
	
	public List<User> findByUid(String uid);
	
	public List<User> findByUidAndTimestamp(String uid,String name);
	
	public List<User> page(int page,String uid);

}

11.新建UserService

package com.hc.service.impl;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Sort;
import org.springframework.data.mongodb.core.MongoOperations;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.Update;
import org.springframework.stereotype.Service;

import com.hc.entity.User;
import com.hc.service.IUserService;

@Service("userService")  
public class UserService implements IUserService {  

	@Autowired
	private MongoOperations mongoOperations; 

	//save存在则更新，不存在则插入
	public void save(User user){
	    mongoOperations.save(user);
	}

	//insert存在则不做处理，不存在则插入
	public void insert(User user){
	    mongoOperations.insert(user);
	}

	//根据userid删除文档
	public void remove(String uid){
	    Query query = new Query();
	    query.addCriteria(Criteria.where("userid").is(uid));
	    mongoOperations.remove(query,User.class); 
	}

	//根据id更新文档
	public int update(User user){
	    Query query = new Query();
	    query.addCriteria(Criteria.where("userid").is(user.getUserid()));
	    Update update = new Update();
	    update.set("name",user.getName());
	    update.set("age",user.getAge());
	    return mongoOperations.updateFirst(query,update,User.class).getN();  //只修改第一个数据
	    //return mongoOperations.updateMulti(query,update,User.class).getN();   //修改所有符合数据
	}

	//单条件查询，find查询所有
	public List<User> findByUid(String uid){
	    Query query = new Query();
	    query.addCriteria(Criteria.where("userid").is(uid));
	    return mongoOperations.find(query,User.class);
	}

	//多条件查询，find查询所有
	public List<User> findByUidAndTimestamp(String uid,String name){
	    Query query = new Query();
	    query.addCriteria(Criteria.where("userid").is(uid).and("name").is(name));
	    return mongoOperations.find(query,User.class);
	}

	//根据uid分页查询
	public List<User> page(int page,String uid){
	    Query query = new Query();
	    query.addCriteria(Criteria.where("userid").is(uid));
	    query.with(new Sort(new Sort.Order(Sort.Direction.DESC,"age")));
	    query.limit(5);
	    query.skip((page-1)*2);
	    return mongoOperations.find(query,User.class);
	}

	


}

12.新建UserController 控制层

package com.hc.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.hc.entity.User;
import com.hc.service.IUserService;

@Controller
@RequestMapping("User")
public class UserController {

	@Autowired
	private IUserService userService;

	//添加用户
	@RequestMapping("save")
	@ResponseBody
	public String save() {
		User user = new User();
		user.setUserid("1.0");
		user.setName("ss");
		user.setAge(2000);
		//userService.save(user);
		userService.insert(user);
		return "SSUCCESS";
	}

	//根据userid删除用户
	@RequestMapping("deleteByuserid")
	@ResponseBody
	public String deleteByuserid() {
		userService.remove("1");
		return "SSUCCESS";
	}

	//根据id更新文档
	@RequestMapping("updateByuserid")
	@ResponseBody
	public String updateByusserid() {
		User user = new User();
		user.setUserid("1.0");
		user.setName("sss");
		user.setAge(20);
		userService.update(user);
		return "SSUCCESS";
	}

	//单条件查询，find查询所有
	@RequestMapping("findByuserid")
	@ResponseBody
	public List<User> findByuserid(String userid) {
		return userService.findByUid(userid);
	}

	//多条件查询，find查询所有
	@RequestMapping("findByuseridandname")
	@ResponseBody
	public List<User> findByuseridandname(String userid,String name) {
		return userService.findByUidAndTimestamp(userid, name);
	}

	//根据uid分页查询
	@RequestMapping("page")
	@ResponseBody
	public List<User> page(int page,String userid){
		return userService.page(page, userid);
	}
}

柠檬味的可乐

关注

2
点赞
踩
7

收藏

觉得还不错? 一键收藏
0
评论
ssm与MongoDB的整合

1.新建一个项目，大框如下：2.新建applicationContext-dao.xml文件&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;beans xmlns="http://www.springframework.org/schema/beans" xmlns:tx="http://www.springframework.org/sc...
复制链接

扫一扫