install.jsp

GJM-OA网络自动化办公系统-采用MVC开发模型

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="htmhead.htm" %>
<jsp:useBean id="sqlbean" scope="session" class="org.zhengmao.soft.sqlcon" />
<%
int create = 100;
if(request.getParameter("create")!=null){
	create = Integer.parseInt(request.getParameter("create"));
}
String sql="";
if(create ==100){       
%>

<dive align=center>
<TABLE cellSpacing=0 cellPadding=0 width="90%" align=center border=0>
  <TBODY>
  <TR>
    <TD bgColor=#000000>
      <TABLE cellSpacing=1 cellPadding=3 width="100%" border=0>
	<TBODY>
	<TR bgcolor=#e3e3ea class=header>
	  <TD >安装程序--提示</TD>
    </TR>
  <TR bgcolor=#e3e3ea>
    <TD>您可以自己创建数据库(create database)和数据表(create table)或者使用这个程序创建数据表(create table)，
    但是必须在已有数据库中(use 'database')创建数据表(create table)，或者你先创建数据库(create database),要不程序会出错。
    <font color=red>请一定记住！运行完此程序以后，先在《超级管理》一项内初始化系统资料，要不会出错！</font>
    </TD></TR>
</TBODY></TABLE></TD></TR></TBODY></TABLE></div>
    
<div align=center>
<form action=install.jsp?create=1 method=post name=iii onsubmit="cmpPwd(this.form)">
<TABLE cellSpacing=0 cellPadding=0 width="90%" align=center border=0>
  <TBODY>
  <TR>
    <TD bgColor=#000000>
      <TABLE cellSpacing=1 cellPadding=3 width="100%" border=0>
	<TBODY>
	<TR bgcolor=#e3e3ea class=header>
	  <TD colspan=2>输入基本资料</TD>
    </TR>
  <TR bgcolor=#e3e3ea>
    <TD>选择数据库类型</TD>
    <TD>    
	<SELECT NAME=rowid >
	<OPTION VALUE="AUTO_INCREMENT" selected>MYSQL SERVER</OPTION>
	<OPTION VALUE="IDENTITY">MS SQL SERVER</OPTION>
	<OPTION VALUE="ROWID">ORACLE SERVER</OPTION>
	</SELECT>您的数据库
    </TD>
  </TR>  
  <TR bgcolor=#e3e3ea>
    <TD>用户名称</TD>
    <TD><INPUT name=username value=""></TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>登陆密码</TD>
    <TD><INPUT name=password type=password value=""></TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>确认密码</TD>
    <TD><INPUT name=password2 type=password value=""></TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>真实姓名</TD>
    <TD><INPUT name=rname type=text value=""></TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD colspan=2 align=middle><INPUT id=submit1 type=submit value=开始安装 name=submit1 IsShowProcessBar="True"></TD>
    </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
    </form>
    </div>
<% }else if(create==1){ %>

<TABLE cellSpacing=0 cellPadding=0 width="99%" align=center border=0>
  <TBODY>
  <TR>
    <TD bgColor=#000000>
      <TABLE cellSpacing=1 cellPadding=3 width="100%" border=0>
	<TBODY>
	<TR bgcolor=#e3e3ea class=header>
	  <TD colspan=2>开始创建数据表--以DBA角色登陆--以后正常使用时请退出DBA角色</TD>
    </TR>
  <TR bgcolor=#e3e3ea>
    <TD>创建《列名转化》数据表：</TD>
	<%
        
	String rowid = request.getParameter("rowid");
	String bincol="mediumblob";
	String txtcol ="text";
	if(rowid.compareTo("IDENTITY")==0){
		bincol = "image";
		txtcol = "text";
		sqlbean.setGBbyte(true);
	}else if(rowid.compareTo("ROWID")==0){
		bincol ="longraw";
		txtcol ="long";
		sqlbean.setGBbyte(true);
	}       
	sql ="create table colname(tbcol varchar(16),gb2312 varchar(16),english varchar(16),isindex tinyint not null default 0,tbname varchar(16),ID int not null  primary key "+rowid+")";
	sqlbean.executeUpdate(sql);
    %>	  
    <TD>创建成功！</TD></TR>
  <TR bgcolor=#e3e3ea>
    <TD>插入《列名转化》数据：</TD>
    <%
sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('ID','"+sqlbean.to_8859_1("序号")+"','"+sqlbean.to_8859_1("No.")+"',0,'url')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('url','"+sqlbean.to_8859_1("网址")+"','"+sqlbean.to_8859_1("URL")+"',1,'url')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('urlname','"+sqlbean.to_8859_1("网站名称")+"','"+sqlbean.to_8859_1("WEB NAME")+"',1,'url')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('urlsn','"+sqlbean.to_8859_1("网站简介")+"','"+sqlbean.to_8859_1("INTRODUCTION")+"',1,'url')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('SubjectId','"+sqlbean.to_8859_1("帖子标志")+"','"+sqlbean.to_8859_1("SubjectID")+"',0,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Name','"+sqlbean.to_8859_1("发帖人名")+"','"+sqlbean.to_8859_1("name")+"',1,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Time','"+sqlbean.to_8859_1("发表时间")+"','"+sqlbean.to_8859_1("time")+"',1,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Subject','"+sqlbean.to_8859_1("帖子标题")+"','"+sqlbean.to_8859_1("Subject")+"',1,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Content','"+sqlbean.to_8859_1("帖子内容")+"','"+sqlbean.to_8859_1("Content")+"',1,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Pic','"+sqlbean.to_8859_1("图片标志")+"','"+sqlbean.to_8859_1("Pic")+"',0,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('click','"+sqlbean.to_8859_1("查看次数")+"','"+sqlbean.to_8859_1("Click")+"',0,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('IP','"+sqlbean.to_8859_1("发帖人IP")+"','"+sqlbean.to_8859_1("IP")+"',0,'bbs')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('title','"+sqlbean.to_8859_1("日程标题")+"','"+sqlbean.to_8859_1("Title")+"',1,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("发生时间")+"','"+sqlbean.to_8859_1("Time")+"',1,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('remindtime','"+sqlbean.to_8859_1("提醒时间")+"','"+sqlbean.to_8859_1("Remind Time")+"',1,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('content','"+sqlbean.to_8859_1("日程内容")+"','"+sqlbean.to_8859_1("Content")+"',1,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('state','"+sqlbean.to_8859_1("提醒状态")+"','"+sqlbean.to_8859_1("Name")+"',0,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('userid','"+sqlbean.to_8859_1("用户标志")+"','"+sqlbean.to_8859_1("UserID")+"',0,'calendar')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('cname','"+sqlbean.to_8859_1("中文名")+"','"+sqlbean.to_8859_1("Chinese Name")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('company','"+sqlbean.to_8859_1("公司")+"','"+sqlbean.to_8859_1("Company")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('duty','"+sqlbean.to_8859_1("职务")+"','"+sqlbean.to_8859_1("Duty")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('phone','"+sqlbean.to_8859_1("电话")+"','"+sqlbean.to_8859_1("Phone")+"',1,'card')";
sqlbean.executeUpdate(sql);


sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('handset','"+sqlbean.to_8859_1("手机")+"','"+sqlbean.to_8859_1("Handset")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('email','"+sqlbean.to_8859_1("Email")+"','"+sqlbean.to_8859_1("Email")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('remark','"+sqlbean.to_8859_1("备注")+"','"+sqlbean.to_8859_1("Remark")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('address','"+sqlbean.to_8859_1("地址")+"','"+sqlbean.to_8859_1("Address")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('fax','"+sqlbean.to_8859_1("传真")+"','"+sqlbean.to_8859_1("Fax")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('postcode','"+sqlbean.to_8859_1("邮编")+"','"+sqlbean.to_8859_1("Postcode")+"',1,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('userid','"+sqlbean.to_8859_1("用户标志")+"','"+sqlbean.to_8859_1("UserID")+"',0,'card')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('send','"+sqlbean.to_8859_1("发送标志")+"','"+sqlbean.to_8859_1("Send")+"',0,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('receive','"+sqlbean.to_8859_1("接受标志")+"','"+sqlbean.to_8859_1("Receive")+"',0,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('message','"+sqlbean.to_8859_1("内容")+"','"+sqlbean.to_8859_1("Message")+"',1,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('zt','"+sqlbean.to_8859_1("用户标志")+"','"+sqlbean.to_8859_1("Zt")+"',0,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('who','"+sqlbean.to_8859_1("发贴用户")+"','"+sqlbean.to_8859_1("Who")+"',1,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("发贴时间")+"','"+sqlbean.to_8859_1("Time")+"',1,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('endtime','"+sqlbean.to_8859_1("结束时间")+"','"+sqlbean.to_8859_1("Endtime")+"',1,'chat')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('type','"+sqlbean.to_8859_1("文件类型")+"','"+sqlbean.to_8859_1("Type")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('tname','"+sqlbean.to_8859_1("人名")+"','"+sqlbean.to_8859_1("Who")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('part','"+sqlbean.to_8859_1("部门")+"','"+sqlbean.to_8859_1("Department")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('title','"+sqlbean.to_8859_1("标题")+"','"+sqlbean.to_8859_1("Title")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('ttext','"+sqlbean.to_8859_1("内容")+"','"+sqlbean.to_8859_1("Content")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('body','"+sqlbean.to_8859_1("数据")+"','"+sqlbean.to_8859_1("Binary Data")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('html','"+sqlbean.to_8859_1("连接")+"','"+sqlbean.to_8859_1("Link")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('filesize','"+sqlbean.to_8859_1("文件大小")+"','"+sqlbean.to_8859_1("File Size")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("发表时间")+"','"+sqlbean.to_8859_1("Time")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('count','"+sqlbean.to_8859_1("查看次数")+"','"+sqlbean.to_8859_1("Click")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('IP','"+sqlbean.to_8859_1("上载IP")+"','"+sqlbean.to_8859_1("IP")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('filename','"+sqlbean.to_8859_1("文件名")+"','"+sqlbean.to_8859_1("File Name")+"',1,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('contenttype','"+sqlbean.to_8859_1("数据类型")+"','"+sqlbean.to_8859_1("Content Type")+"',0,'learn')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('type','"+sqlbean.to_8859_1("文件类型")+"','"+sqlbean.to_8859_1("Type")+"',0,'upfile')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('tname','"+sqlbean.to_8859_1("人名")+"','"+sqlbean.to_8859_1("Who")+"',1,'upfile')";