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-------"); 

原创文章,转载请注明: 转载自搞代码

本文链接地址: spring + mybatis +mysql入门范例

微信支付二维码

微信 赏一包辣条吧~

支付宝支付二维码

支付宝 赏一听可乐吧~

评论

0条评论

发表评论

电子邮件地址不会被公开。 必填项已用*标注