81,092
社区成员
发帖
与我相关
我的任务
分享
public static int ExcecuteNonQurery(string sql,params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
}
}
public int executeUpdate(String sql, Object... params) throws SQLException {
int ret = 0;
PreparedStatement pstmt = null;
try {
pstmt = this.conn.prepareStatement(sql);
for (int i = 0, len = params.length; i < len; i++) {
if (params[i] == null || params[i].toString().length() == 0) {
pstmt.setNull(i + 1, java.sql.Types.VARCHAR);
} else {
pstmt.setObject(i + 1, params[i]);
}
}
ret = executeUpdate(pstmt);
this.log.debug(this.getPreparedSQL(sql, params));
} finally {
this.closePstmt(pstmt);
}
return ret;
}