import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TEST
{
public static String Find(String a)
{
String result="";
int B_id = Integer.parseInt(a);
try
{
System.out.println("1");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("2");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.32.20.105:1521:orcl","system","admin");
System.out.println("3");
Statement stmt = conn.createStatement();
System.out.println("4");
ResultSet rs = stmt.executeQuery("select id,name from B_org where id='"+B_id+"'");
System.out.println("5");
while(rs.next())
{
int b = rs.getInt("id");
//int b = rs.getInt("org_parent_id");
//String x = Integer.toString(a);
String y = Integer.toString(b);
String z = rs.getString("name");
result =y+" "+z;
//String result =rs.getInt(org_level)+" "+rs.getString(org_name)+" "+rs.getInt(org_prent_id);
System.out.print(result);
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("wrong");
}
return result;
}
public static void main(String args[])
{
int b = 1;
System.out.println(TEST.Find(Integer.toString(b)));
}
}
========================================================================
运行结果是1 2 3 4 wrong
我是初学者,本想输出数据表中数据列,求助高手解决问题。
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TEST
{
public static String Find(String a)
{
String result="";
int B_id = Integer.parseInt(a);
try
{
System.out.println("1");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("2");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.32.20.105:1521:orcl","system","admin");
System.out.println("3");
Statement stmt = conn.createStatement();
System.out.println("4");
ResultSet rs = stmt.executeQuery("select id,name from B_org where id='"+B_id+"'");
System.out.println("5");
while(rs.next())
{
int b = rs.getInt("id");
//int b = rs.getInt("org_parent_id");
//String x = Integer.toString(a);
String y = Integer.toString(b);
String z = rs.getString("name");
result =y+" "+z;
//String result =rs.getInt(org_level)+" "+rs.getString(org_name)+" "+rs.getInt(org_prent_id);
System.out.print(result);
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("wrong");
}
return result;
}
public static void main(String args[])
{
int b = 1;
System.out.println(TEST.Find(Integer.toString(b)));
}
}
========================================================================
运行结果是1 2 3 4 wrong
我是初学者,本想输出数据表中数据列,求助高手解决问题。
楼主【stream_li】截止到2008-07-08 17:32:15的历史汇总数据(不包括此帖):
发帖的总数量:0 发帖的总分数:0 每贴平均分数:0
回帖的总数量:0 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:0 未结的总分数:0
结贴的百分比:---------------------结分的百分比:---------------------
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
at oracle.jdbc.driver.OracleSql.main(OracleSql.java:1667)
应该是这个异常
{
int b = rs.getInt("id");
String y = Integer.toString(b);
String z = rs.getString("name");
result =y+" "+z;
//String result =rs.getInt(org_level)+" "+rs.getString(org_name)+" "+rs.getInt(org_prent_id);
System.out.print(result);
} 应该是这里的问题。
试试 rs.getInt(1);
刚没看到 System.out.println("5"); SORRY~~!!