SpringMVC+Ibatis框架搭建

最新推荐文章于 2016-07-05 15:10:05 发布

wangbiao007

最新推荐文章于 2016-07-05 15:10:05 发布

阅读量4.2k

点赞数 1

分类专栏：框架整合文章标签： spring mvc iabtis

本文链接：https://blog.csdn.net/wangbiao007/article/details/51106464

版权

框架整合专栏收录该内容

2 篇文章 0 订阅

订阅专栏

这是一个很简单的SpringMVC+Spring+Ibatis框架 ,下图是文件的基本配置

web.xml

在web.xml中配置两个氢气，一个是SpringMVC的DispacherServlet,一个是Spring的ContextLoaderListener。

DispacherServlet负责初始化的上下文是和SpringMVC有关的bean，比如handlerMapping,handlerAdapter,viewResolve,ContextLoaderListener负责初始化的上下文是Spring有关的bean,比如dao，service

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
	<display-name></display-name>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
	
	<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*:com/springmvcibatis/config/ControllerApplicationContext.xml</param-value>
		</init-param>
	</servlet>
	
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
                      classpath*:com/springmvcibatis/config/IbatisApplicationContext.xml
                      classpath*:com/springmvcibatis/config/ServiceApplicationContext.xml
            </param-value>
	</context-param>
	
	<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>

ControllerApplicationContext.xml

SpringMVC的相关配置和controller层的配置在这个文件中

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     
    xmlns="http://www.springframework.org/schema/beans"    
    xmlns:mvc="http://www.springframework.org/schema/mvc"    
    xmlns:context="http://www.springframework.org/schema/context"    
    xmlns:aop="http://www.springframework.org/schema/aop"    
    xmlns:tx="http://www.springframework.org/schema/tx"    
    xsi:schemaLocation="http://www.springframework.org/schema/beans   
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
        http://www.springframework.org/schema/mvc  
        http://www.springframework.org/schema/mvc/spring-mvc-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   
        http://www.springframework.org/schema/tx   
        http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"> 
        
        <!-- HandlerMapping 解析url，找到执行该url的action-->
        <bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
               <property name="mappings">
                              <props>
                                     <prop key="/login.do">loginAction</prop>
                              </props>
               </property>
        </bean>
        
       
         <bean id="loginAction" class="com.springmvcibatis.controller.UserAction">
                   <property name="methodNameResolver">
	                           <ref local="methodNameResolver"/>
	             </property>
         </bean>     
         
          <!--视图解析器-->  
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">  
            <!-- webroot到一指定文件夹文件路径 -->  
            <property name="prefix" value="/user/"/>  
            <!-- 视图名称后缀  -->  
            <property name="suffix" value=".jsp"/>  
        </bean>  
        <!-- 在url中对应具体的方法,通过m后面带的参数来确定方法 -->
	<bean id="methodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.ParameterMethodNameResolver">	
	            <property name="paramName"><value>m</value></property>   
		        <property name="defaultMethodName"><value>execute</value></property>
	</bean>
</beans>

ServiceApplicationContext.xml

Service层的配置，向Service层中注入DAO

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
          <bean  id="userService" class="com.springmvcibatis.service.UserService">
                   <property name="userDAO" ref="userDAO"></property>
          </bean>
</beans>

IbatisApplicationContext.xml

Ibatis配置和DAO的配置，这个ibatis层配置知道怎么配置，但里面的具体原理还是不太清楚，有时间弄弄吧

<?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"  
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">  
<!--数据源配置 这块用 mysql数据库 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/test" />
		<property name="username" value="root" />
		<property name="password" value="123456" />
	</bean>
	
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		  	   <property name="dataSource" ref="dataSource" />  
		       <property name="configLocation">
		           <value>classpath:com/springmvcibatis/config/SqlMapConfig.xml</value>
		       </property>
    </bean>
    
    <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">  
        <property name="sqlMapClient" ref="sqlMapClient"></property> 
    </bean>
    
    <bean id="userDAO" class="com.springmvcibatis.dao.UserDAOImp">
              <property name="sqlMapClientTemplate" ref="sqlMapClientTemplate"></property>
    </bean>

</beans>

SqlMapConfig.xml
每个dao对应的sql配置文件就在这里面集合，我这里只有一个dao，所以也就一个这个文件里面只配置了一个sql文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
 <sqlMapConfig>
        <sqlMap resource="com/springmvcibatis/pojo/UserSql.xml"/>
 </sqlMapConfig>

UserSql.xml

