mybatis入门操作

test.java:

package com.dqd.mybatis; import java.io.IOException; public class test { public static void main(String[] args) throws IOException { mybatis mb = new mybatis(); //mb.fingUserByIdTest(); //mb.insertUser(); //mb.deleteUser(); mb.updateUser(); } }

mybatis.java:

package com.dqd.mybatis; import java.io.IOException; import java.io.InputStream; import java.util.Date; import java.util.List; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.dqd.pojo.User; public class mybatis { //���id�õ�һ����¼��ͨ���������ģ���ѯ public void fingUserByIdTest() throws IOException { String resource = "SqlMapConfig.xml"; InputStream inputstream = Resources.getResourceAsStream(resource); //�����Ự����,����mybatis��������Ϣ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream); //�õ�sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //ͨ��sqlSession������ݿ� //��һ������Ϊӳ���ļ��е�statement id,Ϊnamespace+"."+statement.id //�ڶ�������ָ����ӳ���ļ���ƥ�����͵IJ��� User user = sqlSession.selectOne("test.fingUserById",1); System.out.println(user); List<User> list = sqlSession.selectList("test.fingUserByName","dqd"); System.out.println(list.size()); //����ͷ���Դ sqlSession.close(); } public void insertUser() throws IOException { String resource = "SqlMapConfig.xml"; InputStream inputstream = Resources.getResourceAsStream(resource); //�����Ự����,����mybatis��������Ϣ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream); //�õ�sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //ͨ��sqlSession������ݿ� User user = new User(); user.setUsername("dqd1"); user.setBirthday(new Date()); user.setSex("0"); user.setAddress("shandong"); sqlSession.insert("test.insertUser",user); //除了查询，其他的需要使用事务提交到数据库中 sqlSession.commit(); System.out.println(user.getId());//注意如果我们不加操作的将id直接取出来的话，总是0!,那么我们可以在user。xml文件 //中进行配置<selectKey>进行字段的配置（这里配置id）使用select last_insert_id()，必须紧接着插入语句 //关闭资源 sqlSession.close(); } public void deleteUser() throws IOException { String resource = "SqlMapConfig.xml"; InputStream inputstream = Resources.getResourceAsStream(resource); //�����Ự����,����mybatis��������Ϣ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream); //�õ�sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //ͨ��sqlSession������ݿ� sqlSession.delete("test.deleteUser",2); //除了查询，其他的需要使用事务提交到数据库中 sqlSession.commit(); //关闭资源 sqlSession.close(); } public void updateUser() throws IOException { String resource = "SqlMapConfig.xml"; InputStream inputstream = Resources.getResourceAsStream(resource); //�����Ự����,����mybatis��������Ϣ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream); //�õ�sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); //ͨ��sqlSession������ݿ� User user = new User(); user.setId(4); user.setUsername("dqd2"); user.setBirthday(new Date()); user.setSex("1"); user.setAddress("henan"); sqlSession.update("test.updateUser",user); //除了查询，其他的需要使用事务提交到数据库中 sqlSession.commit(); //关闭资源 sqlSession.close(); } } user.xml：(注意user.xml是在sqlmap下面)

<?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"> <!-- 原始的ibatis的配置文件的命名形式，而mybatis使用XXMapper.xml --> <!-- 命名空间，对sql的分类化管理 如果使用Mapper代理的方式开发就会有重要的作用 --> <mapper namespace="test"> <!-- 配置sql语句 ，通过select进行数据库查询，id标识映射文件的sql,称作statement的id--> <!-- 指定id的类型 ,value表示接收的参数，并且命名任意,resultType指定是单条映射对应的java对象--> <select id="fingUserById" parameterType="int" resultType="com.dqd.pojo.User"> select * from user where id = #{value} </select> <!-- 注意模糊查询和id查询的语句区别用$而不是# --> <select id="fingUserByName" parameterType="java.lang.String" resultType="com.dqd.pojo.User"> select * from user where username like '%${value}%' </select> <!-- 添加用户 parameterType:指定输入参数的类型pojo #{}指定pojo的属性名，映射到数据库中字段的名称， --> <!-- 设置可以查询id的插入语句 keyproperty表示将查询的主键设置到parameterType中对象的那个属性 order:对insert语句而言 一定注意还需要一个主键的返回类型，否则会报错 --> <insert id="insertUser" parameterType="com.dqd.pojo.User"> <selectKey keyProperty="id" order="AFTER" > select LAST_INSERT_ID() </selectKey> insert into user(username,birthday,sex,address) values(#{username},#{birthday},#{sex},#{address}) </insert> <delete id="deleteUser" parameterType="int"> delete from user where id = #{id} </delete> <!-- 通过传入的pojo(前提是包含有id)根据id更新用户 --> <update id="updateUser" parameterType="com.dqd.pojo.User"> update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id=#{id} </update> </mapper>

log4j.properties:

log4j.rootLogger=DEBUG, stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout # Pattern to output the caller's file name and line number. log4j.appender.stdout.layout.ConversionPattern=%d %5p (%c\:%L) - %m%n

SqlMapConfig.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> <!-- 对事务的管理和连接池的配置 ,如果和spring整合之后environments将抛弃--> <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/mybatis" /> <property name="username" value="root" /> </dataSource> </environment> </environments> <!-- 加载映射文件 --> <mappers> <mapper resource="sqlmap/User.xml" /> </mappers> </configuration>