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
);
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实战入门】一、MyBatis操作入门的源码
Maven搭建Spring+Mybatis+MySql实例,具体过程和效果看博文 http://blog.csdn.net/evankaka/article/details/48784641
整合搭建Spring+SpringMVC+Mybatis+Maven+Mysql开发实例
一个相对简单但比较完整的基于spring+springmvc+mybatis+mysql+maven+eclipse的工程实例,适合初学者参考
基于SSM框架(Spring+SpringMVC+MyBatis) + Mysql数据库 + Tomcat7
使用环境:MyEclipse/Eclipse + Tomcat + MySQL。 使用技术:Spring MVC + Spring + MyBatis 或 JSP + Servlet + JavaBean + JDBC。 https://ymjin.blog.csdn.net/article/details/120785168
项目搭建实例、spring + mybatis + spring mvc + maven + mysql;有任何不懂的技术问题都可以联系我共同讨论
myeclipse+springmvc+spring+mybatis案例附带mysql数据库
系统后端基于SpringMVC+Spring+Hibernate框架,前端页面采用JQuery+Bootstrap等主流技术; 流程引擎基于Snaker工作流;表单设计器基于雷劈网WEB表单设计器。 系统主要功能有: >1.系统管理 >>系统管理包含有:基础...
Ajax+SpringMVC+Spring+Mybatis+MySql+js用户注册实例,具体过程和效果看博文:http://blog.csdn.net/evankaka/article/details/47023975
项目有maven搭建,整合dubbo+spring+springMvc+mybatis+Mysql,压缩包有两个项目分别是提供者和消费者两个项目,启动方式是打成WAR,在tomcat启动
Spring+SpringMVC+Mybatis+Mysql整合实例 ,具体效果和过程看博文 http://blog.csdn.net/evankaka/article/details/45790533
Maven搭建Spring+Mybatis+SpringMVC+MySql实例,具体效果和过程看博文 http://blog.csdn.net/evankaka/article/details/48785513
Springboot+MyBatis+mysql+jsp页面跳转详细示例
Spirng+SpringMVC+Maven+Mybatis+MySQL实例,eclipse+tomcat7+jdk1.7
Spring+Mybatis+SpringMVC+Maven+MySql项目搭建实例.zip
最完整的Spring+Mybatis+SpringMVC+MySql的搭建实例
ZooKeeper+dubbo+springMvc+Mybatis+Mysql实例,项目是由maven搭建的 整合Dubbo\spring\springMvc\Mybatis,整个压缩包中有两个项目分别是提供者和消费,启动方式是打成WAR形式放到tomcat中启动。
利用maven整合ssm框架,Spring+SpringMVC+Mybatis+Mysql整合实例