【Java开源代码栏目提醒】:网学会员,鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“ConnectExcel.java”一文,供大家参考学习!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ConnectExcel {
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//杩炴帴Excel鏁版嵁婧?
Connection con = DriverManager.getConnection("jdbc:odbc:employee", "", "");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from [Sheet1$]");// 鑾峰彇宸ヤ綔琛ㄤ腑鐨勬暟鎹?
// //鏄剧ず鏌ヨ缁撴灉
while(rs.next()){
System.out.print("\t濮撳悕锛? + rs.getString(1));
System.out.print("\t骞撮緞锛? + rs.getString(2));
System.out.print("\t鑱屽姟锛? + rs.getString("鑱屽姟"));
System.out.println();
}
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}