＋设为首页 ＋添加到收藏夹
我想写一个JAVA程序，从EXCEL文件中读取指定位置的数据，请问应该如何做？
谢谢！
//eid.openRS("delete from bom where cpbh="+drCpdh+" and xhxh="+drXh);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
out.println("<SCRIPT LANGUAGE=\"JavaScript\">alert(打开数库源出错，请查看数据源是否正常);window.close();</SCRIPT>");
}
try{
Connection con = DriverManager.getConnection( "jdbc:odbc:dbf" );//dbf为数据原名字
Statement st = con.createStatement();
ResultSet rs = st.executeQuery( "Select * from "+tableName);
while (rs.next()) {
String NUM1=rs.getString(1);
int NUM2=rs.getInt(2);
}
.......
读取时第一列就用getString(1);
