Installation guide
40
public static void releaseConnection( Connection c)
{
if(c != null)
{
try
{
c.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
Appendix-6
CREATE TABLE userinfor
(
username character varying(20) NOT NULL,
passwords character varying(20) NOT NULL,
reportlat double precision,
reportlon double precision
)
INSERT INTO userinfor (username, passwords, reportlat, reportlon)
VALUES
('groupx', 123456, 0, 0)
Appendix-7
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<title>Traffic Hub Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />