Question

java resultset 获取枚举型数据

mysql数据库中有枚举型的数据，那么resultset有没有哪个方法可以获取到枚举型数据的值？

Answer 1

楼上的。。mysql里有这种类型，是一种字符串类数据列类型
ENUM('value1','value2',...) 65535个成员 1或2字节
但是用的比较少。。。

你得写程序自己处理下，大概是下边这样

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class EnumTesting {
Connection connection;

Statement statement;

public EnumTesting() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager
.getConnection("jdbc:mysql://192.168.1.25/test?user=spider&password=spider");
} catch (Exception e) {
System.err.println("Unable to find and load driver");
System.exit(1);
}
}

public void doWork() {
try {
statement = connection.createStatement();
ResultSet rs = statement
.executeQuery("SHOW COLUMNS FROM enumtest LIKE 'status'");

rs.next();
String enums = rs.getString("Type");
System.out.println(enums);
int position = 0, count = 0;
String[] availableEnums = new String[10];

while ((position = enums.indexOf("'", position)) > 0) {
int secondPosition = enums.indexOf("'", position + 1);
availableEnums[count++] = enums.substring(position + 1,
secondPosition);

position = secondPosition + 1;
System.out.println(availableEnums[count - 1]);
}

rs.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}

public static void main(String[] args) {
Enum e = new Enum();
e.doWork();
}
}

Answer 2

如下面所示。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class EnumTesting {
Connection connection;

Statement statement;

public EnumTesting() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager
.getConnection("jdbc:mysql://192.168.1.25/test?user=spider&password=spider");
} catch (Exception e) {
System.err.println("Unable to find and load driver");
System.exit(1);
}
}

public void doWork() {
try {
statement = connection.createStatement();
ResultSet rs = statement
.executeQuery("SHOW COLUMNS FROM enumtest LIKE 'status'");

rs.next();
String enums = rs.getString("Type");
System.out.println(enums);
int position = 0, count = 0;
String[] availableEnums = new String[10];

while ((position = enums.indexOf("'", position)) > 0) {
int secondPosition = enums.indexOf("'", position + 1);
availableEnums[count++] = enums.substring(position + 1,
secondPosition);

position = secondPosition + 1;
System.out.println(availableEnums[count - 1]);
}

rs.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}

public static void main(String[] args) {
Enum e = new Enum();
e.doWork();
}
}

Answer 3

数据库中枚举类型的数据长什么样。。。。

没见过。。。