- 用户操作
- [留言] [发消息] [加为好友]
- 订阅我的博客
-
-
-
-
- overmind的公告
- <div style="font-size:14px">msn:<br> overmind_80@msn.com </div> <!--google Adsense Start--> <script type="text/javascript"><!-- google_ad_client = "pub-1576448528276333"; google_ad_width = 125; google_ad_height = 125; google_ad_format = "125x125_as"; google_ad_channel =""; google_color_border = "CCCCCC"; google_color_bg = "FFFFFF"; google_color_link = "000000"; google_color_url = "666666"; google_color_text = "333333"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <!--google Adsense End--> <br> <!-- Search Google --> <A HREF="http://www.google.com/intl/zh-CN/"> <IMG SRC="http://www.google.com/logos/Logo_40wht.gif" border="0" ALT="Google" align="absmiddle"></A> <!-- Search Google --> <br> <!--firefox start--> <a href="http://www.spreadfirefox.com/?q=affiliates&id=41956&t=77"><img border="0" alt="Get Firefox!" title="Get Firefox!" src="http://www.spreadfirefox.com/community/images/affiliates/Buttons/120x60/blank.gif"/></a> <!--firefox end--> <br> <!--clock start--> <EMBED SRC="http://211.155.23.192/~pilu/hbdx2002/clock/clock47.swf" WIDTH=150 HEIGHT=90 wmode=transparent quality=high loop=true menu=false> <!--clock start--> <br> <!-- alexa <SCRIPT type='text/javascript' language='JavaScript' src='http://xsltcache.alexa.com/traffic_graph/js/g/a/3m?&u=http%3A%2F%2F211.144.133.22%2Fliuqing%2F'></SCRIPT>--> <br> <!-- Blog日历表开始 --> <script language="javascript"> var diarydays="<2004-08-05><2004-08-09><2004-08-12><2004-08-17><2004-08-19><2004-07-14><2004-07-13><2004-07-08><2004-07-05><2004-07-04><2004-07-03><2004-06-27><2004-06-26><2004-06-25>"; </script> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <style> .calendarBigBorder { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; text-decoration: none; width: 170; background-color: #FFFFFF; font-size: 9pt;border:1px dotted #999; } .calendarTd { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #000000; background-color: #eeeeee; height: 18px; width: 11%; text-align: center;} .calendarMInput { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; text-decoration: none; background-color: #FFFFFF; height: 15px; border: 1px solid #666666; width: 19px; color: #0099FF;} .calendarYInput { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #0099FF; text-decoration: none; background-color: #FFFFFF; height: 15px; width: 34px; border: 1px solid #666666;} .calendarMonthTitle { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: normal; height: 24px; text-align: center; color: #333333; text-decoration: none; background-color: #eeeeee; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-bottom-style: none; border-top-color: #999999; border-right-color: #999999; border-bottom-color: #999999; border-left-color: #999999;} .calendarNow { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: bold; color: #000000; background-color: #C0C9D3; height: 18px; text-align: center;} .calendarDaySat { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #333333; text-decoration: none; background-color: #eeeeee; text-align: center; height: 18px; width: 12%;} .calendarDaySun { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #333333; text-decoration: none; background-color: #eeeeee; text-align: center; height: 18px; width: 12%;} .calendarLink { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: normal; color: #333333; text-decoration: none; background-color: #E7E7F6; text-align: center; height: 18px;} .categoryTxt { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; line-height: 23px; color: #333333; text-decoration: none;} .categoryTable { border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-right-color: #000000; border-bottom-color: #000000; border-top-width: 1px; border-top-style: solid; border-top-color: #71b99c;} </style> <SCRIPT LANGUAGE="JavaScript"> var months = new Array("一", "二", "三","四", "五", "六", "七", "八", "九","十", "十一", "十二"); var daysInMonth = new Array(31, 28, 31, 30, 31, 30, 31, 31,30, 31, 30, 31); var days = new Array("日","一", "二", "三","四", "五", "六"); var classTemp; var calendarHover="calendarHover"; var today=new getToday(); var year=today.year; var month=today.month; var newCal; //得到某月天数 function getDays(month, year) { if (1 == month) return ((0 == year % 4) && (0 != (year % 100))) ||(0 == year % 400) ? 29 : 28; else return daysInMonth[month]; } //得到当天时间信息 function getToday() { this.now = new Date(); this.year = this.now.getFullYear(); this.month = this.now.getMonth(); this.day = this.now.getDate(); } //生成日历 function Calendar() { newCal = new Date(year,month,1); //当前月的第一天 today = new getToday(); var day = -1; //用来判断日历中是否为当天 var startDay = newCal.getDay(); //当月开始时间 var endDay=getDays(newCal.getMonth(), newCal.getFullYear());//当月结束时间 var daily = 0; //用来生成日历中的天数值 if ((today.year == newCal.getFullYear()) &&(today.month == newCal.getMonth())) day = today.day; var caltable = document.all.caltable.tBodies.calendar; //得到日历表格的集合 var intDaysInMonth =getDays(newCal.getMonth(), newCal.getFullYear()); //得到当月天数 //生成日历 for (var intWeek = 0; intWeek < caltable.rows.length;intWeek++) for (var intDay = 0;intDay < caltable.rows[intWeek].cells.length;intDay++) { var cell = caltable.rows[intWeek].cells[intDay]; //得到单元袼 //生成字符串用于判断当天是否有日志 var montemp=(newCal.getMonth()+1)<10?("0"+(newCal.getMonth()+1)):(newCal.getMonth()+1); if ((intDay == startDay) && (0 == daily)){ daily = 1;} var daytemp=daily<10?("0"+daily):(daily); var d="<"+newCal.getFullYear()+"-"+montemp+"-"+daytemp+">"; //选择样式 if(day==daily) cell.className="calendarNow"; else if(diarydays.indexOf(d)!=-1) cell.className="calendarLink"; else if(intDay==6) cell.className = "calendarDaySat"; else if (intDay==0) cell.className ="calendarDaySun"; else cell.className="calendarTd"; //生成值 if ((daily > 0) && (daily <= intDaysInMonth)) { cell.innerText = daily; daily++; } else cell.innerText = ""; } document.all.year.value=year; document.all.month.value=month+1; } function subMonth() { if ((month-1)<0) { month=11; year=year-1; } else { month=month-1; } Calendar(); } function addMonth() { if((month+1)>11) { month=0; year=year+1; } else { month=month+1; } Calendar(); } //得到响应事件 function getDiary() { var mon=(newCal.getMonth()+1)<10?("0"+(newCal.getMonth()+1)):(newCal.getMonth()+1); var day=event.srcElement.innerText<10?("0"+event.srcElement.innerText):(event.srcElement.innerText); var d="<"+newCal.getFullYear()+"-"+mon+"-"+day+">"; if ("TD" == event.srcElement.tagName) if (("" != event.srcElement.innerText)&&(diarydays.indexOf(d)!=-1)) { diary.location="/foxmail/archive/"+newCal.getFullYear()+"/"+mon+"/"+day+".aspx"; window.location.href = diary.location; } } function setDate() { if (document.all.month.value<1||document.all.month.value>12) { alert("月的有效范围在1-12之间!"); return; } year=Math.ceil(document.all.year.value); month=Math.ceil(document.all.month.value-1); Calendar(); } </SCRIPT> <table border="0" cellpadding="0" cellspacing="1" class="calendarBigBorder" id="caltable" width="200"> <thead> <tr align="center" valign="middle"> <td colspan="7" class="calendarMonthTitle"> <input name="year" type="text" class="calendarYInput" size="3" maxlength="4" onkeydown="if (event.keyCode==13){setDate()}" onkeyup="this.value=this.value.replace(/[^0-9]/g,'')" onpaste="this.value=this.value.replace(/[^0-9]/g,'')">年 <input name="month" type="text" class="calendarMInput" size="1" maxlength="2" onkeydown="if (event.keyCode==13){setDate()}" onkeyup="this.value=this.value.replace(/[^0-9]/g,'')" onpaste="this.value=this.value.replace(/[^0-9]/g,'')">月 [<a onClick="addMonth()" href="javascript:;">下月</a>] [<a onClick="subMonth()" href="javascript:;">上月</a>]</td> </tr> <tr align="center" valign="middle"> <SCRIPT LANGUAGE="JavaScript"> document.write("<TD class=calendarDaySun id=diary>" + days[0] + "</TD>"); for (var intLoop = 1; intLoop < days.length-1; intLoop++) document.write("<TD class=calendarTd id=diary>" + days[intLoop] + "</TD>"); document.write("<TD class=calendarDaySat id=diary>" + days[intLoop] + "</TD>"); </SCRIPT> </TR> </thead> <TBODY border=1 cellspacing="0" cellpadding="0" ID="calendar" ALIGN=CENTER ONCLICK="getDiary()" onmouseup=document.selection.empty() oncontextmenu="return false" onselectstart="return false" ondragstart="return false" onbeforecopy="return false" oncopy=document.selection.empty() onselect=document.selection.empty()> <SCRIPT LANGUAGE="JavaScript"> for (var intWeeks = 0; intWeeks < 6; intWeeks++) { document.write("<TR style='cursor:hand'>"); for (var intDays = 0; intDays < days.length;intDays++) document.write("<TD class=calendarTd onMouseover='{classTemp=this.className;this.className=calendarHover}' onMouseOut='this.className=classTemp'></TD>"); document.write("</TR>"); } </SCRIPT> </tbody> </table> <script LANGUAGE="JavaScript"> Calendar(); </script> <!-- Blog日历表结束 --> <!-- 天气预报 注意这里涉及到编码问题，%B1%B1%BE%A9为城市代码,可用百度查一下,比如输入北京,地址栏中就会出现%B1%B1%BE%字样的内容--> <center><iframe width=157 height=240 frameborder=0 scrolling=NO src='http://appnews.qq.com/cgi-bin/news_qq_search?city=%B1%B1%BE%A9'></iframe></center> <br>
- 文章分类
- Blogs
- jimhou(RSS)
- www.yyrj.com.cn
- 冰云
- 应用软件论坛-应用软件方面最好的论坛(office、word、excel...)
- flash+as+html
- 推荐的网站
- 老爸一个人的网站（赞）
- 老爸一个人的网站（赞）
- 存档
在一个web项目里面添加hibernate（感谢龚立建同学）
收藏
在eclipse里面很简单，首先是有myEclipse，或者是有Hibernate的其它插件，然后对于这个项目add HibernateCapabilities就可以了。这个东东的核心是配置一个数据库和jdbc之间的连接代码如下
<?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://10.66.12.222:3306/test</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="connection.password">123456</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="show_sql">true</property> <mapping resource="cn/edu/cuc/main/User.hbm.xml" /> </session-factory></hibernate-configuration>实际上很简单，在最后一句是对于一个的表的配置，什么样子的的表呢？
上传表了之后按照如下的结构构建文件结构。
其中User.hbm.xml就是对于User表的映射文件，这个xml文件如下所示
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" ><hibernate-mapping package="cn.edu.cuc.main"><class name="User" table="test"> <id name="id" column="id" type="integer"> <generator class="native"/> </id> <property name="username" type="string" column="username"/> <property name="password" column="pwd"/></class></hibernate-mapping>Hibernate包加载之后会自动生成一个HibernateSessionFactory.java供我们调用。
package cn.edu.cuc.main;import org.hibernate.HibernateException;import org.hibernate.Session;import org.hibernate.cfg.Configuration;
/** *//**
* Configures and provides access to Hibernate sessions, tied to the * current thread of execution. Follows the Thread Local Session * pattern, see {@link http://hibernate.org/42.html }.
*/public class HibernateSessionFactory ...{
/** *//** * Location of hibernate.cfg.xml file. * Location should be on the classpath as Hibernate uses * #resourceAsStream style lookup for its configuration file. * The default classpath location of the hibernate config file is * in the default package. Use #setConfigFile() to update * the location of the configuration file for the current session. 
*/ private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml"; private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); private static Configuration configuration = new Configuration(); private static org.hibernate.SessionFactory sessionFactory; private static String configFile = CONFIG_FILE_LOCATION; private HibernateSessionFactory() ...{ } /** *//** * Returns the ThreadLocal Session instance. Lazy initialize * the <code>SessionFactory</code> if needed. * * @return Session * @throws HibernateException */ public static Session getSession() throws HibernateException ...{ Session session = (Session) threadLocal.get(); if (session == null || !session.isOpen()) ...{ if (sessionFactory == null) ...{ rebuildSessionFactory(); } session = (sessionFactory != null) ? sessionFactory.openSession() : null; threadLocal.set(session); } return session; } /** *//** * Rebuild hibernate session factory * */ public static void rebuildSessionFactory() ...{ try ...{ configuration.configure(configFile); sessionFactory = configuration.buildSessionFactory(); } catch (Exception e) ...{ System.err .println("%%%% Error Creating SessionFactory %%%%"); e.printStackTrace(); } } /** *//** * Close the single hibernate session instance. * * @throws HibernateException */ public static void closeSession() throws HibernateException ...{ Session session = (Session) threadLocal.get(); threadLocal.set(null); if (session != null) ...{ session.close(); } } /** *//** * return session factory * */ public static org.hibernate.SessionFactory getSessionFactory() ...{ return sessionFactory; } /** *//** * return session factory * * session factory will be rebuilded in the next call */ public static void setConfigFile(String configFile) ...{ HibernateSessionFactory.configFile = configFile; sessionFactory = null; } /** *//** * return hibernate configuration * */ public static Configuration getConfiguration() ...{ return configuration; }}此外，我还需要把Test封装成为一个类似于实体Bean的东西，代码如下，这些东西可以自动生成Seter和Getter方法。
package cn.edu.cuc.main;import org.hibernate.HibernateException;import org.hibernate.Session;import org.hibernate.cfg.Configuration;/** *//** * Configures and provides access to Hibernate sessions, tied to the * current thread of execution. Follows the Thread Local Session * pattern, see {@link http://hibernate.org/42.html }. */public class HibernateSessionFactory ...{ /** *//** * Location of hibernate.cfg.xml file. * Location should be on the classpath as Hibernate uses * #resourceAsStream style lookup for its configuration file. * The default classpath location of the hibernate config file is * in the default package. Use #setConfigFile() to update * the location of the configuration file for the current session. */ private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml"; private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); private static Configuration configuration = new Configuration(); private static org.hibernate.SessionFactory sessionFactory; private static String configFile = CONFIG_FILE_LOCATION; private HibernateSessionFactory() ...{ } /** *//** * Returns the ThreadLocal Session instance. Lazy initialize * the <code>SessionFactory</code> if needed. * * @return Session * @throws HibernateException */ public static Session getSession() throws HibernateException ...{ Session session = (Session) threadLocal.get(); if (session == null || !session.isOpen()) ...{ if (sessionFactory == null) ...{ rebuildSessionFactory(); } session = (sessionFactory != null) ? sessionFactory.openSession() : null; threadLocal.set(session); } return session; } /** *//** * Rebuild hibernate session factory * */ public static void rebuildSessionFactory() ...{ try ...{ configuration.configure(configFile); sessionFactory = configuration.buildSessionFactory(); } catch (Exception e) ...{ System.err .println("%%%% Error Creating SessionFactory %%%%"); e.printStackTrace(); } } /** *//** * Close the single hibernate session instance. * * @throws HibernateException */ public static void closeSession() throws HibernateException ...{ Session session = (Session) threadLocal.get(); threadLocal.set(null); if (session != null) ...{ session.close(); } } /** *//** * return session factory * */ public static org.hibernate.SessionFactory getSessionFactory() ...{ return sessionFactory; } /** *//** * return session factory * * session factory will be rebuilded in the next call */ public static void setConfigFile(String configFile) ...{ HibernateSessionFactory.configFile = configFile; sessionFactory = null; } /** *//** * return hibernate configuration * */ public static Configuration getConfiguration() ...{ return configuration; }}最后是一个测试类，继承了TestCase这是一个JUnit测试，很简单，看一下代码。
package test.cn.edu.cuc.main;import java.util.List;import junit.framework.TestCase;import org.hibernate.Session;import org.hibernate.Transaction;import cn.edu.cuc.main.HibernateSessionFactory;import cn.edu.cuc.main.User;public class UserTest extends TestCase...{ @SuppressWarnings("unchecked") public void testUser()...{ User test=new User(); test.setPassword("11111"); test.setUsername("hehe"); Session session=HibernateSessionFactory.getSession(); Transaction transaction=session.beginTransaction(); // session.save(test); String hql="from User"; List<User> testList=session.createQuery(hql).list(); if(testList==null)...{ System.out.println("is null...."); }else...{ System.out.println(testList.size()); for(User t:testList)...{ System.out.println(t.getId()+" ,"+ t.getUsername()+" ,"+t.getPassword()); } } for(User tt:testList)...{ if(tt.getId()==3)...{ session.delete(tt); } } transaction.commit(); System.out.println("is over...."); session.close(); }}注释掉的save（test）可以插入，后面的代码对应的就是查找和删除等，很简单，就是写配置文件比较复杂，不过听说有从数据库结构自动生成Hibernate配置文件的工具，那样的话就简单多了。
发表于 @ 2007年04月29日 19:22:00 | 评论( loading... ) | 举报| 收藏
旧一篇:eclipse的基础配置 | 新一篇:【video】制作方法
- 查看最新精华文章 请访问博客首页相关文章
-
- 发表评论
-
- 表 情：
-
- 评论内容：
- 用 户 名：