一、什么是getString
String getString(int columnIndex)throws SQLException:
getString表示以 Java 编程语言中String的形式获取此 ResultSet对象的当前行中指定列的值。
参数:
columnIndex - 第一个列是 1,第二个列是 2,……
返回:
列值;如果值为 SQL NULL,则返回值为 null
抛出:
SQLException- 如果 columnIndex 无效;如果发生数据库访问错误或在已关闭的结果集上调用此方法
示例代码1:
public class aa {
String name, addr;
Customer cust;
Connection con = obtainConnection();
Statement stmt = con.createStatement();
ResultSet result = stmt.executeQuery(
"SELECT cust_name, address FROM Customer "
+ "WHERE ssn=" + "'" + id + "'");
if(result.next())
{
name = result.getString(1);
addr = result.getString(2);
cust = new Customer(id, name, addr);
}else
{
throw new BrokerException("用户" + id + "的信息没找到 :(");
}
return cust;
}
示例代码2:
public static void jsonArrayTest() {
JSONArray jsonarray = new JSONArray("[{'name':'xiazdong','age':20},{'name':'xzdong','age':15}]");
for (int i = 0; i < jsonarray.length(); i++) {
JSONObject jsonobj = jsonarray.getJSONObject(i);
String name = jsonobj.getString("name");
int age = jsonobj.getInt("age");
System.out.println("name = " + name + ",age = " + age);
}
}