java报表两个示例

package sava; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.servlet.http.HttpServletRequest; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.Node; import org.w3c.dom.NodeList; public class Savadata { private HttpServletRequest request; public Savadata(){ } //构造函数 public Savadata(HttpServletRequest request){ this.request = request; } // public String process(){ try{ String returnValue = ""; DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); DocumentBuilder builder = factory.newDocumentBuilder(); InputStream in = request.getInputStream(); String str = ""; File file = new File("d:\\tem.tmp"); if(!file.exists()) file.createNewFile(); //xml数据写入file OutputStream out = new FileOutputStream(file); byte[] buffer = new byte[1000]; int index = -1; while((index = in.read(buffer))!= -1) { out.write(buffer,0,index); } out.close(); //xml数据写入file结束,xml数据存入file中在通过builder解析成功! Document doc = builder.parse(file); //下面是取出doc的內容 Element element1 = doc.getDocumentElement(); String data = ""; //data里实际保存就是客户端发送的数据 NodeList list = element1.getElementsByTagName("Cell_Content"); for(int i = 0 ; i < list.getLength() ; i++){ Node node = list.item(i); returnValue = node.getNodeName()+"\t:\t"+node.getTextContent(); data = node.getTextContent(); //在这里对data数据进行Split } //连接Access数据库! String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\java\\workspace\\mydb2.mdb"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn=DriverManager.getConnection(strurl) ; Statement stmt=conn.createStatement(); String [] arr=data.split("!"); //组织Sql语句,执行插入操作. String sql=""; for(int i=0;i<arr.length;i++) { String [] arr2=arr[i].split(","); sql = "insert into test values("; for ( int j=0; j<arr2.length; j ++ ) { sql +="'"+arr2[j] + "'"; if ( j < arr2.length - 1 ) sql += ","; } sql += ")"; stmt.execute(sql); } stmt.close(); conn.close(); }catch(Exception e){ e.printStackTrace();//异常! } return null; } }