用Hibernate框架+jtds链接数据库驱动+Sql2008数据库+Tomcat6.0+JDK1.7实现数据库链接

工程环境：MyEclipse8.5

其他配置：Hibernate框架+jtds链接数据库驱动+Sql2008数据库+Tomcat6.0+JDK1.7

开发环境：Win7

这个项目用到的jtds数据库链接驱动需要导入jdts-1.2.jar包

》》--项目源码和相关包--《《

第一步：创建一个项目为Hb_Sql

第二步：引入Hibernate框架

右击项目->MyEclipse->Add Hibernate Capabilities->到下图 填写链接数据库的地址、驱动、user、password->完成Hibernate的配置。

第三步：导入链接数据库用到的相关包和配置

右击项目选择properties->java build path->Libraries->Add JARs选择jdts-1.2.jar

第四步：创建两个JAVA文件和一个XML配置文件 测试链接数据库

1.department.java

package com.cqvie;
public class department {
	private Integer depID;
	private String depName;

	public Integer getDepID() {
		return depID;
	}

	public void setDepID(Integer depID) {
		this.depID = depID;
	}

	public String getDepName() {
		return depName;
	}

	public void setDepName(String depName) {
		this.depName = depName;
	}

	public department() {
		
	}

}

2.test.java

package com.cqvie;

import org.hibernate.*;
import org.hibernate.cfg.*;
//import javax.persistence.Entity;//使用使用jpa的Entity
//import org.hibernate.annotations.Entity;//问题的所在  
public class test {
	public static void insertDep()
	{

	  Configuration configuration=new Configuration().configure();
	  //configuration.configure("/hibernate.cfg.xml");
	  
	  SessionFactory sessionFactory=configuration.buildSessionFactory();
	  Session session=sessionFactory.openSession();
	  Transaction trans=session.beginTransaction();
	  
	  department dep=new department();
	  dep.setDepName("销售部");	  
	  session.save(dep);
	  
	  trans.commit();
	  session.close();

	}
}

3.在src下创建XML配置文件 department.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
    <class name="com.cqvie.department" table="t_dep"><span style="white-space:pre">	<!--</span>t_dep为表名<span style="white-space:pre">--></span>
        <id name="depID" type="java.lang.Integer">
            <column name="depID" /><span style="white-space:pre">			</span><pre name="code" class="html"><span>							<!--</span>depID为列<span>--></span>

<generator class="native" /> </id> <property name="depName" type="java.lang.String"> <column name="depName" length="45" not-null="true" />

<span>							<!--</span>depName<span style="font-family: Arial, Helvetica, sans-serif;">为列</span><span>--></span>

</property> </class></hibernate-mapping>

4.hibernate.cfg.xml

<?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="dialect">
		org.hibernate.dialect.SQLServerDialect
	</property>
	<property name="connection.url">
		jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=Supermarket
	</property>
	<property name="connection.username">sa</property>
	<property name="connection.password">123</property>
	<property name="connection.driver_class">
		net.sourceforge.jtds.jdbc.Driver
	</property>
	<property name="hibernate.show_sql">true</property>
	<mapping resource="department.hbm.xml" />
</session-factory>
</hibernate-configuration>

第五步：运行项目

信息窗口出现下面这个提示就表示数据已经插入数据库

信息: Server startup in 2295 ms
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into t_dep (depName) values (?)

关于这个项目的相关包和源码打包上传！