spring mvc +mybatis 部署实验

最新推荐文章于 2022-09-01 16:00:05 发布

exartcn

最新推荐文章于 2022-09-01 16:00:05 发布

阅读量553

点赞数 1

CC 4.0 BY-SA版权

分类专栏： spring mvc batis

本文链接：https://blog.youkuaiyun.com/exartcn/article/details/52461120

spring mvc 同时被 2 个专栏收录

2 篇文章

订阅专栏

batis

1 篇文章

订阅专栏

本文详细介绍了Spring与MyBatis整合的具体步骤，包括所需jar包、配置文件设置、接口及实现类的设计等，并分享了部署过程中的心得与常见问题解决办法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天继续研究了spring以及mybatis,并进行了整合部署,步骤与心得记录下来

1,jar 所需的jar包

2,mybatis配置文件

2-1 spring-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:mvc="http://www.springframework.org/schema/mvc"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-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/tx
        http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

	<context:component-scan base-package="jp.spring.test" />

	 <!-- don't handle the static resource -->
    <mvc:default-servlet-handler />

     <!-- if you use annotation you must configure following setting -->
    <mvc:annotation-driven />

	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/" />
		<property name="suffix" value=".jsp" />
	</bean>

	<!-- 1. 数据源 : DriverManagerDataSource -->
 	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.ibm.db2.jcc.DB2Driver"></property>
		<property name="url" value="jdbc:db2://localhost:50000/SPRDB"></property>
		<property name="username" value="db2admin"></property>
		<property name="password" value="db2admin"></property>
	</bean>

<!-- 	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource" />
	</bean>

	<bean id="userLoginDao" class="jp.spring.test.dao.impl.UserLoginDaoImpl">
		<property name="jdbcTemplate" ref="jdbcTemplate" />
	</bean> -->

	<!--
        2,mybatis的SqlSession的工厂: SqlSessionFactoryBean dataSource:引用数据源
        MyBatis定义数据源,同意加载配置
    -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="classpath:jp/spring/test/dao/mybatis-config.xml" />
    </bean>


     <!--
         3.mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer sqlSessionFactory
        basePackage:指定sql映射文件/接口所在的包（自动扫描）
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="jp.spring.test.dao"></property>
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
    </bean>

    <!--
        4,事务管理 : DataSourceTransactionManager dataSource:引用上面定义的数据源
    -->
    <bean id="txManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 5,使用声明式事务
         transaction-manager：引用上面定义的事务管理器
     -->
    <tx:annotation-driven transaction-manager="txManager" />
</beans>

2-2,mybatis-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 alias="User" type="jp.spring.test.domain.User" />
    </typeAliases>
    <!-- 实体接口映射资源 -->
    <!--
        说明：如果xxMapper.xml配置文件放在和xxMapper.java统一目录下，mappers也可以省略，
        因为org.mybatis.spring.mapper.MapperFactoryBean默认会去查找与xxMapper.java相同目录和名称的xxMapper.xml
    -->
    <mappers>
        <mapper resource="jp/spring/test/dao/userLoginDao.xml" />
    </mappers>

</configuration>

2-3 dao接口名.xml(userLoginDao.xml)

<?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">
<!--
    namespace：必须与对应的接口全类名一致,可以不需要实体类,用接口就可以调用sql方式
    id:必须与对应接口的某个对应的方法名一致

 -->

 <mapper namespace="jp.spring.test.dao.UserLoginDao">

