<%!
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: // get the machine name or IP address
String get_myhostname (javax. servlet. http. httpservletrequest request ){
String myhostname = NULL;
Try {
Myhostname = request. getremotehost ();
Myhostname = myhostname. touppercase ();
} Catch (exception e ){}
Return myhostname;
}
File: // process an empty string
String dealnull (string Str ){
String returnstr = NULL;
If (STR = NULL) returnstr = "";
Else returnstr = STR;
Return returnstr;
}
File: // process empty objects
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, "& amp ;","&");
TXT = Replace (txt, "& quot ;",""");
TXT = Replace (txt ,"/"",""");
TXT = Replace (txt, "& lt;", "<");
TXT = Replace (txt, "<", "<");
TXT = Replace (txt, "& gt;", "> ");
TXT = Replace (txt, ">", "> ");
TXT = Replace (txt, "& nbsp ;","");
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.doc ument. form1.text1. Select ();");
Out. println ("</SCRIPT> ");
} Catch (exception e ){}
}
File: // get the string length
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: // determine whether it is a number
Boolean isnumeric (string number)
{
Try
{
Integer. parseint (number );
Return true;
}
Catch (numberformatexception sqo)
{
Return false;
}
}
File: // determine whether it is a date
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) (STS Sid + 0.5 );
If (stsid-(INT) stsid = 0.5 ){
If (INT) (stsid-0.5) % 2 = 0)
Stsid1 = (INT) (stsid-0.5 );
Else
Stsid1 = (INT) (STS Sid + 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: // Output Space
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 computer where & #65403; & #65392; & #65418; & #65438; like '"+ nis_m_o +"' or & #65403; & #65392; & #65418; & #65438; like '"+ local_m +"' or & #65403; & #65392; & #65418; & #65438; like '"+ winnt_dc + "'";
Rs = stmt.exe cutequery (SQL );
If (Rs. Next ()){
Reccount = Rs. getint (1 );
Rs = NULL;
}
String sql2 = "select * from computer where & #65403; & #65392; & #65418; & #65438; like '"+ nis_m_o +"' or & #65403; & #65392; & #65418; & #65438; like '"+ local_m +"' or & #65403; & #65392; & #65418; & #65438; like '"+ winnt_dc + "'";
While (Rs. Next ()){
Int I = 0;
Domein [I] = Rs. getstring ("& #65412; & #65438; & #65426; & #65394; & #65437; & #12539 ;);
I ++;
}
For (Int J = 0; j <reccount; j ++ ){
String sql3 = "select * from province where other types where & #65412; & #65438; & #65426; & #65394; & #65437; & #12539; = '"+ domein [J] + "'";
Rs = stmt.exe cutequery (sql3 );
If (Rs. Next ()){
K = k + 1;
Group_syb [k] = Rs. getstring ("& #65400; & #65438; & #65433; & #65392; & #65420; & #65439; other ");
}
}
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(cmd.exe cutequery (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(cmd.exe cutequery (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(.exe cutequery (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 & #65400; & #65438; & #65433; & #65392; & #65420; & #65439; species from different regions where & #65412; & #65438; & #65426; & #65394; & #65437; & #12539; = '"+ in_data.host + "'";
RSF = conn.createstatement(cmd.exe cutequery (SQL );
If (RSF. Next ()){
Out_data.g_syb = dealnull (RSF. getstring ("& #65400; & #65438; & #65433; & #65392; & #65420; & #65439; "));
} Else {
Out_data.g_syb = "";
}
} Catch (Java. SQL. sqlexception sqle ){
System. Out. println ("111111" + sqle );
}
Try {
SQL = "select use case from use case where & #65412; & #65438; & #65426; & #65394; & #65437; & #12539; = '"+ in_data.home1 + "'";
RSF = stf.exe cutequery (SQL );
If (RSF. Next ())
Rdomein1 = dealnull (RSF. getstring (" "));
} Catch (Java. SQL. sqlexception sqle ){
System. Out. println ("22222" + sqle );
}
Try {
SQL = "select use case from use case where & #65412; & #65438; & #65426; & #65394; & #65437; & #12539; = '"+ in_data.home2 + "'";
RSF = stf.exe cutequery (SQL );
If (RSF. Next ())
Rdomein2 = dealnull (RSF. getstring (" "));
} Catch (Java. SQL. sqlexception sqle ){
System. Out. println ("333333" + sqle );
}
Try {
SQL = "select use case from use case where & #65412; & #65438; & #65426; & #65394; & #65437; & #12539; = '"+ in_data.home3 + "'";
RSF = stf.exe cutequery (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 ());
}
}
%>