java 检索数据_java如何从数据库中检索数据

我有代码

public static String getData(String query) {

String output = "";

try {

String connectionUrl = "jdbc:sqlserver://localhost:1234;databaseName=123;user=123;password=123";

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con = DriverManager.getConnection(connectionUrl);

String SQL = "select smth from tableName where smth";

stmt = con.createStatement();

rs = stmt.executeQuery(query);

while (rs.next()) {

output = (String) rs.getObject(1);

}

rs.close();

}

catch (Exception e) {

return "ERROR while retrieving data: " + e.getMessage();

}

return output;

}

如果value是string,它可以工作.但如果它是整数？还是布尔？如何修改这个方法,以便它是通用的,无论我得到什么类型的数据,我仍然将其作为字符串返回？