<%@ 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>