?? firstservlet.java
字號:
/**
* 輸出XML響應的servlet
*/
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.xml.XML;
public class FirstServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private XML xml = new XML() ;
public FirstServlet() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//*************在數(shù)據(jù)庫中取出數(shù)據(jù)****************//
ResultSet result = null ;
Connection con = null ;
Statement stmt = null ;
try {
xml.init() ;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
//*********建立數(shù)據(jù)庫 名為flex*************//
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=flex" ;
//**********換上你自己的用戶名和密碼信息************//
con = DriverManager.getConnection(url, "sa", "sa") ;
stmt = con.createStatement() ;
//**********里面建表名為USERS 具體SQL語句見附件下載**********//
result = stmt.executeQuery("select * from USERS") ;
} catch(Exception e) {
e.printStackTrace() ;
}
//重要:設置響應格式為XML格式
response.setContentType("text/xml") ;
response.setCharacterEncoding("UTF-8") ;
PrintWriter out = response.getWriter() ;
try {
while(result.next()) {
String[] strs = new String[3] ;
strs[0] = result.getString("name") ;
strs[1] = result.getString("pwd") ;
strs[2] = result.getString("school") ;
//*****創(chuàng)建XMLdocument*******//
xml.create(strs) ;
}
result.close() ;
stmt.close() ;
con.close() ;
//*******寫XML文件到客戶端********//
xml.output(out) ;
} catch (Exception e) {
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response) ;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -