<sqlMap namespace="User">
? <resultMap id="result" class="wh.domain.UserBean">
??? <result property="id" column="id" columnIndex="1"/>
??? <result property="name" column="name" columnIndex="2"/>
??? <result property="pwd" column="pwd" columnIndex="3"/>
? </resultMap>
? <select id="getUser" resultMap="result">
??? select id,name,pwd from [user] where id = #value#
? </select>
? <select id="getUserList" resultMap="result">
??? select id,name,pwd from [user]
? </select>
</sqlMap>
5.log4j配置文件
log4j.rootLogger=info, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%t] %d %p [%c] - %m%n
log4j.appender.logfile=org.apache.log4j.RollingFileAppender
log4j.appender.logfile.File=${srping.root}/WEB-INF/spring.log
log4j.appender.logfile.MaxFileSize=512KB
# Keep three backup files.
log4j.appender.logfile.MaxBackupIndex=3
# Pattern to output: date priority [category] - message
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n
6.jdbc.propertis
# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "dataAccessContext-local.xml".
# Targeted at system administrators, to avoid touching the context XML files.
jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://127.0.0.1:1433/test
jdbc.username=sa
jdbc.password=123123