获取mysql内容，生成xml文件，并且以webservice形式发送

[html]  view plain copy

1.   

[html]  view plain copy

1. <xyt>  
2.   
3.           <news id>  
4.                 <url></url>  
5.                 <title></title>  

[html]  view plain copy

1. </news>  
2. t;  

其实是三个知识点综合到一起的，包括如何访问mysql，如何生成xml文件，如何使用进行webservice开发

好了，话不多说，直接粘代码

[java]  view plain copy

1. package com.service;  
2.   
3. import java.io.FileOutputStream;  
4. import java.io.IOException;  
5. import java.sql.*;  
6.   
7. import org.jdom.*;  
8. import org.jdom.output.XMLOutputter;  
9.   
10. public class NewsImpl implements NewsInterface{  
11.   
12.       
13.     public String GetNews(int StartPage, int EndPage)   
14.     {  
15.         // 创建根节点 list;  
16.         Element root = new Element("xyt");  
17.         
18.        // 根节点添加到文档中；  
19.         Document Doc = new Document(root);  
20.          
21.         Connection conn = null;  
22.         Statement stmt = null ;  
23.        // 此处 for 循环可替换成 遍历 数据库表的结果集操作;  
24.         try {  
25.             Class.forName("org.gjt.mm.mysql.Driver").newInstance();  
26.              String url_connect ="jdbc:mysql://localhost/nxu_life?user=root&password=12345&useUnicode=true&characterEncoding=gb2312";  
27.   
28.                 //first为你的数据库名  
29.                 try {  
30.                     conn = DriverManager.getConnection(url_connect);  
31.                 } catch (SQLException e0) {  
32.                     // TODO Auto-generated catch block  
33.                     e0.printStackTrace();  
34.                 }  
35.   
36.                   
37.                 try {  
38.                     stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);  
39.                 } catch (SQLException e00) {  
40.                     // TODO Auto-generated catch block  
41.                     e00.printStackTrace();  
42.                 }  
43.   
44.                 String sql="select page_id,title,url,publishtime,page,department from news where page_id>="+StartPage+" and page_id<="+EndPage;  
45.   
46.                 try {  
47.                     ResultSet rs=stmt.executeQuery(sql);  
48.                      while(rs.next()){  
49.                            String page_id=rs.getString("page_id");  
50.                            String title=rs.getString("title");  
51.                            String url=rs.getString("url");  
52.                            String publishtime=rs.getString("publishtime");  
53.                            String page=rs.getString("page");  
54.                            String department=rs.getString("department");  
55.                            // 创建节点 user;  
56.                            Element elements = new Element("news");  
57.                            // 给 user 节点添加属性 id;  
58.                            elements.setAttribute("id",page_id);  
59.                             
60.                            // 给 user 节点添加子节点并赋值；  
61.                            // new Element("name")中的 "name" 替换成表中相应字段，setText("xuehui")中 "xuehui 替换成表中记录值；  
62.                            elements.addContent(new Element("url").setText(url));  
63.                            elements.addContent(new Element("title").setText(title));  
64.                            elements.addContent(new Element("publishtime").setText(publishtime));  
65.                            elements.addContent(new Element("page").setText(page));  
66.                            elements.addContent(new Element("department").setText(department));  
67.                            // 给父节点list添加user子节点;  
68.                            root.addContent(elements);  
69.                    
70.                        }  
71.                 } catch (SQLException e) {  
72.                     // TODO Auto-generated catch block  
73.                     e.printStackTrace();  
74.                 }  
75.   
76.         } catch (InstantiationException e1) {  
77.             // TODO Auto-generated catch block  
78.             e1.printStackTrace();  
79.         } catch (IllegalAccessException e2) {  
80.             // TODO Auto-generated catch block  
81.             e2.printStackTrace();  
82.         } catch (ClassNotFoundException e3) {  
83.             // TODO Auto-generated catch block  
84.             e3.printStackTrace();  
85.         }  
86.   
87.          
88.        
89.         XMLOutputter XMLOut = new XMLOutputter();  
90.         String XMLString =XMLOut.outputString(Doc);  
91.         return XMLString;  
92.         //System.out.println( XMLString);  
93.     }  
94. }