struts2+hibernate 配置数据库连接，sql 2005

[phpboy]

先问问这个吧，希望大侠指点

[phpboy]

急啊，求助

[zhj92lxs]

<hibernate-configuration>

<session-factory>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<!-- JDBCDriver -->
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<!-- JDBC URL -->
<property name="connection.url">jdbc:sqlserver://localhost:1433;databaseName=test;</property>
<!-- 用户名 -->
<property name="connection.username">sa</property>
<!-- 密码 -->
<property name="connection.password"></property>
<!-- 关系映射 -->
<mapping resource="com/test/User.hbm.xml"/>

</session-factory>
</hibernate-configuration>

<hibernate-mapping>

<class name="com.test.User">

<id name="id" column="id" type="java.lang.Integer">
<generator class="native"/>
</id>

<property name="name" column="name" type="java.lang.String"/>

<property name="age" column="age" type="java.lang.Integer"/>

</class>

</hibernate-mapping>


至于怎么在action中使用就不用说了吧

[phpboy]

我真不知道怎么用，很菜！
能给我个简单流程的例子么？

[jourqel]

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
	<session-factory>
		<property name="myeclipse.connection.profile">mysql</property>
		<property name="connection.url">
			jdbc:mysql://localhost:3306/rjxy
		</property>
		<property name="connection.username">root</property>
		<property name="connection.password">root</property>
		<property name="connection.driver_class">
			com.mysql.jdbc.Driver
		</property>
		<property name="dialect">
			org.hibernate.dialect.MySQLDialect
		</property>
		<property name="hibernate.current_session_context_class">
			thread
		</property>
		<property name="show_sql">true</property>
		<property name="hbm2ddl.auto">update</property>
		<mapping resource="cn/edu/ccu/rjxy/model/Administrator.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/News.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Recruit.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Employment.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Coach.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Experiment.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Pupil_job.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Student.hbm.xml" />
		<mapping resource="cn/edu/ccu/rjxy/model/Status.hbm.xml" />
	</session-factory>
</hibernate-configuration>

这是我某个网站的hibernate.cfg.xml的配置~希望对楼主有帮助~

[zhj92lxs]

这样啊，我现在没时间去弄过demo，其实你可以上网搜一下Struts 2与Hibernate整合，网上有很多的例子，你只需要把hibernate的配置文件换成我给的那个就可以连接sql2005了

[phpboy]

连接之后，我要怎么操作数据库呢？

[phpboy]

就是进行增加，删除，修改，等操作呢？如何用这个连接

[Kaka272827267]

跟做JDBC相仿