mybatis教程2(配置文件)

configuration 配置
    properties 属性
    settings 设置
    typeAliases 类型别名
    typeHandlers 类型处理器
    objectFactory 对象工厂
    plugins 插件
    environments 环境
        environment 环境变量
            transactionManager 事务管理器
            dataSource 数据源
    databaseIdProvider 数据库厂商标识
    mappers 映射器

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssm
username=root
password=123456

<settings>
  <setting name="cacheEnabled" value="true"/>
  <setting name="lazyLoadingEnabled" value="true"/>
  <setting name="multipleResultSetsEnabled" value="true"/>
  <setting name="useColumnLabel" value="true"/>
  <setting name="useGeneratedKeys" value="false"/>
  <setting name="autoMappingBehavior" value="PARTIAL"/>
  <setting name="autoMappingUnknownColumnBehavior" value="WARNING"/>
  <setting name="defaultExecutorType" value="SIMPLE"/>
  <setting name="defaultStatementTimeout" value="25"/>
  <setting name="defaultFetchSize" value="100"/>
  <setting name="safeRowBoundsEnabled" value="false"/>
  <setting name="mapUnderscoreToCamelCase" value="false"/>
  <setting name="localCacheScope" value="SESSION"/>
  <setting name="jdbcTypeForNull" value="OTHER"/>
  <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
</settings>

  <typeAliases>
  	<typeAlias type="com.sxt.bean.User" alias="user"/>
  </typeAliases>

  <typeAliases>
  	<!-- <typeAlias type="com.sxt.bean.User" alias="user"/> -->
  	<package name="com.sxt.bean"/>
  </typeAliases>

@MappedJdbcTypes(JdbcType.VARCHAR)
@MappedTypes(List.class)
public class ListStringTypeHandler extends BaseTypeHandler<List<String>>{

	/**
	 * 设置非空参数
	 * 执行SQL语句时对占位符进行设置
	 * 比如:sql = "insert into t_sysuser(name,age,favorites)values(?,?,?) "
	 */
	@Override
	public void setNonNullParameter(PreparedStatement ps, int i, List<String> parameter, JdbcType jdbcType)
			throws SQLException {
		System.out.println("------------");
		StringBuilder sb = new StringBuilder();
		for (String s : parameter) {
			sb.append(s).append(";");
		}
		// 给占位符设值
		ps.setString(i, sb.toString());
	}

	/**
	 * 获取非空的返回结果
	 * 获取数据库一条记录的某个字段的结果，转换为对应的java类型数据
	 */
	@Override
	public List<String> getNullableResult(ResultSet rs, String columnName) throws SQLException {
		// TODO Auto-generated method stub
		return Arrays.asList(rs.getString(columnName).split(";"));
	}

	@Override
	public List<String> getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
		// TODO Auto-generated method stub
		return Arrays.asList(rs.getString(columnIndex).split(";"));
	}

	@Override
	public List<String> getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
		// TODO Auto-generated method stub
		return Arrays.asList(cs.getString(columnIndex).split(";"));
	}
}

  <typeHandlers>
  	<typeHandler handler="com.sxt.handler.ListStringTypeHandler" />
  </typeHandlers>

	private int id;
	
	private String name;
	
	private int age;
	// 集合数据和表结构中的数据类型不一致，数据是Varchar类型
	private List<String> favorites;

// 3.通过SqlSessionFactory对象获取SQLSession对象
SqlSession session = factory.openSession();
User user = new User();
user.setName("bobo");
user.setAge(18);

List<String> list =new ArrayList<>();
list.add("dnf");
list.add("cs");
list.add("cc");
user.setFavorites(list);
//通过Java动态代理自动提供了UserMapper的实现类
UserMapper mapper = session.getMapper(UserMapper.class);
int count = mapper.addUser(user);
System.out.println("影响的行数:"+count);
session.commit();

 <select id="getUserById" parameterType="int" resultType="user"> 
	select * from t_user where id=#{id}   
</select> 

public interface UserMapper {

	public int addUser(User user);
	
	public User getUserById(int id);
}

	@Test
	public void query() throws IOException {
		// 1.通过Resources对象加载配置文件
		InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
		// 2.获取SqlSessionFactory对象
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream );
		// 3.通过SqlSessionFactory对象获取SQLSession对象
		SqlSession session = factory.openSession();
		
		//通过Java动态代理自动提供了UserMapper的实现类
		UserMapper mapper = session.getMapper(UserMapper.class);
		User list = mapper.getUserById(15);
		System.out.println(list);
		session.commit();
	}

  <!-- 注册映射文件 -->
  <mappers>
  	<mapper resource="com/sxt/dao/UserMapper.xml"/>
  </mappers>

  <!-- 注册映射文件 -->
  <mappers>
  	<!-- <mapper resource="com/sxt/dao/UserMapper.xml"/> -->
  	<package name="com.sxt.dao"/>
  </mappers>