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

          mysql Blob hbn 操作

          Posted on 2008-01-28 09:53 G_G 閱讀(371) 評論(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();

          主站蜘蛛池模板: 娄底市| 固原市| 东源县| 天气| 右玉县| 景德镇市| 连江县| 峨眉山市| 关岭| 如皋市| 英山县| 高台县| 五家渠市| 固原市| 马关县| 雷州市| 芦溪县| 延吉市| 苏州市| 长兴县| 青龙| 黔江区| 长垣县| 景宁| 祁阳县| 维西| 南丹县| 土默特左旗| 宜昌市| 西城区| 泰顺县| 沙坪坝区| 马边| 和龙市| 高青县| 涟源市| 会理县| 个旧市| 大理市| 安岳县| 丁青县|