目录
一、导入pom包
二、配置文件
三、基于应用Dao层继承的类自带方法进行增删改查
3.1实体类Customer
3.2Dao层
3.3测试类
四、基于注解的增删改查
4.1Dao层
4.2测试类
五、一对多关系的表的案例
5.1联系人表
5.2顾客表
5.3Dao层
5.4.测试类
六、多对多关系的表的案例
6.1用户表
6.2角色表
6.3Dao层
6.4测试类
一、导入pom包
4.2.4.RELEASE
5.0.7.Final
1.6.6
1.2.12
0.9.1.2
8.0.27
junit
junit
4.9
test
org.aspectj
aspectjweaver
1.6.8
org.springframework
spring-aop
${spring.version}
org.springframework
spring-context
${spring.version}
org.springframework
spring-context-support
${spring.version}
org.springframework
spring-orm
${spring.version}
org.springframework
spring-beans
${spring.version}
org.springframework
spring-core
${spring.version}
org.hibernate
hibernate-core
${hibernate.version}
org.hibernate
hibernate-entitymanager
${hibernate.version}
org.hibernate
hibernate-validator
5.2.1.Final
c3p0
c3p0
${c3p0.version}
log4j
log4j
${log4j.version}
org.slf4j
slf4j-api
${slf4j.version}
org.slf4j
slf4j-log4j12
${slf4j.version}
mysql
mysql-connector-java
${mysql.version}
org.springframework.data
spring-data-jpa
1.9.0.RELEASE
org.springframework
spring-test
4.2.4.RELEASE
javax.el
javax.el-api
2.2.4
org.glassfish.web
javax.el
2.2.4
二、配置文件
update
三、基于应用Dao层继承的类自带方法进行增删改查
3.1实体类Customer
@Entity
@Table(name="cst_customer_2")
public class Customer implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="cust_id")
private Long custId;
@Override
public String toString() {
return "Customer{" +
"custId=" + custId +
", custName='" + custName + ''' +
", custSource='" + custSource + ''' +
", custIndustry='" + custIndustry + ''' +
", custLevel='" + custLevel + ''' +
", custAddress='" + custAddress + ''' +
", custPhone='" + custPhone + ''' +
'}';
}
@Column(name="cust_name")
private String custName;
@Column(name="cust_source")
private String custSource;
@Column(name="cust_industry")
private String custIndustry;
@Column(name="cust_level")
private String custLevel;
@Column(name="cust_address")
private String custAddress;
@Column(name="cust_phone")
private String custPhone;
public Long getCustId() {
return custId;
}
public void setCustId(Long custId) {
this.custId = custId;
}
public String getCustName() {
return custName;
}
public void setCustName(String custName) {
this.custName = custName;
}
public String getCustSource() {
return custSource;
}
public void setCustSource(String custSource) {
this.custSource = custSource;
}
public String getCustIndustry() {
return custIndustry;
}
public void setCustIndustry(String custIndustry) {
this.custIndustry = custIndustry;
}
public String getCustLevel() {
return custLevel;
}
public void setCustLevel(String custLevel) {
this.custLevel = custLevel;
}
public String getCustAddress() {
return custAddress;
}
public void setCustAddress(String custAddress) {
this.custAddress = custAddress;
}
public String getCustPhone() {
return custPhone;
}
public void setCustPhone(String custPhone) {
this.custPhone = custPhone;
}
}
update
三、基于应用Dao层继承的类自带方法进行增删改查
3.1实体类Customer
@Entity
@Table(name="cst_customer_2")
public class Customer implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="cust_id")
private Long custId;
@Override
public String toString() {
return "Customer{" +
"custId=" + custId +
", custName='" + custName + ''' +
", custSource='" + custSource + ''' +
", custIndustry='" + custIndustry + ''' +
", custLevel='" + custLevel + ''' +
", custAddress='" + custAddress + ''' +
", custPhone='" + custPhone + ''' +
'}';
}
@Column(name="cust_name")
private String custName;
@Column(name="cust_source")
private String custSource;
@Column(name="cust_industry")
private String custIndustry;
@Column(name="cust_level")
private String custLevel;
@Column(name="cust_address")
private String custAddress;
@Column(name="cust_phone")
private String custPhone;
public Long getCustId() {
return custId;
}
public void setCustId(Long custId) {
this.custId = custId;
}
public String getCustName() {
return custName;
}
public void setCustName(String custName) {
this.custName = custName;
}
public String getCustSource() {
return custSource;
}
public void setCustSource(String custSource) {
this.custSource = custSource;
}
public String getCustIndustry() {
return custIndustry;
}
public void setCustIndustry(String custIndustry) {
this.custIndustry = custIndustry;
}
public String getCustLevel() {
return custLevel;
}
public void setCustLevel(String custLevel) {
this.custLevel = custLevel;
}
public String getCustAddress() {
return custAddress;
}
public void setCustAddress(String custAddress) {
this.custAddress = custAddress;
}
public String getCustPhone() {
return custPhone;
}
public void setCustPhone(String custPhone) {
this.custPhone = custPhone;
}
}
@Entity
@Table(name="cst_customer_2")
public class Customer implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="cust_id")
private Long custId;
@Override
public String toString() {
return "Customer{" +
"custId=" + custId +
", custName='" + custName + ''' +
", custSource='" + custSource + ''' +
", custIndustry='" + custIndustry + ''' +
", custLevel='" + custLevel + ''' +
", custAddress='" + custAddress + ''' +
", custPhone='" + custPhone + ''' +
'}';
}
@Column(name="cust_name")
private String custName;
@Column(name="cust_source")
private String custSource;
@Column(name="cust_industry")
private String custIndustry;
@Column(name="cust_level")
private String custLevel;
@Column(name="cust_address")
private String custAddress;
@Column(name="cust_phone")
private String custPhone;
public Long getCustId() {
return custId;
}
public void setCustId(Long custId) {
this.custId = custId;
}
public String getCustName() {
return custName;
}
public void setCustName(String custName) {
this.custName = custName;
}
public String getCustSource() {
return custSource;
}
public void setCustSource(String custSource) {
this.custSource = custSource;
}
public String getCustIndustry() {
return custIndustry;
}
public void setCustIndustry(String custIndustry) {
this.custIndustry = custIndustry;
}
public String getCustLevel() {
return custLevel;
}
public void setCustLevel(String custLevel) {
this.custLevel = custLevel;
}
public String getCustAddress() {
return custAddress;
}
public void setCustAddress(String custAddress) {
this.custAddress = custAddress;
}
public String getCustPhone() {
return custPhone;
}
public void setCustPhone(String custPhone) {
this.custPhone = custPhone;
}
}
3.2Dao层
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {
}
3.3测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class CustomDaoTest {
@Autowired
private CustomerDao customerDao;
@Test
public void TestSave(){
Customer c=new Customer();
c.setCustName("多宝鱼");
customerDao.save(c);
}
@Test
public void TestUpadate(){
Customer c=customerDao.findOne(1L);
c.setCustName("多宝鱼");
customerDao.save(c);
}
@Test
public void testById(){
Customer customer=customerDao.findOne(1L);
System.out.println(customer);
}
@Test
public void testDelete(){
customerDao.delete(1L);
}
四、基于注解的增删改查
4.1Dao层
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {
@Query(value="update Customer set custName=?1 where custId=?2")
@Modifying
void UpdateCustmer(String custName, long custId);
@Query(value="from Customer where custName= ?1 and custId=?2")
Customer findCustNameAndId(String custName, long custId);
@Query(value="select * from cst_customer_2 where cust_name like ?1",nativeQuery = true)
List
4.2测试类
@Test
@Transactional
@Rollback(value=false)
public void testUpdate2(){
customerDao.UpdateCustmer("WW666",2L);
}
@Test
public void findCustNameAndId(){
Customer c=customerDao.findCustNameAndId("多宝鱼",3L);
System.out.println(c);
}
@Test
public void testFindByLikeName(){
List
五、一对多关系的表的案例
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class CustomDaoTest {
@Autowired
private CustomerDao customerDao;
@Test
public void TestSave(){
Customer c=new Customer();
c.setCustName("多宝鱼");
customerDao.save(c);
}
@Test
public void TestUpadate(){
Customer c=customerDao.findOne(1L);
c.setCustName("多宝鱼");
customerDao.save(c);
}
@Test
public void testById(){
Customer customer=customerDao.findOne(1L);
System.out.println(customer);
}
@Test
public void testDelete(){
customerDao.delete(1L);
}
四、基于注解的增删改查
4.1Dao层
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {
@Query(value="update Customer set custName=?1 where custId=?2")
@Modifying
void UpdateCustmer(String custName, long custId);
@Query(value="from Customer where custName= ?1 and custId=?2")
Customer findCustNameAndId(String custName, long custId);
@Query(value="select * from cst_customer_2 where cust_name like ?1",nativeQuery = true)
List
4.2测试类
@Test
@Transactional
@Rollback(value=false)
public void testUpdate2(){
customerDao.UpdateCustmer("WW666",2L);
}
@Test
public void findCustNameAndId(){
Customer c=customerDao.findCustNameAndId("多宝鱼",3L);
System.out.println(c);
}
@Test
public void testFindByLikeName(){
List
五、一对多关系的表的案例
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor { @Query(value="update Customer set custName=?1 where custId=?2") @Modifying void UpdateCustmer(String custName, long custId); @Query(value="from Customer where custName= ?1 and custId=?2") Customer findCustNameAndId(String custName, long custId); @Query(value="select * from cst_customer_2 where cust_name like ?1",nativeQuery = true) List
4.2测试类
@Test
@Transactional
@Rollback(value=false)
public void testUpdate2(){
customerDao.UpdateCustmer("WW666",2L);
}
@Test
public void findCustNameAndId(){
Customer c=customerDao.findCustNameAndId("多宝鱼",3L);
System.out.println(c);
}
@Test
public void testFindByLikeName(){
List
五、一对多关系的表的案例
Customer(顾客)表和Linkman(联系人)表之间的关系是一对多的。
5.1联系人表
@Entity
@Table(name="cst_linkman")
public class LinkMan implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="lkm_id")
private Long lkmId;
@Column(name = "lkm_name")
private String lkmName;
@Column(name="lkm_gender")
private String lkmGender;
@Column(name="lkm_phone")
private String lkmPhone;
@Column(name="lkm_mobile")
private String lkmMobile;
@Column(name="lkm_email")
private String lkmEmail;
@Column(name="lkm_position")
private String lkmPosition;
@Column(name="lkm_memo")
private String lkmMemo;
@ManyToOne(targetEntity = Customer.class)
@JoinColumn(name="lmk_cust_id",referencedColumnName = "cust_id") //外键和表的主键
private Customer customer;
public Long getLkmId() {
return lkmId;
}
public void setLkmId(Long lkmId) {
this.lkmId = lkmId;
}
public String getLkmName() {
return lkmName;
}
public void setLkmName(String lkmName) {
this.lkmName = lkmName;
}
public String getLkmGender() {
return lkmGender;
}
public void setLkmGender(String lkmGender) {
this.lkmGender = lkmGender;
}
public String getLkmPhone() {
return lkmPhone;
}
public void setLkmPhone(String lkmPhone) {
this.lkmPhone = lkmPhone;
}
public String getLkmMobile() {
return lkmMobile;
}
public void setLkmMobile(String lkmMobile) {
this.lkmMobile = lkmMobile;
}
public String getLkmEmail() {
return lkmEmail;
}
public void setLkmEmail(String lkmEmail) {
this.lkmEmail = lkmEmail;
}
public String getLkmPosition() {
return lkmPosition;
}
public void setLkmPosition(String lkmPosition) {
this.lkmPosition = lkmPosition;
}
public String getLkmMemo() {
return lkmMemo;
}
public void setLkmMemo(String lkmMemo) {
this.lkmMemo = lkmMemo;
}
@Override
public String toString() {
return "LinkMan{" +
"lkmId=" + lkmId +
", lkmName='" + lkmName + ''' +
", lkmGender='" + lkmGender + ''' +
", lkmPhone='" + lkmPhone + ''' +
", lkmMobile='" + lkmMobile + ''' +
", lkmEmail='" + lkmEmail + ''' +
", lkmPosition='" + lkmPosition + ''' +
", lkmMemo='" + lkmMemo + ''' +
'}';
}
5.2顾客表
在三的基础上,添加如下内容:
@OneToMany(targetEntity = LinkMan.class)
@JoinColumn(name="lmk_cust_id",referencedColumnName = "cust_id")
private Set linkmans=new HashSet(0);
5.3Dao层
public interface LinkManDao extends JpaRepository, JpaSpecificationExecutor {
}
public interface CustomerDao extends JpaRepository, JpaSpecificationExecutor {
}
5.4.测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestOnetoMany {
@Autowired
private CustomerDao customerDao;
@Autowired
private LinkManDao linkManDao;
@Test
@Transactional
@Rollback(value = false)
public void testAdd(){
Customer customer=new Customer();
customer.setCustName("buka");
LinkMan linkMan=new LinkMan();
linkMan.setLkmName("小明");
customerDao.save(customer);
linkManDao.save(linkMan);
}
}
六、多对多关系的表的案例
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestOnetoMany {
@Autowired
private CustomerDao customerDao;
@Autowired
private LinkManDao linkManDao;
@Test
@Transactional
@Rollback(value = false)
public void testAdd(){
Customer customer=new Customer();
customer.setCustName("buka");
LinkMan linkMan=new LinkMan();
linkMan.setLkmName("小明");
customerDao.save(customer);
linkManDao.save(linkMan);
}
}
六、多对多关系的表的案例
用户表和角色表是多对多的关系。
6.1用户表
@Entity
@Table(name="sys_user")
public class SysUser implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="user_id")
private Long userId;
@Column(name="user_code")
private String userCode;
@Column(name="user_name")
private String username;
@Column(name="user_password")
private String userPassword;
@Column(name="user_state")
private String userState;
@ManyToMany(mappedBy = "users")
private Set roles=new HashSet(0);
public Long getUserId() {
return userId;
}
public void setUserId(Long userId) {
this.userId = userId;
}
public String getUserCode() {
return userCode;
}
public void setUserCode(String userCode) {
this.userCode = userCode;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
public String getUserState() {
return userState;
}
public void setUserState(String userState) {
this.userState = userState;
}
public Set getRoles() {
return roles;
}
public void setRoles(Set roles) {
this.roles = roles;
}
@Override
public String toString() {
return "SysUser{" +
"userId=" + userId +
", userCode='" + userCode + ''' +
", username='" + username + ''' +
", userPassword='" + userPassword + ''' +
", userState='" + userState + ''' +
", roles=" + roles +
'}';
}
}
6.2角色表
@Entity
@Table
public class SysRole implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name="role_id")
private Long roleId;
@Column(name="role_name")
private String roleName;
@Column(name="role_memo")
private String roleMemo;
@ManyToMany
@JoinTable(name="user_role_rel",
joinColumns = {@JoinColumn(name="role_id",referencedColumnName = "role_id")}, //当前表的
inverseJoinColumns = {@JoinColumn(name="user_id",referencedColumnName ="user_id")} //另一个表的
)
private Set users=new HashSet(0);
public Long getRoleId() {
return roleId;
}
public void setRoleId(Long roleId) {
this.roleId = roleId;
}
public String getRoleName() {
return roleName;
}
public void setRoleName(String roleName) {
this.roleName = roleName;
}
public String getRoleMemo() {
return roleMemo;
}
public void setRoleMemo(String roleMemo) {
this.roleMemo = roleMemo;
}
public Set getUsers() {
return users;
}
public void setUsers(Set users) {
this.users = users;
}
@Override
public String toString() {
return "SysRole{" +
"roleId=" + roleId +
", roleName='" + roleName + ''' +
", roleMemo='" + roleMemo + ''' +
", users=" + users +
'}';
}
}
6.3Dao层
public interface SysUserDao extends JpaRepository, JpaSpecificationExecutor {
}
public interface SysRoleDao extends JpaRepository, JpaSpecificationExecutor {
}
6.4测试类
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestManytoMany {
@Autowired
private SysRoleDao sysRoleDao;
@Autowired
private SysUserDao sysUserDao;
@Test
@Transactional
@Rollback(value = false)
public void test(){
SysUser u1=new SysUser();
u1.setUsername("用户2");
SysRole r1=new SysRole();
r1.setRoleName("角色2");
u1.getRoles().add(r1);
r1.getUsers().add(u1);
sysRoleDao.save(r1);
sysUserDao.save(u1);
}
}
public interface SysUserDao extends JpaRepository, JpaSpecificationExecutor { }
public interface SysRoleDao extends JpaRepository, JpaSpecificationExecutor { }



