MyBatis入门教程-优快云博客

本文链接：https://blog.youkuaiyun.com/meililiuwei/article/details/9838107

1，下载jar 包，从 http://code.google.com/p/mybatis/ 中下载 mybatis-3.2.2.jar ，在网上下载 cglib-nodep-2.2.3.jar

2，因为仅测试mybatis ，所以本测试使用 servlet配置，servlet+Mybatis+oracle

3，整理代码

1. 在myeclipse 中创建web 项目，并引入 jar 包， mybatis-3.2.2.jar ,cglib-nodep-2.2.3.jar ,ojdbc14.jar

如图：

2. 创建mybatis 配置文件 mybatis-configuration.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>
   <settings>
	  <setting name="cacheEnabled" value="true"/>
	  <setting name="lazyLoadingEnabled" value="true"/>
	  <setting name="multipleResultSetsEnabled" value="true"/>
	  <setting name="useColumnLabel" value="true"/>
	  <setting name="useGeneratedKeys" value="false"/>
	  <setting name="autoMappingBehavior" value="PARTIAL"/>
	  <setting name="defaultExecutorType" value="SIMPLE"/>
	  <setting name="defaultStatementTimeout" value="25"/>
	  <setting name="safeRowBoundsEnabled" value="false"/>
	  <setting name="mapUnderscoreToCamelCase" value="false"/>
	  <setting name="localCacheScope" value="SESSION"/>
	  <setting name="jdbcTypeForNull" value="OTHER"/>
	  <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
  </settings>
  <!-- 
   1. <typeAlias type="com.test.mybatis.bean.SysUser" alias="SysUser"/>  
  	   Java 类型指定别名，可以在 XML 文件中用别名取代 Java 类的全限定名，
  	   		typeAlias 标签 指定单个java类，即直接使用SysUser
   2. <package name="com.test.mybatis.bean"/>
   	   Java 类型指定别名，可以在 XML 文件中用别名取代 Java 类的全限定名,
   	   		package 标签指定包下所有的类名  即别名，不用使用全限定名
   -->
  <typeAliases >
   <typeAlias type="com.test.mybatis.bean.SysUser" alias="SysUser"/>
  </typeAliases>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@192.168.1.141:1521:orcl"/>
        <property name="username" value="xxx"/>
        <property name="password" value="xxx"/>
      </dataSource>
    </environment>
  </environments>
 
  <mappers>
    <mapper resource="com/test/mybatis/mapper/UserMapper.xml"/>
  </mappers>
   
</configuration>

3. 创建对应的实体po SysUser.java ,

package com.test.mybatis.bean;

import java.io.Serializable;

public class SysUser implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private Long userId;
	private String userName;
	private String passWd;
	private String realName;
	private String lockState;
	public Long getUserId() {
		return userId;
	}
	public void setUserId(Long userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getPassWd() {
		return passWd;
	}
	public void setPassWd(String passWd) {
		this.passWd = passWd;
	}
	public String getRealName() {
		return realName;
	}
	public void setRealName(String realName) {
		this.realName = realName;
	}
	public String getLockState() {
		return lockState;
	}
	public void setLockState(String lockState) {
		this.lockState = lockState;
	}
	
}

4. 创建接口文件 UserMapper.java 和接口实现的配置文件 UserMapper.xml,

UserMapper.java

package com.test.mybatis.mapper;

import java.util.List;

import com.test.mybatis.bean.SysUser;

public interface UserMapper {
	public List<SysUser> load(Long userid);
	public List<SysUser> getUsers(SysUser user);
}

UserMapper.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="com.test.mybatis.mapper.UserMapper">
<resultMap type="SysUser" id="user">
<result column="USERID"  property="userId"/>
<result column="USERNAME" property="userName"/>
<result column="PASSWD" property="passWd"/>
<result column="REALNAME" property="realName" />
<result column="LOCKSTATE"  property="lockState"/>
</resultMap>
<select id="load" resultMap="user" parameterType="java.io.Serializable">
SELECT * FROM SYSUSER WHERE USERID = #{id}
</select>
<select id="getUsers" resultMap="user" parameterType="SysUser">
	SELECT * FROM SYSUSER WHERE  1=1
	<if  test=" userName != null and userName != '' ">
		and userName like CONCAT(CONCAT('%', #{name}),'%')  
	</if>
</select>
</mapper>

5. 配置 web.xml ，

<?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">
	<servlet>
		<servlet-name>test</servlet-name>
		<servlet-class>com.test.servlet.TestServlet</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>test</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	<listener>
		<display-name>frameInit</display-name>
		<listener-class>com.test.cache.FrameInitListener</listener-class>
	</listener>
	<listener>
		<display-name>mybatis</display-name>
		<listener-class>com.test.cache.MybatisListiner</listener-class>
	</listener>
	<welcome-file-list>
	    <welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

6，创建监听程序 FrameInitListener ，MybatisListiner , 初始化测试框架和 mybatis 框架

7，创建请求页面 index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    <form action="test.do?method=user" method="post">
    	<table id="t1" border="1px">
    		<tr>
    			<td>用户名 </td>
    			<td><input type="text" name="username" id="username"></td>
    			<td>密码</td>
    			<td><input type="password" name="pwd" id="pwd"></td>
    			<td><input type="submit" value="登陆"> </td>
    			<td><input type="reset" value="重置"></td>
    		</tr>
    	</table>	
    </form>
  </body>
</html>

8. 创建处理请求的servlet 文件名 TestServlet.java

package com.test.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.List;

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

import org.apache.ibatis.session.SqlSession;

import com.test.factroy.SessionFactory;
import com.test.mybatis.bean.SysUser;
import com.test.mybatis.mapper.UserMapper;

public class TestServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	SessionFactory factory = new SessionFactory();
	public void doGet(HttpServletRequest request,
			HttpServletResponse response)
			throws ServletException, IOException {
			System.out.println(" 请求get 成功   ");
			service(request, response);
			
	}
	protected void doPost(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
			System.out.println(" 请求post 成功   ");
			service(req, res);
	}

	protected void service(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		String method = req.getParameter("method");
		res.setContentType("text/html;charset=utf-8"); 
		System.out.println("调用service 标记 "+method);
		SqlSession session = factory.getSession();
		UserMapper mapper = session.getMapper(UserMapper.class);
		List<SysUser> list = mapper.load(1811L);
		Iterator<SysUser> it = list.iterator();
		while(it.hasNext()){
			SysUser user = it.next();
			PrintWriter out = res.getWriter();
			out.print("username=="+user.getUserName()+"---realname=="+user.getRealName());
			System.out.println("username=="+user.getUserName()+"---realname=="+user.getRealName());
			out.flush();
		}
		
		session.commit();
		session.close();
	}
}

9. 测试项目源码

http://download.youkuaiyun.com/detail/meililiuwei/5892685