Rhythmk 一步一步学 JAVA 15 mybatis 入门学习1.docx
- 文档编号:27642170
- 上传时间:2023-07-03
- 格式:DOCX
- 页数:15
- 大小:30.07KB
Rhythmk 一步一步学 JAVA 15 mybatis 入门学习1.docx
《Rhythmk 一步一步学 JAVA 15 mybatis 入门学习1.docx》由会员分享,可在线阅读,更多相关《Rhythmk 一步一步学 JAVA 15 mybatis 入门学习1.docx(15页珍藏版)》请在冰豆网上搜索。
Rhythmk一步一步学JAVA15mybatis入门学习1
Rhythmk一步一步学JAVA(15)mybatis入门学习-1
1、mybatis通过mybatis-generator-core-1.3.2 代码生成:
工具下载地址:
解压工具包 mybatis-generator-core-1.3.2 找到lib目录添加配置文件,根据文档说明执行代码生成:
xmlversion="1.0"encoding="UTF-8"?
>
DOCTYPEgeneratorConfiguration
PUBLIC"-//mybatis.org//DTDMyBatisGeneratorConfiguration1.0//EN"
"http:
//mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
--
使用说明:
cmd
cd安装包存放路径
eg:
cdC:
\MybatisCodeBuildTool\lib
执行:
java-jarmybatis-generator-core-1.3.2.jar-configfile配置文件.xml-overwrite
-->
--陪在数据库连接驱动-->
connectionURL="jdbc: mysql: //localhost/mybatistest"userId="root"password="wangkun"> --model实体代码生成: targetPackage: 命名空间 targetProject: 生成文件目录(需要存在目录) --> targetProject="javacodedir"> targetProject="javacodedir"> targetPackage="com.rhythmk.dao"targetProject="javacodedir"> --- table代码配置: tableName: 数据库表名 domainObjectName: 映射对象名 通过下面配置选择生成操作方法,默认为true enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" --> --ignoreColumn: 排除属性---> 2、mybatis增改查: 项目结构: config.properties: 1 2 3 4 db.driver=com.mysql.jdbc.Driver db.url=jdbc: mysql: //localhost: 3306/mybatistest? useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull db.user=root db.pass=wangkun SqlMapConfig.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 xml version="1.0"encoding="UTF-8"? > DOCTYPE configurationPUBLIC"-//mybatis.org//DTDConfig3.0//EN" "http: //mybatis.org/dtd/mybatis-3-config.dtd"> --引入配置文件--> MyUserMapper.xml: xmlversion="1.0"encoding="UTF-8"? > DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN""http: //mybatis.org/dtd/mybatis-3-mapper.dtd"> -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> ID,UserName,CreateTime -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> select frommyuser whereID=#{id,jdbcType=TINYINT} -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> deletefrommyuser whereID=#{id,jdbcType=TINYINT} -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> insertintomyuser(ID,UserName,CreateTime ) values(#{id,jdbcType=TINYINT},#{username,jdbcType=VARCHAR},#{createtime,jdbcType=TIMESTAMP} ) -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> insertintomyuser =null"> ID, =null"> UserName, =null"> CreateTime, =null"> #{id,jdbcType=TINYINT}, =null"> #{username,jdbcType=VARCHAR}, =null"> #{createtime,jdbcType=TIMESTAMP}, -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> updatemyuser =null"> UserName=#{username,jdbcType=VARCHAR}, =null"> CreateTime=#{createtime,jdbcType=TIMESTAMP}, whereID=#{id,jdbcType=TINYINT} -- WARNING-@mbggenerated ThiselementisautomaticallygeneratedbyMyBatisGenerator,donotmodify. --> updatemyuser setUserName=#{username,jdbcType=VARCHAR}, CreateTime=#{createtime,jdbcType=TIMESTAMP} whereID=#{id,jdbcType=TINYINT} --设置参数类型为Map则可以通过Map 进行参数化传值, 同时parameterType也可以设置为具体的JaveBean类型如上面方法进行查询传值 --> select frommyuser whereID=#{id,jdbcType=TINYINT}AndUserName=#{UserName} 测试代码: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 private static SqlSessionFactorysqlSessionFactory= null; static{ try { InputStream is=org.apache.ibatis.io.Resources.getResourceAsStream("SqlMapConfig.xml"); sqlSessionFactory=new SqlSessionFactoryBuilder().build(is); } catch (Exceptione){ //TODO: handleexception e.printStackTrace(); } } /** * 添加数据 */ public static void testInsert() { SqlSessionsession=sqlSessionFactory.openSession(); MyUseruser=new MyUser(); user.setCreatetime(new Date()); user.setUsername("RHYTHMK"); session.insert("insert",user); mit(); } /** * 查询数据 */ public static void testSelectOne() { SqlSessionsession=sqlSessionFactory.openSession(); try { MyUseruser=session.selectOne("selectByPrimaryKey",1); System.out.printf(user.getUsername()); } catch (Exceptione){ //TODO: handleexception e.printStackTrace(); }finally{ session.close(); } } /** * 修改数据 */ public static void testUpdate() { SqlSessionsession=sqlSessionFactory.openSession(); MyUseruser=new MyUser(); user.setCreatetime(new Date()); user.setUsername("RHYTHMK_update"); user.setId(Byte.parseByte("1")); session.insert("updateByPrimaryKeySelective",user); mit(); } public static void testSelectByMap() { Map map.put("id", "2"); map.put("UserName", "wangk2"); SqlSessionsession=sqlSessionFactory.openSession(); MyUseruser=(MyUser)session.selectOne("selectUser",map); System.out.println("testSelect: "+user.getId().toString()); }
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Rhythmk 一步一步学 JAVA 15 mybatis 入门学习1 一步一步 入门 学习