日期:2014-05-18  浏览次数:20812 次

jsp中如何执行下列程序?急!
import   java.io.FileInputStream;
import   java.io.IOException;
import   java.sql.Connection;
import   java.sql.DriverManager;
import   java.sql.SQLException;
import   java.sql.Statement;

import   org.apache.poi.hssf.usermodel.HSSFCell;
import   org.apache.poi.hssf.usermodel.HSSFRow;
import   org.apache.poi.hssf.usermodel.HSSFSheet;
import   org.apache.poi.hssf.usermodel.HSSFWorkbook;
import   org.apache.poi.poifs.filesystem.POIFSFileSystem;

public   class   POITest   {
  private   static   Connection   conn   =   null;
  private   static   Statement   stmt   =   null;
  private   static   boolean   connectDB2()   {

    String   url   =   " ";
    String   username   =   "username ";
    String   password   =   "password ";

    //加载驱动程序以连接数据库
    try   {
      //添加类库驱动包db2jcc.jar和db2jcc_license_cu.jar
      Class.forName( "com.ibm.db2.jcc.DB2Driver ");
      url   =   "jdbc:db2://192.168.0.1:50000/dbname ";
      //添加类库驱动包db2java.jar
      //Class.forName( "com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
      //url   =   "jdbc:db2:njtcdata ";
      conn   =   DriverManager.getConnection(url,   username,   password);
      stmt   =   conn.createStatement();
    }
    //捕获加载驱动程序异常
    catch   (ClassNotFoundException   cnfex)   {
      System.err.println( "装载JDBC驱动程序失败。 ");
      cnfex.printStackTrace();
      return   false;
    }
    //捕获连接数据库异常
    catch   (SQLException   sqlex)   {
      System.err.println( "无法连接数据库 ");
      sqlex.printStackTrace();
      //System.exit(1);   //   terminate   program
      return   false;
    }
    return   true;
  }

  private   static   boolean   readExcelToDB2()   {
    POIFSFileSystem   fs   =   null;
    HSSFWorkbook   wb   =   null;
    try   {
      fs   =   new   POIFSFileSystem(new   FileInputStream( "c:\\test.xls "));
      wb   =   new   HSSFWorkbook(fs);
    }   catch   (IOException   e)   {
      e.printStackTrace();
      re