jdbc 批量插入数据不能插入
rt,我一次次的插入是没有问题的,但是批量插入就不能插入,控制台也没有报错,但就是不能成功写到数据库中。高手指点下,下面是代码:
public class OracleTMobileDao implements TMobileDao {
public long addMobilesBatch(String mobile_Number, String mobile_Type,
String Card_Number, String is_Available,long total)
{
long rs = 0;
Card_Number = "0000000000000";//将card_number的值写成固定的值。
Connection conn = OracleDaoFactory.getConnection();
String mobile_Num = mobile_Number;
try {
conn.setAutoCommit(false);
String sql = "insert into TMobile values(?,?,?,?)";
PreparedStatement stmt = conn.prepareStatement(sql);
long mobile_NumLong =Long.parseLong(mobile_Number);
for(long i=0;i<total;i++)
{
mobile_NumLong+=i;
mobile_Num=mobile_NumLong+"";
stmt.setString(1, mobile_Num);
stmt.setString(2, mobile_Type);
stmt.setString(3, Card_Number);
stmt.setString(4, is_Available);
stmt.addBatch();
}
int s[] = stmt.executeBatch();
for(int i=0;i<s.length;i++)
{
rs +=s[i];
}
conn.setAutoCommit(true);
} catch (SQLException e) {
if(conn!=null)
try {
conn.rollback();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}
return rs;
}
}