hibernate 简单的根据id查询，select 没有*而只查了users0_id

最新推荐文章于 2019-07-07 23:25:05 发布

sakura579

最新推荐文章于 2019-07-07 23:25:05 发布

阅读量668

点赞数

文章标签： Hibernate Sqlserver

本文链接：https://blog.csdn.net/qq_39486658/article/details/89002434

版权

首先是查询id方法

@Override
	public Users findUsersById(int id) {
		// TODO Auto-generated method stub
		Session s = null;
		Users users = null;
		try {
			s = HibernateUtil.getSession();
			users = (Users) s.get(Users.class, id);
			return users;
		}finally {
			if(s!=null) {
				s.close();
			}
		}
	}

##其次是jar包
其中原本是cglib-2.1.3 萌新不懂得与cglib-2.2区别，但也更换（欢迎大佬指教，谢谢）
在这里插入图片描述
##测试方法

public class TestDao {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		UsersDao usersdao = new  UsersDaoHibernateImpl();
		Users user=usersdao.findUsersById(1);
		System.out.println(user.getName());
		System.out.println(user.getName()+"\n"+user.getPassword());
	}

}

##测试图片
在这里插入图片描述
##数据库

##users类

public class Users {
private int id;
private String name;
private int password;

public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public int getPassword() {
	return password;
}
public void setPassword(int password) {
	this.password = password;
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}


}

##HibernateUtil方法类

public class HibernateUtil {
	private static SessionFactory sessionFactory;
	private HibernateUtil() {
		
	}
	static{
		Configuration cfg = new Configuration();
		cfg.configure();
		sessionFactory = cfg.buildSessionFactory();
	}
	public static Session getSession() {
		return sessionFactory.openSession();
	}
	
}

##users.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.gsh.thehang.entity">
<class  name="Users">
<id name="id">
	<generator class="native"></generator>
</id>
<properties name="name" unique="true"></properties>
<properties name="password" unique="true"></properties>
</class>
</hibernate-mapping>

##Hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
		<property name="connection.url">jdbc:sqlserver://localhost:1433;database=thehang</property>
		<property name="hibernate.connection.username">sa</property>
		<property name="hibernate.connection.password">123456</property>
		<property name="dialect"> org.hibernate.dialect.SQLServerDialect</property>
		<property name="show_sql">true</property>
		<property name="hibernate.hbm2ddl.auto">update</property> 
		<mapping resource="com/gsh/thehang/entity/Users.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

##全部代码都在上面，如缺，会补，谢谢大佬