为什么连不上Oracle? HKGVRU.APAC.FEDEX.COM 这个改成数据库的 SID 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 HKGVRU.APAC.FEDEX.COM 改成数据库名 thanks ,刚才找他重新要了一份数据库列表。这个问题解决了。现在第二个问题, try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@155.161.166.69:1521:TPEVRU"; String user = "tpevru"; String password = "vru123"; Connection cnn = DriverManager.getConnection(url, user, password); PreparedStatement ps = cnn.prepareStatement("select * from report_summary_day where report_day = '20050909'"); ResultSet rs = ps.executeQuery(); while (rs.next()) { System.out.println(rs.getString("REPORT_DAY") + "," + rs.getString("REPORT_ID") + "," + rs.getString("COUNT_FIRST") + "," + rs.getString("COUNT_ALL") + "," + rs.getString("SECOND_ALL")); } rs.close(); ps.close(); cnn.close(); } catch (Exception ex) { ex.printStackTrace(); }我直接打开SQL/Plus输入SQL语句是可以看到有数据的,可是这样就得不到,这又是什么问题啊? 抱歉,这个问题还是存在,他给的数据库连接是Oracle下的,C:\oracle\ora92\network\ADMIN\tnsnames.ora,里面内容如下:HKGVRU.APAC.FEDEX.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 155.161.185.242)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = hkgvru) ) )它里面的数据库名称是HKGVRU吗?可为什么我在cmd中输入tnsping HKGVRU不行,全部输入tnsping HKGVRU.APAC.FEDEX.COM就可以呢? 对不起,我错了,那么大一个SERVICE_NAME我都没看到,这个错误实在太..........我都不好说什么了,快点结帖,希望看到的人不多。^_^多谢两位了 急!高分求java复杂对象到json的转换 servlet下的.java文件在tomcat下webinfo/classesa中根本没有怎么办 大家帮忙看看,servlets问题 hibernate开发工具求教 为什么ActionForm获取为空 刚开始接触java,想做web开发,大家说该学些什么东西? 高分请教:WEB文件夹的权限管理 为什么Servlet生成的随机数图片显示不出来? 关于自定义包 如何在applet中实现网页的过渡 求救:有个JSP不能执行,只是改了名字就OK了,但是改回来又不OK了,到底问题出在哪里? 为何数据不能插入?
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@155.161.166.69:1521:TPEVRU";
String user = "tpevru";
String password = "vru123"; Connection cnn = DriverManager.getConnection(url, user, password);
PreparedStatement ps = cnn.prepareStatement("select * from report_summary_day where report_day = '20050909'");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("REPORT_DAY") + "," +
rs.getString("REPORT_ID") + "," +
rs.getString("COUNT_FIRST") +
"," + rs.getString("COUNT_ALL") + "," +
rs.getString("SECOND_ALL"));
}
rs.close();
ps.close();
cnn.close(); }
catch (Exception ex) {
ex.printStackTrace();
}我直接打开SQL/Plus输入SQL语句是可以看到有数据的,可是这样就得不到,这又是什么问题啊?
HKGVRU.APAC.FEDEX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 155.161.185.242)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hkgvru)
)
)它里面的数据库名称是HKGVRU吗?可为什么我在cmd中输入tnsping HKGVRU不行,全部输入tnsping HKGVRU.APAC.FEDEX.COM就可以呢?