findByProperty的简单用法
写一个简单的bean以及生成对应的数据库表和Dao接口和方法
工具:myeclipse
一、
1.bean(这里我采用了JPA注解方式)
@Entity
@Table(name = "ADMINS")
public class Admins implements java.io.Serializable {
@Id
@Column(name = "ADMINS_ID", precision = 10, scale = 0)
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="Aid")//引用一个叫Aid的序列
@SequenceGenerator(name="Aid",sequenceName="ID_Auto_Increment")//引用数据库中的序列,叫ID_Auto_Increment(这里的序列需要在数据库自行创建,因为我用的是Oracle数据库),上面的Aid是别名
private Long adminsId;
@Column(name = "ADMINSNAME", unique=true,nullable = false)
private String adminsname;
@Column(name = "A_PASSWORD", nullable = false)
private String APassword;
@Column(name = "ADMINISTRATORSD")
@org.hibernate.annotations.Type(type="yes_no")
private Boolean administratorsd;
//对应的get、set方法及构造方法根据需求自习生成,这里只列出关键部分
}
2.配置xml(persistence.xml)
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="Graduation_project"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>cd.pojo.Admins</class><properties>
<property name="hibernate.connection.driver_class" value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
<property name="hibernate.connection.username" value="cdkeda"/>
<property name="hibernate.connection.password" value="147"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>//(这里如果数据库里面没有同名表就用update,有就用create)
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/>//这里是Oracle的方言
</properties>
</persistence-unit>
</persistence>
3.写个简单的测试类
package cd.test;