createtable_sql.java

linux 网络监控 。主要是对Linux系统的网络数据进行监控。

package main.tool;

import java.util.ArrayList;
import java.util.List;

/**
 * 建表语句类
 * 2009-3-31
 * @author		zhengguohua
 * @version	1.0
 * @since		JDK1.6(建议) 
 * @author Administrator
 *
 */
public class CreateTable_SQL {
	
	// --删除数据库
	public static String dropDataBase(String DBName){
		return"drop database  if exists "+DBName;
	}
	
	//--创建数据库
	public static String createDataBase(String DBName,String character){
		return "create database if not exists "+DBName+" default character set "+character;
	}
	
	//--创建用户表
	public static String createUsers(){
		return "create table users  ("+
				"user_id int(10),"+		//-- 用户id
				"user_type int(10),"+		//-- 用户类型
				"user_name varchar(32),"+		//-- 用户名
				"login_name varchar(20) unique,"+		//-- 登陆名
				"login_password varchar(32),"+		//-- 登陆密码
				"primary key(user_id)"+	
				");";
	}
	
	//--初始化用户表
	public static List<String> initUsers(){
		List<String> sql_list = new ArrayList<String>();
		sql_list.add("insert into users values(1,1,'admin','admin','admin');");
		sql_list.add("insert into users values(2,2,'tarena','tarena','tarena');");
		return sql_list;
	}
	
	//--创建采集原始记录表
	public static String createDetails(int n){
		return "create table details_"+n+" ("+
				"loginname	varchar(20) ,"+		//-- 登录名
				"loginip	varchar(24),"+		//-- 登录ip
				"logindate	timestamp,"+		//-- 登录时间
				"logoutdate	timestamp,"+		//-- 退出时间
				"labip		varchar(24),"+		//-- 实验室ip
				"duration	long"+				//-- 登录时长
				");";
	}
	
	//--创建采集整合表[天表]
	public static String createDetailDays(int n){
		return "create table detaildays_"+n+"("+
	          	"loginname	varchar(20) ,"+		//-- 登录名
	          	"loginip		varchar(24),"+	//-- 登录ip
	          	"logouttime	timestamp,"+		//-- 登出时间
	          	"labip		varchar(24),"+		//-- 实验室ip
	          	"duration	long,"+				//-- 登录时长
	          	"primary key (loginname, labip, logouttime,loginip)"+
	          	");";
	}
	
	//--创建采集整合表[月表]
	public static String createDetailMonths(int n){
		return "create table detailmonths_"+n+" ("+
			  	"loginname	varchar(20),"+		//-- 用户名
			  	"loginip		varchar(24),"+	//-- 用户登录ip
			  	"logouttime	timestamp,"+		//-- 统计日期（格式：yyyy-mm--dd 00:00:00）
			  	"labip		varchar(24),"+		//-- 服务器ip
			  	"duration	long,"+				//-- 时长
			  	"primary key(loginname, 	labip, 	logouttime)"+
			  	");";
	}
	//--创建采集整合表[年表]
	public static String createDetailYears(int n){
		return "create table detailyears_"+n+" ("+
    			"loginname	varchar(20),"+		//-- 登录名
    			"loginip		varchar(24),"+	//-- 登录ip
    			"logouttime	timestamp,"+		//-- 整合时间
    			"labip		varchar(24),"+		//-- 实验室ip
    			"duration	long,"+				//-- 登录时长
    			"primary key(loginname, labip, logouttime)"+
    			");";
	}
	
	//--创建按IP整合表[日]
	public static String createDetailDays(){
		return "create table detaildays ("+
				"logouttime	timestamp,"+	//-- 整合时间
				"labip		varchar(24),"+	//-- 实验室ip
				"duration	long,"+			//-- 登录时长
				"primary key(labip, logouttime)"+
				");";
	}
	
	//--创建按IP整合表[月]
	public static String createDetailMonths(){
		return "create table detailmonths("+
				"logouttime	timestamp,"+	//-- 整合时间
				"labip		varchar(24),"+	//-- 实验室ip
				"duration	long,"+			//-- 登录时长
				"primary key(labip, logouttime)"+
				");";
	}
	
	//--创建按IP整合表[年]
	public static String createDetailYears(){
		return "create table detailyears("+
				"logouttime	timestamp,"+	//-- 整合时间
				"labip		varchar(24),"+	//-- 实验室ip
				"duration	long,"+			//-- 登录时长
				"primary key(labip, logouttime)"+
				");";
	}
}