java jdbc 命名参数_JDBC中的命名参数 (Named parameters in JDBC)

To avoid including a large framework, I think a simple homemade class can do the trick.

Example of class to handle named parameters:

public class NamedParamStatement {

public NamedParamStatement(Connection conn, String sql) throws SQLException {

int pos;

while((pos = sql.indexOf(":")) != -1) {

int end = sql.substring(pos).indexOf(" ");

if (end == -1)

end = sql.length();

else

end += pos;

fields.add(sql.substring(pos+1,end));

sql = sql.substring(0, pos) + "?" + sql.substring(end);

}

prepStmt = conn.prepareStatement(sql);

}

public PreparedStatement getPreparedStatement() {

return prepStmt;

}

public ResultSet executeQuery() throws SQLException {

return prepStmt.executeQuery();

}

public void close() throws SQLException {

prepStmt.close();

}

public void setInt(String name, int value) throws SQLException {

prepStmt.setInt(getIndex(name), value);

}

private int getIndex(String name) {

return fields.indexOf(name)+1;

}

private PreparedStatement prepStmt;

private List fields = new ArrayList();

}

Example of calling the class:

String sql;

sql = "SELECT id, Name, Age, TS FROM TestTable WHERE Age < :age OR id = :id";

NamedParamStatement stmt = new NamedParamStatement(conn, sql);

stmt.setInt("age", 35);

stmt.setInt("id", 2);

ResultSet rs = stmt.executeQuery();

Please note that the above simple example does not handle using named parameter twice. Nor does it handle using the : sign inside quotes.