spring + ibatis(现以改名为mybatis)

圣凤凌霜

　　<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><!-- 数据源 //////////////////////////--><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"destroy-method="close"><property name="driverClass" value="com.mysql.jdbc.Driver"></property><property name="minPoolSize" value="20"></property><property name="initialPoolSize" value="25"></property><property name="maxPoolSize" value="100"></property><property name="maxStatements" value="200"></property><property name="maxStatementsPerConnection" value="200"></property><property name="acquireIncrement" value="3"></property><property name="acquireRetryAttempts" value="10"></property><property name="autoCommitOnClose" value="false"></property><property name="acquireRetryDelay" value="2000"></property><property name="jdbcUrl"value="jdbc:mysql://192.168.0.73:3306/test?characterEncoding=utf8"></property><property name="user" value="root"></property><property name="password" value="xlinwoox"></property></bean><bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="classpath:sqlMapConfig.xml" /></bean><bean id="signDAO" class="com.test.dao.impl.SignDAO"><property name="sqlMapClient" ref="sqlMapClient"></property></bean><bean id="signService" class="com.test.service.SignService"><property name="signDAO" ref="signDAO"></property></bean></beans>
　　以上为spring配置
　　<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig      PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig><settings cacheModelsEnabled="true" enhancementEnabled="true"lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="1000"maxSessions="228" maxTransactions="128" useStatementNamespaces="true" /><sqlMap resource="sign.xml" /></sqlMapConfig>
　　<?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 namespace="sign"><select id="getAllSign" parameterClass="java.lang.Integer"resultClass="com.test.po.Sign"><!--[CDATA[select id as id,username as username,password as passwordfrom sign]]></select><select id="getById" parameterClass="java.lang.Integer"resultClass="com.test.po.Sign"><![CDATA[select id as id,username as username,password as passwordfrom signwhere id = #id#]]></select><select id="getByUP" parameterClass="java.util.Map" resultClass="com.test.po.Sign"><![CDATA[select id as id,username as username,password as passwordfrom signwhere username = #username# and password=#password#]]></select><insert id="insert" parameterClass="com.test.po.Sign"><![CDATA[insert into `sign`(username,password)values(#username#,#password#)]]--></insert></sqlMap>
　　package com.test.dao.impl;import java.util.HashMap;import java.util.List;import java.util.Map;import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;import com.test.dao.ISignDAO;import com.test.po.Sign;public class SignDAO extends SqlMapClientDaoSupport implements ISignDAO {public List<Sign> getAllSign() {return (List<Sign>) getSqlMapClientTemplate().queryForList("sign.getAllSign");}public Sign getById(Integer id) {return (Sign) getSqlMapClientTemplate().queryForObject("sign.getById",id);}public Sign getByUP(String username, String password) {Map<String, String> params = new HashMap<String, String>();params.put("username", username);params.put("password", password);return (Sign) getSqlMapClientTemplate().queryForObject("sign.getByUP",params);}public void insert(Sign sign) {getSqlMapClientTemplate().insert("sign.insert", sign);}}