spring+mybatis+springMvc+maven简单整合

最新推荐文章于 2024-09-14 17:58:43 发布

little_胖

最新推荐文章于 2024-09-14 17:58:43 发布

阅读量1k

点赞数

分类专栏：框架文章标签： springmvc spring mybatis maven

本文链接：https://blog.csdn.net/wangjie_wang/article/details/38177947

版权

框架专栏收录该内容

2 篇文章 0 订阅

订阅专栏

一、首先我们先要做点前期准备工作：将测试用的数据表先建好

CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uname` varchar(50) NOT NULL,
  `upassword` varchar(50) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

二、将三个框架所需要的包都导入进来，既在pom.xml文件中添加依赖：

<dependencies>

      <!--log4j-->
      <dependency>
          <groupId>log4j</groupId>
          <artifactId>log4j</artifactId>
          <version>1.2.15</version>
      </dependency>

      <!--mysql-->
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>3.1.14</version>
      </dependency>

     <!--mybatis-->
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.2.0</version>
      </dependency>
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.2.1</version>
      </dependency>

      <!--spring-->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context</artifactId>
          <version>3.1.1.RELEASE</version>
      </dependency>

      <!--spring-jdbc-->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>3.1.1.RELEASE</version>
      </dependency>

      <!--springMvc-->
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-webmvc</artifactId>
          <version>3.1.1.RELEASE</version>
      </dependency>


      <!-- servlet jsp and jstl -->
      <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>3.0.1</version>
          <scope>provided</scope>
      </dependency>
      <dependency>
          <groupId>javax.servlet.jsp</groupId>
          <artifactId>jsp-api</artifactId>
          <version>2.0</version>
          <scope>provided</scope>
      </dependency>
      <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
      </dependency>

      <!--dbcp连接池-->
      <dependency>
          <groupId>commons-dbcp</groupId>
          <artifactId>commons-dbcp</artifactId>
          <version>1.2.2</version>
      </dependency>

    <!--junit-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>

  </dependencies>

三、在resources中添加各种配置文件

3.1添加jdbc.properties文件：

#数据库驱动
driver=com.mysql.jdbc.Driver
#需要连接的数据库
url=jdbc:mysql://localhost:3306/all_data
#用户名
user=root
#密码
password=

3.2添加mybatis核心文件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 type="pojo.User" alias="User" />
    </typeAliases>

    <!--加入映射文件-->
    <mappers>
        <mapper resource="mapper/User.xml" />
    </mappers>

</configuration>

映射文件中加入的是每个实体类的配置文件：

User.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">
<mapper namespace="UserDao">
    <select id="isExist" parameterType="User" resultType="int" >
        select count(*) from users where uname=#{uname} and upassword=#{upassword}
    </select>
</mapper>

3.3添加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:context="http://www.springframework.org/schema/context"
       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.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
		http://www.springframework.org/schema/tx   http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">
    <!--default-autowire="byType"-->
    <!--引用jdbc文件-->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations" value="classpath:jdbc.properties" />
    </bean>

    <!--数据源-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${url}" />
        <property name="username" value="${user}" />
        <property name="password" value="${password}" />
    </bean>

    <!--sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--指定用到的连接池-->
        <property name="dataSource" ref="dataSource"/>
        <!--指定mybatis的核心文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml" />
    </bean>

    <!--sqlSession-->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory" />
    </bean>

    <!--扫描的包-->
    <context:component-scan base-package="*" />

    <!--若有相同类型的两个bean，这注入时会异常-->

</beans>

加入springMvc的配置文件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:tx="http://www.springframework.org/schema/tx"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        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/mvc
    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">


    <!--<mvc:annotation-driven />-->
    <!--<context:component-scan base-package="controller" />-->

    <!--配置JSP页面-->
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver" >
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>
    <!-- 自动扫描包，可以写多个 -->
    <!--<context:component-scan base-package="*" ></context:component-scan>-->

</beans>

注意：我测试了一下，控制层的扫描只有在spring-servlet中写才有用，而DAO层和Service层随便在哪个配置文件（ApplicationContext和spring-servlet）中写都可以。

四、在web.xml文件中启动springMvc的配置和spring的配置：

 <!-- Spring MVC配置 -->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!-- 可以自定义servlet.xml配置文件的位置和名称，默认为WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，如spring-servlet.xml-->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-servlet.xml</param-value>
        </init-param>

        <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>

    <!--加载spring的配置文件-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:ApplicationContext.xml</param-value>
    </context-param>

五、各个配置文件都写好了之后，我们就可以开始写类了：

下面是我最后都写好的包结构：

5.1首先，我先把三个jsp页面写了，index.jsp用来登陆，err.jsp和suc.jsp分别是登陆失败和登陆成功的页面：

index.jsp：

<html>
<body>
<form method="post" action="login.do">
    username:<input name="username" type="text"><br/>
    password:<input name="password" type="password"><br/>
    <input type="submit">
</form>
</body>
</html>

err.jsp：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title></title>
</head>
<body>
It's Error!
</body>
</html>

suc.jsp：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title></title>
</head>
<body>
It's OK!
</body>
</html>

5.2写与数据库中对应的实体类User：

package pojo;

import java.lang.String;

public class User {
    private int uid;
    private String uname;
    private String upassword;

    public int getUid() {
        return uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getUpassword() {
        return upassword;
    }

    public void setUpassword(String upassword) {
        this.upassword = upassword;
    }
}

5.3然后将UserDao和UserDaoImpl写了：

UserDao：

package dao.inter;

import pojo.User;

public interface UserDao {
    public int isExis(User user);
}

UserDaoImpl：

package dao.impl;

import dao.inter.UserDao;
import org.apache.ibatis.session.SqlSession;
import org.springframework.stereotype.Repository;
import pojo.User;

import javax.annotation.Resource;

/**
 * Created by jaky.wang on 2014/7/27.
 */
@Repository
public class UserDaoImpl implements UserDao {

    @Resource
    private SqlSession sqlSession;

    @Override
    public int isExis(User user) {
        return (Integer)sqlSession.selectOne("UserDao.isExist",user);
    }
}

5.3开始写service吧：

UserServiceInter:

package service.inter;

import pojo.User;

/**
 * Created by jaky.wang on 2014/7/27.
 */
public interface UserServiceInter {
    public boolean isExist(User user);
}

UserServiceImpl:

package service.impl;

import dao.inter.UserDao;
import org.springframework.stereotype.Service;
import pojo.User;
import service.inter.UserServiceInter;

import javax.annotation.Resource;

/**
 * Created by jaky.wang on 2014/7/27.
 */
@Service
public class UserServiceImpl implements UserServiceInter {

    @Resource
    private UserDao userDao;

    @Override
    public boolean isExist(User user) {
        if (userDao.isExis(user) == 1) {
            return true;
        }
        return false;
    }
}

5.4最后我们就可以写控制层了：

LoginController：

package controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import pojo.User;
import service.inter.UserServiceInter;

import javax.annotation.Resource;

@Controller
@RequestMapping("/")
public class LoginController {

    @Resource
    private UserServiceInter userService;

    @RequestMapping("login.do")
    public String login(@RequestParam("username")String username, @RequestParam("password")String password) {
        User user = new User();
        user.setUpassword(password);
        user.setUname(username);
        if (userService.isExist(user)) {
            return "suc";
        }
        return "err";

    }

}

六、大功告成，现在就将工程打包部署到Tomcat上去试试吧。

这里只是做了最基础的整合，后面对其中的各种配置还会继续学习，敬请期待哟。