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();

          主站蜘蛛池模板: 丽水市| 越西县| 徐水县| 石棉县| 镇宁| 临沭县| 集贤县| 汶川县| 正镶白旗| 同心县| 晋中市| 含山县| 醴陵市| 武胜县| 锦屏县| 中西区| 靖江市| 东乌珠穆沁旗| 滦南县| 天镇县| 凤山市| 霍州市| 富民县| 阿克苏市| 巍山| 喜德县| 安泽县| 新晃| 伊宁县| 尚志市| 平武县| 如东县| 盐池县| 北安市| 咸宁市| 花莲县| 前郭尔| 伊通| 宣化县| 虎林市| 永新县|