applicationContext.xml
(树叶或白菜)
<?
xml
version
=
"1.0"
encoding
=
"UTF-8"
?>
<!
DOCTYPE
beans
PUBLIC
"-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd"
>
<
beans
>
<
bean
id
=
"DataSource"
class
=
"org.apache.commons.dbcp.BasicDataSource"
>
<
property
name
=
"driverClassName"
>
<
value
>
com.microsoft.jdbc.sqlserver.SQLServerDriver
</
value
>
</
property
>
<
property
name
=
"url"
>
<!-- value中间不能有空格-->
<
value
>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DB_Wuliu
</
value
>
</
property
>
<
property
name
=
"username"
>
<
value
>
sa
</
value
>
</
property
>
</
bean
>
<
bean
id
=
"SessionFactory"
class
=
"org.springframework.orm.hibernate3.LocalSessionFactoryBean"
>
<
property
name
=
"dataSource"
>
<
ref
bean
=
"DataSource"
/>
</
property
>
<
property
name
=
"hibernateProperties"
>
<
props
>
<
prop
key
=
"hibernate.dialect"
>
org.hibernate.dialect.SQLServerDialect
</
prop
>
<
prop
key
=
"hibernate.show_sql"
>
true
</
prop
>
</
props
>
</
property
>
<
property
name
=
"mappingResources"
>
<
list
>
<
value
>
com/Lianxi.hbm.xml
</
value
>
<
value
>
com/Luser.hbm.xml
</
value
>
</
list
>
</
property
>
</
bean
>
<
bean
id
=
"LuserDAO"
class
=
"com.LuserDAO"
>
<
property
name
=
"sessionFactory"
>
<
ref
bean
=
"SessionFactory"
/>
</
property
>
</
bean
>
<!-- struts中action的配置。"iuser"为UserAction类中声明的接口变量,"LuserDAO"为接口的实现类-->
<
bean
name
=
"/user"
class
=
"com.struts.action.UserAction"
>
<
property
name
=
"iuser"
>
<
ref
bean
=
"LuserDAO"
/>
</
property
>
</
bean
>
</
beans
>
struts-config.xml
<?
xml
version
=
"1.0"
encoding
=
"UTF-8"
?>
<!
DOCTYPE
struts-config
PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
"http://struts.apache.org/dtds/struts-config_1_2.dtd"
>
<
struts-config
>
<
data-sources
/>
<
form-beans
>
<
form-bean
name
=
"userForm"
type
=
"com.struts.form.UserForm"
/>
<
form-bean
name
=
"lianxirenForm"
type
=
"com.struts.form.LianxirenForm"
/>
</
form-beans
>
<
global-exceptions
/>
<
global-forwards
/>
<
action-mappings
>
<!-- type
属性里写代理类
-->
<
action
attribute
=
"userForm"
input
=
"/user.jsp"
name
=
"userForm"
parameter
=
"method"
path
=
"/user"
scope
=
"request"
type
=
"org.springframework.web.struts.DelegatingActionProxy"
>
<
forward
name
=
"user"
path
=
"/user.jsp"
/>
</
action
>
</
action-mappings
>
<!-- 需要加插件-->
<
message-resources
parameter
=
"com.struts.ApplicationResources"
/>
<
plug-in
className
=
"org.springframework.web.struts.ContextLoaderPlugIn"
>
<
set-property
property
=
"contextConfigLocation"
value
=
"/WEB-INF/classes/applicationContext.xml"
/>
</
plug-in
>
</
struts-config
>
一个
DAO
类
package
com.hp.hibernate.bean;
import
java.util.List;
import
org.apache.commons.logging.Log;
import
org.apache.commons.logging.LogFactory;
import
org.hibernate.LockMode;
import
org.springframework.context.ApplicationContext;
import
org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import
com.hp.struts.dao.IPlacard;
public
class
DbPlacardDAO
extends
HibernateDaoSupport
implements
IPlacard {
protected
void
initDao() {
// do nothing
}
// save
public
void
hp_sava(DbPlacard dbplacard) {
getHibernateTemplate().save(dbplacard);
}
// selectAll
public
List hp_findAll() {
List list = getHibernateTemplate().find(
"from DbPlacard"
);
return
list;
}
// delete by Id
public
void
hp_delete(DbPlacard dbplacard) {
getHibernateTemplate().delete(dbplacard);
}
// update by Id
public
void
hp_update(DbPlacard dbplacard) {
getHibernateTemplate().update(dbplacard);
}
// select by Id
public
DbPlacard hp_findById(Integer id) {
DbPlacard placard = (DbPlacard) (getHibernateTemplate().get(
"com.hp.hibernate.bean.DbPlacard"
, id));
return
placard;
}
}
Junit
测试
package
com.bean;
import
java.util.List;
import
org.springframework.context.ApplicationContext;
import
org.springframework.context.support.FileSystemXmlApplicationContext;
import
junit.framework.TestCase;
public
class
BUserDAOTest
extends
TestCase {
ApplicationContext
ctx
=
new
FileSystemXmlApplicationContext(
"src/applicationContext.xml"
);
//
实例化一个接口对象
IUser
dao
= (IUser)
ctx
.getBean(
"BUserDAO"
);
public
void
testSelectAll() {
List list;
list =
dao
.selectAll();
System.
out
.println(list.size());
}
}
模糊查询
public
List powerFuzzyQuery(String powerName) {
List list = getHibernateTemplate().find(
"from jfis.bean.JfisPowerSys where powerName like ?"
,
"%"
+ powerName +
"%"
);
return
list;
}