import java.sql.* ;public class wanglei
{
public static void main(String [] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver") ;
Driver oracle = new oracle.jdbc.driver.OracleDriver() ; String url = "jdbc:oracle:thin:@192.168.1.9:1521:sky" ;
Connection c = DriverManager.getConnection(url,"wanglei","wanglei") ;
Statement stmt = c.createStatement() ;
ResultSet rs = stmt.executeQuery("select * from wa") ;
while (rs.next())
{
System.out.println(rs.getString("NAME")) ;
System.out.println(rs.getString("NO")) ;
}
stmt.close() ;
c.close() ;
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
异常捕获,说表或视图不存在,但我明明建了表的,用sqlplus也能查询,在管理器里面也可以找到的……
救命!
现在有两条记录,换了grant select on wa to wanglei这条语句也不行,select * from wanglei.wa也不行,我的数据库名字 叫sky ,哎怎么回事啊,我的QQ346685272,哪位高手能加我指点一下,谢谢了!
{
public static void main(String [] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver") ;
Driver oracle = new oracle.jdbc.driver.OracleDriver() ; String url = "jdbc:oracle:thin:@192.168.1.9:1521:sky" ;
Connection c = DriverManager.getConnection(url,"wanglei","wanglei") ;
Statement stmt = c.createStatement() ;
ResultSet rs = stmt.executeQuery("select * from wa") ;
while (rs.next())
{
System.out.println(rs.getString("NAME")) ;
System.out.println(rs.getString("NO")) ;
}
stmt.close() ;
c.close() ;
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
异常捕获,说表或视图不存在,但我明明建了表的,用sqlplus也能查询,在管理器里面也可以找到的……
救命!
现在有两条记录,换了grant select on wa to wanglei这条语句也不行,select * from wanglei.wa也不行,我的数据库名字 叫sky ,哎怎么回事啊,我的QQ346685272,哪位高手能加我指点一下,谢谢了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货