📄 datatidy_compare_column.jsp

📁 程序功能：页面间获取参数
💻 JSP
字号:
程序功能：页面间获取参数，链接数据库并实现数组控件功能。
<%@ page contentType="text/html;charset=GB2312"%>   
<%@ page import="java.sql.*"%>  
<%@ page import="java.sql.ResultSet"%> 
<%@ page import="java.lang.*"%> 

<%
    String dest_table = request.getParameter("dest");
    String sour_table = request.getParameter("sour");
    String row_num    = request.getParameter("rownum");
    
    System.out.println(dest_table);
    System.out.println(sour_table);
    System.out.println(row_num);
    
%>


<%session.setAttribute("A",dest_table);%>
<%session.setAttribute("B",sour_table);%>

<jsp:useBean id="DB_Conn" scope="page" class="JavaBean.DB_Conn"/>
<jsp:useBean id="DB_User" scope="page" class="JavaBean.DB_User"/>
	
<%
	DB_Conn.ConnectDestDB(); 
	ResultSet dest_rs11 = null;
	String sql_dest11 = "select　* from "+dest_table;
	dest_rs11 = DB_Conn.sm.executeQuery(sql_dest11);
	ResultSetMetaData   mtdt11=dest_rs11.getMetaData(); 
    int  column_length=mtdt11.getColumnCount();
%>

<%
	DB_Conn.ConnectDestDB(); 
	ResultSet dest_rs1 = null;
	String sql_dest1 = "select * from USER_COL_COMMENTS,USER_TAB_COLS where USER_COL_COMMENTS.table_name=USER_TAB_COLS.table_name and USER_COL_COMMENTS.column_name= USER_TAB_COLS.column_name and USER_COL_COMMENTS.table_name="+"'"+dest_table+"'";
	dest_rs1 = DB_Conn.sm.executeQuery(sql_dest1);
%>

<%
	DB_Conn.ConnectSourceDB();
	ResultSet sour_rs1 = null;
	String sql_sour1 = "select * from "+sour_table;
    sour_rs1 = DB_Conn.sm.executeQuery(sql_sour1);
    ResultSetMetaData   mtdt2=sour_rs1.getMetaData(); 
    int  nmb2=mtdt2.getColumnCount();
%> 

<body background="file:///C:/Documents%20and%20Settings/Administrator/桌面/25ca80c47b2852c638db49c0.gif" style="background-attachment: fixed">


<%!
     public String getStr(String s)
     {
        String str=s;
        try
        {
          byte b[]=str.getBytes("ISO-8859-1");
          str=new String(b);
          return str;
        }
        catch(Exception e)
        {
          return null;
        }
     }  
%>



<center>
<p><FONT style="FONT-SIZE:10pt">目标--源字段对照</font>
<hr>
  </center>		
  <FONT style="FONT-SIZE:10pt">提示：</font>
<br>
  <FONT style="FONT-SIZE:10pt">1.根据目标表字段在下拉列表中选择原表字段；</font>
 <br> 
  <FONT style="FONT-SIZE:10pt">2.确认无误点击“确定”；</font>
  <br>
 <FONT style="FONT-SIZE:10pt">3.点击“返回”，返回原表目标表关系对照页面。</font>
  <center>
<br>
<table border="1" width="68%" height="50" id="table2" cellpadding="0" cellspacing="0" bordercolor=black bordercolordark=black bordercolorlight="#7B7B7B">
<tr bgcolor="#C4E1FF">
<td align="center" colspan="3" height="20"><FONT style="FONT-SIZE:10pt">目标表名称：<%out.print(dest_table);%></font></td>
<td align="center" colspan="2" height="20"><FONT style="FONT-SIZE:10pt">原表名称：<% out.print(sour_table);%></font></td>
</tr>
<tr bgcolor="#C4E1FF">
<td align="center" width="16%" height="20"><FONT style="FONT-SIZE:10pt">字段名称</font></td>
<td align="center" width="22%" height="20"><FONT style="FONT-SIZE:10pt">字段含义</font></td>
<td align="center" width="17%" height="20"><FONT style="FONT-SIZE:10pt">字段类型</font></td>
<td align="center" width="12%" height="20"><FONT style="FONT-SIZE:10pt">字段名称</font></td>
<td align="center" width="30%" height="20"><FONT style="FONT-SIZE:10pt">相应字段类型</font></td>
</tr>

