62,614
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
public class DisplayAuthors
{
// database URL
static final String DATABASE_URL = "jdbc:mysql://localhost/books";
// launch the application
public static void main( String args[] )
{
Connection connection = null; // manages connection
Statement statement = null; // query statement
ResultSet resultSet = null; // manages results
// connect to database books and query database
try
{
// establish connection to database
connection = DriverManager.getConnection(
DATABASE_URL, "javafp", "javafp" );
// create Statement for querying database
statement = connection.createStatement();
// query database
resultSet = statement.executeQuery(
"SELECT authorID, firstName, lastName FROM authors" );
// process query results
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println( "Authors Table of Books Database:\n" );
for ( int i = 1; i <= numberOfColumns; i++ )
System.out.printf( "%-8s\t", metaData.getColumnName( i ) );
System.out.println();
while ( resultSet.next() )
{
for ( int i = 1; i <= numberOfColumns; i++ )
System.out.printf( "%-8s\t", resultSet.getObject( i ) );
System.out.println();
} // end while
} // end try
catch ( SQLException sqlException )
{
sqlException.printStackTrace();
} // end catch
finally // ensure resultSet, statement and connection are closed
{
try
{
resultSet.close();
statement.close();
connection.close();
} // end try
catch ( Exception exception )
{
exception.printStackTrace();
} // end catch
} // end finally
} // end main
} // end class DisplayAuthors
unzip -l mysql-connector-java-5.1.13-bin.jar | grep META
0 06-23-10 17:38 META-INF/
2182 06-23-10 17:38 META-INF/MANIFEST.MF
0 06-23-10 17:38 META-INF/services/
21 06-23-10 17:38 META-INF/services/java.sql.Driver
463 06-23-10 17:38 META-INF/INDEX.LIST
public static void main( String args[] )
{
Connection connection = null; // manages connection
Statement statement = null; // query statement
ResultSet resultSet = null; // manages results
// connect to database books and query database
try
{
//--------------华丽的分割线--------------
Class.forName("com.mysql.jdbc.Driver");
// establish connection to database
connection = DriverManager.getConnection(
DATABASE_URL, "javafp", "javafp" );
// create Statement for querying database
statement = connection.createStatement();
// query database
resultSet = statement.executeQuery(
"SELECT authorID, firstName, lastName FROM authors" );
......