private void initCreateUserinfoSchma() throws SQLException {
  ResultSet rs;
  rs=stmt.executeQuery("show tables from test like'userinformation'");
  if (false == rs.next()) {
    String sql="CREATE TABLE userinformation " + "(id varchar(10) not NULL, " + " password VARCHAR(10) not Null, "+ " PRIMARY KEY ( id )) Engine=Innodb default charset = utf8";
    stmt.executeUpdate(sql);
  }
  rs=stmt.executeQuery("show tables from test like'useripandaccess'");
  if (false == rs.next()) {
    String sql="CREATE TABLE useripandaccess " + "(id varchar(10) not NULL, " + "ipaddress varchar(30) not NULL, "+ "accessAndTerminateTime datetime not null,"+ "type varchar(10)"+ ") Engine=Innodb default charset = utf8";
    stmt.executeUpdate(sql);
  }
}

private void initCreateUserinfoSchma ( ) throws SQLException { ResultSet rs ; rs = stmt . executeQuery ( "show tables from test like'userinformation'" ) ; if ( false == rs . next ( ) ) { String sql = "CREATE TABLE userinformation " + "(id varchar(10) not NULL, " + " password VARCHAR(10) not Null, " + " PRIMARY KEY ( id )) Engine=Innodb default charset = utf8" ; stmt . executeUpdate ( sql ) ; } rs = stmt . executeQuery ( "show tables from test like'useripandaccess'" ) ; if ( false == rs . next ( ) ) { String sql = "CREATE TABLE useripandaccess " + "(id varchar(10) not NULL, " + "ipaddress varchar(30) not NULL, " + "accessAndTerminateTime datetime not null," + "type varchar(10)" + ") Engine=Innodb default charset = utf8" ; stmt . executeUpdate ( sql ) ; } }
int database system scema for gameplayer
