spring框架中数据库配置使用

一、web.xml

配置加载spring文件，默认加载applicationContext.xml

<!-- Spring ApplicationContext配置文件的路径 ,可使用通配符，多个路径用,号分隔 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
			classpath:/config/itumpsub/spring/spring-common.xml
		</param-value>
	</context-param>

二、UserMapper.xml

具体的sql语句写在这个配置文件中，文件位置：/zttools/src/sqlmap/itumpsub/sqlserver/UserMapper.xml

<?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="com.itumpsub.dao.sqlserver.UserMapper" >
 <!--  <resultMap id="BaseResultMap" type="com.itumpsub.dto.sqlserver.User" >
 	<id column="ID" property="id" jdbcType="INTEGER" />
    <result column="USERNAME" property="username" jdbcType="VARCHAR" />
    <result column="PASSWORD" property="password" jdbcType="VARCHAR" />
    <result column="AGE" property="age" jdbcType="INTEGER" />
  </resultMap>
 -->
  <select id="selectAll" resultType="java.util.Map" >
    select USERNAME,PASSword, AGE, score from TEST_USER, TEST_SCORE where TEST_USER.ID=TEST_SCORE.USERID
  </select>
 
</mapper>

三、sqlserver-mybatis-config.xml

调用UserMapper.xml的配置就写在这个文件中，文件位置：/zttools/src/mybatis/itumpsub/sqlserver-mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE