posts - 165, comments - 198, trackbacks - 0, articles - 1
            BlogJava :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理

          mysql Blob hbn 操作

          Posted on 2008-01-28 09:53 G_G 閱讀(369) 評論(0)  編輯  收藏 所屬分類: hibernate
          1.數據庫
          mysql>?desc?lotteryinformation?;
          +-------------+--------------+------+-----+---------+-------+
          |?Field???????|?Type?????????|?Null?|?Key?|?Default?|?Extra?|
          +-------------+--------------+------+-----+---------+-------+
          |?id??????????|?int(11)??????|?NO???|?PRI?|?NULL????|???????|
          |?type????????|?varchar(255)?|?NO???|?????|?NULL????|???????|
          |?title???????|?varchar(255)?|?YES??|?????|?NULL????|???????|
          |?inputTime???|?datetime?????|?YES??|?????|?NULL????|???????|
          |?content?????|?blob?????????|?YES??|?????|?NULL????|???????|
          |?recommended?|?bit(1)???????|?YES??|?????|?NULL????|???????|
          |?categories??|?varchar(255)?|?YES??|?????|?NULL????|???????|
          +-------------+--------------+------+-----+---------+-------+

          2.代碼
          ??????? //插入
          ??? ??? Session?sess?
          =??HibernateSessionFactory.getSession();
          ????????Transaction?tr?
          =?sess.beginTransaction();
          ????????LotteryNew?nn?
          =?new?LotteryNew();
          ????????nn.setInputTime(
          new?Date());
          ????????nn.setCategories(
          "t");
          ????????nn.setTitle(
          "new");
          ????????nn.setRecommended(
          true);
          ????????Blob?bo?
          =?Hibernate.createBlob("ggggg".getBytes());
          ????????nn.setContent(bo);
          ????????sess.save(nn);
          ????????tr.commit();
          ????????HibernateSessionFactory.closeSession();
          ???????
          ??? ??? //修改
          ????????sess?
          =??HibernateSessionFactory.getSession();
          ????????tr?
          =?sess.beginTransaction();
          ????????LotteryNew?lo?
          =?(LotteryNew)?sess.get(LotteryNew.class,?nn.getId());
          ????????Blob?bog?
          =?Hibernate.createBlob("xxxxx".getBytes());
          ????????lo.setContent(bog);
          ????????tr.commit();
          ????????HibernateSessionFactory.closeSession();
          ????????
          ??????? //查找
          ????????sess?
          =??HibernateSessionFactory.getSession();
          ????????LotteryNew?lo2?
          =?(LotteryNew)?sess.get(LotteryNew.class,?lo.getId());
          ????????InputStream?in?
          =?lo2.getContent().getBinaryStream()?;
          ????????
          byte[]?bbr?=?new?byte[in.available()];
          ????????in.read(bbr);
          ????????System.out.println(
          new?String(bbr));
          ????????HibernateSessionFactory.closeSession();

          主站蜘蛛池模板: 揭阳市| 巫山县| 祥云县| 绩溪县| 河西区| 大荔县| 福海县| 绥芬河市| 蒲江县| 新闻| 松江区| 辉南县| 东源县| 双牌县| 九江市| 钦州市| 丹阳市| 呼玛县| 河间市| 酉阳| 淮南市| 武山县| 镇康县| 桐柏县| 蛟河市| 方正县| 旺苍县| 龙海市| 柞水县| 塔河县| 玉林市| 碌曲县| 婺源县| 施甸县| 监利县| 武胜县| 大荔县| 丽江市| 武威市| 德昌县| 洛浦县|