Heim > Java > javaLernprogramm > So verwenden Sie Mybatis zur Integration der Spring-Methodenfreigabe

So verwenden Sie Mybatis zur Integration der Spring-Methodenfreigabe

黄舟
Freigeben: 2017-09-02 10:43:56
Original
1318 Leute haben es durchsucht

In diesem Artikel wird hauptsächlich der Beispielcode für die Integration von Spring durch Mybatis vorgestellt. Freunde, die ihn benötigen, können sich auf

Andere benötigte Tools oder Technologien beziehen:

Projektmanagement-Tools: Maven

Front-End-WEB-Anzeige: JSP

Andere Frameworks: Spring, Spring MVC

Datenbank: Derby

Erstellen Sie eine neues Maven-Webprojekt

Maven-Abhängigkeiten:


<!-- Spring --> 
    <dependency> 
      <groupId>org.springframework</groupId> 
      <artifactId>spring-context</artifactId> 
      <version>4.0.0.RELEASE</version> 
    </dependency> 
    <dependency> 
      <groupId>org.springframework</groupId> 
      <artifactId>spring-webmvc</artifactId> 
      <version>4.0.0.RELEASE</version> 
    </dependency> 
    <dependency> 
      <groupId>org.springframework</groupId> 
      <artifactId>spring-tx</artifactId> 
      <version>4.0.0.RELEASE</version> 
    </dependency> 
    <dependency> 
      <groupId>org.springframework</groupId> 
      <artifactId>spring-jdbc</artifactId> 
      <version>4.0.0.RELEASE</version> 
    </dependency> 
    <!-- AspectJ --> 
    <dependency> 
      <groupId>org.aspectj</groupId> 
      <artifactId>aspectjrt</artifactId> 
      <version>1.6.10</version> 
    </dependency> 
    <!-- Logging --> 
    <dependency> 
      <groupId>org.slf4j</groupId> 
      <artifactId>slf4j-api</artifactId> 
      <version>1.6.6</version> 
    </dependency> 
    <dependency> 
      <groupId>org.slf4j</groupId> 
      <artifactId>jcl-over-slf4j</artifactId> 
      <version>1.6.6</version> 
      <scope>runtime</scope> 
    </dependency> 
    <dependency> 
      <groupId>org.slf4j</groupId> 
      <artifactId>slf4j-log4j12</artifactId> 
      <version>1.6.6</version> 
      <scope>runtime</scope> 
    </dependency> 
    <!-- @Inject --> 
    <dependency> 
      <groupId>javax.inject</groupId> 
      <artifactId>javax.inject</artifactId> 
      <version>1</version> 
    </dependency> 
    <!-- Servlet --> 
    <dependency> 
      <groupId>javax.servlet</groupId> 
      <artifactId>servlet-api</artifactId> 
      <version>2.5</version> 
      <scope>provided</scope> 
    </dependency> 
    <dependency> 
      <groupId>javax.servlet.jsp</groupId> 
      <artifactId>jsp-api</artifactId> 
      <version>2.1</version> 
      <scope>provided</scope> 
    </dependency> 
    <dependency> 
      <groupId>javax.servlet</groupId> 
      <artifactId>jstl</artifactId> 
      <version>1.2</version> 
    </dependency> 
    <!-- Mybatis --> 
    <dependency> 
      <groupId>org.mybatis</groupId> 
      <artifactId>mybatis</artifactId> 
      <version>3.2.7</version> 
    </dependency> 
    <dependency> 
      <groupId>org.mybatis</groupId> 
      <artifactId>mybatis-spring</artifactId> 
      <version>1.2.1</version> 
    </dependency> 
    <!-- Test --> 
    <dependency> 
      <groupId>junit</groupId> 
      <artifactId>junit</artifactId> 
      <version>4.9</version> 
      <scope>test</scope> 
    </dependency> 
    <!-- Derby --> 
    <dependency> 
      <groupId>org.apache.derby</groupId> 
      <artifactId>derby</artifactId> 
      <version>10.10.2.0</version> 
    </dependency> 
    <dependency> 
      <groupId>org.apache.derby</groupId> 
      <artifactId>derbyclient</artifactId> 
      <version>10.10.2.0</version> 
    </dependency>
