mstandarddatabaseutil.java

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

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

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

public class MStandardDatabaseUtil
implements MDatabaseUtil
{
//--------------------------------------------------------------------------------
public boolean tableExists( Connection connection )
throws SQLException
{
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables( null, null, "TSTATE", null );
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  varchar( 256 ), paramName varchar( 256 ), paramValue varchar( 512 ), userAgent varchar( 512 ) )";
MSqlUtil.executeUpdate( connection, queryString );
	
	// create index
queryString = "create index tIndex on tState( t )";
MSqlUtil.executeUpdate( connection, queryString );
}
//--------------------------------------------------------------------------------
}