java读取mysql内容_读取数据库内容

[java]代码库import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

public class DMLReaderValues {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection connection = DriverManager

.getConnection("jdbc:odbc:practiceDatabase");

Statement statement = connection.createStatement();

ResultSet resultSet = statement

.executeQuery("select * from Catalog;");

ResultSetMetaData data = resultSet.getMetaData();

boolean b = resultSet.next();

while (b) {

for (int i = 1; i <= data.getColumnType(i); i++) {

System.out.print(resultSet.getString("编号")+""

+ resultSet.getString("名称")+""

+ resultSet.getString("年份")+""

+ resultSet.getString("在架")+""

+ resultSet.getString("作者")+""

+ resultSet.getString("总页数")+""

+ resultSet.getString("表演")+""

+ resultSet.getString("格式")+"");

b = resultSet.next();

}

System.out.println();

}

resultSet.close();

statement.close();

connection.close();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO: handle exception

System.out.println("SQLexception:" + e.getMessage());

}

}

}