posts - 41,  comments - 40,  trackbacks - 0

import java.io.FileWriter;
import java.io.IOException;
import java.io.BufferedWriter;

import java.awt.Toolkit;

import java.sql.Types;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;

import javax.swing.JOptionPane;


final class GetSQLServerType
{
  private Connection        connection;
  private Statement         statement;
  private ResultSet         resultSet;
  private ResultSetMetaData metaData;

  public GetSQLServerType()
  {
    try{ //实例化MSSQL2000的驱动
         Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );

         //连接数据库
         connection=DriverManager.getConnection( "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind", "sa", "" );

         //创建Statement接口对象
         statement=connection.createStatement();

         resultSet=statement.executeQuery( " SELECT * FROM SQLServerType " );

         metaData=resultSet.getMetaData();

         int columnCount=metaData.getColumnCount();

         FileWriter fw=new FileWriter( "SQLServerType.htm" );
         BufferedWriter bfw=new BufferedWriter( fw );

         bfw.write( "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=GBK\">" ); bfw.newLine();
         bfw.write( "<title>SQL Server数据类型对应Java类型</title>" ); bfw.newLine();

         //申明样式表//////////////////////////////////////////
         bfw.write( "<style type=text/css>" ); bfw.newLine();
         bfw.write( "td{ color:          #000000;" ); bfw.newLine();
         bfw.write( "    background:     #FFFFFF;" ); bfw.newLine();
         bfw.write( "    height:         20px;" ); bfw.newLine();
         bfw.write( "    font-size:      10pt;" ); bfw.newLine();
         bfw.write( "    font-weight:    normal;" ); bfw.newLine();
         bfw.write( "    font-family:    宋体;" ); bfw.newLine();
         bfw.write( "    text-align:     right;" ); bfw.newLine();
         bfw.write( "    vertical-align: middle;" ); bfw.newLine();
         bfw.write( "    table-layout:   fixed;" ); bfw.newLine();
         bfw.write( "    padding-top:    2;" ); bfw.newLine();
         bfw.write( "    padding-bottom: 2;" ); bfw.newLine();
         bfw.write( "    padding-left:   2;" ); bfw.newLine();
         bfw.write( "    padding-right:  2;" ); bfw.newLine();
         bfw.write( "  }" ); bfw.newLine();
         bfw.write( "td.left{ text-align: left; }" ); bfw.newLine();
         bfw.write( "td.center{ text-align: center; }" ); bfw.newLine();
         bfw.write( "</style>" ); bfw.newLine();

         bfw.write( "<body>" ); bfw.newLine();
         bfw.write( "<table border=1 bordercolor=#000000 cellspacing=0 style=\"border-collapse:collapse\">" );bfw.newLine();
         bfw.write( "  <tr>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnClassName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnLabel( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getCatalogName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnCount()</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnDisplaySize( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnType( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getColumnTypeName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getPrecision( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getScale( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getSchemaName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.getTableName( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isAutoIncrement( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isCaseSensitive( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isCurrency( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isDefinitelyWritable( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isNullable( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isReadOnly( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isSearchable( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isSigned( column )</td>" );bfw.newLine();
         bfw.write( "    <td noWrap class=center>metaData.isWritable( column )</td>" );bfw.newLine();
         bfw.write( "  </tr>" );bfw.newLine();

         for( int column=0; column<columnCount; column++ )
            {
              /*/
              //metaData的所有方法
              bfw.write( "metaData.getColumnCount() "                         + metaData.getColumnCount() );bfw.newLine();
              bfw.write( "metaData.isAutoIncrement( "+( column+1 )+" ) "      + metaData.isAutoIncrement( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isCaseSensitive( "+( column+1 )+" ) "      + metaData.isCaseSensitive( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isSearchable( "+( column+1 )+" ) "         + metaData.isSearchable( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isCurrency( "+( column+1 )+" ) "           + metaData.isCurrency( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isNullable( "+( column+1 )+" ) "           + metaData.isNullable( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isSigned( "+( column+1 )+" ) "             + metaData.isSigned( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnDisplaySize( "+( column+1 )+" ) " + metaData.getColumnDisplaySize( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnLabel( "+( column+1 )+" ) "       + metaData.getColumnLabel( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnName( "+( column+1 )+" ) "        + metaData.getColumnName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getSchemaName( "+( column+1 )+" ) "        + metaData.getSchemaName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getPrecision( "+( column+1 )+" ) "         + metaData.getPrecision( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getScale( "+( column+1 )+" ) "             + metaData.getScale( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getTableName( "+( column+1 )+" ) "         + metaData.getTableName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getCatalogName( "+( column+1 )+" ) "       + metaData.getCatalogName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnType( "+( column+1 )+" ) "        + metaData.getColumnType( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnTypeName( "+( column+1 )+" ) "    + metaData.getColumnTypeName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isReadOnly( "+( column+1 )+" ) "           + metaData.isReadOnly( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isWritable( "+( column+1 )+" ) "           + metaData.isWritable( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isDefinitelyWritable( "+( column+1 )+" ) " + metaData.isDefinitelyWritable( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.getColumnClassName( "+( column+1 )+" ) "   + metaData.getColumnClassName( ( column+1 ) ) );bfw.newLine();
              bfw.write( "metaData.isSigned( "+( column+1 )+" ) "             + metaData.isSigned( ( column+1 ) ) );bfw.newLine();
              bfw.write( "--------------------------------------------------------------------------------" );bfw.newLine();
              //*/

              bfw.write( "  <tr>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnClassName( column+1 )   +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnLabel( column+1 )       +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getCatalogName( column+1 )       +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnCount()                 +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnDisplaySize( column+1 ) +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnName( column+1 )        +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnType( column+1 )        +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getColumnTypeName( column+1 )    +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getPrecision( column+1 )         +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getScale( column+1 )             +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getSchemaName( column+1 )        +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.getTableName( column+1 )         +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isAutoIncrement( column+1 )      +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isCaseSensitive( column+1 )      +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isCurrency( column+1 )           +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isDefinitelyWritable( column+1 ) +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isNullable( column+1 )           +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isReadOnly( column+1 )           +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isSearchable( column+1 )         +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isSigned( column+1 )             +"</td>" );bfw.newLine();
              bfw.write( "    <td noWrap class=center>"+metaData.isWritable( column+1 )           +"</td>" );bfw.newLine();
              bfw.write( "  </tr>" );bfw.newLine();
            }

         bfw.write( "</table>" );bfw.newLine();
         bfw.write( "</body>" ); bfw.newLine();

         bfw.flush();
         fw.close();
       }
    catch( IOException ioe )
         {
           Toolkit.getDefaultToolkit().beep();
           JOptionPane.showMessageDialog( null, "创建文件失败!", "创建文件错误", JOptionPane.WARNING_MESSAGE );
           System.out.println( ioe );
         }
    catch( ClassNotFoundException cnfe )
         {
           Toolkit.getDefaultToolkit().beep();
           JOptionPane.showMessageDialog( null, "找不到数据库驱动文件!", "数据库错误", JOptionPane.WARNING_MESSAGE );
           System.out.println( cnfe );
         }
    catch( SQLException se )
         {
           Toolkit.getDefaultToolkit().beep();
           JOptionPane.showMessageDialog( null, "连接数据库失败!请检查数据库是否运行。", "数据库错误", JOptionPane.WARNING_MESSAGE );
           System.out.println( se );
         }
    finally{ try{ if( resultSet!=null )
                    {
                      resultSet.close();  //关闭ResultSet接口实例
                    }

                  if( statement!=null )
                    {
                      statement.close();  //关闭Statement接口实例
                    }

                  if( connection!=null )
                    {
                      connection.close();  //关闭Connection接口实例
                    }
                }
             catch( SQLException se )
                  {
                    System.out.println( se );
                  }
           }
  }

  public static void main( String[] arg )
  {
    GetSQLServerType g=new GetSQLServerType();
  }
}

posted on 2007-07-03 04:03 NeedJava 阅读(360) 评论(0)  编辑  收藏 所属分类: Java

只有注册用户登录后才能发表评论。


网站导航: