[標題]:在MyEclipse中開發(fā)Hibernate入門
[時間]:2009-6-17
[摘要]:一個MyEclipse Hibernate HelloWorld。
[關(guān)鍵字]:Hibernate，入門，MyEclipse，HelloWorld，MySQL Connector/J
[環(huán)境]:MyEclipse7 ，Hibernate3.2，MySQL5.1
[作者]:Winty (wintys@gmail.com) http://www.aygfsteel.com/wintys
[正文]:
1、新建工程:
在MyEclipse中新建一個Java Web Project( 或Java Project)，名叫MyEclipseHibernate，在工程名上點擊右鍵，在彈出菜單中選擇"MyEclipse=>Add Hibernate Capabilities..."(或選擇菜單欄上"MyEclipse=>Project Capabilities=>Add Hibernate Capabilities...")。其中連接數(shù)據(jù)庫使用MySQL驅(qū)動(放置位置/MyEclipseHibernate/WebRoot/WEB-INF/lib/mysql-connector-java-5.1.7-bin.jar)。MySQL驅(qū)動下載地址:http://dev.mysql.com/downloads/connector/j/5.1.html。
根據(jù)提示配置，會生成類似配置文件:
/MyEclipseHibernate/src/hibernate.cfg.xml：
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="connection.username">root</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/db
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile"></property>
<property name="connection.password">root</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="show_sql">true</property>
<!--后來添加的BookAuthor.hbm.xml-->
<mapping resource="wintys/hibernate/BookAuthor.hbm.xml" />
</session-factory>
</hibernate-configuration>
2、在MySQL中建立數(shù)據(jù)庫表:
CREATE TABLE `bookauthor` (
`authorId` varchar(100) NOT NULL DEFAULT '0',
`authorAge` int(4) DEFAULT NULL,
`authorName` varchar(20) DEFAULT NULL,
PRIMARY KEY (`authorId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
3、編寫實體類及映射文件:
BookAuthor.java:
package wintys.hibernate;
/**
* BookAuthor Bean
* @version 2009-5-19
* @author Winty(wintys@gmail.com) http://www.aygfsteel.com/wintys
*/
public class BookAuthor{
private int authorId;
private int authorAge;
private String authorName;
public int getAuthorId(){
return authorId;
}
public void setAuthorId(int authorId){
this.authorId = authorId;
}
public int getAuthorAge(){
return authorAge;
}
public void setAuthorAge(int authorAge){
this.authorAge = authorAge;
}
public String getAuthorName(){
return authorName;
}
public void setAuthorName(String authorName){
this.authorName = authorName;
}
}
編寫映射文件，并將其加入到hibernate.cfg.xml映射中:
/MyEclipseHibernate/src/wintys/hibernate/BookAuthor.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>
<class name="wintys.hibernate.BookAuthor" table="bookauthor">
<id name="authorId" column="authorId">
<generator class="increment"/>
</id>
<property name="authorAge"/>
<property name="authorName"/>
</class>
</hibernate-mapping>
4、測試
/MyEclipseHibernate/WebRoot/index.jsp:
<%@page contentType="text/html;charset=GBK" %>
<%@page import="wintys.hibernate.*"%>
<%@page import="org.hibernate.*"%>
<%@page import="org.hibernate.cfg.*"%>
<%
try{
SessionFactory sf =
new Configuration().configure().buildSessionFactory();
Session ss = sf.openSession();
Transaction tc = ss.beginTransaction();
BookAuthor bookAuthor = new BookAuthor();
bookAuthor.setAuthorId(8884);
bookAuthor.setAuthorAge(449);
bookAuthor.setAuthorName("asefdww");
ss.save(bookAuthor);
tc.commit();
ss.close();
out.println("insert:OK");
}catch(HibernateException e){
out.println(e.getMessage());
e.printStackTrace();
}
%>
5、運行結(jié)果
控制顯示:
Hibernate: select max(authorId) from bookauthor
Hibernate: insert into bookauthor (authorAge, authorName, authorId) values (?, ?, ?)
Web頁面顯示:
insert:OK
[參考資料]:
使用myeclipse開發(fā)第一個hibernate程序 : http://blog.csdn.net/freesnail/archive/2009/02/19/3908877.aspx
[附件]:手動開發(fā)Hibernate應用程序
[1]、
HibernateJavaSE_HelloWorld.zip : http://2xozaw.bay.livefilestore.com/y1pseTFkzzt9ht_m4qbiNjJvgDpKT5gp1ifnbX7HLhvjkmRQY0EmSyw9aE90Bu-mp6hkHEIcTDuIvm-6l_3BmztD2kRBO5d1kZe/HibernateJavaSETest_HelloWorld.zip?download
http://www.aygfsteel.com/Files/wintys/HibernateJavaSE_HelloWorld.zip
[2]、
HibernateJavaWeb_HelloWorld.zip : http://2xozaw.bay.livefilestore.com/y1pOG7LonhMrFHqc1OOqVYABFdZ8vONRfx2kgKu_TI5i6A6xqrah1fH7y2ImTcaMk-S0rrYUhoGJY7G3kqGFIrkEQ/HibernateJavaWeb_HelloWorld.zip?download
http://www.aygfsteel.com/Files/wintys/HibernateJavaWeb_HelloWorld.zip
posted on 2009-06-17 22:21
天堂露珠 閱讀(494)
評論(0) 編輯 收藏 所屬分類:
Hibernate