String sql = "SELECT * FROM Country where cid = \'"+cid+ "\'";
ResultSet rs = stat.executeQuery(sql);
while (rs.next())
{
String Name = rs.getString(2);
int Population = rs.getInt(3);
int Area = rs.getInt(4);
String Government = rs.getString(5);
String Capital = rs.getString(6);
float CapLatitude = rs.getFloat(7);
float CapLongitude = rs.getFloat(8);
ret = "CID" + "\t\t\t" + ":" +cid+"\n"
+"Name" + "\t\t\t" + ":" +Name+"\n"
+"Population" + "\t\t\t" + ":" + Population+"\n"
+"Area" + "\t\t\t" + ":" + Area+"\n"
+"Government" + "\t\t" + ":" + Government+"\n"
+"Capital" + "\t\t\t" + ":" + Capital+"\n"
+"CapLatitude" + "\t\t" + ":" + CapLatitude+"\n"
+"CapLongitude" + "\t\t" + ":" + CapLongitude;
}
rs.close();
ResultSet rs = stat.executeQuery(sql);
while (rs.next())
{
String Name = rs.getString(2);
int Population = rs.getInt(3);
int Area = rs.getInt(4);
String Government = rs.getString(5);
String Capital = rs.getString(6);
float CapLatitude = rs.getFloat(7);
float CapLongitude = rs.getFloat(8);
ret = "CID" + "\t\t\t" + ":" +cid+"\n"
+"Name" + "\t\t\t" + ":" +Name+"\n"
+"Population" + "\t\t\t" + ":" + Population+"\n"
+"Area" + "\t\t\t" + ":" + Area+"\n"
+"Government" + "\t\t" + ":" + Government+"\n"
+"Capital" + "\t\t\t" + ":" + Capital+"\n"
+"CapLatitude" + "\t\t" + ":" + CapLatitude+"\n"
+"CapLongitude" + "\t\t" + ":" + CapLongitude;
}
rs.close();
解决方案 »
- 关于strut2 标签中hidden的相关问题,求解~
- jsp调用ocx
- 在html下拉框中的option选项,如何动态添加,我是初学者,请大侠多多指点,谢谢阿,在线急等。
- 单选按钮的问题!怎么才能实现 没点中为灰色 选中的可以写东西拿??????
- 在网上找到一个JSP的发送邮件程序,自己稍作修改,但是运行出错,程序很短,达人帮忙看看
- 请教DispatchAction滴个问题
- JspSmartUpload下载报错getOutputStream() has already been called for this response
- 开发<定制画自助订购WEB应用系统> 哪位大神能帮帮忙?
- 请问如何将一个xml Document object转换为string?谢谢!
- 谁知道哪儿有jbuilder5下载
- TMD,反对用IE作庞大的function rich功能!!!
- 在论坛中怎样判断用户离开了呢?
我是想用过程或函数来调用啊!!