Question

JAVA调用ORACLE存储过程

我在网上找了一个例子，可是大家有谁知道它为什么只能插入数据型的，字符型的它就插不进呢！
http://unixboy.javaeye.com/blog/167807
有谁知道的帮我一下！是JAVA调用ORACLE的

Answer 1

给你个方法，自己参研吧。
private static final String DELETE_ENTRIES_BY_DATE_RANGE_SPNAME = "deleteEntriesByDateRangeSpName";

public int deleteByDateRange(Date start, Date end) {
// get connection
Connection conn = getConnection();
try {
// set auto commit false
conn.setAutoCommit(false);
// retrieve callableStatement by deleteEntriesByDateRangeSpName
CallableStatement cs = prepareCallableStatement(conn,
deleteEntriesByDateRangeSpName);
cs.setString("application_name", applicationName);
cs.setString("module_name", moduleName);
cs.setDate("startDate", Util.convUtilDateToSqlDate(start));
cs.setDate("endDate", Util.convUtilDateToSqlDate(end));

cs.registerOutParameter("deleted_rows", java.sql.Types.INTEGER);

cs.execute();

int affectedRows = cs.getInt("deleted_rows");
// transaction commit
conn.commit();
// close cs
cs.close();

return affectedRows;

Answer 2

public int deleteByDateRange(Date start, Date end) {
// get connection
Connection conn = getConnection();
try {
// set auto commit false
conn.setAutoCommit(false);
// retrieve callableStatement by deleteEntriesByDateRangeSpName
CallableStatement cs = prepareCallableStatement(conn,
deleteEntriesByDateRangeSpName);
cs.setString("application_name", applicationName);
cs.setString("module_name", moduleName);
cs.setDate("startDate", Util.convUtilDateToSqlDate(start));
cs.setDate("endDate", Util.convUtilDateToSqlDate(end));

cs.registerOutParameter("deleted_rows", java.sql.Types.INTEGER);

cs.execute();

int affectedRows = cs.getInt("deleted_rows");
// transaction commit
conn.commit();
// close cs
cs.close();

return affectedRows;