hibernate+jtds链接数据库
<!--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>
//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();
}
}
//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() {
}
}
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"> <id name="depID" type="java.lang.Integer"> <column name="depID" /> <generator class="native" /> </id> <property name="depName" type="java.lang.String"> <column name="depName" length="45" not-null="true" /> </property> </class> </hibernate-mapping>