此表结构
-- Create table
create table ZT
(
ZT_ID NUMBER(10) not null,
BT VARCHAR2(100),
SJ DATE default sysdate,
NL VARCHAR2(1024),
BTTP VARCHAR2(100)
)
tablespace DAQIN
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table ZT
is '专题';
-- Add comments to the columns
comment on column ZT.ZT_ID
is '专题ID';
comment on column ZT.BT
is '标题';
comment on column ZT.SJ
is '时间';
comment on column ZT.NL
is '内容';
comment on column ZT.BTTP
is '标题图片';
-- Create/Recreate primary, unique and foreign key constraints
alter table ZT
add constraint PK_ZT primary key (ZT_ID)
using index
tablespace DAQIN
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
后台增加方法,采用hibernate3增加方法如下:
package com.chinmusic;
import com.chinmusic.creDrive.HibernateSessionFactory;import com.chinmusic.bean.Zt;public class SecondHibernate {
public static void main(String [] args){
if(zt==null)
zt=new Zt();
//新增
HibernateSessionFactory.currentSession().save(zt);
//提交事务
HibernateSessionFactory.currentSession().beginTransaction().commit();
//操作成功
; HibernateSessionFactory.closeSession();
}
}
前台用如下:<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="com.chinmusic.bean.Zt" %>
<%@ page import="com.chinmusic.SecondHibernate"%>
<%@ page import="com.chinmusic.bean.Zt" %>
<%@ page import="java.util.Date" %>
<%@ page import="com.chinmusic.SecondHibernate" %>
<%
SecondHibernate db=new SecondHibernate();
Zt adminUser=new Zt();
adminUser.setBt("ddd");
adminUser.setNl("3333"); adminUser.setSj(new Date()); db.getData(adminUser);
%>
-- Create table
create table ZT
(
ZT_ID NUMBER(10) not null,
BT VARCHAR2(100),
SJ DATE default sysdate,
NL VARCHAR2(1024),
BTTP VARCHAR2(100)
)
tablespace DAQIN
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table ZT
is '专题';
-- Add comments to the columns
comment on column ZT.ZT_ID
is '专题ID';
comment on column ZT.BT
is '标题';
comment on column ZT.SJ
is '时间';
comment on column ZT.NL
is '内容';
comment on column ZT.BTTP
is '标题图片';
-- Create/Recreate primary, unique and foreign key constraints
alter table ZT
add constraint PK_ZT primary key (ZT_ID)
using index
tablespace DAQIN
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
后台增加方法,采用hibernate3增加方法如下:
package com.chinmusic;
import com.chinmusic.creDrive.HibernateSessionFactory;import com.chinmusic.bean.Zt;public class SecondHibernate {
public static void main(String [] args){
if(zt==null)
zt=new Zt();
//新增
HibernateSessionFactory.currentSession().save(zt);
//提交事务
HibernateSessionFactory.currentSession().beginTransaction().commit();
//操作成功
; HibernateSessionFactory.closeSession();
}
}
前台用如下:<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="com.chinmusic.bean.Zt" %>
<%@ page import="com.chinmusic.SecondHibernate"%>
<%@ page import="com.chinmusic.bean.Zt" %>
<%@ page import="java.util.Date" %>
<%@ page import="com.chinmusic.SecondHibernate" %>
<%
SecondHibernate db=new SecondHibernate();
Zt adminUser=new Zt();
adminUser.setBt("ddd");
adminUser.setNl("3333"); adminUser.setSj(new Date()); db.getData(adminUser);
%>
1.6591E124 ddd 2006-8-23 上午 11:02:50 3333