📄 tasktofindata.jsp

📁 tomcat最新安装程序
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.Date,java.util.Calendar,java.io.*,java.sql.*,java.util.Vector,java.text.*"%>           
  <%
  Connection conn=null;
  Statement stmt=null;
  Statement stmtimge=null;
  Statement stmts=null;
  Statement stmtb=null;
  ResultSet rs=null;
  ResultSet rsA=null;
  ResultSet rsB=null;
  ResultSet rsImage=null;
  StringBuffer Name=null;
  Date d_Date=null;
  String sql;
  String insertsql;
   

  Class.forName("org.gjt.mm.mysql.Driver");//用jdbc:odbc桥连接数据库
  conn    =DriverManager.getConnection("jdbc:mysql://192.168.0.13:3306/krm","root","123");//连接数据库 
  stmts   =conn.createStatement();//创建陈述
  stmt    =conn.createStatement();//创建陈述 
  stmtb   =conn.createStatement();//创建陈述	 
  stmtimge=conn.createStatement();//创建陈述
 %> 



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>数据转移工具</title>
</head>
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<body > 
<table border="1" width="95%" align="center"  bordercolor="A1B7DB" class="collapse">
   <tr bgcolor="#0066CC"><td colspan="4" class="common"  height="20"><div align="center"><font color="#FFFFFF">财务报销单编号数据迁移</font></div>
       </td>
   <tr>
   <tr bgcolor="#D4E8F4">
      <td width="10%" class="common"  height="20" align="center">序号</td>
	  <td width="10%" class="common"  height="20" align="center">财务报销单号</td>
	  <td width="40%" class="common"  height="20" align="center">任务编号(FM_ExpenseAccountInfo:EI_ItemID)</td>
	  <td width="40%" class="common"  height="20" align="center">任务名称(FM_ExpenseAccountInfo:EI_ItemName)</td>
   </tr>
   <%

     sql = "SELECT  EI_ItemID,EI_ID  from FM_ExpenseAccountInfo";
	 
     rsA=stmts.executeQuery(sql);
	 int num = 1;
	 if(rsA!= null&&rsA!= null) {
	    while(rsA.next()){
		String serialNum=rsA.getString("EI_ID");
		String taskid=rsA.getString("EI_ItemID");
		String sqldetail = "SELECT  TA_Detail.D_Topic  from TA_Detail where TA_Detail.D_Serial='" + taskid + "'";
                rsB=stmtb.executeQuery(sqldetail);
		String topicname = null;
		if (rsB!= null && rsB.next()==true)
		{
		  //rsB.next();
		  topicname = rsB.getString("D_Topic"); 
		  insertsql="update  FM_ExpenseAccountInfo set EI_ItemName = '"+topicname+"' where EI_ID='"+serialNum+"'" ; 
		  //insertsql="update  FM_ExpenseAccountInfo set EI_SerialNum = '"+serialNum+"' where EI_ID='"+serialNum+"'" ; 		
                  stmt.executeUpdate(insertsql);
		 } 
    %>
	<tr bgcolor="#F7FDF3">
	   <td width="10%" class="common" align="center"><%=num%></td>
	   <td width="10%" class="common" align="center"><%=serialNum%></td>
	   <td width="40%" class="common" align="center">
	   <%
	   //String strd = new String(topicname.getBytes("iso8859_1"), "GB2312");
	   out.print(taskid);
	   %>
	   </td>
	   <td width="40%" class="common" align="center">
	   <%out.print(topicname);%>
	   </td>	   
 
<%
  num++;
    } 
  }
%>
</table> 
   
<%
rsA.close();
rsB.close();
stmts.close();
stmt.close();
stmtb.close();
%>

<%
out.print("财务数据迁移完毕!");
%>



</body>
</html>
⌨️ 快捷键说明

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