public static void authenticate(String username, String password) {
Logger.info("Attempting to authenticate with " + username + ":" + password);
Admin admin = Admin.findByUsername(username);
if ((admin != null) && (admin.checkPassword(password) == true)) {
Logger.info("Successfull authentication of " + admin.username);
/**
* wanted to put an extra value in session - logged_in_adminid to distinguish an admin, as a
* user could be logged in and type the route for admin URLs and get into the restricted
* access areas. By putting a new value in session, it can only be set if an admin is logged
* in.
*/
session.put("logged_in_adminid", admin.id);
/**
* if login successful, communicate back to AJAX call in adminlogin.js and that will handle
* the next screen
*/
JSONObject obj = new JSONObject();
String value = "correct";
obj.put("inputdata", value);
renderJSON(obj);
} else {
/**
* if login unsuccessful, communicate back to AJAX call in adminlogin.js and that will
* redisplay login.html with error
*/
Logger.info("Authentication failed");
JSONObject obj = new JSONObject();
String value = "Error: Incorrect Email/Password entered.";
obj.put("inputdata", value);
renderJSON(obj);
}
}
public boolean tableExists(String tableName) {
try {
Admin admin = connection.getAdmin();
return admin.tableExists(TableName.valueOf(tableName));
} catch (IOException e) {
e.printStackTrace();
}
return false;
}
public void createTable(String tableName, List<String> columnFamilies) {
try {
Admin admin = connection.getAdmin();
HTableDescriptor descriptor = new HTableDescriptor(TableName.valueOf(tableName));
for (String family : columnFamilies) {
descriptor.addFamily(new HColumnDescriptor(family));
}
admin.createTable(descriptor);
} catch (IOException e) {
e.printStackTrace();
}
}
public boolean removeTable(String tableName) {
try {
Admin admin = connection.getAdmin();
TableName t = TableName.valueOf(tableName);
if (admin.tableExists(t)) {
admin.disableTable(t);
admin.deleteTable(t);
return true;
}
} catch (IOException e) {
e.printStackTrace();
}
return false;
}
public static Admin getCurrentAdmin() {
/**
* get currently logged in admin for Candidate (CandidateController.java) + Office
* (OfficeController.java) constructors via new logged_in_adminid written to session on admin
* login
*/
String adminId = session.get("logged_in_adminid");
if (adminId == null) {
return null;
}
Admin logged_in_admin = Admin.findById(Long.parseLong(adminId));
Logger.info("In Admin controller: Logged in admin is " + logged_in_admin.username);
return logged_in_admin;
}
public void printStats() throws IOException {
Admin admin = connection.getAdmin();
ClusterStatus status =
admin.getClusterStatus(); // co ClusterStatusExample-1-GetStatus Get the cluster status.
System.out.println("Cluster Status:\n--------------");
System.out.println("HBase Version: " + status.getHBaseVersion());
System.out.println("Version: " + status.getVersion());
System.out.println("Cluster ID: " + status.getClusterId());
System.out.println("Master: " + status.getMaster());
System.out.println("No. Backup Masters: " + status.getBackupMastersSize());
System.out.println("Backup Masters: " + status.getBackupMasters());
System.out.println("No. Live Servers: " + status.getServersSize());
System.out.println("Servers: " + status.getServers());
System.out.println("No. Dead Servers: " + status.getDeadServers());
System.out.println("Dead Servers: " + status.getDeadServerNames());
System.out.println("No. Regions: " + status.getRegionsCount());
System.out.println("Regions in Transition: " + status.getRegionsInTransition());
System.out.println("No. Requests: " + status.getRequestsCount());
System.out.println("Avg Load: " + status.getAverageLoad());
System.out.println("Balancer On: " + status.getBalancerOn());
System.out.println("Is Balancer On: " + status.isBalancerOn());
System.out.println("Master Coprocessors: " + Arrays.asList(status.getMasterCoprocessors()));
System.out.println("\nServer Info:\n--------------");
for (ServerName server :
status
.getServers()) { // co ClusterStatusExample-2-ServerInfo Iterate over the included
// server instances.
System.out.println("Hostname: " + server.getHostname());
System.out.println("Host and Port: " + server.getHostAndPort());
System.out.println("Server Name: " + server.getServerName());
System.out.println("RPC Port: " + server.getPort());
System.out.println("Start Code: " + server.getStartcode());
ServerLoad load =
status.getLoad(
server); // co ClusterStatusExample-3-ServerLoad Retrieve the load details for the
// current server.
System.out.println("\nServer Load:\n--------------");
System.out.println("Info Port: " + load.getInfoServerPort());
System.out.println("Load: " + load.getLoad());
System.out.println("Max Heap (MB): " + load.getMaxHeapMB());
System.out.println("Used Heap (MB): " + load.getUsedHeapMB());
System.out.println("Memstore Size (MB): " + load.getMemstoreSizeInMB());
System.out.println("No. Regions: " + load.getNumberOfRegions());
System.out.println("No. Requests: " + load.getNumberOfRequests());
System.out.println("Total No. Requests: " + load.getTotalNumberOfRequests());
System.out.println("No. Requests per Sec: " + load.getRequestsPerSecond());
System.out.println("No. Read Requests: " + load.getReadRequestsCount());
System.out.println("No. Write Requests: " + load.getWriteRequestsCount());
System.out.println("No. Stores: " + load.getStores());
System.out.println("Store Size Uncompressed (MB): " + load.getStoreUncompressedSizeMB());
System.out.println("No. Storefiles: " + load.getStorefiles());
System.out.println("Storefile Size (MB): " + load.getStorefileSizeInMB());
System.out.println("Storefile Index Size (MB): " + load.getStorefileIndexSizeInMB());
System.out.println("Root Index Size: " + load.getRootIndexSizeKB());
System.out.println("Total Bloom Size: " + load.getTotalStaticBloomSizeKB());
System.out.println("Total Index Size: " + load.getTotalStaticIndexSizeKB());
System.out.println("Current Compacted Cells: " + load.getCurrentCompactedKVs());
System.out.println("Total Compacting Cells: " + load.getTotalCompactingKVs());
System.out.println("Coprocessors1: " + Arrays.asList(load.getRegionServerCoprocessors()));
System.out.println("Coprocessors2: " + Arrays.asList(load.getRsCoprocessors()));
System.out.println("Replication Load Sink: " + load.getReplicationLoadSink());
System.out.println("Replication Load Source: " + load.getReplicationLoadSourceList());
System.out.println("\nRegion Load:\n--------------");
for (Map.Entry<byte[], RegionLoad>
entry : // co ClusterStatusExample-4-Regions Iterate over the region details of the
// current server.
load.getRegionsLoad().entrySet()) {
System.out.println("Region: " + Bytes.toStringBinary(entry.getKey()));
RegionLoad regionLoad =
entry
.getValue(); // co ClusterStatusExample-5-RegionLoad Get the load details for the
// current region.
System.out.println("Name: " + Bytes.toStringBinary(regionLoad.getName()));
System.out.println("Name (as String): " + regionLoad.getNameAsString());
System.out.println("No. Requests: " + regionLoad.getRequestsCount());
System.out.println("No. Read Requests: " + regionLoad.getReadRequestsCount());
System.out.println("No. Write Requests: " + regionLoad.getWriteRequestsCount());
System.out.println("No. Stores: " + regionLoad.getStores());
System.out.println("No. Storefiles: " + regionLoad.getStorefiles());
System.out.println("Data Locality: " + regionLoad.getDataLocality());
System.out.println("Storefile Size (MB): " + regionLoad.getStorefileSizeMB());
System.out.println("Storefile Index Size (MB): " + regionLoad.getStorefileIndexSizeMB());
System.out.println("Memstore Size (MB): " + regionLoad.getMemStoreSizeMB());
System.out.println("Root Index Size: " + regionLoad.getRootIndexSizeKB());
System.out.println("Total Bloom Size: " + regionLoad.getTotalStaticBloomSizeKB());
System.out.println("Total Index Size: " + regionLoad.getTotalStaticIndexSizeKB());
System.out.println("Current Compacted Cells: " + regionLoad.getCurrentCompactedKVs());
System.out.println("Total Compacting Cells: " + regionLoad.getTotalCompactingKVs());
System.out.println();
}
}
}
public static void yearQuarterGeneralAverage(String value) {
Admin.reports(value, 3);
}
public static void subjectsGradePerQuarter(String subject) {
Admin.reports(subject, 2);
}
public static void generalAveragePerQuarter(int studentId) {
Admin.reports(String.valueOf(studentId), 1);
}
public static void uploadFile(String filename, File file) {
User user = User.find("byEmail", Security.connected()).first();
Upload uploadObj = new Upload();
uploadObj.UploadFile(filename, user, file);
Admin.upload();
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final java.lang.String _jspx_method = request.getMethod();
if (!"GET".equals(_jspx_method)
&& !"POST".equals(_jspx_method)
&& !"HEAD".equals(_jspx_method)
&& !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) {
response.sendError(
HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD");
return;
}
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
response.setContentType("text/html; charset=UTF-8");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("\r\n");
out.write(
"<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n");
out.write("<title>공지사항</title>\r\n");
out.write(
"<link href=\"http://netdna.bootstrapcdn.com/bootstrap/2.3.2/css/bootstrap.min.css\" rel=\"stylesheet\">\r\n");
out.write("<style>\r\n");
out.write("\t thead tr { background: #eee; }\r\n");
out.write("\t tbody tr:hover { background-color: #DAD9FF; cursor: pointer; }\r\n");
out.write("</style>\r\n");
out.write("\r\n");
out.write(
"<script src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\r\n");
out.write("<script>\r\n");
out.write("\t$(function(){\r\n");
out.write("\t\t $(\"tbody tr\").click(function(){\r\n");
out.write("\t\t\t location.href=\"adminContent.jsp?idx=\"+$(this).attr(\"data-id\");\r\n");
out.write("\t\t });\r\n");
out.write("\t});\r\n");
out.write("</script>\r\n");
out.write("</head>\r\n");
int id;
id = (int) session.getAttribute("id");
System.out.println(id);
// 해당 학번=id(세션) 값으로 정보를 불러온다.
User user = Register.selectDetail(id);
ArrayList<Admin> list = AdminPage.selectAll();
String cmd = request.getParameter("cmd");
if (request.getMethod().equals("POST")) {
if (cmd.equals("logout")) {
session.invalidate();
out.write("\r\n");
out.write("\t\t\t\t<script>\r\n");
out.write("\t\t\t\t\talert(\"로그아웃 되었습니다\");\r\n");
out.write("\t\t\t\t\tlocation.href=\"login.jsp\";\r\n");
out.write("\t\t\t\t</script>\r\n");
out.write("\t\t\t");
}
}
out.write("\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write("<div>\r\n");
out.write("\t<form method=\"post\">\r\n");
out.write(
"\t\t<button class=\"btn btn-small\" name=\"cmd\" value=\"logout\">로그 아웃</button>\r\n");
out.write("\t</form>\r\n");
out.write("</div>\r\n");
out.write("<div class=\"container\">\r\n");
out.write("\t<h2>공지사항 게시판</h2><hr/>\r\n");
out.write("\t<form>\r\n");
out.write("\t\t<table class=\"table table-condensed table-bordered\">\r\n");
out.write("\t\t\t<thead>\r\n");
out.write(" \t\t<tr>\r\n");
out.write(" \t\t\t<th>번호</th>\r\n");
out.write(" \t\t\t<th>제목</th>\r\n");
out.write(" \t\t\t<th>작성자</th>\r\n");
out.write(" \t\t</tr>\r\n");
out.write(" \t</thead>\r\n");
out.write(" \t<tbody>\r\n");
out.write("\t\t\t");
for (Admin admin : list) {
out.write("\r\n");
out.write("\t\t\t<tr data-id=\"");
out.print(admin.getIdx());
out.write("\">\r\n");
out.write(" \t\t\t<td>");
out.print(admin.getIdx());
out.write("</td>\r\n");
out.write(" \t\t\t<td>");
out.print(admin.getTitle());
out.write("</td>\r\n");
out.write(" \t\t\t<td>");
out.print(admin.getName());
out.write("</td>\r\n");
out.write(" \t\t</tr>\r\n");
out.write(" \t\t");
}
out.write("\r\n");
out.write(" \t</tbody>\r\n");
out.write("\t\t</table>\r\n");
out.write("\t\t\r\n");
out.write("\t\t");
if (user.getLevel() == 2 || user.getLevel() == 3) {
out.write("\r\n");
out.write("\t\t<div>\r\n");
out.write("\t\t\t<a href=\"adminWrite.jsp\" class=\"btn btn-small\">글쓰기</a>\r\n");
out.write("\t\t</div>\r\n");
out.write("\t\t");
}
out.write("\r\n");
out.write("\t</form>\r\n");
out.write("\t</div>\r\n");
out.write("</body>\r\n");
out.write("</html>");
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
if (response.isCommitted()) {
out.flush();
} else {
out.clearBuffer();
}
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public static List<KeyValue> getAllTrainInfo(Configuration config, String date) {
List<KeyValue> result = new ArrayList<>();
String strJson = null;
BufferedWriter writer = null;
Table table = null;
try (Connection connect = ConnectionFactory.createConnection(config);
Admin admin = connect.getAdmin()) {
TableName tablename = TableName.valueOf(TABLE_NAME);
if (!admin.tableExists(tablename)) {
System.out.println("Table does not exist.");
return null;
}
table = connect.getTable(tablename);
Put put = null;
String start = null;
String end = null;
writer = new BufferedWriter(new FileWriter(new File(strConfig), true));
for (KeyValue item : lstAllProcessStation) {
start = (String) item.getKey();
end = (String) item.getValue();
try {
try {
Thread.sleep(200);
} catch (InterruptedException e1) {
e1.printStackTrace();
}
System.out.println("process : " + start + ":" + end);
strJson = getFromAPIX(mapStationCode.get(start), mapStationCode.get(end), date);
writer.write(start + ":" + end);
writer.newLine();
} catch (Exception e) {
System.out.println(start + ":" + end + "error");
e.printStackTrace();
break;
}
JSONObject jo = new JSONObject(strJson);
if (jo.has("httpstatus") && (jo.getInt("httpstatus") == 200)) {
JSONObject joData = jo.getJSONObject("data");
if (joData.has("flag") && joData.getBoolean("flag")) {
result.add(new DefaultKeyValue(start, end));
// 插入到hbase
String rowkey = start + ":" + end;
put = new Put(rowkey.getBytes());
put.addColumn(
CF_JSON.getBytes(), "json".getBytes(), joData.toString().getBytes("utf-8"));
table.put(put);
System.out.println("start " + start + "\t end " + end + "\t has ticket");
}
}
}
} catch (IOException e) {
e.printStackTrace();
} finally {
if (writer != null) {
try {
writer.flush();
writer.close();
} catch (IOException e) {
e.printStackTrace();
}
}
if (table != null) {
try {
table.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
return result;
}