mysql 列名不显示_MySQL报列名找不到错误

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

public class MysqlTest {

/**

* @param args

*/

public static void main(String[] args) throws Exception {

Class.forName("com.mysql.jdbc.Driver");

//String url="jdbc:mysql://localhost:3306/mydb?user=******&password=******&useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false";

String url="jdbc:mysql://localhost:3306/mydb?user=******&password=******&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false";

Connection conn = DriverManager.getConnection(url);

PreparedStatement stmt = conn.prepareStatement("select id as myid,name as myname from test");

ResultSet rs = stmt.executeQuery();

ResultSetMetaData rsmd = rs.getMetaData();

String c1 = rsmd.getColumnName(1);

String c2 = rsmd.getColumnName(2);

while(rs.next()){

String id = rs.getString(c1);//报列名找不到异常

String name = rs.getString(c2);

System.out.println(id+"|"+name);

}

System.out.println(conn);

rs.close();

stmt.close();

conn.close();

}

}

Exception in thread "main" java.sql.SQLException: Column ‘id‘ not found.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)

at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1073)

at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5212)

at com.bill99.mysql.MysqlTest.main(MysqlTest.java:25)

解决办法：

JDBC URL中增加useOldAliasMetadataBehavior=true参数

原文：http://my.oschina.net/u/1274122/blog/503631