Hibernate的增删改查

User 包

 

package com;

 

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.Id;

import javax.persistence.Table;

 

import org.hibernate.annotations.GenericGenerator;

 

@Entity

@Table(name = "s_user")

public class User {

 

private Integer id;// int(11) NOT NULL主键

private String loginName;// varchar(20) NULL账号

private String loginPwd;

private String userName;

 

// 主键 ： @Id 主键生成方式：strategy = "increment"

// 映射表中id这个字段，不能为空，并且是唯一的

@GenericGenerator(name = "generator", strategy ="increment")

@Id

@GeneratedValue(generator = "generator")

@Column(name = "id", unique = true, nullable = false)

public Integer getId() {

return id;

}

 

public void setId(Integer id) {

this.id = id;

}

 

// 映射表中name这个字段 ，长度是500

@Column(name = "loginName", length = 500)

public String getLoginName() {

return loginName;

}

 

public void setLoginName(String loginName) {

this.loginName = loginName;

}

 

// 映射表中description这个字段 ，长度是500

@Column(name = "loginPwd", length = 500)

public String getLoginPwd() {

return loginPwd;

}

 

public void setLoginPwd(String loginPwd) {

this.loginPwd = loginPwd;

}

 

//映射表中description这个字段 ，长度是500

@Column(name = "userName", length = 500)

public String getUserName() {

return userName;

}

 

public void setUserName(String userName) {

this.userName = userName;

}

 

}

 

 

 

 

 

 

 

 

 

 

 

 

添加

package zsgc;

 

import org.hibernate.Session;

 

import com.HibernateSessionFactory;

import com.User;

 

 

 

public class Add {

public static void main(String[] args) {

Session sesss = HibernateSessionFactory.getSession();

sesss.beginTransaction();//开启事物

//中间写内容

User user = new User();

user.setLoginName("admin");

user.setLoginPwd("admin");

user.setUserName("管理员");

sesss.save(user);

sesss.getTransaction().commit();

sesss.close();

//sesss.getTransaction();//提交事物

 

}

 

}

 

删除

 

package zsgc;

 

import org.hibernate.Session;

 

import com.HibernateSessionFactory;

import com.User;

 

public class Dlelte {

public static void main(String[] args) {

Session sesss = HibernateSessionFactory.getSession();

sesss.beginTransaction();// 开启事物

// 中间写内容

User user = new User();

user.setId(2);

sesss.delete(user);

sesss.getTransaction().commit();

sesss.close();

}

 

}

 

 

修改

 

 

package zsgc;

 

import org.hibernate.Session;

 

import com.HibernateSessionFactory;

import com.User;

 

public class Update {

public static void main(String[] args) {

Session sesss = HibernateSessionFactory.getSession();

sesss.beginTransaction();// 开启事物

// 中间写内容

User user = new User();

user.setId(2);

user.setLoginName("qwe");

user.setLoginPwd("qwe");

sesss.saveOrUpdate(user);

sesss.getTransaction().commit();

sesss.close();

}

 

}

 

 

查询

 

package zsgc;

 

import java.util.List;

 

import org.hibernate.Query;

import org.hibernate.Session;

 

import com.HibernateSessionFactory;

import com.User;

 

public class QueryUser {

public static void main(String[] args) {

Session sesss = HibernateSessionFactory.getSession();

sesss.beginTransaction();// 开启事物

// 中间写内容

Query query = sesss.createQuery("from User ");

List list = query.list();

for (User u:list) {

System.out.print(u.getId()+",");

System.out.print(u.getLoginName()+",");

System.out.print(u.getLoginPwd()+",");

System.out.print(u.getUserName()+",");

System.out.println();

}

sesss.getTransaction().commit();

sesss.close();

}

}

 

转载于:https://www.cnblogs.com/fangshao/p/5546005.html