81,092
社区成员
发帖
与我相关
我的任务
分享
<?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.0.xsd">
<!-- SqlMapClient -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<!-- 指定配置文件的位置,让spring去寻找 -->
<property name="configLocation">
<value>/WEB-INF/config/SqlMapConfig.xml</value>
</property>
</bean>
<!-- 配置数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/test-vtm?useUnicode=true&characterEncoding=UTF-8</value>
<!-- ?useUnicode=true&characterEncoding=UTF-8 -->
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>123456</value>
</property>
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMap resource="com/yh/model/User.xml" />
</sqlMapConfig>
<?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">
<!--http://www.springframework.org/schema/beans/spring-beans-2.5.xsd 配置不能太高,太高會從網上下載 -->
<bean id="userAction" class="com.yh.web.UserAction">
<property name="userService">
<ref bean="userService" />
</property>
</bean>
<bean id="userService" class="com.yh.service.UserService">
<property name="userDao">
<ref bean="userDao" />
</property>
</bean>
<bean id="userDao" class="com.yh.dao.UserDao">
<!-- 将工厂注入到用户dao层 -->
<property name="sqlMapClient">
<ref bean="sqlMapClient" />
</property>
</bean>
</beans>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<!-- 设置别名 -->
<typeAlias alias="user" type="com.yh.model.User" />
<select id="findUserListCount" resultClass="int">
select count(*) from user
</select>
<!--insert id="insertUser" parameterClass="user">
INSERT INTO
user(NAME,PWD)
VALUES (#name#, #pwd#)
</insert-->
</sqlMap>