install.jsp

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

sqlbean.executeUpdate(sql);

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

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('ttext','"+sqlbean.to_8859_1("内容")+"','"+sqlbean.to_8859_1("Content")+"',1,'upfile')";
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,'upfile')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('html','"+sqlbean.to_8859_1("连接")+"','"+sqlbean.to_8859_1("Link")+"',0,'upfile')";
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,'upfile')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('count','"+sqlbean.to_8859_1("查看次数")+"','"+sqlbean.to_8859_1("Click")+"',0,'upfile')";
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,'upfile')";
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,'upfile')";
sqlbean.executeUpdate(sql);

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

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

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

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

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("时间")+"','"+sqlbean.to_8859_1("Time")+"',1,'notice')";
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,'notice')";
sqlbean.executeUpdate(sql);

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

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('name','"+sqlbean.to_8859_1("软件名")+"','"+sqlbean.to_8859_1("Soft Name")+"',1,'soft')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('content','"+sqlbean.to_8859_1("软件介绍")+"','"+sqlbean.to_8859_1("Introduction")+"',1,'soft')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('size','"+sqlbean.to_8859_1("大小")+"','"+sqlbean.to_8859_1("Size")+"',0,'soft')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('best','"+sqlbean.to_8859_1("标志")+"','"+sqlbean.to_8859_1("IsBest")+"',0,'soft')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('telname','"+sqlbean.to_8859_1("名称")+"','"+sqlbean.to_8859_1("Name")+"',1,'tel')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('username','"+sqlbean.to_8859_1("登陆名称")+"','"+sqlbean.to_8859_1("Username")+"',1,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('pwd','"+sqlbean.to_8859_1("登陆密码")+"','"+sqlbean.to_8859_1("Password")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('urule','"+sqlbean.to_8859_1("用户等级")+"','"+sqlbean.to_8859_1("Grade")+"',0,'myuser')";
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,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('wenti','"+sqlbean.to_8859_1("问题")+"','"+sqlbean.to_8859_1("Question")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('daang','"+sqlbean.to_8859_1("答案")+"','"+sqlbean.to_8859_1("Answer")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('shenhe','"+sqlbean.to_8859_1("审核状态")+"','"+sqlbean.to_8859_1("Check")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('time','"+sqlbean.to_8859_1("注册时间")+"','"+sqlbean.to_8859_1("Reg Time")+"',1,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('IP','"+sqlbean.to_8859_1("登陆IP")+"','"+sqlbean.to_8859_1("Log IP")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('state','"+sqlbean.to_8859_1("登陆状态")+"','"+sqlbean.to_8859_1("Online")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('name','"+sqlbean.to_8859_1("真实姓名")+"','"+sqlbean.to_8859_1("True Name")+"',1,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('logIP','"+sqlbean.to_8859_1("注册IP")+"','"+sqlbean.to_8859_1("Reg IP")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Utime','"+sqlbean.to_8859_1("最后登陆")+"','"+sqlbean.to_8859_1("Last Log")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('times','"+sqlbean.to_8859_1("登陆次数")+"','"+sqlbean.to_8859_1("Times")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('pagesize','"+sqlbean.to_8859_1("默认页面大小")+"','"+sqlbean.to_8859_1("Pagesize")+"',0,'myuser')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Uname','"+sqlbean.to_8859_1("姓名")+"','"+sqlbean.to_8859_1("Name")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('sex','"+sqlbean.to_8859_1("性别")+"','"+sqlbean.to_8859_1("Sex")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('grade','"+sqlbean.to_8859_1("等级")+"','"+sqlbean.to_8859_1("Grade")+"',0,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('birthday','"+sqlbean.to_8859_1("生日")+"','"+sqlbean.to_8859_1("Birthday")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('polity','"+sqlbean.to_8859_1("党派")+"','"+sqlbean.to_8859_1("Polity")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('health','"+sqlbean.to_8859_1("健康")+"','"+sqlbean.to_8859_1("Health")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Nplace','"+sqlbean.to_8859_1("住址")+"','"+sqlbean.to_8859_1("Dwell")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('weight','"+sqlbean.to_8859_1("体重")+"','"+sqlbean.to_8859_1("Weight")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('idcard','"+sqlbean.to_8859_1("身份证")+"','"+sqlbean.to_8859_1("IDCard")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('marriage','"+sqlbean.to_8859_1("婚姻")+"','"+sqlbean.to_8859_1("Marriage")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Fschool','"+sqlbean.to_8859_1("毕业学校")+"','"+sqlbean.to_8859_1("Finished School")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('member','"+sqlbean.to_8859_1("家庭成员")+"','"+sqlbean.to_8859_1("Member")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('speciality','"+sqlbean.to_8859_1("个人专长")+"','"+sqlbean.to_8859_1("Speciality")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('length','"+sqlbean.to_8859_1("长度")+"','"+sqlbean.to_8859_1("Length")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('study','"+sqlbean.to_8859_1("学习")+"','"+sqlbean.to_8859_1("Study")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('foreign1','"+sqlbean.to_8859_1("外语")+"','"+sqlbean.to_8859_1("Foreign lang")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Elevel','"+sqlbean.to_8859_1("外语水平")+"','"+sqlbean.to_8859_1("English Level")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Clevel','"+sqlbean.to_8859_1("计算机水平")+"','"+sqlbean.to_8859_1("Computer Level")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Hplace','"+sqlbean.to_8859_1("出生地")+"','"+sqlbean.to_8859_1("Home Place")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('QQ','"+sqlbean.to_8859_1("QQ")+"','"+sqlbean.to_8859_1("OICQ")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('call','"+sqlbean.to_8859_1("联系电话")+"','"+sqlbean.to_8859_1("Contact Call")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('place','"+sqlbean.to_8859_1("通讯地址")+"','"+sqlbean.to_8859_1("Post Address")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('love','"+sqlbean.to_8859_1("个人爱好")+"','"+sqlbean.to_8859_1("Love")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('aword','"+sqlbean.to_8859_1("奖励")+"','"+sqlbean.to_8859_1("Aword")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('experience','"+sqlbean.to_8859_1("工作经历")+"','"+sqlbean.to_8859_1("Experience")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('family','"+sqlbean.to_8859_1("家庭")+"','"+sqlbean.to_8859_1("Family")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('contact','"+sqlbean.to_8859_1("联系方法")+"','"+sqlbean.to_8859_1("Contact")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('nation','"+sqlbean.to_8859_1("民族")+"','"+sqlbean.to_8859_1("Nation")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('height','"+sqlbean.to_8859_1("身高")+"','"+sqlbean.to_8859_1("Height")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('Ltime','"+sqlbean.to_8859_1("输入时间")+"','"+sqlbean.to_8859_1("Ltime")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('photo','"+sqlbean.to_8859_1("图片类型")+"','"+sqlbean.to_8859_1("Photo Type")+"',1,'userinfo')";
sqlbean.executeUpdate(sql);

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

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('mobile','"+sqlbean.to_8859_1("手机")+"','"+sqlbean.to_8859_1("Handset")+"',1,'userinfo')";
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,'userinfo')";
sqlbean.executeUpdate(sql);

sql = "insert into colname(tbcol,gb2312,english,isindex,tbname)values('havephoto','"+sqlbean.to_8859_1("有无图片")+"','"+sqlbean.to_8859_1("Have Photo")+"',0,'userinfo')";
sqlbean.executeUpdate(sql);