Question

oracle 10g+spring+ibatis问题

一个面试机会要求Spring与ibatis框架集成作品，我只学过SSH框架，哪位大师能帮帮忙讲解一下，或者提供一些简单易上手的参考资料，数据库要求Oracle10g，（我学的是SQL SERVER2005.....5555）周六面试，要求带作品的，太感谢了

Answer 1

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
" http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap> <select id="getAllUsers" resultClass="com.air.Account">
SELECT * FROM USER_ACCOUNT order by USERID
</select>
<!-- 无映射 -->
<select id="getAllUsers1" resultClass="com.air.Account"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <!-- 内联映射->实体类 -->
<select id="getAllUsers2" resultClass="com.air.Account"
parameterClass="string">
SELECT USERID as userid, USERNAME as username, PASSWORD as
password, GROUPNAME as groupname FROM USER_ACCOUNT WHERE
GROUPNAME=#groupName#
</select> <!-- 内联映射->MAP类 -->
<select id="getAllUsers3" resultClass="hashmap"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <!-- 显示映射->实体类 -->
<resultMap id="accoutResult" class="com.air.Account">
<result property="userid" column="USERID" />
<result property="username" column="USERNAME" />
<result property="password" column="PASSWORD" />
<result property="groupname" column="GROUPNAME" />
</resultMap>
<select id="getAllUsers4" resultMap="accoutResult"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <!-- 显示映射->MAP类 -->
<resultMap id="mapResult" class="hashmap">
<result property="userid" column="USERID" />
<result property="username" column="USERNAME" />
<result property="password" column="PASSWORD" />
<result property="groupname" column="GROUPNAME" />
</resultMap>
<select id="getAllUsers5" resultMap="mapResult"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <!-- XML -->
<select id="selectXML" parameterClass="string" resultClass="xml"
xmlResultName="log">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <select id="getOneUser" resultClass="com.air.Account"
parameterClass="string">
SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#
</select> <!-- 自动参数映射 -->
<insert id="insertOneUser1" parameterClass="com.air.Account">
INSERT INTO USER_ACCOUNT
(
USERNAME, PASSWORD, GROUPNAME
)VALUES(
#username#,#password#,#groupname#
)
</insert> <!-- 内联参数映射 -->
<insert id="insertOneUser2" parameterClass="com.air.Account">
INSERT INTO USER_ACCOUNT
(
USERNAME, PASSWORD, GROUPNAME
)VALUES(
#username:VARCHAR#,
#password:VARCHAR#,
#groupname:VARCHAR#
)
</insert> <!-- 外联参数映射 -->
<parameterMap id="parameterMapEx" class="com.air.Account">
<parameter property="username" jdbcType="VARCHAR"/>
<parameter property="password" jdbcType="VARCHAR"/>
<parameter property="groupname" jdbcType="VARCHAR"/>
</parameterMap>
<insert id="insertOneUser3" parameterMap="parameterMapEx">
INSERT INTO USER_ACCOUNT
(
USERNAME, PASSWORD, GROUPNAME
)VALUES(
?,?,?
)
</insert>

<!-- 自动生成的键 -->
<insert id="insertOneUser4" parameterClass="com.air.Account">
INSERT INTO USER_ACCOUNT
(
USERID,USERNAME, PASSWORD, GROUPNAME
)VALUES(
#userid#,
#username#,
#password#,
#groupname#
)
<selectKey
keyProperty="userid"
resultClass="int">
SELECT LAST_INSERT_ID()
</selectKey>
</insert> <!-- 存储过程 -->
<parameterMap id="pro" class="java.util.Map">
<parameter property="name" jdbcType="VARCHAR"
javaType="string" mode="IN"/>
</parameterMap>
<procedure id="pro_insert" parameterMap="pro">
{call new_proc(?)}
</procedure>

</sqlMap> 这个是Ibatis的写法。其他的跟SSH都是差不多

Answer 2

你跟我一样。。同样的东西 咱俩估计是一家公司。。