?? install.jsp
字號:
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('ischeck','"+sqlbean.to_8859_1("檔案修改")+"','"+sqlbean.to_8859_1("Is Checked")+"',0,'userinfo')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('dq','"+sqlbean.to_8859_1("地區(qū)")+"','"+sqlbean.to_8859_1("Province")+"',1,'post')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('dm','"+sqlbean.to_8859_1("地名")+"','"+sqlbean.to_8859_1("City")+"',1,'post')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('yb','"+sqlbean.to_8859_1("郵編")+"','"+sqlbean.to_8859_1("Postcode")+"',1,'post')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('qh','"+sqlbean.to_8859_1("區(qū)號")+"','"+sqlbean.to_8859_1("Tel")+"',1,'post')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('start','"+sqlbean.to_8859_1("開始號碼")+"','"+sqlbean.to_8859_1("Start No")+"',1,'shouji')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('end','"+sqlbean.to_8859_1("結(jié)束號碼")+"','"+sqlbean.to_8859_1("End No")+"',1,'shouji')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('city','"+sqlbean.to_8859_1("所屬城市")+"','"+sqlbean.to_8859_1("Belong To1")+"',1,'shouji')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('city1','"+sqlbean.to_8859_1("所屬城市1")+"','"+sqlbean.to_8859_1("Belong To2")+"',1,'shouji')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('detail','"+sqlbean.to_8859_1("說明")+"','"+sqlbean.to_8859_1("Detail")+"',1,'shouji')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('start','"+sqlbean.to_8859_1("開始")+"','"+sqlbean.to_8859_1("Start")+"',1,'ipaddr')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('end','"+sqlbean.to_8859_1("結(jié)束")+"','"+sqlbean.to_8859_1("End")+"',1,'ipaddr')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('country','"+sqlbean.to_8859_1("國家")+"','"+sqlbean.to_8859_1("Country")+"',1,'ipaddr')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('local','"+sqlbean.to_8859_1("地區(qū)")+"','"+sqlbean.to_8859_1("Local")+"',1,'ipaddr')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('detail','"+sqlbean.to_8859_1("詳細(xì)")+"','"+sqlbean.to_8859_1("Detail")+"',1,'ipaddr')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("時間")+"','"+sqlbean.to_8859_1("Time")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('towho','"+sqlbean.to_8859_1("接收ID")+"','"+sqlbean.to_8859_1("To")+"',0,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('stowho','"+sqlbean.to_8859_1("接收人名")+"','"+sqlbean.to_8859_1("ToID")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('userid','"+sqlbean.to_8859_1("發(fā)送ID")+"','"+sqlbean.to_8859_1("SenderID")+"',0,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('username','"+sqlbean.to_8859_1("發(fā)送人名")+"','"+sqlbean.to_8859_1("Sender")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('ssb','"+sqlbean.to_8859_1("抄送NAME")+"','"+sqlbean.to_8859_1("Copy to")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('sb','"+sqlbean.to_8859_1("抄送ID")+"','"+sqlbean.to_8859_1("CopyID")+"',0,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('title','"+sqlbean.to_8859_1("標(biāo)題")+"','"+sqlbean.to_8859_1("Title")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('status','"+sqlbean.to_8859_1("分類")+"','"+sqlbean.to_8859_1("Kind")+"',0,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('message','"+sqlbean.to_8859_1("內(nèi)容")+"','"+sqlbean.to_8859_1("Message")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('url','"+sqlbean.to_8859_1("附件下載")+"','"+sqlbean.to_8859_1("URL")+"',1,'allmail')";
sqlbean.executeUpdate(sql);
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('isread','"+sqlbean.to_8859_1("是否閱讀")+"','"+sqlbean.to_8859_1("is Readed")+"',0,'allmail')";
sqlbean.executeUpdate(sql);
%>
<TD><font color=red>如果沒有輸入成功，刪除以后請手工及時輸入《列名轉(zhuǎn)化》數(shù)據(jù)！數(shù)據(jù)文件是colname.txt</font></TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《常用網(wǎng)址》數(shù)據(jù)庫：</TD>
<%
sql = "create table url(ID int not null primary key "+rowid+",url varchar(64),urlname varchar(50),urlsn varchar(255))";
sqlbean.executeUpdate(sql);
sql = "insert into url(url,urlname,urlsn) values('http://www.zhengmao.org','"+sqlbean.to_8859_1("周易在線")+"','"+sqlbean.to_8859_1("在線預(yù)測留言本")+"')";
sqlbean.executeUpdate(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《聊天室》數(shù)據(jù)庫：</TD>
<%
sql = "create table bbs(ID int not null primary key "+rowid+",SubjectId int not null default 0,Name varchar(128),Time datetime not null,Subject varchar(255),Content "+txtcol+",Pic varchar(128),click smallint not null default 0,IP varchar(20))";
sqlbean.executeUpdate(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《工作單位》數(shù)據(jù)庫：</TD>
<%
sql ="create table bumen(ID int not null primary key "+rowid+",type varchar(64) not null)";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《日程安排》數(shù)據(jù)庫：</TD>
<%
sql ="create table calendar(ID int not null primary key "+rowid+",title varchar(62),time datetime not null,remindtime datetime not null,content "+txtcol+",state varchar(1) not null default '0',userid int not null default 0)";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《通訊錄》數(shù)據(jù)庫：</TD>
<%
sql ="create table card(ID int not null primary key "+rowid+",cname varchar(16),company varchar(128),address varchar(128),postcode varchar(6),duty varchar(16),phone varchar(32),fax varchar(32),handset varchar(11),email varchar(32),remark varchar(255),userid int not null default 0)";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《在線會議》數(shù)據(jù)庫：</TD>
<%
sql ="create table chat(ID int not null primary key "+rowid+",send int not null default 0,receive int not null default 0,message "+txtcol+",zt varchar(1) not null default '0',who varchar(32),time varchar(16),endtime datetime)";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《文件學(xué)習(xí)》數(shù)據(jù)庫：</TD>
<%
sql ="create table learn(ID int not null primary key "+rowid+",type tinyint not null default 0,tname varchar(16),part varchar(32),title varchar(32),ttext "+txtcol+",body "+bincol+",html varchar(128),filesize int not null default 0,time datetime,count int not null default 0,IP varchar(20),filename varchar(32),contenttype varchar(32))";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《報文明細(xì)》數(shù)據(jù)庫：</TD>
<%
sql ="create table upfile(ID int not null primary key "+rowid+",type tinyint not null default 0,tname varchar(16),part varchar(32),title varchar(32),ttext varchar(255),body "+bincol+",html varchar(128),filesize int not null default 0,time datetime,IP varchar(20),count int not null default 0,filename varchar(32),contenttype varchar(32) not null default '')";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《通知數(shù)據(jù)》數(shù)據(jù)庫：</TD>
<%
sql ="create table notice(ID int not null primary key "+rowid+",tname varchar(16),part varchar(32),type tinyint not null default 0,title varchar(32),ttext "+txtcol+",time datetime,IP varchar(20),click tinyint not null default 0,userid int not null default 0)";
sqlbean.executeUpdate(sql);
//System.out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《軟件下載》數(shù)據(jù)庫：</TD>
<%
sql ="create table soft(ID int not null primary key "+rowid+",name varchar(32),upname int not null default 0,content "+txtcol+",url varchar(64),size varchar(32) not null default '0',time datetime,best varchar(1) not null default '0')";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《文件欄目》數(shù)據(jù)庫：</TD>
<%
sql ="create table type(ID int not null primary key "+rowid+",type varchar(32))";
sqlbean.executeUpdate(sql);
//System.out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《常用電話》數(shù)據(jù)庫：</TD>
<%
sql ="create table tel(ID int not null primary key "+rowid+",telname varchar(16),telephone varchar(24))";
sqlbean.executeUpdate(sql);
//System.out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《注冊用戶》數(shù)據(jù)庫：</TD>
<%
sql ="create table myuser(ID int not null primary key "+rowid+",username varchar(16) not null,pwd varchar(16) not null,part varchar(32) ,urule varchar(1) not null default 'd',email varchar(64) ,wenti varchar(32) ,daang varchar(32) ,shenhe varchar(1) not null default '0',time datetime ,IP varchar(20) ,online tinyint not null default 0,phone varchar(24) ,name varchar(16),logIP varchar(20) ,Utime datetime ,times int not null default 0,mobile varchar(11) ,pagesize tinyint not null default 10)";
sqlbean.executeUpdate(sql);
sql = "insert into myuser (name,username,pwd,urule,shenhe,online) values('"
+request.getParameter("rname")+"','"
+request.getParameter("username")+"','"
+request.getParameter("password")+"','a',1,0)";
sqlbean.executeUpdate(sql);
//System.out.println(" insert into myuser");
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《用戶檔案》數(shù)據(jù)庫：</TD>
<%
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 tinyint 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)";
sqlbean.executeUpdate(sql);
//out.println(sql);
sql = "select * from myuser where username='"+sqlbean.to_8859_1(request.getParameter("username"))+"'";
sqlbean.executeQuery(sql);
if(sqlbean.next()){
sql ="insert into userinfo(userid,Uname) values("
+"'" + sqlbean.getString("ID") + "',"
+"'" + sqlbean.to_8859_1(request.getParameter("username")) + "')";
sqlbean.executeUpdate(sql);
}
//System.out.println("userinfo");
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《郵政編碼》數(shù)據(jù)庫：</TD>
<%
sql ="create table post(dq varchar(20),dm varchar(20),yb varchar(6),qh varchar(4),ID int not null primary key "+rowid+")";
sqlbean.executeUpdate(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《手機(jī)地址》數(shù)據(jù)庫：</TD>
<%
sql ="create table shouji(start int,ends int,city varchar(16),city1 varchar(16),detail varchar(32),ID int not null primary key "+rowid+")";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《IP地址》數(shù)據(jù)庫：</TD>
<%
sql ="create table ipaddr(start varchar(20),ends varchar(20),country varchar(64),local varchar(64),detail varchar(64),ID int not null primary key "+rowid+")";
sqlbean.executeUpdate(sql);
%>
<TD>創(chuàng)建成功！</TD></TR>
<TR bgcolor=#e3e3ea>
<TD>創(chuàng)建《郵件》數(shù)據(jù)庫：</TD>
<%
sql ="create table allmail(ID int not null primary key "+rowid+",time datetime,towho int not null default 0,stowho varchar(32),userid int not null default 0,username varchar(32),ssb varchar(32),sb int not null default 0,title varchar(128),status tinyint not null default 0,message "+txtcol+",url varchar(64),isread tinyint not null default 0)";
sqlbean.executeUpdate(sql);
//out.println(sql);
%>
<TD>創(chuàng)建成功！</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<p align=center><font color=red>請在第一次登陸進(jìn)去后，在左側(cè)的樹型菜單《超級管理》中依次運(yùn)行《單位管理》--添加各部門，《用戶管理》修改超級用戶的資料，《文件管理》---《添加欄目》將數(shù)據(jù)添加進(jìn)入數(shù)據(jù)庫<br>
然后重新登陸一次，就可以正確運(yùn)行《GJM-OA》系統(tǒng)了。</font></p>
<p align=center>請將《郵政編碼》《手機(jī)地址》《IP地址》三個文本文件導(dǎo)入數(shù)據(jù)庫<br>
然后進(jìn)行<a href="index.html">開始運(yùn)行</a></p>
<%}%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -