JAVA链接DB2数据库的例子

王朝java/jsp·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

package com.wisdom;

import Java.lang.StringBuffer;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.DriverManager;

import java.sql.*;

import com.wisdom.base.DateUtil;

public class Test

{

public Test()

{

}

public static void main(String[] args)

{

Test test = new Test();

Connection conn = null;

try

{

Class.forName("com.ibm.db2.jcc.DB2Driver");

conn = DriverManager.getConnection(

"jdbc:db2://192.168.0.93:50000/CPICSMS", "administrator",

"rose");//

test.save(conn);

}

catch (SQLException ex)

{

ex.printStackTrace();

}

catch (ClassNotFoundException ex)

{

}

finally

{

try

{

if (conn != null)

{

conn.close();

}

}

catch (SQLException ex1)

{

}

}

}

private void save(Connection conn)

{

if (conn == null)

return;

PreparedStatement pstmt = null;

StringBuffer sb = new StringBuffer("");

sb.append("insert into SM_PrioritySend_SM_List(ServiceID, SMContent, SendTarget, Priority, RCompleteTimeBegin,")

.append(

" RCompleteTimeEnd, RCompleteHourBegin, RCompleteHourEnd, RequestTime, RoadBy,")

.append(

"SendTargetDesc,OgIdentity, FeeValue, LinkID, PAD1, PAD2, PAD3, PAD4, PAD5)")

.append(" values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

String sql = sb.toString();

try

{

pstmt = conn.prepareStatement(sql);

for (int i=0;i<2000;i++ ) {

pstmt.setString(1, "111");

pstmt.setString(2, "12121'''中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文中文'''2");

pstmt.setString(3, "13840015338");

pstmt.setInt(4, 1);

pstmt.setDate(5, DateUtil.getCurrentDate());

pstmt.setDate(6, DateUtil.getCurrentDate());

pstmt.setInt(7, 1);

pstmt.setInt(8, 1439);

pstmt.setTimestamp(9, DateUtil.getCurrentTimestamp());

pstmt.setInt(10, 1);

pstmt.setString(11, "SRZF10012");

pstmt.setString(12, "10000");

pstmt.setFloat(13, 0);

pstmt.setString(14, "sadfasfd");

pstmt.setString(15, "sadfasfd");

pstmt.setString(16, "sadfasfd");

pstmt.setString(17, "sadfasfd");

pstmt.setString(18, "sadfasfd");

pstmt.setString(19, "sadfasfd");

pstmt.executeUpdate();

}

}

catch (SQLException ex)

{

ex.printStackTrace();

}

finally

{

try

{

if (pstmt != null)

{

pstmt.close();

}

}

catch (SQLException ex1)

{

}

}

}

}

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航