<!--   <resultMap id="user" type="jp.spring.test.domain.User">
		<result property="name" column="USER_NAME" />
		<result property="password" column="USER_PASSWORD" />
		<result property="age" column="USER_AGE" />
		<result property="sex" column="USER_SEX" />
	</resultMap> -->

	<select id="getUserInfo" parameterType="User" resultType="User">
		SELECT * FROM LOGIN_INFO WHERE NAME=#{name} AND PASSWORD=#{password}
	</select>

	<select id="getUserByName" parameterType="String" resultType="User">
		SELECT * FROM LOGIN_INFO WHERE NAME=#{name}
	</select>

	<insert id="userRegister" parameterType="User">
	INSERT INTO USER_INFO (NAME,AGE,SEX) VALUES(#{name},#{age},#{sex})

	</insert>

	<insert id="updateWithUser_login" parameterType="User">
	INSERT INTO LOGIN_INFO (NAME,PASSWORD) VALUES(#{name},#{password})
	</insert>

 </mapper>

3,spring mvc

3-1,domain

package jp.spring.test.domain;

import org.springframework.stereotype.Component;

@Component
public class User {
	private String name;
	private String password;
	private String age;
	private String sex;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	@Override
	public String toString() {
		return "user [name=" + name + ", password=" + password + ", age=" + age + ", sex=" + sex + "]";
	}
}

3-2,dao

package jp.spring.test.dao;

import jp.spring.test.domain.User;

public interface UserLoginDao {
	public User getUserInfo(User user);

	public User getUserByName(String name);

	public void userRegister(User user);

	public void updateWithUser_login(User user);
}

3-3,service

package jp.spring.test.service;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import jp.spring.test.dao.UserLoginDao;
import jp.spring.test.domain.User;
@Service
public class Webservice {
	@Autowired
	private UserLoginDao userLoginDao;

	public User checkLogin(User user){
		 User user1 = userLoginDao.getUserInfo(user);
		return user1;
	}
	public User checkRegister(String name){
		User user = userLoginDao.getUserByName(name);
		return user;
	}
	public void userRegister(User user){
		userLoginDao.userRegister(user);
		userLoginDao.updateWithUser_login(user);
	}
}

3-4,controller

package jp.spring.test.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import jp.spring.test.domain.User;
import jp.spring.test.service.Webservice;

@Controller
@RequestMapping("/zhangjie")
public class WebController {
	@Autowired
	private Webservice webservice;

	@RequestMapping("hello")
	public String tohelloPage(){
		return "hello";
	}

	@RequestMapping(value="loginCheck",params="login",method=RequestMethod.POST)
	public String userLogin(@RequestParam("name") String name,
										@RequestParam("password") String password,
										Model model) {
		String veiwId=null;
		User user=new User();
		user.setName(name);
		user.setPassword(password);
		User user2= webservice.checkLogin(user);
		if(user2==null){
			veiwId="hello";
			model.addAttribute("message","ユーザー名かパスポートか間違いました");
		}else{
			veiwId="index";
			model.addAttribute("message","ようこそ、いっラシャいませ");
			model.addAttribute("userName",user2.getName());
		}
		return veiwId;
	}
	@RequestMapping(value="loginCheck",params="register",method=RequestMethod.POST)
	public String userRegister() {
		return "register";
	}
	@RequestMapping(value="register",params="register",method=RequestMethod.POST)
	public String userregister(@RequestParam("name") String name,
									@RequestParam("password") String password,
									@RequestParam("sex") String sex,
									@RequestParam("age") String age,
									Model model) {
		String viewId=null;
		User user=new User();
		user.setAge(age);
		user.setName(name);
		user.setPassword(password);
		user.setSex(sex);
		User user2= webservice.checkRegister(name);
		if(user2==null){
			 webservice.userRegister(user);
			viewId="index";
			model.addAttribute("message","ようこそ、いっラシャいませ");
		}else{
			viewId="register";
			model.addAttribute("message","ユーザー名もあります、お名前変更して、もう一度う試してください");
		}
		return viewId;
	}
}

4,jsp

略

部署的过程中,问题大多出在数据库sql文方面,总体而言,非常便捷.

文章部分内容来源于互联网,感谢各位作者

------------------------------------------------------------------------

以上是基于mybatis的面向接口编程的实例,虽然更为便利,但是还是想试一试用实现类部署的方法

对于利用DAO的实现类,实现mybatis的功能需要在以上的基础上做几下的修改

1,spring-servlet.xml

需要在spring-servlet.xml中去掉mybatis的接口/类包自动扫描

去除以下的代码

 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="jp.spring.test.dao"></property>
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
 </bean>

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">2</span><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">,保证mapper.xml文件名,</span><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">mapper.xml中的</span><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">namespace,mapper </span><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">resource 引用的xml保持一致</span>

3,实现类如下

package jp.spring.test.dao.impl;

import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Repository;

import jp.spring.test.dao.UserLoginDao;
import jp.spring.test.domain.User;

@Repository
public class UserLoginDaoImpl  implements UserLoginDao{
	@Autowired
	@Qualifier("sqlSession")
	private SqlSession sqlSession;

	@Override
	public User getUserInfo(User user) {
		// TODO 自動生成されたメソッド・スタブ
		System.out.println("impl");
		return sqlSession.selectOne("UserLoginDao.getUserInfo",user);
	}

	@Override
	public User getUserByName(String name) {
		// TODO 自動生成されたメソッド・スタブ
		System.out.println("impl");
		return sqlSession.selectOne("getUserByName",name);
	}

	@Override
	public void userRegister(User user) {
		// TODO 自動生成されたメソッド・スタブ
		System.out.println("impl");
		this.sqlSession.insert("UserLoginDao.userRegister", user);

	}

	@Override
	public void updateWithUser_login(User user) {
		// TODO 自動生成されたメソッド・スタブ
		System.out.println("impl");
		this.sqlSession.insert("updateWithUser_login", user);
	}


}

总结,目前而言,面向接口的方式可能更便捷一些,但在实际项目开发中,到底哪一种方式更为合理,也许只有到具体环境中才能分辩.