📄 transdata.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.112:3306/krm","root","");//连接数据库 
  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="2" class="common"  height="20"><div align="center"><font color="#FFFFFF">财务报销单编号数据迁移</font></div>
       </td>
   <tr>
   <tr bgcolor="#D4E8F4">
      <td width="50%" class="common"  height="20" align="center">序号</td>
	  <td width="50%" class="common"  height="20" align="center">财务报销单号</td>
   </tr>
   <%

     sql ="SELECT  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");
		insertsql="update  FM_ExpenseAccountInfo set EI_SerialNum = '"+serialNum+"' where EI_ID='"+serialNum+"'" ; 		
       stmt.execute(insertsql);
    %>
	<tr bgcolor="#F7FDF3">
	   <td width="50%" class="common" align="center"><%=num%></td>
	   <td width="50%" class="common" align="center"><%=serialNum%></td>	   
 
<%
  num++;
    } 
  }
%>
</table> 
   
<%
rsA.close();
stmts.close();
stmt.close();
%>





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

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