ORACLE版本10G,JAR包 为ORACLE目录下的ojdbc14.jar, JDK版本为 1.6
JDBC代码如下
- Java code
try { Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "yongning"; String password = "yongning"; Connection conn = DriverManager.getConnection(url,user,password); DatabaseMetaData dmd = conn.getMetaData(); System.out.println(dmd.getDatabaseMajorVersion()); System.out.println(dmd.getDatabaseProductName()); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from test_book1"); ResultSetMetaData rsmd = rs.getMetaData(); int columnCount = rsmd.getColumnCount(); System.out.println(columnCount);// for(int i = 1; i <= columnCount; i++){ //把列名打印在一行,每个列名之间间隔一个制表位(\t) System.out.print(rsmd.getColumnName(i)+"\t"); } System.out.println(); System.out.println("-----------------------------"); while(rs.next()){ //数据表的一行 System.out.println("奶奶的,就是不给我输出"); for(int i = 1; i <= columnCount; i++){ //一行中的每个列 System.out.print(rs.getString(rsmd.getColumnName(i)) + "\t"); } System.out.println(); } }catch(Exception e){ e.printStackTrace(); } }
建立表的语句如下
- SQL code
create table test_book1(id number,bookname varchar(64));insert into test_book1 values('1','我我我');select * from test_book1; ID BOOKNAME----- ------------------------- 1 我我我
输出结果
10
Oracle
2
ID BOOKNAME
-----------------------------
我好无解啊,我怀疑是不是JAR包有问题,是不是ojdbc14.jar 不能再 1.6版本下使用,
------解决方案--------------------
確定insert资料之后有提交哈?