每个dao对应的sql配置文件,文件里面就是和增删查改有关的

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
 "http://www.ibatis.com/dtd/sql-map-2.dtd">
 <sqlMap>
          <typeAlias type="com.springmvcibatis.pojo.User" alias="User"/>
          <resultMap class="User" id="user">
                    <result property="id" column="id"></result>
                    <result property="username" column="username"></result>
                    <result property="password" column="password"></result>
          </resultMap>
          
          <select id="selectByName"  parameterClass="java.lang.String" resultMap="user">
                    select * from user where username=#username#;
          </select>
          
          <select id="selectList" resultMap="user">
                    select * from user;
          </select>
          <!-- 插入一条并返回主键id -->
          <insert id="insertUser" parameterClass="User" >
                   insert into user(username,password) values(#username#,#password#)
                   <selectKey resultClass="int" keyProperty="id">
                      select LAST_INSERT_ID() AS VALUE
                   </selectKey>
          </insert>
          
          <delete id="deleteUser" parameterClass="int">
                    delete from user where id=#id#;
          </delete>
 </sqlMap>

UserAction.java

contrller层

package com.springmvcibatis.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;

import com.springmvcibatis.pojo.User;
import com.springmvcibatis.service.UserService;

public class UserAction extends MultiActionController{
	/**
	 * 登陆
	 * @param request
	 * @param response
	 * @return
	 */
	public ModelAndView login(HttpServletRequest request,HttpServletResponse response){		
		String userName = request.getParameter("userName");
		String password = request.getParameter("password");
		UserService service = (UserService) this.getApplicationContext().getBean("userService");
		boolean result = service.selectUserByName(userName, password);
		String viewName = null;
		if(result){		
			viewName = "success";
		}else{
			viewName = "fail";
		}
		ModelAndView mv = new ModelAndView(viewName);
		return  mv;		
	}
	
	/**
	 * 注册
	 * @param request
	 * @param response
	 * @return
	 */
	public ModelAndView resign(HttpServletRequest request,HttpServletResponse response){		
		String userName = request.getParameter("userName");
		String password = request.getParameter("password");
		UserService service = (UserService) this.getApplicationContext().getBean("userService");
		User user = new User();
		user.setUsername(userName);
		user.setPassword(password);
		int i = service.insertUser(user);
		ModelAndView mv = new ModelAndView("success");
		return mv;
	}

}

UserService.java

service层

package com.springmvcibatis.service;

import java.util.List;

import com.springmvcibatis.dao.UserDAO;
import com.springmvcibatis.pojo.User;

public class UserService {
	 private UserDAO userDAO;

	public UserDAO getUserDAO() {
		return userDAO;
	}

	public void setUserDAO(UserDAO userDAO) {
		this.userDAO = userDAO;
	}
	
	public boolean selectUserByName(String userName,String password){
		List<User> list = userDAO.selectByName(userName);
		boolean result = false;
		if(list!=null&&list.size()>0){
			User user = list.get(0);
			if(password.equals(user.getPassword())){
				result = true;
			}
		}
		return result;
	}
	
	public int insertUser(User user){
		int id = userDAO.insertUser(user);
		return id;
	}
	
	public int deleteUser(int id){
		int result = userDAO.deleteUser(id);
		return result;
	}

}

UserDAO.java
dao接口

package com.springmvcibatis.dao;

import java.util.List;

import com.springmvcibatis.pojo.User;

public interface UserDAO {
	public List<User> selectByName(String userName);
	
	public int insertUser(User user);
	
	public List<User> selectList();
	
	public int deleteUser(int id);

}

UserDAOImp.java

dao的实现类，这个继承了SqlMapClientDaoSupport，还有一个构造方法

package com.springmvcibatis.dao;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.springmvcibatis.pojo.User;

public class UserDAOImp extends SqlMapClientDaoSupport implements UserDAO{
    
	public UserDAOImp(){
		super();
	}
	public List<User> selectByName(String userName) {
		List<User> list = (List<User>) getSqlMapClientTemplate().queryForList("selectByName", userName);
		return list;
	}

	public int insertUser(User user) {
		int id = (Integer) getSqlMapClientTemplate().insert("insertUser", user);
		return id;
	}

	public List<User> selectList() {
		List<User> list = getSqlMapClientTemplate().queryForList("selectList");
		return list;
	}

	public int deleteUser(int id) {
		int result = getSqlMapClientTemplate().delete("deleteUser", id);
		return result;
	}

}

User.java

pojo

package com.springmvcibatis.pojo;

public class User {
	private int id;
	private String username;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	

}

最近找工作找的挺郁闷的，真的怀疑自己的能力了，工作还没杀着落，昨天来将这个框架搭好了，已经快工作两年了还搞大学时候的事情，哎，只怪以前没有好好学习，现在也没好好学习，这篇文章没啥注释，挺过意不去的，其实ibatis的源码自己也没看，只知道怎么用，里面具体怎么走的还真不知道。主要是给菜鸟看的，也是对自己成长的一个记录，以后为围绕这个框架添砖加瓦的，还有AOP，事物管理之类的给加上。何时才能找到工作！！！