java链接oracle9i,sql2000的数据库出现问题,帮忙指正。
代码:import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;public class QueryODBCTest
{
private Connection con;
public void getStudent(Connection con,String sql)
{
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
String number = rs.getString("学号");
String name = rs.getString("姓名");
String date = rs.getString("出生日期");
String spe = rs.getString("专业");
String address = rs.getString("山东");
System.out.println("\n:" + name + "\tѧ:" + number + "\t:" + date + "\t:" + spe + "\t:" + address);
}
st.close();
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public Connection getConnection()
{
//String url = "jdbc:oracle:thin:@localhost:1521:yuyu";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yuqian";
String userName = "sa";
String password = "11";
try
{
//Class.forName("oracle.jdbc.driver.OracleDriver");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(url,userName,password);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException ex)
{
ex.printStackTrace();
}
return con;
}
public static void main (String[] args)
{
QueryODBCTest test = new QueryODBCTest();
Connection a = test.getConnection();
String b = "select * from student";
test.getStudent(a, b);
}
}报错:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at QueryODBCTest.getConnection(QueryODBCTest.java:51)
at QueryODBCTest.main(QueryODBCTest.java:70)
Exception in thread "main" java.lang.NullPointerException
at QueryODBCTest.getStudent(QueryODBCTest.java:18)
at QueryODBCTest.main(QueryODBCTest.java:72)Process completed.
--------------------Configuration: <Default>--------------------
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at QueryODBCTest.getConnection(QueryODBCTest.java:52)
at QueryODBCTest.main(QueryODBCTest.java:70)
Exception in thread "main" java.lang.NullPointerException
at QueryODBCTest.getStudent(QueryODBCTest.java:18)
at QueryODBCTest.main(QueryODBCTest.java:72)
classpath已经配置,仍然报错。请高手指点,我用的jcreate。
代码:import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;public class QueryODBCTest
{
private Connection con;
public void getStudent(Connection con,String sql)
{
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
String number = rs.getString("学号");
String name = rs.getString("姓名");
String date = rs.getString("出生日期");
String spe = rs.getString("专业");
String address = rs.getString("山东");
System.out.println("\n:" + name + "\tѧ:" + number + "\t:" + date + "\t:" + spe + "\t:" + address);
}
st.close();
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public Connection getConnection()
{
//String url = "jdbc:oracle:thin:@localhost:1521:yuyu";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yuqian";
String userName = "sa";
String password = "11";
try
{
//Class.forName("oracle.jdbc.driver.OracleDriver");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(url,userName,password);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException ex)
{
ex.printStackTrace();
}
return con;
}
public static void main (String[] args)
{
QueryODBCTest test = new QueryODBCTest();
Connection a = test.getConnection();
String b = "select * from student";
test.getStudent(a, b);
}
}报错:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at QueryODBCTest.getConnection(QueryODBCTest.java:51)
at QueryODBCTest.main(QueryODBCTest.java:70)
Exception in thread "main" java.lang.NullPointerException
at QueryODBCTest.getStudent(QueryODBCTest.java:18)
at QueryODBCTest.main(QueryODBCTest.java:72)Process completed.
--------------------Configuration: <Default>--------------------
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at QueryODBCTest.getConnection(QueryODBCTest.java:52)
at QueryODBCTest.main(QueryODBCTest.java:70)
Exception in thread "main" java.lang.NullPointerException
at QueryODBCTest.getStudent(QueryODBCTest.java:18)
at QueryODBCTest.main(QueryODBCTest.java:72)
classpath已经配置,仍然报错。请高手指点,我用的jcreate。
jar 包是否加到里面