 |
| 链接DB2数据库的例子（用于保存）！ |
|
十年 原创 更新：2006-12-16 15:47:54 版本: 1.0
|
|
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, "|SRZF|100|12|||");
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)
{
}
}
}
}
|
|
|
评论人：paulhybryant
|
发表时间: Wed Jan 17 10:26:19 CST 2007
|
|
只给了代码,唉,没什么实际的作用啊
|
|
|
|
|
|
7 
3
