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

          mysql Blob hbn 操作

          Posted on 2008-01-28 09:53 G_G 閱讀(370) 評論(0)  編輯  收藏 所屬分類: hibernate
          1.數(shù)據(jù)庫
          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();

          主站蜘蛛池模板: 赫章县| 桑日县| 赤城县| 栾川县| 石河子市| 科技| 桓台县| 三江| 高碑店市| 固原市| 汤阴县| 治县。| 亚东县| 城固县| 麻江县| 民乐县| 旅游| 拉萨市| 榆中县| 重庆市| 清远市| 惠州市| 海阳市| 洪泽县| 隆尧县| 和硕县| 罗源县| 达拉特旗| 西畴县| 晋江市| 白水县| 衡山县| 泰顺县| 格尔木市| 青岛市| 墨玉县| 灵宝市| 克拉玛依市| 万山特区| 历史| 平乡县|