📄 show.java
字号:
package ajax;
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 java.util.*;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.postgresql.geometric.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Show extends HttpServlet {
/**
* Constructor of the object.
*/
public Show() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Vector vDate=new Vector();
response.setContentType("text/xml");//设置返回数据类型为xml格式
java.io.PrintWriter out=response.getWriter();
try
{
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/gis" ;
Connection con = DriverManager.getConnection(url, "postgres" , "123456" );
Statement st = con.createStatement();
String sql = "select *,astext(the_geom) as geom from device";
System.out.println("sdflkjklafj");
ResultSet rs = st.executeQuery(sql);
Device dev;
while (rs.next())
{
dev=new Device();
dev.setGid(rs.getInt("gid"));
dev.setDeviceid(rs.getLong("deviceid"));
dev.setName(rs.getString("name"));
dev.setGbcode(rs.getLong("gbcode"));
dev.setLevel(rs.getInt("level"));
dev.setType(rs.getString("type"));
dev.setIp(rs.getString("ip"));
dev.setMask(rs.getString("mask"));
dev.setMac(rs.getString("mac"));
dev.setLon(rs.getFloat("longitude"));
dev.setLat(rs.getFloat("latitude"));
dev.setParentid(rs.getString("pareantid"));
dev.setStatus(rs.getInt("status"));
dev.setDescription(rs.getString("descriptio"));
dev.setText_geom(rs.getString("geom"));
// PGpoint p=new PGpoint();
// p.setValue(rs.getString("geom"));
// dev.setThe_geom(p);
vDate.add(dev);//把数据库中的数据添加到向量中
// System.out.println(rs.getInt("gid"));
// System.out.println(rs.getString("geom"));
}
out.print(parasToXML(vDate));
rs.close();
st.close();
con.close();
}
catch (Exception ee)
{
System.out.print(ee.getMessage());
}
/*
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the POST method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();*/
}
public String parasToXML (Vector v)
{
Document document = DocumentHelper.createDocument();
document.setXMLEncoding("UTF-8");
Element topElt = document.addElement("device");
//StringBuffer buf=new StringBuffer();
//buf.append("<?xml version=\"1.0\"encoding=\"utf-8\"?>");
//buf.append("<device>");
for(int i=0;i<v.size();i++)
{
Device dev=(Device)v.get(i);
String a=dev.getText_geom().substring(dev.getText_geom().indexOf('(')+1, dev.getText_geom().indexOf(' '));
String b=dev.getText_geom().substring(dev.getText_geom().indexOf(' ')+1, dev.getText_geom().indexOf(')'));
topElt.addElement("item");
Element lon=topElt.addElement("long");
Element lat=topElt.addElement("lat");
lon.addText(a);
lat.addText(b);
System.out.print(lon.getText());
/*
buf.append("<item>");
buf.append("<id>"+dev.getDeviceid()+"</id>");
buf.append("<long>"+a+"</long>");
buf.append("<lat>"+b+"</lat>");
//buf.append("<location>"+dev.getThe_geom()+"</location>");
buf.append("</item>");*/
}
//buf.append("<device>");
return document.asXML();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -