spring + mybatis +mysql入门范例

spring + mybatis +mysql入门实例
0 – prepare

    安装 : STS 2.9.1.RELEASE， mysql等
    在STS中新建一个spring template project – spring MVC project即可

1 – create db

 create table user  ( id int NOT NULL primary key auto_increment,  name varchar(20) NOT NULL,  age int NOT NULL ); 

欢迎大家阅读《spring + mybatis +mysql入门范例》,跪求各位点评，by 搞代码

 insert into user (name, age) values ("name1", 11) 

2 – POJO

 package com.xx.test.dao;  import java.io.Serializable;  public class User implements Serializable {   private static final long serialVersionUID = -433577178466098132L;  private int id;  private String name;  private int age;    public int getId() {   return id;  }  public void setId(int id) {   this.id = id;  }  public String getName() {   return name;  }  public void setName(String name) {   this.name = name;  }  public int getAge() {   return age;  }  public void setAge(int age) {   this.age = age;  } } 

3 – mapper（使用注解，不用xml配置文件）

 package com.xx.test.dao;  import java.util.List;  import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select;  public interface UserMapper {    @Insert("INSERT into user (name, age) VALUES (#{name}, #{age})")  public void insertUser(User user);    @Select("SELECT * from user  WHERE id = #{id}")  public User getUser(@Param("id") int id);    @Select("SELECT * from user")  public List<User> getAllUser(); } 

4 – mybatis-context.xml

  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>   <property name="url" value="jdbc:mysql://localhost:3306/mytest" />   <property name="username" value="root" />   <property name="password" value="admin" />  </bean>      <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean>        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource" />    </bean>        <!-- mapper bean -->    <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">        <property name="mapperInterface" value="com.xx.test.dao.UserMapper" />        <property name="sqlSessionFactory" ref="sqlSessionFactory" />    </bean> 

5 – 修改web.xml，加上mybatis-context

  <servlet>   <servlet-name>appServlet</servlet-name>   <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>   <init-param>    <param-name>contextConfigLocation</param-name>    <param-value>     /WEB-INF/spring/appServlet/servlet-context.xml,     /WEB-INF/classes/mybatis-context.xml,    </param-value>   </init-param>   <load-on-startup>1</load-on-startup>  </servlet> 

6 – 修改pom.xml （修改完后用maven下载依赖的jar包）

   <!-- mybatis -->    <dependency>    <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>1.1.1</version>   </dependency>          <!-- mysql -->      <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.21</version>        </dependency> 

7 – test

   List<User> users = userMapper.getAllUser();   for(User u : users) {    System.out.println(u.getName()+", id >> "+u.getId());   }   System.out.println("----------insert before-------");   User u = new User();   u.setName("insertUser");   u.setAge(22);   userMapper.insertUser(u);   System.out.println("----------insert end-------"); 

喜欢 (0)赏

[搞代码]

分享 (0)