Maven + myBatis 的简单实例

1. 添加依赖，修改pom.xml文件

在pom.xml文件中增加以下代码：
		<!-- sqlServer 驱动 -->
		<dependency>
		    <groupId>com.microsoft.sqlserver</groupId>
		    <artifactId>mssql-jdbc</artifactId>
		    <version>6.2.0.jre8</version>
		    <scope>runtime</scope>
		</dependency>
		<!-- myBatis的依赖包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.7</version>
		</dependency>
		

2. 准备好配置文件，myBatis的配置文件，映射文件等

 <configuration>
                  <settings>  
                     <!-- myBatis 默认是log4j输出，打印日志 -->
			        <setting name="logImpl" value="STDOUT_LOGGING" />    
			      </settings> 
                 <!-- 注册对象的空间命名 -->
                 <environments default="sqlServer">
	                 <environment id="sqlServer">
	                 <transactionManager type="JDBC"/>
	                 <dataSource type="POOLED">
	                 <!-- 1.加载数据库驱动：oracle.jdbc.driver.OracleDriver -->
	                 <!-- <property name="driver" value="oracle.jdbc.driver.OracleDriver"/> -->
	                 <property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
	                 <!-- 2.数据库连接地址：oracle.jdbc.driver.OracleDriver -->
	                 <!-- <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/> -->
	                 <property name="url" value="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=数据库名称"/>
	                 <!-- 数据库用户... -->
	                 <property name="username" value="username"/>
	                 <!-- 数据库密码... -->
	                 <property name="password" value="password"/>
	                 </dataSource>
	                 </environment>
                 </environments>
                 <!-- 注册映射文件：java对象与数据库之间的xml文件路径！ -->
                 <mappers>
					<mapper resource="config/tsysUser.xml"/>                 
                 </mappers>
                 </configuration>

3. 书写javaBean类，注意和数据库中的字段名，字段类型保持一致

public class TsysUserMapper {
	private int     nId;
	private String  name;
	private String  sex;
	private int  	age; 
	get/set....

5. 书写映射sql文件

 <!-- 命名空间mapper：cn.fqf.bean -->
	 <mapper namespace="cn.fqf.bean.TsysUserMapper">
		 <select id="selectUserById" parameterType="int" resultType="cn.fqf.bean.TsysUserMapper">
		 <!-- 底层的SQL语句 -->
		 SELECT * FROM  tsysuser WHERE nid  = #{id}
		 </select>
	 </mapper>

6. 测试

private SqlSessionFactory factory = null;
	
	@Before
	public void before() throws IOException{
		factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("sqlMapConfig.xml"));
	}
	
	@Test
	public void testSelect(){
		SqlSession sqlSession = factory.openSession();
		Object user = sqlSession.selectOne("selectUserById", 1);
		System.out.println(user);
		// 释放资源
		sqlSession.close();
	}

8. 输出接口：（测试成功）