W3Cschool
恭喜您成為首批注冊用戶
獲得88經(jīng)驗(yàn)值獎(jiǎng)勵(lì)
當(dāng)將Java bean映射到實(shí)體時(shí),我們可以在映射注釋中設(shè)置數(shù)據(jù)庫表列定義。
以下代碼將列定義設(shè)置為 VARCHAR(40)
。
@Column(columnDefinition = "VARCHAR(40)") private String name;
@Column注釋表示物理數(shù)據(jù)庫列的特定特征。
下面的代碼來自Person.java。
package cn.w3cschool.common; import static javax.persistence.FetchType.LAZY; import javax.persistence.Basic; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Lob; import javax.persistence.Table; @Entity @Table(name="EMP") public class Person { @Id @Column(name = "EMP_ID") private long id; @Column(columnDefinition = "VARCHAR(40)") private String name; private String surname; public Person() {} public Person(String name, String surname) { this.name = name; this.surname = surname; } public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSurname() { return surname; } public void setSurname(String surname) { this.surname = surname; } @Override public String toString() { return "Person [id=" + id + ", name=" + name + ", surname=" + surname + "]"; } }
這里是顯示如何使用Person實(shí)體的代碼。
package cn.w3cschool.common; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import org.springframework.transaction.annotation.Transactional; @Transactional public class PersonDaoImpl { public void test(){ Person p1 = new Person("Tom", "Smith"); p1.setId(1L); Person p2 = new Person("Jack", "Kook"); p2.setId(2L); save(p1); save(p2); listAll(); } private void listAll(){ List<Person> persons = getAll(); for (Person person : persons) { System.out.println(person); } } @PersistenceContext private EntityManager em; public Long save(Person person) { em.persist(person); return person.getId(); } public List<Person>getAll() { return em.createQuery("SELECT p FROM Person p", Person.class).getResultList(); } }下載 Column_Definition.zip
這里是運(yùn)行上面的代碼的結(jié)果。
以下是數(shù)據(jù)庫表轉(zhuǎn)儲(chǔ)。
Table Name: EMP Row: Column Name: EMP_ID, Column Type: BIGINT: Column Value: 1 Column Name: NAME, Column Type: VARCHAR: Column Value: Tom Column Name: SURNAME, Column Type: VARCHAR: Column Value: Smith Row: Column Name: EMP_ID, Column Type: BIGINT: Column Value: 2 Column Name: NAME, Column Type: VARCHAR: Column Value: Jack Column Name: SURNAME, Column Type: VARCHAR: Column Value: Kook
Copyright©2021 w3cschool編程獅|閩ICP備15016281號(hào)-3|閩公網(wǎng)安備35020302033924號(hào)
違法和不良信息舉報(bào)電話:173-0602-2364|舉報(bào)郵箱:jubao@eeedong.com
掃描二維碼
下載編程獅App
編程獅公眾號(hào)
聯(lián)系方式:
更多建議: