ibatis又名(mybatis)使用方法,针对jdbc的封装
来源:互联网 发布:mac dmg u盘装系统 编辑:程序博客网 时间:2024/05/16 04:36
1.先导入包到项目lib文件夹中;
3.编写映射文件:
2.在src根目录文件中建立:SqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><typeAliases><typeAlias type="cn.com.leadfar.cms.backend.model.Admin" alias="Admin"/><typeAlias type="cn.com.leadfar.cms.backend.model.Article" alias="Article"/></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/wuyanwen" /><property name="username" value="wuyanwen" /><property name="password" value="wuyanwen" /></dataSource></environment> </environments><mappers><mapper resource="cn/com/leadfar/cms/backend/dao/impl/Admin.xml" /><mapper resource="cn/com/leadfar/cms/backend/dao/impl/Article.xml" /></mappers></configuration>
3.编写映射文件:
Admin.xml文件
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="cn.com.leadfar.cms.backend.model.Admin"><insert id="add" parameterType="Admin">insert into t_admin (username,password) values (#{username},#{password})</insert><select id="findAdminByUsername" parameterType="string" resultType="Admin">select * from t_admin where username = #{username}</select></mapper>
4.利用ibatisAPI文档直接拿来使用:package cn.com.leadfar.cms.backend.dao.impl;import org.apache.ibatis.session.SqlSession;import cn.com.leadfar.cms.backend.dao.AdminDao;import cn.com.leadfar.cms.backend.model.Admin;import cn.com.leadfar.cms.utils.MyBatisUtil;public class AdminDaoForMyBatisImpl extends BaseDao implements AdminDao {public void addAdmin(Admin admin) {add(admin);}public Admin findAdminByUsername(String username) {//打开一个sessionSqlSession session = MyBatisUtil.getSession();Admin admin = null;try {admin = (Admin)session.selectOne(Admin.class.getName()+".findAdminByUsername", username);} catch (Exception e) {e.printStackTrace();} finally{//关闭sessionsession.close();}return admin;}}5.leadfar.cms.utilspackage cn.com.leadfar.cms.utils;import java.io.IOException;import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MyBatisUtil {static SqlSessionFactory factory = null;static{try {//通过配置文件,创建工厂对象Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");factory = new SqlSessionFactoryBuilder().build(reader);} catch (IOException e1) {e1.printStackTrace();}}public static SqlSession getSession(){return factory.openSession();}}
- ibatis又名(mybatis)使用方法,针对jdbc的封装
- 针对JDBC的简单封装
- JDBC使用方法的封装
- Jdbc&Hibernate&MyBatis&IBatis
- 针对mybatis的理解
- 从一次查询看MyBatis对JDBC的封装
- iBATIS缓存的使用方法
- 破损的键盘(又名:悲剧文本)
- 利用Java针对MySql封装的jdbc框架类 JdbcUtils 完整实现
- ibatis与mybatis区别,hibernate、mybatis、JDBC区别
- ibatis与mybatis区别,hibernate、mybatis、JDBC区别
- ibatis与mybatis区别?Hibernate、MyBatis、JDBC区别?
- mybatis(ibatis)框架
- ibatIS学习笔记---Ibatis的基本使用方法
- 针对JSON的封装操作
- 针对recyclerView的adapter封装
- jdbc、Hibernate、ibatis的区别
- SqlMapClientTemplate对Ibatis的封装
- WIN7下VC++6.0打开文件出错
- Android环境下直接测试驱动 | 链接的目录视图包括很多嵌入式驱动技术 | 不错
- 一口一口吃掉Struts(八)——四种forward
- linux install 命令
- c#播放音频文件
- ibatis又名(mybatis)使用方法,针对jdbc的封装
- TCP连接的终止----被动关闭
- UML类图几种关系的总结
- poj 1941-递归
- How to Audit the Top 10 Oracle E-Business Suite Security Risks
- 如何与陌生人交谈的技巧
- LinkedHashMap源码分析(基于JDK1.6
- Yii 多个子站同时登录
- 学会正确审视自己