请高手帮忙分析下程序!
程序如下:
import java.sql.*;
import javax.sql.*;//JDBC API
import java.util.*;//提供collection类的访问
public class GDAO{
Connection con;
Statement stmt;
ResultSet resultSet;
public GDAO() {
this("AlarmsTable"); }
public GDAO(String dataSourseName) {
try {
String url = "jdbc:odbc:" + dataSourseName;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url, "", "");
}
catch (SQLException e) {
System.out.println("SQLException in GDAO: ");
e.printStackTrace();
}
catch (Exception e) {
e.printStackTrace();
}
}
public void executeQuery( String query ) throws SQLException
{
System.out.println("Preparing and executing query ...");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
resultSet =stmt.executeQuery(query);
}
public static void main(String args[])
{
GDAO gdao = new GDAO();
try {
gdao.executeQuery(
"select AlarmsID, AlarmsSourse from Alarms");
gdao.resultSet.last();
gdao.resultSet.deleteRow();
if (gdao.resultSet.rowDeleted())
System.out.println("success");
else
System.out.println("faulse");
gdao.con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
异常如下:
E:\Java\jdk1.5.0\JavaPrograms>javac GDAO.java
E:\Java\jdk1.5.0\JavaPrograms>java GDAO
Preparing and executing query ...
java.lang.ArrayIndexOutOfBoundsException: -1
at sun.jdbc.odbc.JdbcOdbcResultSet.rowDeleted(Unknown Source)
at GDAO.main(GDAO.java:47)
请问有谁能指点指点啊!
数据源配置过了.
问题点数：0、回复次数：2Top
1 楼nini_killer（杀手）回复于 2005-04-03 16:30:43 得分 0
主函数中生成GDAO对象时没有databasename
试一下：GDAO gdao = new GDAO(数据库名称)
否则url怎么知道是什么数据库啊！
：）Top
2 楼enuoCM（cheng）回复于 2005-04-04 12:58:44 得分 0
无参数的构造函数以默认的AlarmsTable为数据源,
所以能与数据库建立起连接.
为什么:
at sun.jdbc.odbc.JdbcOdbcResultSet.rowDeleted 为 Unknown Source;
-------------------------------------------------------------------
java.lang.ArrayIndexOutOfBoundsException: -1
能说明什么?Top
