python小脚本之数据导入

迈不过友情╰ 2022-09-18 10:55 131阅读 0赞

# python小脚本之 数据导入 #

[\[复制链接\]][Link 1]

# python小脚本之 数据导入 #

[\[复制链接\]][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td>&nbsp;</td> 
   <td> 
    <div style="top:33px; position:fixed"> 
     <a rel="nofollow"></a> 
     <div> 
      <div> 
       <a href="http://www.okpython.com/home.php?mod=space&amp;uid=1" rel="nofollow">xieaotian</a> 
      </div> 
     </div> 
    </div> </td> 
   <td> 
    <div> 
     <div> 电梯直达  
      <a title="跳转到指定楼层" rel="nofollow"><img src="http://www.okpython.com/static/image/common/fj_btn.png" alt="跳转到指定楼层"></a> 
     </div> 
     <strong><a href="http://www.okpython.com/forum.php?mod=viewthread&amp;tid=4058" rel="nofollow"><em>1</em><sup>#</sup></a></strong> 
     <div> 
      <div></div> 
      <div> 
       <img src="http://www.okpython.com/static/image/common/online_admin.gif" alt=""> 
       <em>发表于 <span title="2013-11-12 12:07:12">6&nbsp;天前</span></em> 
       <span>|</span> 
       <a href="http://www.okpython.com/forum.php?mod=viewthread&amp;tid=4058&amp;page=1&amp;authorid=1" rel="nofollow">只看该作者</a> 
       <span><img src="http://www.okpython.com/static/image/common/arw_r.gif" alt="回帖奖励"></span> 
      </div> 
     </div> 
    </div> 
    <div> 
     <div> 
      <div> 
       <table> 
        <tbody> 
         <tr> 
          <td>有测试数据需要入库, 逗号分隔的 csv格式 ,不想大动干戈用java来操作 <br> 写python小脚本进行操作 
           <div> 
            <div> 
             <ol> 
              <li>import cx_Oracle&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>dns_tns=cx_Oracle.makedsn("192.168.0.288",1521,"skynet")&nbsp; &nbsp;<br> </li> 
              <li>print dns_tns&nbsp; &nbsp;<br> </li> 
              <li>con = cx_Oracle.connect('alibaba', 'zhimakamen', dns_tns)&nbsp; &nbsp;<br> </li> 
              <li>cur=con.cursor()&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>for index,line in enumerate(file("f2.csv")):&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;sql="""insert into iq_data_B011F8286A1B2000A&nbsp; &nbsp;<br> </li> 
              <li>&nbsp; &nbsp; (field1,field2,field3,field4) values ("""&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;for fields in (line.split(",")):&nbsp; &nbsp;<br> </li> 
              <li>&nbsp; &nbsp; sql=sql+"'"+fields+"',"&nbsp;&nbsp;<br> </li> 
              <li>&nbsp;&nbsp;cur.execute(sql[:-1]+")")&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>con.commit()&nbsp; &nbsp;<br> </li> 
              <li>con.close()&nbsp;&nbsp;<br> </li> 
              <li><br> </li> 
             </ol> 
            </div> 
            <em>复制代码</em> 
           </div> </td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div style="top:33px; position:fixed"> 
     <a rel="nofollow"></a> 
     <div> 
      <div> 
       <a href="http://www.okpython.com/home.php?mod=space&amp;uid=1" rel="nofollow">xieaotian</a> 
      </div> 
     </div> 
    </div> </td> 
   <td> 
    <div> 
     <div> 电梯直达  
      <a title="跳转到指定楼层" rel="nofollow"><img src="http://www.okpython.com/static/image/common/fj_btn.png" alt="跳转到指定楼层"></a> 
     </div> 
     <strong><a href="http://www.okpython.com/forum.php?mod=viewthread&amp;tid=4058" rel="nofollow"><em>1</em><sup>#</sup></a></strong> 
     <div> 
      <div></div> 
      <div> 
       <img src="http://www.okpython.com/static/image/common/online_admin.gif" alt=""> 
       <em>发表于 <span title="2013-11-12 12:07:12">6&nbsp;天前</span></em> 
       <span>|</span> 
       <a href="http://www.okpython.com/forum.php?mod=viewthread&amp;tid=4058&amp;page=1&amp;authorid=1" rel="nofollow">只看该作者</a> 
       <span><img src="http://www.okpython.com/static/image/common/arw_r.gif" alt="回帖奖励"></span> 
      </div> 
     </div> 
    </div> 
    <div> 
     <div> 
      <div> 
       <table> 
        <tbody> 
         <tr> 
          <td>有测试数据需要入库, 逗号分隔的 csv格式 ,不想大动干戈用java来操作 <br> 写python小脚本进行操作 
           <div> 
            <div> 
             <ol> 
              <li>import cx_Oracle&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>dns_tns=cx_Oracle.makedsn("192.168.0.288",1521,"skynet")&nbsp; &nbsp;<br> </li> 
              <li>print dns_tns&nbsp; &nbsp;<br> </li> 
              <li>con = cx_Oracle.connect('alibaba', 'zhimakamen', dns_tns)&nbsp; &nbsp;<br> </li> 
              <li>cur=con.cursor()&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>for index,line in enumerate(file("f2.csv")):&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;sql="""insert into iq_data_B011F8286A1B2000A&nbsp; &nbsp;<br> </li> 
              <li>&nbsp; &nbsp; (field1,field2,field3,field4) values ("""&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;for fields in (line.split(",")):&nbsp; &nbsp;<br> </li> 
              <li>&nbsp; &nbsp; sql=sql+"'"+fields+"',"&nbsp;&nbsp;<br> </li> 
              <li>&nbsp;&nbsp;cur.execute(sql[:-1]+")")&nbsp; &nbsp;<br> </li> 
              <li>&nbsp;&nbsp;<br> </li> 
              <li>con.commit()&nbsp; &nbsp;<br> </li> 
              <li>con.close()&nbsp;&nbsp;<br> </li> 
              <li><br> </li> 
             </ol> 
            </div> 
            <em>复制代码</em> 
           </div> </td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

[Link 1]: http://www.okpython.com/forum.php?mod=viewthread&tid=4058