MyBatis工作流程图
实例代码:
1:创建一个用户类
- package com.org.mybatis.entity;
- import java.io.Serializable;
- import javax.xml.crypto.Data;
- public class User implements Serializable {
- private static final long serialVersionUID = 1L;
- private String id;
- private String name;
- private String password;
- private Data createdate;
- .....
- }
2:创建一个用户接口
- package com.org.mybatis.entity;
- import com.org.mybatis.entity.User;
- public interface UserInterface {
- User getUser(int id);
- }
- }
3:创建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.org.mybatis.service.UserInterface">
<select id="getUser" parameterType="int" resultType="com.org.mybatis.entity.User">
select * from ls_user where id=#{id}
</select>
</mapper>
4:创建xml配置文件(数据库的链接和导入xml映射文件)
- <?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
<environments default="environment">
<environment id="environment">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://127.0.01:3306/dome" />
<property name="username" value="root" />
<property name="password" value="123456" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/org/mybatis/mapper/user.xml" />
</mappers>
</configuration>
5:测试
- import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import com.org.mybatis.entity.User;
import com.org.mybatis.service.UserInterface;
import com.org.mybatis.url.UrlDome; - public class UserDome {
private static SqlSessionFactoryBuilder sessionFactoryBuilder;
private static SqlSessionFactory sessionFactory;
private static SqlSession session;
private static InputStream is; - static{
sessionFactoryBuilder=new SqlSessionFactoryBuilder();
is = UserDome.class.getClassLoader().getResourceAsStream(UrlDome.SQL_CONFIG);
sessionFactory=sessionFactoryBuilder.build(is);
session = sessionFactory.openSession();
} - /**第一种写法:
* 该方法的使用需要在user.xml配置文件的mapper 设置为user.xml所在的路径
* 比如:<mapper namespace="com.org.mybatis.mapper.user">
* **/
public static void test1(){
try {
String statement = "com.org.mybatis.mapper.user.getUser";
User user = session.selectOne(statement, 1);
System.out.println(user.getName());
} finally {
session.close();
}
}
/**第二种写法:
* 该方法的使用需要在user.xml配置文件的mapper 设置为UserInterface就所在的包
* 比如:<mapper namespace="com.org.mybatis.service.UserInterface">
* **/
public static void test2(){
try {
UserInterface userMapper=session.getMapper(UserInterface.class);
User user=userMapper.getUser(1);
System.out.println(user.getName());
} finally {
session.close();
}
} - public static void main(String[] args) {
test2();
}
}