myBatis系列之一:搭建开发环境
来源:互联网 发布:孙俪淘宝店铺名 编辑:程序博客网 时间:2024/05/21 22:53
1. pom.xml文件中加入mybatis和数据库依赖,这里使用mysql:
2. 在类路径下创建mybatis的配置文件Configuration.xml
3. 执行创建数据库和表的sql:
4. com.john.hbatis.model.User类:
com/john/hbatis/model路径下的User.xml
5. 测试类:
- <properties>
- <mybatis.version>3.2.3</mybatis.version>
- <mysql.version>5.1.26</mysql.version>
- <slf4j.api.version>1.7.5</slf4j.api.version>
- <testng.version>6.8.7</testng.version>
- </properties>
- <dependencies>
- <dependency>
- <groupId>org.mybatis</groupId>
- <artifactId>mybatis</artifactId>
- <version>${mybatis.version}</version>
- </dependency>
- <!-- Database driver -->
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>${mysql.version}</version>
- </dependency>
- <!-- mybatis启动要加载log4j -->
- <dependency>
- <groupId>org.slf4j</groupId>
- <artifactId>slf4j-log4j12</artifactId>
- <version>${slf4j.api.version}</version>
- </dependency>
- <!-- Test -->
- <dependency>
- <groupId>org.testng</groupId>
- <artifactId>testng</artifactId>
- <version>${testng.version}</version>
- </dependency>
- </dependencies>
2. 在类路径下创建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>
- <typeAliases><!-- 别名 -->
- <typeAlias alias="User" type="com.john.hbatis.model.User" />
- </typeAliases>
- <environments default="development">
- <environment id="development">
- <transactionManager type="JDBC"/>
- <dataSource type="POOLED"><!-- 数据源 -->
- <property name="driver" value="com.mysql.jdbc.Driver" />
- <property name="url" value="jdbc:mysql://localhost:3306/hbatis" />
- <property name="username" value="root" />
- <property name="password" value="123456" />
- </dataSource>
- </environment>
- </environments>
- <mappers><!-- ORM映射文件 -->
- <mapper resource="com/john/hbatis/model/User.xml" />
- </mappers>
- </configuration>
3. 执行创建数据库和表的sql:
- -- Create the database named 'hbatis'.
- -- It's OK to use `, not OK to use ' or " surrounding the database name to prevent it from being interpreted as a keyword if possible.
- CREATE DATABASE IF NOT EXISTS `hbatis`
- DEFAULT CHARACTER SET = `UTF8`;
- -- Create a table named 'User'
- CREATE TABLE `user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT NULL,
- `age` int(11) DEFAULT NULL,
- `address` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- -- Insert a test record
- Insert INTO `user` VALUES ('1', 'john', '120', 'hangzhou,westlake');
4. com.john.hbatis.model.User类:
- public class User {
- private int id;
- private String name;
- private String age;
- private String address;
- // Getters and setters are omitted
- // 如果有带参数的构造器,编译器不会自动生成无参构造器。当查询需要返回对象时,ORM框架用反射来调用对象的无参构造函数,导致异常:java.lang.NoSuchMethodException: com.john.hbatis.model.User.<init>()
- // 这时需要明确写出:
- public User() {
- }
- public User(String name, int age, String address) {
- this.name = name;
- this.age = age;
- this.address = address;
- }
- }
com/john/hbatis/model路径下的User.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.john.hbatis.model.UserMapper">
- <select id="getUserById" parameterType="int" resultType="User">
- select * from `user` where id = #{id}
- </select>
- </mapper>
5. 测试类:
- public class MyBatisBasicTest {
- private static final Logger log = LoggerFactory.getLogger(MyBatisBasicTest.class);
- private static SqlSessionFactory sqlSessionFactory;
- private static Reader reader;
- @BeforeClass
- public static void initial() {
- try {
- reader = Resources.getResourceAsReader("Configuration.xml");
- sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
- } catch (IOException e) {
- log.error("Error thrown while reading the configuration: {}", e);
- } finally {
- if (reader != null) {
- try {
- reader.close();
- } catch (IOException e) {
- log.error("Error thrown while closing the reader: {}", e);
- }
- }
- }
- }
- @Test
- public void queryTest() {
- SqlSession session = sqlSessionFactory.openSession();
- User user = (User)session.selectOne("com.john.hbatis.model.UserMapper.getUserById", 1);
- log.info("{}: {}", user.getName(), user.getAddress());
- }
- }
0 0
- myBatis系列之一:搭建开发环境
- orm-mybatis开发系列之一:环境搭建
- mybatis基础教程之一:开发环境搭建
- Mybatis实战教程之一开发环境搭建
- JAVA学习系列之一-搭建开发环境
- mybatis实战教程(mybatis in action)之一:开发环境搭建
- mybatis实战教程(mybatis in action)之一:开发环境搭建
- mybatis实战教程(mybatis in action)之一:开发环境搭建
- mybatis实战教程(mybatis in action)之一:开发环境搭建
- mybatis实战教程(mybatis in action)之一:开发环境搭建
- Cordova系列之一开发环境搭建(windows)
- 【ExtJs3】系列之一:环境搭建
- mybatis 开发环境搭建
- MyBatis开发环境搭建
- mybatis开发环境搭建
- MyBatis开发环境搭建
- mybatis开发环境搭建
- 搭建maven+spring+freemaker+mybatis环境之一
- <many to one>和<one to many>
- linux命令
- 论用可变可联数组模拟人类大脑运算模式(二)无算法计算的实现
- 利用MyBatis的动态SQL特性抽象统一SQL查询接口
- 如何为TableLayout添加边框
- myBatis系列之一:搭建开发环境
- Java内存分配原理精讲
- backtrace函数的原理
- php获取地址栏信息
- Linkers and Loaders
- memcached 第二篇----安装使用
- 黑马训练营--String和StringBuffer(重点中的重点,一定要背的出来)
- myBatis系列之二:以接口方式交互数据
- (Manual) GoLang之参考文档