<%@ page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.cscexport.*,java.util.*,com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <META name="GENERATOR" content="IBM WebSphere Studio"> <META http-equiv="Content-Style-Type" content="text/css"> <LINK href="theme/Master.css" rel="stylesheet" type="text/css"> <TITLE>Encript Memployee ==>> Salary</TITLE> </HEAD> <BODY> <% UProfile UP = new UProfile(); UP = new UProfile(); UP.setDbName("THAIMETAL2"); //UP.setDbName("MYHRDBS"); UP.setSchemaName("PR"); UP.setUserName("myhradmin"); UP.set("companyid", "10"); //UP.set("companyid", "10"); UP.set("lang", "eng"); UP.set("appname","Payroll"); int error=0; out.println("============Start encrypt=========="+"<br>"); try{ DbInquiry inq = new InitialInquiry(UP).getDbInquiry(); inq.setSchemaName(UP.getSchemaName()); inq.initMyTable("memployee","*", "runno"); inq.setColumn("*"); inq.refresh(); while (inq.next()) { DbRecord recXXX = inq.getCurrentDbRecord(); DbRecord rec = new InitialRecord(UP).getDbRecord("memployee"); Vector vt = recXXX.getAllKey(); for (int i=0;i<vt.size();i++) { String key = (String) vt.elementAt(i); rec.set(key, recXXX.getString(key)); } //if (rec.search()){ out.println(">> emp="+rec.getString("employeeid") +" >> salary="+rec.getString("salary") +" >> oldsalary="+rec.getString("oldsalary") +"<br>"); FieldManager fm = rec.getField("salary"); fm.setProperty("encrypt","true"); //rec.save(); //} } out.println("============encrypt success=========="+"<br>"); }catch(Exception e){ out.println(e.printStackTrace()); } %> </BODY> </HTML>