Nach dem Login kopieren

SQL-Tabellenerstellung und Dateneinfügung


CREATE TABLE USER_TEST_TB(  
ID INT PRIMARY KEY,  
USERNAME VARCHAR(20) NOT NULL,  
PASSWORD VARCHAR(20) NOT NULL,  
NICKNAME VARCHAR(20) NOT NULL  
);    
INSERT INTO USER_TEST_TB VALUES(1,&#39;1st&#39;,&#39;111&#39;,&#39;Jack&#39;);  
INSERT INTO USER_TEST_TB VALUES(2,&#39;2nd&#39;,&#39;222&#39;,&#39;Rose&#39;);  
INSERT INTO USER_TEST_TB VALUES(3,&#39;3rd&#39;,&#39;333&#39;,&#39;Will&#39;);
Nach dem Login kopieren

web.xml (unter scr/main/webapp/WEB-INF)


<?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"> 
  <!-- Spring 的配置 --> 
  <context-param> 
    <param-name>contextConfigLocation</param-name> 
    <param-value>/WEB-INF/*Context.xml</param-value> 
  </context-param> 
  <listener> 
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 
  </listener> 
  <servlet> 
    <servlet-name>appServlet</servlet-name> 
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 
    <load-on-startup>1</load-on-startup> 
  </servlet> 
  <servlet-mapping> 
    <servlet-name>appServlet</servlet-name> 
    <url-pattern>/</url-pattern> 
  </servlet-mapping> 
</web-app>
Nach dem Login kopieren

appServlet-servlet.xml (Springs Servlet-Konfigurationsdatei scr/ main/webapp/WEB-INF)


<?xml version="1.0" encoding="UTF-8"?> 
<beans:beans xmlns="http://www.springframework.org/schema/mvc" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns:beans="http://www.springframework.org/schema/beans" 
  xmlns:context="http://www.springframework.org/schema/context" 
  xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.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.xsd"> 
  <!-- 开启Annotation支持 --> 
  <annotation-driven /> 
  <!-- Spring的渲染层配置 --> 
  <beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
    <beans:property name="prefix" value="/WEB-INF/views/" /> 
    <beans:property name="suffix" value=".jsp" /> 
  </beans:bean> 
  <!-- Spring的Annotation默认扫描包 --> 
  <context:component-scan base-package="com.bjpowernode.practice" /> 
  <!-- 引入其他Spring配置文件 --> 
  <beans:import resource="classpath:applicationContext.xml" /> 
</beans:beans>
Nach dem Login kopieren

JSP-Datei


show.jsp(src/main/webapp/WEB-INF/views目录下)
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" 
  pageEncoding="ISO-8859-1"%> 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> 
<title>Show All Users</title> 
<style type="text/css"> 
*{ 
margin: 0px; 
padding: 0px; 
} 
</style> 
</head> 
<body> 
  <table border="1px" bordercolor="green"> 
    <thead> 
      <tr> 
        <th>USER_NAME</th> 
        <th>PASSWORD</th> 
        <th>NICK_NAME</th> 
        <th>EDIT</th> 
        <th>DELETE</th> 
      </tr> 
      <c:forEach items="${users}" var="user" varStatus="status"> 
        <tr> 
          <td>${user.username}</td> 
          <td>${user.password}</td> 
          <td>${user.nickname}</td> 
          <td><a href="update/${user.id}" rel="external nofollow" >edit</a></td> 
          <td><a href="delete/${user.id}" rel="external nofollow" >delete</a></td> 
        </tr> 
      </c:forEach> 
    </thead> 
  </table> 
  <a href="insert" rel="external nofollow" >Add new User</a> 
</body> 
</html>
Nach dem Login kopieren

update.jsp( src/main/webapp/WEB-INF/views-Verzeichnis)


<%@ page language="java" contentType="text/html; charset=ISO-8859-1" 
  pageEncoding="ISO-8859-1"%> 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> 
<title>Update Profile</title> 
</head> 
<body> 
  <form action="${user.id}" method="post"> 
    User ID:${user.id}<br> 
    Username:<input type="text" name="username" value="${user.username}"/><br> 
    Password:<input type="text" name="password" value="${user.password}"/><br> 
    Nickname:<input type="text" name="nickname" value="${user.nickname}"/><br> 
    <input type="submit" value="submit"> 
  </form> 
</body> 
</html>
Nach dem Login kopieren

insert.jsp(src/main/webapp/WEB-INF/views-Verzeichnis)


<%@ page language="java" contentType="text/html; charset=ISO-8859-1" 
  pageEncoding="ISO-8859-1"%> 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> 
<title>Insert Profile</title> 
</head> 
<body> 
 
  <form action="" method="post"> 
    User Id:<input type="text" name="id"><br> 
    Username:<input type="text" name="username" /><br> 
    Password:<input type="text" name="password"/><br> 
    Nickname:<input type="text" name="nickname"/><br> 
    <input type="submit" value="submit"> 
  </form> 
</body> 
</html>
Nach dem Login kopieren

applicationContext.xml (Die Anwendungskonfigurationsdatei von Spring befindet sich im Verzeichnis src/main/resources)


<?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:aop="http://www.springframework.org/schema/aop" 
  xmlns:context="http://www.springframework.org/schema/context" 
  xmlns:lang="http://www.springframework.org/schema/lang" xmlns:mvc="http://www.springframework.org/schema/mvc" 
  xmlns:tx="http://www.springframework.org/schema/tx" 
  xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring" 
  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-4.0.xsd 
    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd 
    http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-4.0.xsd 
    http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd 
    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd 
    http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd"> 
  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
    <property name="basePackage" value="com.bjpowernode.practice" /> 
    <property name="sqlSessionFactoryBeanName" value="derbySqlSessionFactory" /> 
  </bean> 
  <!-- 配置Derby驱动数据源 --> 
  <bean id="derbyDataSource" 
    class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
    <property name="driverClassName" value="org.apache.derby.jdbc.ClientDriver" /> 
    <property name="url" value="jdbc:derby://localhost:1527/freud;create=true" /> 
  </bean> 
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" 
    name="derbySqlSessionFactory"> 
    <property name="dataSource" ref="derbyDataSource" /> 
    <property name="mapperLocations" value="classpath*:com/freud/practice/*Mapper.xml" /> 
  </bean> 
  <!-- 事务管理器 --> 
  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
    <property name="dataSource" ref="derbyDataSource" /> 
  </bean> 
  <!-- 开启基于注解的事务 --> 
  <tx:annotation-driven /> 
</beans>
Nach dem Login kopieren

Java-Datei

UserController.Java (im Verzeichnis src/main/java/com.bjpowernode.practice.controller)


package com.bjpowernode.practice.controller; 
import com.bjpowernode.practice.User; 
import com.bjpowernode.practice.UserMapper; 
import java.util.List; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Controller; 
import org.springframework.ui.Model; 
import org.springframework.web.bind.annotation.PathVariable; 
import org.springframework.web.bind.annotation.RequestMapping; 
import org.springframework.web.bind.annotation.RequestMethod; 
import org.springframework.web.servlet.config.annotation.EnableWebMvc; 
@EnableWebMvc 
@Controller 
public class UserController 
{ 
  @Autowired 
  private UserMapper userMapper; 
  /** 
   * 
   * 获得所有的User信息 
   * 
   * @param model 
   * @return 
   */ 
  @RequestMapping(value = {"/", ""}, method = RequestMethod.GET) 
  public String getAllUser(Model model) 
  { 
    List<User> users = userMapper.getUsers(); 
    System.out.println("Show all user size:" + users.size()); 
    model.addAttribute("users", users); 
    return "show"; 
  } 
  /** 
   * 
   * INSERT的GET请求,跳转到Insert的View即insert.jsp 
   * 
   * @return 
   */ 
  @RequestMapping(value = {"/insert", ""}, method = RequestMethod.GET) 
  public String insertUser() 
  { 
    return "insert"; 
  } 
  /** 
   * 
   * INSERT的POST请求,执行插入操作并返回ShowAll页面 
   * 
   * @param user 
   * @return 
   */ 
  @RequestMapping(value = {"/insert", ""}, method = RequestMethod.POST) 
  public String insertUserPOST(User user) 
  { 
    userMapper.insertUser(user); 
    return "redirect:/"; 
  } 
  /** 
   * 
   * UPDATE的GET请求,跳转到update的View即update.jsp 
   * 
   * @param id 
   * @param model 
   * @return 
   */ 
  @RequestMapping(value = {"/update/{id}", ""}, method = RequestMethod.GET) 
  public String updateUser(@PathVariable String id, Model model) 
  { 
    model.addAttribute("user", userMapper.getUser(Integer.valueOf(id))); 
    return "update"; 
  } 
  /** 
   * 
   * UPDATE的POST请求,执行更新操作并返回ShowAll页面 
   * 
   * @param id 
   * @param user 
   * @return 
   */ 
  @RequestMapping(value = {"/update/{id}", ""}, method = RequestMethod.POST) 
  public String updateUserPOST(@PathVariable String id, User user) 
  { 
    userMapper.updateUser(user); 
    return "redirect:/"; 
  } 
  /** 
   * 
   * 通过Id删除USER 
   * 
   * @param id 
   * @return 
   */ 
  @RequestMapping(value = {"/delete/{id}", ""}, method = RequestMethod.GET) 
  public String deleteUser(@PathVariable int id) 
  { 
    userMapper.deleteUser(id); 
    return "redirect:/"; 
  } 
}
Nach dem Login kopieren

Benutzer .java (in src/main/java/com.bjpowernode.practice)


package com.bjpowernode.practice; 
/** 
 * 
 * User 对象。 
 * 
 * @author Freud Kang 
 * 
 */ 
public class User 
{ 
  private Integer id; 
  private String username; 
  private String password; 
  private String nickname; 
  public Integer getId() 
  { 
    return id; 
  } 
  public void setId(Integer 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; 
  } 
  public String getNickname() 
  { 
    return nickname; 
  } 
  public void setNickname(String nickname) 
  { 
    this.nickname = nickname; 
  } 
}
Nach dem Login kopieren

UserMapper.java (in src/main/java /com.bjpowernode.practice Verzeichnis)


package com.bjpowernode.practice; 
import java.util.List; 
public interface UserMapper 
{ 
  /** 
   * 
   * 获得所有User 
   * 
   * @return 
   */ 
  public List<User> getUsers(); 
  /** 
   * 
   * 通过Id获得User 
   * 
   * @param id 
   * @return 
   */ 
  public User getUser(int id); 
  /** 
   * 
   * 插入User 
   * 
   * @param user 
   */ 
  public void insertUser(User user); 
  /** 
   * 
   * 更新User 
   * 
   * @param user 
   */ 
  public void updateUser(User user); 
  /** 
   * 
   * 通过Id删除User 
   * 
   * @param userId 
   */ 
  public void deleteUser(int userId); 
}
Nach dem Login kopieren

UserMapper.xml (Mybatis-Mapper-Konfigurationsdatei, im Verzeichnis src/main/java/com.bjpowernode.practice unten)


<?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.bjpowernode.practice.UserMapper"> 
  <!-- 查询 --> 
  <select id="getUsers" resultType="com.bjpowernode.practice.User"> 
    select * 
    from USER_TEST_TB 
  </select> 
  <!-- 查询 --> 
  <select id="getUser" resultType="com.bjpowernode.practice.User"> 
    select * 
    from USER_TEST_TB 
    where ID=#{id} 
  </select> 
  <!-- 插入 --> 
  <insert id="insertUser"> 
    insert into  
      USER_TEST_TB  
    values(#{id},#{username},#{password},#{nickname}) 
  </insert> 
  <!-- 更改 --> 
  <update id="updateUser"> 
    update USER_TEST_TB set 
      USERNAME = #{username}, 
      PASSWORD = #{password}, 
      NICKNAME = #{nickname} 
    where ID = #{id} 
  </update> 
  <!-- 删除 --> 
  <delete id="deleteUser"> 
    delete from USER_TEST_TB where ID=#{id} 
  </delete> 
</mapper>
Nach dem Login kopieren

Zusammenfassung

Das obige ist der detaillierte Inhalt vonSo verwenden Sie Mybatis zur Integration der Spring-Methodenfreigabe. Für weitere Informationen folgen Sie bitte anderen verwandten Artikeln auf der PHP chinesischen Website!

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage