自定义报表打印JSP源程序代码

package com.wsy; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class ConnDB{ protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;" + "DatabaseName=db_DefinedReport;SelectMethod=Cursor"; protected static String dbUser = "sa"; protected static String dbPwd = ""; protected static String second = null; private static Connection conn = null; Statement stmt=null; ResultSet rs=null; public ConnDB(){ try { if (conn == null) { Class.forName(dbClassName).newInstance(); conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd); } else return; } catch (Exception ee) { ee.printStackTrace(); } } public static ResultSet executeQuery(String sql) { try { if(conn==null) new ConnDB(); return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); return null; } finally { } } public static int executeUpdate(String sql) { try { if(conn==null) new ConnDB(); return conn.createStatement().executeUpdate(sql); } catch (SQLException e) { //.System.out.println(e.getMessage()); e.printStackTrace(); return -1; } finally { } } /*************************************************** *method name: close() *功能:关闭数据库链接 *return value: void ****************************************************/ public void close(){ try { if (rs != null) rs.close(); } catch (Exception e) { e.printStackTrace(System.err); }finally{} try { if (stmt != null) stmt.close(); } catch (Exception e) { e.printStackTrace(System.err); }finally{} try { if (conn != null) { conn.close(); } } catch (Exception e) { e.printStackTrace(System.err); }finally{} } public List getTablesType(){ List l=new ArrayList(); String sql="select * from tb_type"; try{ ConnDB conn=new ConnDB(); ResultSet rs=conn.executeQuery(sql); while(rs.next()){ GoodType goodType=new GoodType(); goodType.setID(rs.getInt(1)); goodType.setTypeName(rs.getString(2)); l.add(goodType); } }catch(Exception e){ e.printStackTrace(); } return l; } public static List getTables(int id){ List l=new ArrayList(); String sql="select * from tb_goods where typeId='"+id+"'"; try{ ConnDB conn=new ConnDB(); ResultSet rs=conn.executeQuery(sql); while(rs.next()){ Goods goods=new Goods(); goods.setId(String.valueOf(rs.getInt(1))); goods.setGoodsName(rs.getString("goodsName")); goods.setIntroduce(rs.getString("introduce")); goods.setPrice(rs.getString("price")); l.add(goods); } }catch(Exception e){ e.printStackTrace(); } return l; } public static List getColumns(String tablename){ List l=new ArrayList(); try{ ConnDB conn=new ConnDB(); DatabaseMetaData meta=conn.conn.getMetaData(); ResultSet rs=meta.getColumns(null, null, tablename,null); while(rs.next()){ l.add(rs.getString("COLUMN_NAME")); } }catch(Exception e){ e.printStackTrace(); } return l; } public static List getGoods(int page){ DownTable down=new DownTable(); List l=new ArrayList(); String sql="select top 6 * from tb_goods where id not in(select top "+down.getPageSize()*page+" id from tb_goods order by id)order by id"; try{ ConnDB conn=new ConnDB(); ResultSet rs=conn.executeQuery(sql); while(rs.next()){ Goods goods=new Goods(); goods.setId(rs.getString(1)); goods.setGoodsName(rs.getString(3)); goods.setIntroduce(rs.getString(4)); goods.setPrice(rs.getString(5)); l.add(goods); } }catch(Exception e){ e.printStackTrace(); } return l; } public static List getGoodsType(){ List l=new ArrayList(); String sql="select * from tb_type"; try{ ConnDB conn=new ConnDB(); ResultSet rs=conn.executeQuery(sql); while(rs.next()){ GoodType goodt=new GoodType(); goodt.setID(Integer.parseInt(rs.getString(1))); goodt.setTypeName(rs.getString(2)); l.add(goodt); } }catch(Exception e){ e.printStackTrace(); } return l; } public static List getOrders(){ List l=new ArrayList(); String sql="select * from tb_order"; try{ ConnDB conn=new ConnDB(); ResultSet rs=conn.executeQuery(sql); while(rs.next()){ Order order=new Order(); order.setOrderID(rs.getString(1)); order.setUsername(rs.getString(2)); order.setAddress(rs.getString(3)); order.setPostcode(rs.getString(4)); order.setTel(rs.getString(5)); order.setOrderDate(rs.getString(6)); l.add(order); } }catch(Exception e){ e.printStackTrace(); } return l; } public static void main(String[] args) { getColumns("tb_type"); } }