📄 closeconnection.java
字号:
package servlet;import java.io.File;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.jatools.core.ZReportDocument;import com.jatools.data.rs.sql.ZSqlReader;public class CloseConnection extends HttpServlet { static final private String CONTENT_TYPE = "text/html; charset=GBK"; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); try { ZReportDocument doc = ZReportDocument.load(new File("./templates/table.xml")) ; ZSqlReader reader =(ZSqlReader) doc.getReader() ; java.sql.Statement st = reader.getConnection().getConnection().createStatement() ; st.execute("SHUTDOWN") ; st.close() ; reader.getConnection().getConnection().close() ; } catch (Exception ex) { throw new ServletException(ex); } PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>CloseConnection</title></head>"); out.println("<body>"); out.println("<p>ok!</p>"); out.println("</body></html>"); } //Clean up resources public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -