<?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 password from sign ]]> </select> <select id="getById" parameterClass="java.lang.Integer" resultClass="com.test.po.Sign"> <![CDATA[ select id as id, username as username, password as password from sign where 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 password from sign where 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); } }