用线程入库的操作 OperateDB 01

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import org.apache.log4j.Logger;

public class
{
private static Logger logger = Logger.getLogger(OperateDB.class);

private OperateDB()
{

}

/**
* 设置TableName_Field对象中的数据设置到PreparedStatement 2012-1-7,Xgw123485
* TableName_Field中包含了(表名,和表对应的要国入数据库的值)
*/
public static void putValue2Pstatement(TableName_Field table,
PreparedStatement pstatement)
{
int index = 1;
String fieldValue = null;
for (EsbTableField esbTableField : table.getList())
{
fieldValue = esbTableField.getFieldValue();
// 如果字段的数据类型是整形
if ("int".equals(esbTableField.getDatetype()))
{
// 默认0
int value = 0;
try
{
value = Integer.parseInt(fieldValue);
}
catch (Exception e)
{
logger.error("Fail parseInt" + fieldValue, e);
}
try
{
pstatement.setInt(index, value);
}
catch (Exception e)
{
logger.error("Fail setInt index = " + index + " value = "
+ value, e);
}
}
else if ("String".equals(esbTableField.getDatetype()))
{
if (null == fieldValue)
{
fieldValue = "";
}
try
{
pstatement.setString(index, fieldValue);
}
catch (Exception e)
{
logger.error("Fail setString index = " + index
+ " value = " + fieldValue, e);
}
}
// 如果字段的数据类型是日期型
else if ("timestamp".equals(esbTableField.getDatetype()))
{
if (null == fieldValue)
{
fieldValue = Tools.dateFormatString(new Date());
}
java.sql.Timestamp stamp = java.sql.Timestamp
.valueOf(fieldValue);
try
{
pstatement.setTimestamp(index, stamp);
}
catch (Exception e)
{
logger.error("Fail setDate index = " + index + " value = "
+ fieldValue, e);
}
}
// 如果字段的数据类型是Blob型
else if ("blob".equals(esbTableField.getDatetype()))
{
if (null == fieldValue)
{
fieldValue = "";
}
try
{
pstatement.setBytes(index, fieldValue.getBytes());
}
catch (Exception e)
{
logger.error("Fail setBytes index = " + index + " value = "
+ fieldValue, e);
}
}
index++;
}
}