第一步·：创建数据库
数据库名为·y2165
第二部搭建mybatis环境
1.在pom.xml 文件中引入jar包
2.替换build节点，为了让程序编译在main中所有子包下的配置文件
3.构建大配置位于resourcse
pom.xml
<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> </resources> </build>小配置 <?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"> <mapper namespace="cn.happy.dao.IStudentInfoDAO"> <!-- id:唯一标识：通过此id，程序可唯一锁定一条SQL parameterType：参数类型 resultType：结果类型 --> <resultMap id="stuId" type="studentinfo"> <id column="stuId" property="stuID"/> <result column="stuName" property="stuName"/> </resultMap> <select id="findAll" resultMap="stuId"> select * from studentinfo </select> <select id="getStudentById" resultMap="stuId"> select * from studentinfo WHERE stuId=1; </select> </mapper>大配置 <?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> <typeAliases> <package name="cn.happy.entity"></package> <package name="cn.happy.entity"/> </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:///y2165" /> <property name="username" value="root" /> <property name="password" value="" /> </dataSource> </environment> </environments> <!--映射文件：描述某个实体和数据库表的对应关系 --> <mappers> <mapper resource="IStudentInfoDao.xml" /> </mappers> </configuration>工具类（位于包util下） package cn.happy.util; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.util.Properties; import org.apache.ibatis.datasource.DataSourceFactory; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; /** * @author Siva * */ public class myBatis { private static SqlSessionFactory sqlSessionFactory; public static SqlSessionFactory getSqlSessionFactory() { if (sqlSessionFactory == null) { InputStream inputStream = null; try { inputStream = Resources.getResourceAsStream("mybatis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { throw new RuntimeException(e.getCause()); } finally { if (inputStream != null) { try { inputStream.close(); } catch (IOException e) { } } } } return sqlSessionFactory; } public static SqlSession getSqlSession() { return getSqlSessionFactory().openSession(); } }