初学java,请教各位大侠:
出错信息:
返回的conn值:oracle.jdbc.driver.T4CConnection@1be5d1
java.sql.SQLException: 对只转发结果集的无效操作: last
at oracle.jdbc.driver.BaseResultSet.last(BaseResultSet.java:98)
at jdbc_oracle.getConnection(jdbc_oracle.java:27)
at jdbc_oracle.main(jdbc_oracle.java:52)
连接fail
返回的值:null----------------------
源代码:
//import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.Date;public class jdbc_oracle {
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("oracle.jdbc.OracleDriver");
String url="jdbc:oracle:thin:@10.4.9.11:1521:orcl";
String user="ty";
String password="a123";
PreparedStatement pstm = null;
try {
conn = DriverManager.getConnection(url,user,password);
System.out.println("返回的conn值:"+conn);
String sql = "select * from t_import_log";
pstm =conn.prepareStatement(sql);
//pstm =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = pstm.executeQuery();
rs.last();
int rowcount = rs.getRow();
System.out.println("jy_import_log:"+rowcount);
return conn; } catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return null;
}
public static void main(String[] args) {
Connection conn = getConnection();
if (conn != null) {
System.out.println("连接succ");
System.out.println("返回的值:"+conn);
} else {
System.out.println("连接fail");
System.out.println("返回的值:"+conn);
}
}
}
出错信息:
返回的conn值:oracle.jdbc.driver.T4CConnection@1be5d1
java.sql.SQLException: 对只转发结果集的无效操作: last
at oracle.jdbc.driver.BaseResultSet.last(BaseResultSet.java:98)
at jdbc_oracle.getConnection(jdbc_oracle.java:27)
at jdbc_oracle.main(jdbc_oracle.java:52)
连接fail
返回的值:null----------------------
源代码:
//import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.Date;public class jdbc_oracle {
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("oracle.jdbc.OracleDriver");
String url="jdbc:oracle:thin:@10.4.9.11:1521:orcl";
String user="ty";
String password="a123";
PreparedStatement pstm = null;
try {
conn = DriverManager.getConnection(url,user,password);
System.out.println("返回的conn值:"+conn);
String sql = "select * from t_import_log";
pstm =conn.prepareStatement(sql);
//pstm =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = pstm.executeQuery();
rs.last();
int rowcount = rs.getRow();
System.out.println("jy_import_log:"+rowcount);
return conn; } catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return null;
}
public static void main(String[] args) {
Connection conn = getConnection();
if (conn != null) {
System.out.println("连接succ");
System.out.println("返回的值:"+conn);
} else {
System.out.println("连接fail");
System.out.println("返回的值:"+conn);
}
}
}
解决方案 »
- 有关《java核心开发技术从入门到精通》的问题:atan是什么意思啊...
- 传智博客的贪食蛇 有两句代码不懂什么意思,希望高人帮下苦难的自学者!!
- 急Hibernate中使用SQL语句问题!!!!
- 在Java中使用观察者模式时,Observable的方法notifyObservers(Object arg)的问题
- servlet运行问题,大家帮个忙!
- 各位大虾救命呀
- 一个关于类调用的问题
- java 代码中遇到,请问是什么意思?
- 问个小问题:如何在退出菜单的事件处理中发出一个退出消息?
- 读取CSV文件指定列的值,并生成一个新的CSV文件如何实现
- 有关java方面的几道题,想请大家帮忙看一下,新手菜鸟一枚
- 求救大神!!为什么这个私有化的值没有改变啊
pstm =conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);