sql语句不会获取值，麻烦看看

我想输出满足username=username的id，该怎么输出

while(rs111.next()){
int id = rs.getInt("id");
System.out.println("id:"+id);
}???

拼接sql语句啊，需要传什么就传什么。

 //查询语句
String username = "";
String sql = "select id from test where username='" + username + "'";

//获取结果
rs.getString("id");

String id = resultSet.getString(1);

Or

String id = resultSet.getString("id");

String id = resultSet.getString(1);

//获取结果
String id = rs.getString("id");
System.out.println(id);

tring id = resultSet.getString(1);

.....
 String sql111 = “SELECT id FROM test WHERE username = '”+ username + "'";
 ......
 ResultSet rs111= rst111.excuteQuery(sql1111);
 While(rs111.next()){
     int id = rs111.getInt("id");
     System.out.println("id:"+id);
 }

大概这样吧

拼接sql语句就可以了，代码如下

String username = "";//这里赋上你想查询的username的值
String sql = "select id from test where username='"+username+"'";//这里被'"++"'包起来的username就是上面的

while(rs111.next()){
int id = rs.getInt("id");
System.out.println("id:"+id);
就是这样的啊

建议用预编译语句，这样有sql注入风险