sheetdatasource.java

在java中实现的excel导出功能。这也是一个很好的例子。

package src.com.jp.or.cheng.excel;

import java.sql.*;

public class SheetDataSource {

 private static Connection con ;
 
 private static final String DatabaseName = "POIDEMO";
 
 private static final String userName = "sa";
 
 private static final String password = "123";
 
 public SheetDataSource()
 {
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   try {
     con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName="+DatabaseName,userName,password);
   } catch (SQLException e) {
    e.printStackTrace();
   }
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
 }
 
 public static ResultSet selectAllDataFromDB() throws SQLException 
 { 
   new SheetDataSource();
   Statement stmt = con.createStatement();
   return stmt.executeQuery("select * from COMPANY");
 }
 
}