mybatis小案例

 

 

db-config.properties

db.driveName=com.mysql.jdbc.Driver

db.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8

db.name=root

db.pwd=root

 

mybatis.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">

<!--

一个mybatis的全局配置文件

现在需要我们配置的有：pool中连接数据库配置

-->

<configuration>

<properties resource="config/db-config.properties"></properties>

<environments default="development">

<environment id="development">

<transactionManager type="JDBC"/>

<dataSource type="POOLED">

<property name="driver" value="${db.driveName}"/>

<property name="url" value="${db.url}"/>

<property name="username" value="${db.name}"/>

<property name="password" value="${db.pwd}"/>

</dataSource>

</environment>

</environments>

<!--引入单个实体的orm映射-->

<mappers>

<mapper resource="config/User.xml"/>

</mappers>

</configuration>

 

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.szt.User">

<!--

id:功能的唯一标识

parameterType:传给通配的参数类型

resultType:最后返回实体类型

#{}等价于原来的？通配

-->

<select id="User" resultType="com.szt.User" parameterType="String">

select * from user where id = #{id}

</select>

</mapper>

 

Test.java

public class Test {

public static void main(String[] args) throws IOException {

//基于全局配置文件，加载一个SqlSessionFactory对象

String resource="config/mybatis.xml";

InputStream inputStream=Resources.getResourceAsStream(resource);

SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);

//从SqlSessionFactory中获取SqlSession

SqlSession session =sqlSessionFactory.openSession();

User user= session.selectOne("User","111");

System.out.println(user);

session.close();

}

}