install.jsp

GJMOA网络自动化办公系统是一套基于jsp的办公自动化系统在LINUX+ORACLE+TOMCAT环境下运行

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("地区")+"','"+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("区号")+"','"+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("结束号码")+"','"+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("结束")+"','"+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("地区")+"','"+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("详细")+"','"+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("发送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("发送人名")+"','"+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("标题")+"','"+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("内容")+"','"+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>如果没有输入成功，删除以后请手工及时输入《列名转化》数据！数据文件是colname.txt</font></TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《常用网址》数据库：</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("在线预测留言本")+"')";
    sqlbean.executeUpdate(sql);    
    %>	  
    <TD>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《聊天室》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《工作单位》数据库：</TD>
    <%
    sql ="create table bumen(ID int not null  primary key "+rowid+",type varchar(64) not null)";
    sqlbean.executeUpdate(sql);    
    //out.println(sql);
    %>	  
    <TD>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《日程安排》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《通讯录》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《在线会议》数据库：</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>创建成功！</TD></TR>  
  <TR bgcolor=#e3e3ea>
    <TD>创建《文件学习》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《报文明细》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《通知数据》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《软件下载》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《文件栏目》数据库：</TD>
    <%
    sql ="create table type(ID int not null  primary key "+rowid+",type varchar(32))";
    sqlbean.executeUpdate(sql); 
    //System.out.println(sql);
    %>	  
    <TD>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《常用电话》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《注册用户》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《用户档案》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《邮政编码》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《手机地址》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《IP地址》数据库：</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>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《邮件》数据库：</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>创建成功！</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
 <p align=center><font color=red>请在第一次登陆进去后，在左侧的树型菜单《超级管理》中依次运行《单位管理》--添加各部门，《用户管理》修改超级用户的资料，《文件管理》---《添加栏目》将数据添加进入数据库<br>
然后重新登陆一次，就可以正确运行《GJM-OA》系统了。</font></p>
 <p align=center>请将《邮政编码》《手机地址》《IP地址》三个文本文件导入数据库<br>
然后进行<a href="index.html">开始运行</a></p>
<%}%>