JDBC连接oracle的问题!
wzacs 2007-11-20 08:53:44 源码如下:
import java.sql.*;
public class ConnectDB
{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
String driver="oracle.jdbc.driver.oracledriver";
String url="jdbc:oralce:thin:@jujumao:1521:wzacs";
String user="wzacs";
String password="36987asd";
String sql="select * from student";
public void doConnect()
{
try
{
Class.forName(driver).newInstance();
System.out.println("加载驱动成功");
conn=DriverManager.getConnection(url,user,password);
System.out.println("连接数据库成功");
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println("------记录------");
System.out.println("学号"+rs.getString("sno"));
System.out.println("姓名"+rs.getString("sname"));
System.out.println("性别"+rs.getString("ssex"));
System.out.println("年龄"+rs.getInt("sage"));
System.out.println("专业"+rs.getString("sdept"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
ConnectDB aa=new ConnectDB();
aa.doConnect();
}
}
编译通过了 不过运行是报错如下:
import java.sql.*;
public class ConnectDB
{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
String driver="oracle.jdbc.driver.oracledriver";
String url="jdbc:oralce:thin:@jujumao:1521:wzacs";
String user="wzacs";
String password="36987asd";
String sql="select * from student";
public void doConnect()
{
try
{
Class.forName(driver).newInstance();
System.out.println("加载驱动成功");
conn=DriverManager.getConnection(url,user,password);
System.out.println("连接数据库成功");
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println("------记录------");
System.out.println("学号"+rs.getString("sno"));
System.out.println("姓名"+rs.getString("sname"));
System.out.println("性别"+rs.getString("ssex"));
System.out.println("年龄"+rs.getInt("sage"));
System.out.println("专业"+rs.getString("sdept"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
ConnectDB aa=new ConnectDB();
aa.doConnect();
}
}
编译通过后运行有一下问题:
Exception in thread "main" java.lang.UnsupportedClassVersionError: ConnectDB (Un
supported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
请问是什么原因啊?
谢谢个位高手了!!!!!