mmysqlutil.java

来自「httptunnel.jar httptunnel java 源码」· Java 代码 · 共 33 行

package net.jumperz.app.MGuardian.plugin.sessionIdManager2;

import java.sql.*;
import net.jumperz.sql.*;

public class MMySqlUtil
implements MDatabaseUtil
{
//--------------------------------------------------------------------------------
public boolean tableExists( Connection connection )
throws SQLException
{
String queryString =
"SHOW TABLES LIKE 'tState'";
ResultSet rs = MSqlUtil.executeQuery( connection, queryString );
boolean tableExists = rs.next();
rs.close();
return tableExists;
}
//--------------------------------------------------------------------------------
public void createTable( Connection connection )
throws SQLException
{
	// create table
String queryString = "create table tState ( t  timestamp, ip  varchar( 15 ), host  text, paramName text, paramValue text, userAgent text )";
MSqlUtil.executeUpdate( connection, queryString );
	
	// create index
queryString = "create index tIndex on tState( t )";
MSqlUtil.executeUpdate( connection, queryString );
}
//--------------------------------------------------------------------------------	
}