[转]通过jdbc-odbc桥来访问excel文件? stmnt con.createStatement() }catch(Exception e){ Syste
[转]通过jdbc-odbc桥来访问excel文件
?
stmnt = con.createStatement();
}catch(Exception e){
System.out.println("con is error!!");
e.printStackTrace();
}
}
/**
* 读取excel文件内容
* @param
*/
public void getResult(){
try {
ResultSet rs = stmnt.executeQuery("SELECT * FROM [Sheet1$]");
//获得列的总数
ResultSetMetaData RSMD = rs.getMetaData();
int rowCount = RSMD.getColumnCount();
//获得和打印记录
System.out.println( "查得的记录为:");
while( rs.next() ) {
for (int i = 1;i <= rowCount;i++){
System.out.print(rs.getString(i)+", ");
}
System.out.println(" ");
}
}
catch( SQLException e ) {
System.out.println("get is error!!");
e.printStackTrace();
}
}
/**
* 向excel文件写入内容
* @param
*/ /*
public void setPar(){
try{
int result =
stmnt.executeUpdate("insert into [sheet1$] values ('marry',21,'English','women','teacher')");
System.out.println("result is : "+result);
}catch(SQLException e ){
System.out.println("Set is error!!");
e.printStackTrace();
}
}*/
/**
* 测试函数
* @param
*/
public static void main(String[] args) {
handleExcel TestHpc = new handleExcel();
//TestHpc.setPar();
TestHpc.getResult();
}
}?
来源：http://www.wangchao.net.cn/bbsdetail_70665.html
