java.lang.Object
com.rsi.ipstat.DBManager
- public class DBManager
- extends java.lang.Object
|
Field Summary |
(package private) static PoolManager |
poolManager
|
|
Method Summary |
static boolean |
checkIP(java.lang.String ip,
int id)
|
static boolean |
checkPort(java.lang.String name,
int pid)
|
static boolean |
checkUser(java.lang.String user,
int id)
|
static PortTable |
getPortByID(int pid)
|
static int |
getPortCount()
|
static PortTable |
getPortList()
|
static PortTable |
getPortShortList()
|
static UserStat |
getSummaryStat(java.lang.String user,
java.lang.String time,
java.lang.String str,
int port)
|
static UserStat |
getSummaryStat(java.lang.String user,
java.lang.String from_time,
java.lang.String till_time,
java.lang.String str,
int port)
|
static java.lang.String |
getUser(java.lang.String user,
java.lang.String passwd)
|
static UserTable |
getUserByID(int id)
|
static int |
getUserCount()
|
static UserTable |
getUserList()
|
static UserTable |
getUserShortList()
|
static UserStat |
getUserStat(java.lang.String user,
java.lang.String time,
int port)
|
static UserStat |
getUserStatByDay(java.lang.String user,
java.lang.String time,
int port)
|
static UserStat |
getUserStatByDay(java.lang.String user,
java.lang.String from_time,
java.lang.String till_time,
int port)
|
static MaxSum |
getUserStatMax(java.lang.String user,
java.lang.String time,
int port)
|
static boolean |
portAdd(PortTable port)
|
static boolean |
portDelete(int pid)
|
static boolean |
portUpdate(PortTable port)
|
static boolean |
userAdd(UserTable usr)
|
static boolean |
userDelete(java.lang.String user)
|
static boolean |
userUpdate(UserTable usr)
|
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
poolManager
static PoolManager poolManager
DBManager
public DBManager()
getUserStat
public static UserStat getUserStat(java.lang.String user,
java.lang.String time,
int port)
getUserStatByDay
public static UserStat getUserStatByDay(java.lang.String user,
java.lang.String time,
int port)
getUserStatByDay
public static UserStat getUserStatByDay(java.lang.String user,
java.lang.String from_time,
java.lang.String till_time,
int port)
getUserStatMax
public static MaxSum getUserStatMax(java.lang.String user,
java.lang.String time,
int port)
getSummaryStat
public static UserStat getSummaryStat(java.lang.String user,
java.lang.String time,
java.lang.String str,
int port)
getSummaryStat
public static UserStat getSummaryStat(java.lang.String user,
java.lang.String from_time,
java.lang.String till_time,
java.lang.String str,
int port)
userAdd
public static boolean userAdd(UserTable usr)
userUpdate
public static boolean userUpdate(UserTable usr)
userDelete
public static boolean userDelete(java.lang.String user)
getUser
public static java.lang.String getUser(java.lang.String user,
java.lang.String passwd)
checkUser
public static boolean checkUser(java.lang.String user,
int id)
checkIP
public static boolean checkIP(java.lang.String ip,
int id)
getUserByID
public static UserTable getUserByID(int id)
getUserList
public static UserTable getUserList()
getUserShortList
public static UserTable getUserShortList()
getUserCount
public static int getUserCount()
portAdd
public static boolean portAdd(PortTable port)
portUpdate
public static boolean portUpdate(PortTable port)
portDelete
public static boolean portDelete(int pid)
checkPort
public static boolean checkPort(java.lang.String name,
int pid)
getPortByID
public static PortTable getPortByID(int pid)
getPortList
public static PortTable getPortList()
getPortShortList
public static PortTable getPortShortList()
getPortCount
public static int getPortCount()