我正在尝试与MySQL数据库建立连接,但是当我使用PreparedStatement
时,Eclipse返回Set project JRE build path entry to 'JavaSE-1.7'
是的,我将编译器版本更改为1.7,但是Android仅适用于1.5和1.6,对吗?如何连接到我的数据库?这是我连接的实际方法:
private ArrayList<String> sql = new ArrayList<String>();
private Connection con;
public String getUsuario(String...parametros) throws SQLException {
sql.add("SELECT "+parametros[1]+"FROM users WHERE `usuario_id` = "+parametros[0]+";");
for (String string : sql) {
try (PreparedStatement stm = con.prepareStatement(string);
ResultSet rs = stm.executeQuery()) {
while(rs.next()) {
System.out.println(rs.getString("usuario_senha"));
}
}
}
return "";
}
您正在使用Java7中引入的try-with-resources
语法。您需要将其更改为Java 6。您可以做这样的事情:
PreparedStatement stm = null;
ResultSet rs = null;
for (String string : sql) {
try {
stm = con.prepareStatement(string);
rs = stm.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("usuario_senha"));
}
} finally {
if (rs != null) {
rs.close();
}
if (stm != null) {
stm.close();
}
}
}