?? hhh.jsp
字號:
<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);
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -