控制面板已添加数据源并且连接正常,可还找不到驱动,请各位指点一下
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;public class Test
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc::odbc:mine", "scott", "tiger");
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("用户名" + rs.getString(2));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;public class Test
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc::odbc:mine", "scott", "tiger");
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("用户名" + rs.getString(2));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
Oracle in OraDb11g_home2是这个吗?
sqldeveloper\jdbc\lib\ojdbc14.jar;F:\app\wd\product\11.1.0\db_2\oui\jlib\classes
12.jar
仍然报错
你得创建一个oracle odbc数据源:mine
先自己测试这个数据源看能否连通吧
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class Test
{
public static void main(String[] args)
{
try
{
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//得到连接
Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:TEST", "scott", "tiger");
//从下面开始和sql server一样
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("用户名" + rs.getString(2));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
试试
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:45)
多了一个冒号