插入Oracle数据库

Database oracle;

String sql= "insert into tableName values(?,?,?,?)";

PreparedStatement ps = oralce.getCurrentConnection().pareparedStatement(sql);

int rows = 0;

for(int i=0;i<Entity.length;i++) //Entity实体数组

{

    ps.setString(1, Entity[i].getStudentName());

    ps.setInt(2, Entity[i].getStudentAge());

    ps.setDate(3, new java.sql.Date(data.getTime()));  //data:java.util.Date

               //StringToDate(java.util.Date):new SimpleDateFormat("yyyyMMdd").parse("20110307");

    ps.setDouble(4, Entity[i].getStudentEnlish());

 

    ps.addBatch();

    if(rows % 100 == 0)

    {

        ps.executeBatch();

        ps.clearBatch();

    }

}

    ps.executeBatch();

    ps.clearBatch();

    ps.close();