jsp控制excel

/* package database; import java.sql.*; public class dbbean { private Connection con; private ResultSet rs; public static Connection getConnection() throws SQLException { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); return null; } return DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=UserInfo","sa","12345678"); } public ResultSet executeQuery(String sql) { try { con = dbbean.getConnection(); Statement statement = con.createStatement(); rs = statement.executeQuery(sql); } catch(SQLException ex) { } return rs; } public int executeUpdate(String sql) { int count = 0; Statement stmt = null; try { con = dbbean.getConnection(); stmt = con.createStatement(); count = stmt.executeUpdate(sql); } catch(SQLException ex) { } finally { try { if(stmt != null) stmt.close(); if(con != null) con.close(); } catch(SQLException ex) { System.err.print(ex); } } return count; } public void freeRs(ResultSet rs) { try { if(rs != null) { rs.close(); con.close(); } } catch(Exception e) { } } } */ package database; import java.sql.*; public class dbbean { private Connection con; private ResultSet rs; public static Connection getConnection() throws SQLException { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); return null; } return DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=UserInfo","sa","12345678"); } public ResultSet executeQuery(String sql) { try { con = dbbean.getConnection(); Statement statement = con.createStatement(); rs = statement.executeQuery(sql); } catch(SQLException ex) { } return rs; } public int executeUpdate(String sql) { int count = 0; Statement stmt = null; try { con = dbbean.getConnection(); stmt = con.createStatement(); count = stmt.executeUpdate(sql); } catch(SQLException ex) { ex.printStackTrace(); } finally { try { if(stmt != null) stmt.close(); if(con != null) con.close(); } catch(SQLException ex) { System.err.print(ex); } } return count; } public void freeRs(ResultSet rs) { try { if(rs != null) { rs.close(); con.close(); } } catch(Exception e) { } } }