Mybatis实现数据的增删改查(CRUD).doc

Mybatis实现数据的增删改查（CRUD） 什么是 MyBatis？ MyBatis 是支持普通 SQL 查询，存储过程和高级映射的优秀持久层框架。 MyBatis 消除了几乎所有的 JDBC 代码和参数的手工设置以及对结果集的检索。MyBatis 可以使用简单的XML 或注解用于配置和原始映射，将接口和 Java 的 POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录。 MyBatis下载：/mybatis/mybatis-3/releases Mybatis实例 对一个User表的CRUD操作： User表： -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11 NOT NULL AUTO_INCREMENT, `userName` varchar(50 DEFAULT NULL, `userAge` int(11 DEFAULT NULL, `userAddress` varchar(200 DEFAULT NULL, PRIMARY KEY (`id` ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, summer, 30, shanghai; INSERT INTO `user` VALUES (2, test2, 22, suzhou; INSERT INTO `user` VALUES (3, test1, 29, some place; INSERT INTO `user` VALUES (4, lu, 28, some place; INSERT INTO `user` VALUES (5, xiaoxun, 27, nanjing; 在Src目录下建一个mybatis的xml配置文件Configuration.xml xml version=1.0 encoding=UTF-8 ? DOCTYPE configuration PUBLIC -////DTD Config 3.0//EN /dtd/mybatis-3-config.dtd configuration typeAliases typeAlias alias=User type=com.mybatis.test.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://:3306/mybatis / property name=username value=root/ property name=password value=admin/ dataSource environment environments mappers mapper resource=com/mybatis/test/User.xml/ mappers configuration 定义User mappers的User.xml配置文件 xml version=1.0 encoding=UTF-8 ? DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN /dtd/mybatis-3-mapper.dtd mapper namespace=com.mybatis.test.IUserOperation select id=selectUserByID parameterType=int resultType=User select * from `user` where user.id = #{id} select select id=selectUsersByName parameterType=string resultType=User select * from user