hhh.jsp

来自「网络自动化办公系统」· JSP 代码 · 共 12 行

<jsp:useBean id="sqlbean" scope="session" class="org.zhengmao.soft.sqlcon" />
 <%
 String rowid="auto_increment";
 String txtcol="text";
 String bincol="blob";
    String sql ="create table userinfo(ID int not null  primary key "+rowid+",userid int not null default 0,Uname varchar(16),sex tinyint not null default 0,duty varchar(16),grade varchar(16),birthday varchar(32),polity varchar(16),health varchar(16),Nplace varchar(32),weight varchar(16),idcard varchar(15),marriage varchar(8) not null default 0,Fschool varchar(64),member varchar(16),speciality varchar(16),length varchar(8),study varchar(8),foreign1 varchar(16),Elevel varchar(8),Clevel varchar(8),Hplace varchar(64),QQ varchar(10),call varchar(16),place varchar(64),love varchar(64),award varchar(63),experience varchar(64),family varchar(64),contact varchar(64),remark "+txtcol+",nation varchar(16),height varchar(8),Ltime datetime,photo varchar(32) not null default 'image/jpeg',photo1 "+bincol+",phone varchar(24),mobile varchar(11),email varchar(64),havephoto tinyint not null default 0,ischeck tinyint not null default 0)";
//    String sql ="create table userinfo(ID int not null  primary key "+rowid+",userid int not null default 0,Uname varchar(16),sex varchar(6) not null default '"+sqlbean.to_8859_1("男性")+"',duty varchar(16),grade varchar(16),birthday varchar(32),polity varchar(16),health varchar(16),Nplace varchar(32),weight varchar(16),idcard varchar(15),marriage varchar(8) not null default '"+sqlbean.to_8859_1("未婚")+"',Fschool varchar(64),member varchar(16),speciality varchar(16),length varchar(8),study varchar(8),foreign1 varchar(16),Elevel varchar(8),Clevel varchar(8),Hplace varchar(64),QQ varchar(10),call varchar(16),place varchar(64),love varchar(64),award varchar(63),experience varchar(64),family varchar(64),contact varchar(64),remark "+txtcol+",nation varchar(16),height varchar(8),Ltime datetime,photo varchar(32) not null default 'image/jpeg',photo1 image,phone varchar(24),mobile varchar(11),email varchar(64),havephoto tinyint not null default 0,ischeck tinyint not null default 0)";
    sqlbean.executeUpdate(sql);
    out.println(sql);
 %>