ibatis 单表查询 一对多查询
生成数据库的语句如下： 数据库是试用mysql数据库
/*
Navicat MySQL Data Transfer
Source Server : mysqlTest
Source Server Version : 50022
Source Host : localhost:3306
Source Database : ibatis_db
Target Server Type : MYSQL
Target Server Version : 50022
File Encoding : 65001
Date: 2013-05-02 22:49:28
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `book`
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`oid` int(10) NOT NULL,
`name` varchar(50) default NULL,
PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', 'java开发宝典');
-- ----------------------------
-- Table structure for `book_user`
-- ----------------------------
DROP TABLE IF EXISTS `book_user`;
CREATE TABLE `book_user` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`book_oid` int(10) default NULL,
PRIMARY KEY (`id`),
KEY `FK_user_1` (`book_oid`),
CONSTRAINT `FK_user_1` FOREIGN KEY (`book_oid`) REFERENCES `book` (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of book_user
-- ----------------------------
INSERT INTO `book_user` VALUES ('1', 'tom', '1');
INSERT INTO `book_user` VALUES ('2', 'lily', '1');
文件下载
资源详情
[{"title":"（ 23 个子文件 1.77MB ） ibatis 单表查询 一对多查询","children":[{"title":"testforibatis","children":[{"title":".project <span style='color:#111;'> 389B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"ibatis","children":[{"title":"User.xml <span style='color:#111;'> 2.02KB </span>","children":null,"spread":false},{"title":"User.class <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"TestHelloIbatis.class <span style='color:#111;'> 4.26KB </span>","children":null,"spread":false},{"title":"onetomany","children":[{"title":"book.xml <span style='color:#111;'> 976B </span>","children":null,"spread":false},{"title":"Book.class <span style='color:#111;'> 972B </span>","children":null,"spread":false},{"title":"Book_User.class <span style='color:#111;'> 941B </span>","children":null,"spread":false},{"title":"TestDB.class <span style='color:#111;'> 2.46KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"sql-map-config.xml <span style='color:#111;'> 867B </span>","children":null,"spread":false}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"ibatis","children":[{"title":"User.xml <span style='color:#111;'> 2.02KB </span>","children":null,"spread":false},{"title":"TestHelloIbatis.java <span style='color:#111;'> 3.64KB </span>","children":null,"spread":false},{"title":"User.java <span style='color:#111;'> 631B </span>","children":null,"spread":false},{"title":"onetomany","children":[{"title":"book.xml <span style='color:#111;'> 976B </span>","children":null,"spread":false},{"title":"Book.java <span style='color:#111;'> 507B </span>","children":null,"spread":false},{"title":"TestDB.java <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Book_User.java <span style='color:#111;'> 464B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"sql-map-config.xml <span style='color:#111;'> 867B </span>","children":null,"spread":false}],"spread":true},{"title":".classpath <span style='color:#111;'> 499B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"mysql-connector-java-5.1.6-bin.jar <span style='color:#111;'> 686.78KB </span>","children":null,"spread":false},{"title":"junit-4.8.2.jar <span style='color:#111;'> 231.78KB </span>","children":null,"spread":false},{"title":"ibatis-2.3.4.726.jar <span style='color:#111;'> 375.35KB </span>","children":null,"spread":false},{"title":"mybatis-3.2.2.jar <span style='color:#111;'> 683.42KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]
评论信息
其他资源
- 自动驾驶系列报告三---芯片篇
- 成像原理、视差图以及uv视差计算PPT文档及代码
- 多目标进化算法java程序
- 滚动轴承振动信号的包络谱分析
- uwb室内定位算法
- C#通过ACCESS数据库，对学生信息表进行查询添加修改删除
- 基于MATLAB_Robotics工具箱的工业机器人轨迹规划及仿真研究
- NISTSP_1011-I-2-0.pdf
- texstudio3.0.4+《一份（不太）简短的LATEX介绍》
- 研究生分布式数据库考试试题及其答案
- stm32f103rct6开发资料 小系统 开发文档
- Sublime SFTP插件
- 控制律设计详细介绍
- 遗传算法的车间调度算法求解的PPT
- 追踪linux TCP/IP 代码运行_光盘文件1
- 行为识别算法TSN介绍
- IE控件分析工具
- 新巴巴运动网-10天的文档
- 校园办公管理系统.zip
- gitlab issue详细操作流程
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明