sql 加密代码 java_java 数据的加密与解密普遍实例代码

pageEncoding="utf-8"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

String xdocserver1 = EjbServerName.getValue("xdocserver");

System.out.println("basePath basePath==========================="+basePath);

%>

StringBuffer sb=new StringBuffer();

String part = request.getParameter("szbm");

String str1=new String(part.getBytes("ISO-8859-1"),"GBK");

String sta = request.getParameter("syzt");

String str2=new String(sta.getBytes("ISO-8859-1"),"GBK");

String tems1 = "";

if(str2.equals("正在使用")){

tems1="use";

}else if(str2.equals("暂停使用")){

tems1="pause";

}else if(str2.equals("停止使用")){

tems1="stop";

} else{

tems1="use";

}

String s1 = Base64.encodeFixLenString(tems1);

String sql="";

List menuList=new ArrayList();

sql =" select t.companyid ,a.laborname ,t.keysn ,t.keystatus from sys_key t "+

" left join IBSUSERS b on b.id = t.id left join labor a on a.labornum = b.labornum where 1=1 ";

if(!str1.equals("")){

sql +=" and t.companyid like '%"+str1+"%' ";

}

if(!s1.equals("")){

sql +=" and t.keystatus = '"+s1+"'";

}

try {

List list = IBOSrvUtil.getBaseDao().selectListBySql(sql);

sb.append("");

if(list.size()>0){

for(int i=0;i

Map map = (Map) list.get(i);

sb.append("");

String keysn=Base64.decodeToFixLenString(map.get("KEYSN")==null?"":map.get("KEYSN").toString());

String laborname=map.get("LABORNAME")==null?"":map.get("LABORNAME").toString();

String companyid=map.get("COMPANYID")==null?"":map.get("COMPANYID").toString();

String temstatus =Base64.decodeToFixLenString(map.get("KEYSTATUS")==null?"":map.get("KEYSTATUS").toString());

Map compMap = new HashMap();

String status = "";

if(temstatus.equals("use")){

status="正在使用";

}else if(temstatus.equals("pause")){

status="暂停使用";

}else{

status="停止使用";

}

sb.append("").append(keysn).append("");

sb.append("").append(laborname).append("");

sb.append("").append(companyid).append("");

sb.append("").append(status).append("");

sb.append("");

}

}

sb.append("");

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

System.out.println("sb===null=============="+sb);

%>

document.form1.submit();

function dosubmit(){

document.getElementById("btnSub").disabled = true;

if(document.getElementById("szbm" ).value!="" || document.getElementById("syzt" ).value!="" )

{

var f1 = document.getElementById("b1");

f1.submit();

} else{

alert("请输入查询条件！");

document.getElementById("btnSub").disabled = false;

return ;

}

}

//如果这三个条件同时为空的话就弹出提示框。否则执行F1并提交F1.就是得到的B1