mysql类型转换java_将Mysql的数据类型转换为Java程序

在ResultSetMetaData上使用getColumnTypeName()。

一个例子是：

public class getColumnDataTypes

{

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

{

String driver = "com.mysql.jdbc.Driver";

String connString = "jdbc:mysql://localhost:3300/DATABASE,USERNAME,PASSWORD";

Class.forName(driver);

Connection connection = DriverManager.getConnection(connString);

Statement statement = connection.createStatement();

//Query

ResultSet resultSet = statement.executeQuery("SELCET * FROM table");

ResultSetMetaData rsmd = resultSet.getMetaDate();

//Get number of columns returned

int numOfCols = rsmd.getColumnCount();

//Print out type for each column

for(int i=1; i<=numOfCols; ++i)

{

System.out.println("Column [" + i + "] data type: " + rsmd.getColumnTypeName(i));

}

//Close DB connection

statement.close();

connection.close();

}

}