ssh整合
1、
2、
|
4、applicationContext.xml <?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:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- 自动扫描与装配bean --> <context:component-scan base-package="com.workit"></context:component-scan> <!-- 导入外部的properties文件 --> <context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置数据库连接池(c3p0) --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <!-- 基本信息 --> <property name="jdbcUrl" value="${jdbcUrl}"></property> <property name="driverClass" value="${driverClass}"></property> <property name="user" value="${user}"></property> <property name="password" value="${password}"></property> <!-- 其他配置 --> <!--初始化时获取三个连接,取值应在minPoolSize与maxPoolSize之间。Default: 3 --> <property name="initialPoolSize" value="3"></property> <!--连接池中保留的最小连接数。Default: 3 --> <property name="minPoolSize" value="30"></property> <!--连接池中保留的最大连接数。Default: 15 --> <property name="maxPoolSize" value="150"></property> <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 --> <property name="acquireIncrement" value="30"></property> <!-- 控制数据源内加载的PreparedStatements数量。如果maxStatements与maxStatementsPerConnection均为0,则缓存被关闭。Default: 0--> <property name="maxStatements" value="80"></property> <!-- maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0--> <property name="maxStatementsPerConnection" value="50"></property> <!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 --> <property name="maxIdleTime" value="18000"></property> </bean>
<!-- 配置SessionFactory --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <property name="configLocation" value="classpath:hibernate.cfg.xml"></property> </bean>
<!-- 配置声明式事务管理(采用注解的方式) --> <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory"></property> </bean> <tx:annotation-driven transaction-manager="txManager"/> </beans>
|
5、hibernate.cfg.xml <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration> <session-factory>
<property name="myeclipse.connection.profile">WorkitDb</property> <property name="connection.url"> jdbc:oracle:thin:@localhost:1521:oracle10 </property> <property name="connection.username">workit</property> <property name="connection.password">workit</property> <property name="connection.driver_class"> oracle.jdbc.driver.OracleDriver </property> <property name="dialect"> org.hibernate.dialect.Oracle9Dialect </property> <property name="format_sql">true</property> <property name="hbm2ddl.auto">update</property>
<!-- 导入映射配置 --> <mapping resource="com/workit/bean/EmpBean.hbm.xml" /> </session-factory> </hibernate-configuration> |
10、jdbc.properties jdbcUrl = jdbc:oracle:thin:@localhost:1521:oracle10 driverClass = oracle.jdbc.driver.OracleDriver user = workit password =workit
|
6、struts.xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts> <!-- 配置为开发模式 --> <constant name="struts.devMode" value="true" /> <!-- 配置扩展名为action -->
<!-- 配置主题 --> <constant name="struts.ui.theme" value="simple" /> <package name="workit" extends="struts-default"> <!-- 部门模块 --> <action name="EmpAction_*" class="com.workit.action.EmpAction" method = "{1}"> <result name = "findAllEmpt">/index.jsp</result> <result name = "uploadFiles">/index.jsp</result> <param name="uploadDir">/upload</param> </action>
</package>
</struts>
|
7、jdbc.properties jdbcUrl= jdbc:oracle:thin:@localhost:1521:oracle10 driverClass= oracle.jdbc.driver.OracleDriver user= workit password=workit |
|
12、通过hibernate反转生成bean
右键new
|
|
|
|
|
|
|
|