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("內(nèi)容")+"','"+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("數(shù)據(jù)")+"','"+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("發(fā)表時間")+"','"+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("查看次數(shù)")+"','"+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("發(fā)表人名")+"','"+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("內(nèi)容")+"','"+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("瀏覽次數(shù)")+"','"+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("審核狀態(tài)")+"','"+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("登陸狀態(tài)")+"','"+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("登陸次數(shù)")+"','"+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("畢業(yè)學校")+"','"+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("聯(lián)系電話")+"','"+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("工作經(jīng)歷")+"','"+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("聯(lián)系方法")+"','"+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("圖片數(shù)據(jù)")+"','"+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);