 Mybatis入门及CURD)
一、快速搭建第一个mybatis项目1、pom.xml依赖dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.2/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.47/version/dependency2、搭建数据库CREATEDATABASE`mybatis`;USE`mybatis`;DROPTABLEIFEXISTS`user`;CREATETABLE`user`(`id`int(20)NOTNULL,`name`varchar(30)DEFAULTNULL,`pwd`varchar(30)DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;insertinto`user`(`id`,`name`,`pwd`)values(1,'张三','123456'),(2,'李四','abcdef'),(3,'王五','987654');3、编写核心配置文件,resource下创建mybatis-config.xml?xml version="1.0" encoding="UTF-8" ?!DOCTYPEconfigurationPUBLIC"-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"configurationenvironmentsdefault="development"environmentid="development"transactionManagertype="JDBC"/dataSourcetype="POOLED"propertyname="driver"value="com.mysql.jdbc.Driver"/propertyname="url"value="jdbc:mysql://localhost:3306/mybatis?useSSL=trueamp;useUnicode=trueamp;characterEncoding=utf8"/propertyname="username"value="root"/propertyname="password"value="123456"//dataSource/environment/environmentsmappers!-- mapper resource="UserMapper.xml"/--mapperclass="com.sj.dao.UserMapper"//mappers/configuration4、编写工具类packagecom.sj.utils;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importjava.io.IOException;importjava.io.InputStream;publicclassMybatisUtils{privatestaticSqlSessionFactorysqlSessionFactory;static{try{//读取配置文件Stringresource="mybatis-config.xml";InputStreaminputStream;inputStream=Resources.getResourceAsStream(resource);//新建一个SqlSessionFactoryBuilder,通过它创建一个工厂,通过工厂创建一个sqlsessionsqlSessionFactory=newSqlSessionFactoryBuilder().build(inputStream);}catch(IOExceptione){e.printStackTrace();}}publicstaticSqlSessiongetSqlSession(){returnsqlSessionFactory.openSession();}}