/**
*该程序用来测试JDBC和MySQL连接
*/
package test;

import java.sql.*;

public class QueryJDBC
{
static
{
try
{
//驱动和odbc不同

Class.forName ( "org.gjt.mm.mysql.Driver" );
System.out.println ( "success loading mysql Driver...." );
} catch ( Exception e )
{
System.out.println ( "Error loading mysql Driver....." );
e.printStackTrace ( );
}
}

/**
* @param args
*/
public static void main ( String agrs[] )
{
try
{
//连接参数与Access不同

String url = "jdbc:mysql://localhost/LearnJSP";
//建立连接

Connection con = DriverManager.getConnection ( url, "root", "011124" );
//建立发送SQL命令的Statement对象

Statement stmt = con.createStatement ( );
//返回查询结果

ResultSet rs = stmt.executeQuery ( "select * from userinfo" );

ResultSetMetaData md = rs.getMetaData ( );

int col = md.getColumnCount ( );
for ( int i = 1; i <= col; i++ )
{
System.out.println ( md.getColumnName ( i ) + "/t" );
}
while ( rs.next ( ) )
{
String strData = "";
for ( int i = 1; i <= col; i++ )
{
strData = strData + rs.getString ( i ) + "/t";
}
System.out.println ( strData );
}
//断开Connection连接

rs.close();
stmt.close();
con.close ( );
} catch ( SQLException e )
{
e.printStackTrace ( );
}
}

}