<%!
stc_RSYB_Name stcRSYName1[];
stc_SYB_INF stcSYBINF1[];
%>
<%/*
String p = (String) session.getValue("access");
if (p==null || !p.equals("1")) {
response.sendRedirect("error.htm");
return;
}*/
%>
<%!
file://得到机器名字或IP
String get_Myhostname(javax.servlet.http.HttpServletRequest request){
String myhostname = null;
try{
myhostname = request.getRemoteHost();
myhostname = myhostname.toUpperCase();
}catch(Exception e){}
return myhostname;
}
file://处理空字符串
String dealNull(String str) {
String returnstr = null;
if (str == null) returnstr = "";
else returnstr = str;
return returnstr;
}
file://处理空对象
Object dealNull(Object obj){
Object returnstr = null;
if (obj == null) returnstr = (Object)("");
else returnstr = obj;
return returnstr;
}
int dealEmpty(String s) {
s = dealNull(s);
if (s.equals("")) return 0;
return Integer.parseInt(s);
}
String replace(String str,String substr,String restr){
String[] tmp = split(str,substr);
String returnstr = null;
if(tmp.length!=0) {
returnstr = tmp[0];
for(int i = 0 ; i < tmp.length - 1 ; i++)
returnstr =dealNull(returnstr) + restr +tmp[i+1];
}
return dealNull(returnstr);
}
String htmlEncode(String txt){
txt = replace(txt,"&","&");
txt = replace(txt,"&","&");
txt = replace(txt,""",""");
txt = replace(txt,"\"",""");
txt = replace(txt,"<","<");
txt = replace(txt,"<","<");
txt = replace(txt,">",">");
txt = replace(txt,">",">");
txt = replace(txt," "," ");
txt = replace(txt," "," ");
return txt;
}
String unHtmlEncode(String txt){
txt = replace(txt,"&","&");
txt = replace(txt,""","\"");
txt = replace(txt,"<","<");
txt = replace(txt,">",">");
txt = replace(txt," "," ");
return txt;
}
file://ALERT Function
void sAlert(String title,String msg,String focus, JspWriter out){
try {
out.println("<script language='javascript'>");
out.println("alert(\"" + title + "\" + \"\\r\\n\" + \"" + replace(replace(msg,"''","'"),"\"","\\\"") +"\");");
out.println(focus);
out.println("</script>");
} catch(Exception e) { System.out.println(e);}
}
file://CONFIRM Function
void sConfirm(String title,String msg ,String location,JspWriter out){
try{
out.println("<script language='javascript'>");
out.println("if(confirm(\"" + title + "\" + \"\\r\\n\" + \"" + replace(msg,"\"","\\\"") + "\")){" );
out.println("var d = (new Date()).toString();");
out.println(location + "+ d;");
out.println("}");
out.println("parent.document.form1.text1.select();");
out.println("</script>");
} catch (Exception e) { }
}
file://得到字符串长度
int getStringLength(String s) {
int p = 0;
try {
int iLength = 0;
int irealLength = 0;
int j = 0;
p = s.getBytes("Shift_JIS").length;
} catch(java.io.UnsupportedEncodingException e) {}
return p;
}
void formatString(String s,int b,JspWriter out){
b--;
String t = "";
try {
int leng = getStringLength(s);
int j = 0;
if (leng > b) {
for (int i = 1; i <= b ; i++) {
t = s.substring(0,i);
if (t.getBytes("Shift_JIS").length <= b ) {
j++;
} else break;
}
file://j = j+1;
file://System.out.println("b=" + b + "----" + "j=" + j);
for(int i = 0;i < j; i++){
if(s.substring(i,i+1).equals(" "))
out.print(" ");
if(!s.substring(i,i+1).equals(" "))
out.print(htmlEncode(s.substring(i,i+1)));
}
if (s.substring(0,j).getBytes("Shift_JIS").length == b){
out.print("|");
}else{
out.print(" |");
}
} else {
for (int i = 0; i < b - leng ; i++)
t = t + " ";
for (int i = 0; i < s.length(); i++){
if(s.substring(i,i+1).equals(" "))
out.print(" ");
if(!s.substring(i,i+1).equals(" "))
out.print(htmlEncode(s.substring(i,i+1)));
}
out.print(htmlEncode(t + "|"));
}
} catch(Exception e){System.out.println("----" + e);}
}
file://判断是否为数字
boolean isNumeric(String number)
{
try
{
Integer.parseInt(number);
return true;
}
catch(NumberFormatException sqo)
{
return false;
}
}
file://判断是否为日期
String mk_date(String c_date,int c_mode)
{
String wk_buf= "";
String ToDay = "";
try
{
ToDay = Integer.toString(java.util.Calendar.getInstance().get(java.util.Calendar.YEAR));
switch(c_mode)
{
case 0:
{
wk_buf = c_date.substring(2, 4) + "/" + c_date.substring(4, 6);
if (c_date.length() == 8)
{
wk_buf = wk_buf + "/" + c_date.substring(6, 8);
}
break;
}
case 1:
{
for (int i=0; i<c_date.length();i++)
{
if (c_date.substring(i, i+1) == " ")
{
wk_buf = wk_buf + "0";
}
else
{
wk_buf = wk_buf + c_date.substring(i, i+1);
}
}
c_date = wk_buf;
wk_buf = "";
if (c_date.substring(0, 1) != "0" )
{
wk_buf = "19";
}
else
{
wk_buf = "20";
}
wk_buf = wk_buf + c_date.substring(0, 2) + c_date.substring(3, 5);
if (c_date.length() == 8)
{
wk_buf = wk_buf + c_date.substring(6, 8);
}
break;
}
case 2:
{
wk_buf = c_date.substring(0, 4) + c_date.substring(5, 7) + c_date.substring(8, 10);
break;
}
case 3:
{
for(int i=0; i<c_date.length();i++ )
{
if (c_date.substring(i, i+1) == " ")
{
wk_buf = wk_buf + "0";
}
else
{
wk_buf = wk_buf + c_date.substring(i, i+1);
}
}
c_date = wk_buf;
wk_buf = "";
if (Integer.parseInt(c_date.substring(0,2)) > Integer.parseInt(ToDay.substring(2, 4)))
{
wk_buf = Integer.toString(Integer.parseInt(ToDay.substring(0,2)) - 1);
}
else
{
wk_buf = ToDay.substring(0,2);
}
wk_buf = wk_buf + c_date.substring(0,2) + c_date.substring(3,5);
if (c_date.length() == 8)
{
wk_buf = wk_buf + c_date.substring(6,8);
}
break;
}
case 4:
{
wk_buf = c_date.substring(0,4) + "/" + c_date.substring(4,6) + "/" + c_date.substring(6, 8);
break;
}
case 5:
{
wk_buf = c_date.substring(0,4) + c_date.substring(5, 7);
break;
}
}
}
catch(Exception e)
{
System.out.println("wrong : " + e);
}
return wk_buf;
}
int cInt(float stsid){
int cInt = 0;
try{
int stsid1 = 0;
if(stsid > 0){
if((stsid - (int)stsid > 0) && (stsid - (int)stsid != 0.5))
stsid1 = (int)(stsid + 0.5);
if(stsid - (int)stsid == 0.5){
if(((int)(stsid-0.5))%2 == 0)
stsid1 = (int)(stsid - 0.5);
else
stsid1 = (int)(stsid + 0.5);
}
if(stsid - (int)stsid ==0)
stsid1 = (int)stsid;
}else{
stsid = -stsid;
if((stsid - (int)stsid > 0) && (stsid - (int)stsid != 0.5))
stsid1 = - (int)(stsid + 0.5);
if(stsid - (int)stsid == 0.5){
if(((int)(stsid-0.5))%2 == 0)
stsid1 = - (int)(stsid - 0.5);
else
stsid1 = - (int)(stsid + 0.5);
}
if(stsid - (int)stsid ==0)
stsid1 = - (int)stsid;
}
cInt = stsid1;
}catch(Exception e){}
return cInt;
}
long cLng(float numb){
int nu = 0;
long cLng = 0;
try{
nu = cInt(numb);
cLng = (long) nu;
}catch(Exception e){}
return cLng;
}
float dealFloat(String s){
s=dealNull(s);
if (s.equals(""))
return 0;
return Float.parseFloat(s);
}
String[] split(String source,String div){
int arynum = 0,intIdx=0,intIdex=0,div_length = div.length();
if(source.compareTo("")!=0){
if(source.indexOf(div)!=-1){
intIdx = source.indexOf(div);
for(int intCount =1 ; ; intCount++){
if(source.indexOf(div,intIdx+div_length)!=-1){
intIdx= source.indexOf(div,intIdx+div_length);
arynum = intCount;
}
else {arynum+=2;break;}
}
}else arynum =1;
}else arynum = 0;
intIdx=0;
intIdex=0;
String[] returnStr = new String[arynum];
if(source.compareTo("")!=0){
if(source.indexOf(div)!=-1){
intIdx = (int)source.indexOf(div);
returnStr[0]= (String)source.substring(0,intIdx);
for(int intCount =1 ; ; intCount++){
if(source.indexOf(div,intIdx+div_length)!=-1){
intIdex=(int)source.indexOf(div,intIdx+div_length);
returnStr[intCount] = (String)source.substring(intIdx+div_length,intIdex);
intIdx = (int)source.indexOf(div,intIdx+div_length);
}
else {
returnStr[intCount] = (String)source.substring(intIdx+div_length,source.length());
break;
}
}
}
else {returnStr[0] = (String)source.substring(0,source.length());return returnStr;}
}
else {return returnStr;}
return returnStr;
}
public class stc_RSYB_Name
{
public int pos = -1;
public String NAME = "";
public String host = "";
public String home1 = "";
public String home2 = "";
public String home3 = "";
}
public class stc_SYB_INF
{
String reg_name = "";
String G_SYB = "";
String R_SYB = "";
}
file://输出空格
void showBlank(int num,JspWriter out){
try{
for(int i=0;i<=num;i++)
out.print(" ");
}
catch(Exception e){}
}
String g_syb_mk(){
String g_syb_mk = null;
String NIS_M_O = "1???????????????????????????????????????????????????????????????";
String LOCAL_M = "?1??????????????????????????????????????????????????????????????";
String WINNT_DC = "????1???????????????????????????????????????????????????????????";
String NIS_LOCAL = "11??????????????????????????????????????????????????????????????";
int Ret = 0,RecCount = 0,K = 0;
String Set_Ret = "ssy";
String[] DOMEIN = null;
String[] Group_SYB = null;
int WK_SYB[];
try{
String sql = "select count(*) from 寁嶼婡 where 话兽庬暿 like '"+ NIS_M_O +"' or 话兽庬暿 like '" + LOCAL_M +"' or 话兽庬暿 like '"+WINNT_DC +"'";
rs = stmt.executeQuery(sql);
if(rs.next()){
RecCount = rs.getInt(1);
rs = null;
}
String sql2 = "select * from 寁嶼婡 where 话兽庬暿 like '"+ NIS_M_O +"' or 话兽庬暿 like '" + LOCAL_M +"' or 话兽庬暿 like '"+WINNT_DC +"'";
while(rs.next()){
int i = 0;
DOMEIN[i] = rs.getString("霓也輺?);
i++;
}
for(int j = 0 ; j < RecCount ; j++){
String sql3 = "select * from 僌儖乕僾庬暿 where 霓也輺?= '" + DOMEIN[j] +"'";
rs = stmt.executeQuery(sql3);
if(rs.next()){
K = K + 1;
Group_SYB[K] = rs.getString("皋侔踢庬暿");
}
}
for(int l = 0; l < 32; l++){
for(int m = 0; m < K; m++){
if(Group_SYB[m].substring(l,l+1).equals("1")){
if(l==1){
Set_Ret = "1";
}else{
Set_Ret = Set_Ret + "1";
}
break;
}else{
if(m==K){
if(l==1){
Set_Ret = "0";
}else{
Set_Ret = Set_Ret + "0";
}
}
}
}
}
g_syb_mk = Set_Ret;
}catch(Exception e) { }
return g_syb_mk;
}
int reCount(String strtable,String Sel)
{
String mySt="";
int t = 0;
ResultSet rsd=null;
try
{
mySt= "select count(*) ads from " + strtable + " " + Sel;
rsd= conn.createStatement().executeQuery(mySt);
if (rsd.next())
{
t=rsd.getInt("ads");
}
}
catch(SQLException sqe)
{
System.out.println("ODBC Wrong :" + sqe +"+" +mySt);
}
rsd = null;
return t;
}
int dCount(String duan,String strTable,String strSel)
{
int t=0;
ResultSet rss=null;
try
{
String mySql="select count(*) ads from " + strTable + " where " + strSel + " and "+ duan +" is not null ";
rss= conn.createStatement().executeQuery(mySql);
if (rss.next())
{
t=rss.getInt("ads");
}
}
catch(Exception sqe)
{
System.out.println(sqe);
}
rss=null;
return t;
}
String dLookup(String duan,String strTable,String strSel)
{
String strReturn = null;
ResultSet rss = null;
try{
String strsql = "select "+duan+" from "+strTable+" where "+ strSel;
rss = conn.createStatement().executeQuery(strsql);
if(rss.next()){
strReturn = rss.getString(duan);
}
}catch(java.sql.SQLException sqle){
System.out.println("dLookup_Exception:"+sqle);
}
rss = null;
return strReturn;
}
String rTrim(String str){
String rstr = str;
if(str == null)
{
rstr = "";
}
else
{
if(str.length() == 0) rstr = "";
if(str.length() > 0)
{
for(int i = str.length() ; i > 0 ; i--)
{
if(str.substring(i-1,i).equals(" "))
rstr = rstr.substring(0,i-1);
else break;
}
}
}
return rstr;
}
void sybinf_set(stc_RSYB_Name in_data, stc_SYB_INF out_data) throws java.sql.SQLException{
String NEW_SYB = "00000000000000000000000000000000";
out_data.reg_name = in_data.NAME;
String sql = "";
String rdomein1 = "";
String rdomein2 = "";
String rdomein3 = "";
ResultSet rsf = null;
Statement stf = conn.createStatement();
try {
sql = "Select 皋侔踢庬暿 From 僌儖乕僾庬暿 Where 霓也輺?= '" + in_data.host + "'";
rsf = conn.createStatement().executeQuery(sql);
if (rsf.next()) {
out_data.G_SYB = dealNull(rsf.getString("皋侔踢庬暿"));
} else {
out_data.G_SYB = "";
}
} catch(java.sql.SQLException sqle) {
System.out.println("111111" + sqle);
}
try {
sql = "Select 棙梡庬暿 From 棙梡庬暿 Where 霓也輺?= '" + in_data.home1 + "'";
rsf = stf.executeQuery(sql);
if (rsf.next())
rdomein1 = dealNull(rsf.getString("棙梡庬暿"));
} catch(java.sql.SQLException sqle) {
System.out.println("22222" + sqle);
}
try {
sql = "Select 棙梡庬暿 From 棙梡庬暿 Where 霓也輺?= '" + in_data.home2 + "'";
rsf = stf.executeQuery(sql);
if (rsf.next())
rdomein2 = dealNull(rsf.getString("棙梡庬暿"));
} catch(java.sql.SQLException sqle) {
System.out.println("333333" + sqle);
}
try {
sql = "Select 棙梡庬暿 From 棙梡庬暿 Where 霓也輺?= '" + in_data.home3 + "'";
rsf = stf.executeQuery(sql);
if (rsf.next())
rdomein3 = dealNull(rsf.getString("棙梡庬暿"));
} catch(java.sql.SQLException sqle) {
System.out.println("444444" + sqle);
}
rsf = null;
stf = null;
String p = Char_OR(rdomein1, rdomein2);
if (p.equals("")) p = NEW_SYB;
String q = Char_OR(p, rdomein3);
if (q.equals("")) q = NEW_SYB;
out_data.R_SYB = q;
}
String Char_OR(String arg1, String arg2) {
int len1 = -1, len2 = -1, max_len = -1, min_len = -1;
String ret_sts = "";
int long_f = -1;
len1 = arg1.length();
len2 = arg2.length();
if (len1 == 0 && len2 > 0)
return arg2;
else if (len1 > 0 && len2 == 0)
return arg1;
else if (len1 == 0 && len2 == 0)
return "";
ret_sts = "";
if (len1 > len2) {
max_len = len1;
min_len = len2;
long_f = 1;
} else if (len1 < len2) {
max_len = len2;
min_len = len1;
long_f = 2;
} else {
max_len = len1;
min_len = len2;
long_f = 0;
}
for (int i = 1; i <= max_len; i++) {
if (i <= min_len) {
if (arg1.substring(i-1, i).equals("1") || arg2.substring(i-1, i).equals("1"))
ret_sts = ret_sts + "1";
else
ret_sts = ret_sts + "0";
} else {
if (long_f == 1)
ret_sts = ret_sts + arg1.substring(i-1, i);
else if (long_f == 2)
ret_sts = ret_sts + arg2.substring(i-1, i);
}
}
return ret_sts;
}
%>
<%!
void writeFile(String myString,String target_file){
try {
java.io.PrintWriter pw = new java.io.PrintWriter(new java.io.FileOutputStream(target_file));
pw.println(myString);
pw.close();
myString="";
} catch(java.io.IOException e) {
System.out.println(e.getMessage());
}
}
%>