String sql = "{call dbo.pr_OutboundNotice_Save(?,?,?,?,?,?,?)}";
try {
statement = conn.prepareCall(sql);
statement.setString(1, EnterpriseNo);
statement.setString(2, xml);
statement.setInt(3, 0);
statement.setTimestamp(4, new Timestamp(new Date().getTime()));
statement.registerOutParameter(5, Types.INTEGER);
statement.registerOutParameter(6, Types.VARCHAR);
statement.registerOutParameter(7, Types.VARCHAR);
// 执行
ResultSet executeQuery = statement.executeQuery();
if (executeQuery.next()) {
if (!statement.getMoreResults()) {
}
}
if (!statement.getMoreResults()) {
returnValue=statement.getInt(5);
returnMsg=statement.getString(6);
}
if(returnValue == 1){
returnMsg=returnMsg.substring(returnMsg.indexOf('保'))+","+returnMsg.substring(0,returnMsg.indexOf('保'));
}else{
returnMsg=returnMsg.substring(returnMsg.indexOf('>')+1);
}
Map<String, Object> RowMap = new LinkedHashMap<String, Object>();
RowMap.put("returnValue", returnValue);
RowMap.put("returnMsg", returnMsg);
listt.add(RowMap);
res.put("Tables", listt);
} catch (java.sql.SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (java.sql.SQLException e) {
e.printStackTrace();
}
try {
statement.close();
} catch (java.sql.SQLException e) {
e.printStackTrace();
}
}