关于数据库连接的一个javabean配置的问题

0 0

关于数据库连接的一个javabean配置的问题10

oracleutil.java如下：
package com.oracleutil;

import java.sql.SQLException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;

public class OracleUtil {
private String dataSourceName;
private DataSource ds;

public OracleUtil() {

}

public OracleUtil(String dataSourceName) {
this.dataSourceName = dataSourceName;
}

public void setDataSourceName(String dataSourceName) {
this.dataSourceName = dataSourceName;
}

public void init() {
try {
   Context initContext = new InitialContext();
   this.ds = (DataSource) initContext.lookup(dataSourceName);
   initContext.close();
} catch (NamingException e) {
   e.printStackTrace();
}
}

public int update(String sql, String[] params) {
QueryRunner qr = new QueryRunner(ds);
int result = 0;
try {
   result = qr.update(sql, params);
} catch (SQLException e) {
   e.printStackTrace();
}
return result;
}

public Object query(String sql, String[] params, ResultSetHandler rsh) {
QueryRunner qr = new QueryRunner(ds);
Object results = null;
try {
   results = qr.query(sql, params, rsh);
} catch (SQLException e) {
   e.printStackTrace();
}
return results;
}
}

我用的驱动是class12.java，运行的时候报错java.lang.NoSuchMethodError: com.oracleutil.OracleUtil.update(Ljava/lang/String;Ljava/lang/Object;)I
请指教！

问题补充：

successfulroof 写道

这不是驱动的问题，是你程序的问题。
你调用的时候用的是 update（String[] args,Object[] obj）
但是你定义的是 update(String sql, String[] params)

请教一下咋改正！
OracleUtil程序：
package com.oracleutil;

import java.sql.SQLException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;

public class OracleUtil {
private String dataSourceName;
private DataSource ds;

public OracleUtil() {

}

public OracleUtil(String dataSourceName) {
this.dataSourceName = dataSourceName;
}

public void setDataSourceName(String dataSourceName) {
this.dataSourceName = dataSourceName;
}

public void init() {
try {
 Context initContext = new InitialContext();
 this.ds = (DataSource) initContext.lookup(dataSourceName);
 initContext.close();
} catch (NamingException e) {
 e.printStackTrace();
}
}

public int update(String sql, String[] params) {
QueryRunner qr = new QueryRunner(ds);
int result = 0;
try {
 result = qr.update(sql, params);
} catch (SQLException e) {
 e.printStackTrace();
}
return result;
}

public Object query(String sql, String[] params, ResultSetHandler rsh) {
QueryRunner qr = new QueryRunner(ds);
Object results = null;
try {
 results = qr.query(sql, params, rsh);
} catch (SQLException e) {
 e.printStackTrace();
}
return results;
}
}

<%@ page language="java" pageEncoding="utf-8"%>
<%@ page
import="java.text.SimpleDateFormat"%>
<%@ page import="com.StringUtil"%>

<%@ include file="/header.jsp"%>
<jsp:useBean id="db" class="com.oracleutil.OracleUtil" scope="request"></jsp:useBean>
<jsp:useBean id="gb" class="com.guestbook.Guestbook" scope="request"></jsp:useBean>
<%request.setCharacterEncoding("utf-8"); %>
<jsp:setProperty property="*" name="gb" />

<%
String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
int result = 0;

String name = gb.getName();
String title = gb.getTitle();

if (StringUtil.validateNull(name)) {
%>
对不起，姓名不能为空，请您重新输入！ 
<a href="<%=context%>/addMessage.jsp">添加新的留言</a> 
<%} else if (StringUtil.validateNull(title)) {%>
对不起，主题不能为空，请您重新输入！ 
<a href="<%=context%>/addMessage.jsp">添加新的留言</a> 
<% } else {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String param[] = { StringUtil.filterHtml(name), StringUtil.filterHtml(gb.getEmail()),
StringUtil.filterHtml(gb.getPhone()), StringUtil.filterHtml(title),
gb.getContent(), sdf.format(new java.util.Date()) };
 db.setDataSourceName("java:/comp/env/jdbc/oracleds");
db.init();
result = db.update(sql, param);

if (result == 0) {
%>
对不起，添加留言不成功，请您重新输入！ 
<a href="<%=context%>/addMessage.jsp">添加新的留言</a> 
<%} else { %>
祝贺您，成功添加留言。 
<a href="<%=context%>/getMessages.jsp">查看所有留言内容</a> 
<%}
}%>
<%@ include file="/footer.jsp" %>

Web综合