<%String f_ls_text_name,s_ls_text_name,t_ls_text_name,ls_select_name;
  String ls_num,ls_textarea_name;
%>

  <%
   String  CK[]=new String[column_length];
   String  T_TX[]=new String[column_length];
  %>

 <%System.out.println(column_length);%>

<form name="columnform" action="" method="post">
<input type=hidden name="DEST_TABLE" value = "<%=dest_table%>">
<input type=hidden name="SOUR_TABLE" value = "<%=sour_table%>">
<input type=hidden name="ROW_NUM" value = "<%=row_num%>">
<input type=hidden name="NMB1" value ="<%=column_length%>">
<p>
<textarea style="display:none" name="TOTAL" cols="17"></textarea>

<%int j=0;%>

<%while (dest_rs1.next()){%>
<%
            
	          ls_num = String.valueOf(j); 
	          ls_select_name = "CK" + ls_num;
	          f_ls_text_name = "F_TX" + ls_num;
	          s_ls_text_name = "S_TX" + ls_num;
	          t_ls_text_name = "T_TX" + ls_num;
	          ls_textarea_name="MD_RE"+ls_num;

              CK[j]=ls_select_name;
              T_TX[j]=t_ls_text_name;
              j=j+1;        
%>

</p>

<tr>

<td align="center" width="16%" height="17">
<input type="text" readonly="true" name="F_TX" size="15" value=<%=dest_rs1.getString("COLUMN_NAME")%> </td>
<%String c=dest_rs1.getString("COMMENTS");%>
<%String d=getStr(c); %>
<td align="center" width="22%" height="17"><FONT style="FONT-SIZE:10pt"><%=dest_rs1.getString("COMMENTS")%></font></td>
<td align="center" width="17%" height="17"><input type="text" readonly="true" name="S_TX" size="15" value ="<%=dest_rs1.getString("DATA_TYPE")%>"></td>
<td align="center" width="12%" height="17">

<select name="CK" size="1" onchange="check(<%=ls_num%>)"> 
   <% for(int i=1;i<=nmb2;i++){%> 
   <option  value="<%=mtdt2.getColumnName(i)+'*'+mtdt2.getColumnTypeName(i)+'*'%>"><%out.println(mtdt2.getColumnName(i)+'\n'); %></option>
   <% } %>
   </select>  
   </td>
<td align="center" width="30%" height="17">
<input type="text" readonly="true" name="T_TX" size="24" value =""><textarea style="display:none" rows="2"   name="MD_RE" cols="1"></textarea></td>	

</tr>
<%}%>

  <SCRIPT   LANGUAGE="JavaScript">   
  function  check(j){   
  document.all.T_TX[j].value=document.all.CK[j].value;   
  document.all.MD_RE[j].value =document.all.DEST_TABLE.value+'*'+document.all.SOUR_TABLE.value+'*'+ document.all.F_TX[j].value  + '*' + document.all.S_TX[j].value + '*' +  document.all.CK[j].value ;    
  return;
  }   
  
  function cl()
  {
   window.close();
  }
   function c2()
  {
for(y=0;y<<%=column_length%>;y++){
document.all.TOTAL.value=document.all.TOTAL.value+document.all.MD_RE[y].value;
}
opener.myform.MD_RT[<%=row_num%>].value=document.all.TOTAL.value;
opener.myform.new<%=row_num%>.value=document.all.TOTAL.value;
opener.myform.COLUMN_LENGTH<%=row_num%>.value=document.all.NMB1.value;
  window.close();
  }
   
  </SCRIPT> 
  </table>
  </center>	
  <center>
<br>

<input type="button" onclick = "c2()" value="确定">


</form>
</center>
💿 文件大小 3 K
👤 上传用户 zhou28
📂 所属分类数据库系统
🏷️ 相关标签

#程序 #参数 #页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -