亚洲综合网美国十次,久久亚洲AV无码精品色午夜,男人的天堂亚洲一区二区三区

iBatis模具

Posted on 2007-04-07 16:48 它山の石閱讀(97) 評論(0) 編輯收藏

SqlMapConfig.xml

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

<!DOCTYPE sqlMapConfig
3

PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
4

"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
5

<sqlMapConfig>
6

<properties resource="com/sigon/ibatis/SqlMapConfig.properties" />
7

<settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />
8

<transactionManager type="JDBC" commitRequired="false">
10

<dataSource type="SIMPLE">
11

<property name="JDBC.Driver" value="${driver}" />
12

<property name="JDBC.ConnectionURL" value="${url}" />
13

<property name="JDBC.Username" value="${username}" />
14

<property name="JDBC.Password" value="${password}" />
15

<property name="Pool.MaximumActiveConnections" value="10" />
16

<property name="Pool.MaximumIdleConnections" value="5" />
17

<property name="Pool.MaximumWait" value="60000" />
18

</dataSource>
19

</transactionManager>
20

<sqlMap resource="com/sigon/ibatis/maps/User.xml" />
21

</sqlMapConfig>
22

user.xml

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

<!DOCTYPE sqlMap
3

PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
4

"http://ibatis.apache.org/dtd/sql-map-2.dtd">
5

<sqlMap namespace="User">
6

<typeAlias alias="user" type="com.sigon.ibatis.User" />
8

<select id="getUser" parameterClass="java.lang.String" resultClass="user">
9

<![CDATA[
10

select
11

name,
12

sex
13

from t_user
14

where name = #name#
15

]]>
16

</select>
17

<select id="getAllUser" resultClass="user">
19

<![CDATA[
20

select
21

id,
22

name,
23

sex
24

from t_user
25

]]>
26

</select>
27

<update id="updateUser" parameterClass="user">
29

<![CDATA[
30

UPDATE t_user SET name=#name#, sex=#sex# WHERE id = #id# ]]>
31

</update>
32

<insert id="insertUser" parameterClass="user">INSERT INTO t_user ( name, sex) VALUES ( #name#, #sex# )</insert>
34

<delete id="deleteUser" parameterClass="java.lang.String">delete from t_user where id=#value#</delete>
36<img src="http://www.blogjava.n

光の境

光の代碼學(xué)習(xí)基地

隨筆檔案

文章檔案

最新隨筆

最新評論

iBatis模具

公告

常用鏈接

java

評論排行榜

閱讀排行榜