javac时提示找不到符号DataProc,是不是指找不到类DataProc?java文件如下:packagedb;importjava.sql.*;importjava.util.*;publicclassSelectList{Stringstr="select*fromotable";St...
javac时提示找不到符号DataProc,是不是指找不到类DataProc?
java文件如下:
package db;
import java.sql.*;
import java.util.*;
public class SelectList{
String str="select * from otable";
String str2=null;
ResultSet rs=null;
Vector bmlist=null;
DataProc dataproc=null;
public SelectList() throws Exception{
try{
bmlist=new Vector();
dataproc=new DataProc();
}catch(Exception e){throw e;}
}
public Vector getList() throws Exception{
try{
dataproc.setSQL(str);
rs=dataproc.getData();
while(rs.next())
{bmlist.addElement(new String(rs.getString(1)));}
return bmlist;
}catch(SQLException e){throw e;}
}
public ResultSet manList(String strbm) throws Exception{
try{str2="select * from utable";
dataproc.setSQL(str2);
rs=dataproc.getData();
return rs;
}catch(SQLException e){throw e;}
}
}
======================
DataProc.class与这个java是同一个文件夹db里的,试了在前面加上import DataProc;也不行,不知是什么原因,忘 高手指教,谢谢。
package db;
import java.sql.*;
public class DataProc{
String strsql="";
String rvalue="";
Connection con=null;
ResultSet rs=null;
Statement stmt=null;
public DataProc() throws Exception{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:dblink";
String uid="";
String pwd="";
con=DriverManager.getConnection(url,uid,pwd);
}catch(SQLException e){throw e;}
}
public void setSQL(String str)
{this.strsql=str;}
public void newData() throws Exception
{try{stmt=con.createStatement();
stmt.executeUpdate(strsql);
stmt.close();
con.close();
}catch(SQLException e){throw e;}
}
public ResultSet getData() throws Exception
{try{stmt=con.createStatement();
rs=stmt.executeQuery(strsql);
return rs;
}catch(SQLException e){throw e;}
}
public void closeCon() throws Exception...
展开