Question

求java查询时sql中的字段名

比如select a,b,c from d
结果是一条 1，2，3
我自己写的jdbc里面，怎么获取出a，b，c？

Answer 1

在java程序里，你要声明Connection, Statement, ResultSet，连接到数据库等
ResultSet resultset=statement.executeQuery("select a,b,c from d);
while (resultset.next()) {
String aa=resSelectForInsert.get.String(1);
String bb=resSelectForInsert.get.String(2);
String cc=resSelectForInsert.get.String(3);
System.out.println("output aa=:"+aa +" bb:="+bb +"cc:="+cc);
}

Answer 2

Statement stmt=con.createStatement();
ResultSet rs-stmt.executeQuery("select a,b,c from d");
while(rs.next())
{
类型 e=rs.get类型("a");
b c 类似
}