用JAVA连接ORACLE数据库查询不到数据

2010-04-12 12:31:15 830 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Oracle数据库db.prorerties配置文件以及数据库连接工具类 db.properties的配置文件： driver=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@127.0.0.1:1521:XE username=u08 password=u08 工具类 private static String driver; private static String url 阅读详情

程序源代码如下：
package conn;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class CConnOracle {
/**
* @param args
*/
public static void main(String[] args) {
try {
int iStuId = 0;
String sStuName = null;
String sStuClass = null;
String strSql = "select col_stu_id, col_stu_name, col_stu_class from table_student";
Connection objConn = null;

Driver objDriver = (Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

Properties objProp = new Properties();
objProp.put("user", "tester");
objProp.put("password", "tester");

objConn = objDriver.connect("jdbc:oracle:thin:@127.0.0.1:1521:testdb", objProp);
objConn.setAutoCommit(false);

PreparedStatement objStmt = objConn.prepareStatement(strSql,
ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

ResultSet objRS = objStmt.executeQuery();
while(objRS.next())
{
iStuId = objRS.getInt("col_stu_id");
sStuName = objRS.getString("col_stu_name");
sStuClass = objRS.getString("col_stu_class");
System.out.println(iStuId + "---" + sStuName + "---" + sStuClass);
}

if(null != objRS)
{
objRS.close();
}
if(null != objStmt)
{
objStmt.close();
}
if(null != objConn)
{
objConn.close();
}
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

问题：查询不到结果，单步跟踪，发现执行到while时未进入循环体

说明：初学JAVA，尝试了一下，但是失败了，求解！

...全文

Java连接Oracle数据库的示例代码最基本的Oracle数据库连接代码（只针对Oracle11g）： 1、右键项目->构建路径->配置构建路径，选择第三项“库”，然后点击“添加外部Jar”，选择“D:\Oracle\app\oracle\product\11.2.0\server \jdbc\lib\ojdbc6_g.jar”（注：D:\Oracle为数据库的安装路径）。 2、以下代码为非常标准的Oracle数据库连... 阅读详情

gaohaibox

Eclipse 58,439 成员 49,457 内容

+ 关注 + 加入社区

切换为时间正序

gaohaibox 2010-04-12

打赏
举报

我发现一个现象：我把我那段代码放到同事机器上可以查询到数据，在我的机器上就没有，是不是跟我的机器的配置有关系？？？

soooooga 2010-04-12

打赏
举报



import java.sql.*;



public class JDBCExample {



	public static void main(String[] args) {

		String driver = "oracle.jdbc.driver.OracleDriver";

		String url = "jdbc:oracle:thin:@127.0.0.1:1521:testdb";

		String sql = "select col_stu_id, col_stu_name, col_stu_class from table_student";

		String username = "tester";

		String password = "tester";

		int iStuId = 0;

		String sStuName = null;

		String sStuClass = null;

		try {

			Class.forName(driver);

			// new oracle.jdbc.driver.OracleDriver();

			Connection con = DriverManager.getConnection(url, username,

					password);

			PreparedStatement pstmt = con.prepareStatement(sql);

			ResultSet rs = pstmt.executeQuery();

			while (rs.next()) {

				iStuId = objRS.getInt("col_stu_id");

				sStuName = objRS.getString("col_stu_name");

				sStuClass = objRS.getString("col_stu_class");

				System.out.println(iStuId + "---" + sStuName + "---" + sStuClass);

			}

			rs.close();

			pstmt.close();

			con.close();

		} catch (ClassNotFoundException e) {

			e.printStackTrace();

		} catch (SQLException e) {

			e.printStackTrace();

		}

	}



}