下ibatis

public class Person implements Serializable {    private static final long serialVersionUID = 9006203036989086304L;    private Integer id;    private String pName;    private String sex;    private Integer age;//省略setter getter方法｝

 <sqlMap namespace="Person"> <typeAlias alias="person" type="com.bean.Person"/>     <select id="getPerson" resultClass="person" parameterClass="java.lang.String">         <![CDATA[         select * from tab_person where id=#value#         ]]>     </select>     <insert id="insertPerson" parameterClass="person">         <![CDATA[         insert into tab_person(id,pname,sex,age) values(#id#,#pname#,#sex#,#age#)         ]]>     </insert>     <update id="updatePerson" parameterClass="person">         <![CDATA[         update tab_person set pname=#pname#,sex=#sex#,age=#age# where id=#id#         ]]>     </update>     <delete id="deletePerson" parameterClass="java.lang.String">         <![CDATA[         delete tab_person where id=#id#         ]]>     </delete> </sqlMap>

 <sqlMapConfig>     <settings cacheModelsEnabled="true"                enhancementEnabled="true"                 lazyLoadingEnabled="true"                errorTracingEnabled="true"                 maxRequests="32"                maxSessions="10"                maxTransactions="5"                useStatementNamespaces="false" />     <transactionManager type="JDBC">         <dataSource type="SIMPLE">             <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>             <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>             <property name="JDBC.Username" value="system"/>             <property name="JDBC.Password" value="oraclepass"/>         </dataSource>     </transactionManager>     <sqlMap resource="com/bean/Person.xml"/> </sqlMapConfig>

public static void main(String[] args){        try {            String resource="SqlMapConfigExample.xml";            Reader reader=Resources.getResourceAsReader(resource);            XmlSqlMapClientBuilder xmlSqlMapClientBuilder=new XmlSqlMapClientBuilder();            SqlMapClient sqlMapClient=xmlSqlMapClientBuilder.buildSqlMap(reader);            sqlMapClient.startTransaction();            Person person=new Person("gahd", "man", 21);            sqlMapClient.insert("insertPerson",person);            sqlMapClient.commitTransaction();        } catch (IOException e) {            e.printStackTrace();        }catch (Exception e) {            e.printStackTrace();        }    }