这问题我一直无法解决请高人帮助,以下是我的代码和异常:
package com.myjavaconnection;
import java.sql.*;
public class myconnectionfactory
{
private static myconnectionfactory ref=new myconnectionfactory();
public myconnectionfactory()
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("加载异常");
e.printStackTrace();
}
}
public static Connection getCon() throws SQLException
{
String url="jdbc:oracle:thin:@localhost:1521:demon";
Connection con=DriverManager.getConnection(url, "scott", "tiger");
return con; }
public static ResultSet getRes(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
ResultSet set=st.executeQuery(sql);
return set;
}
public static int getExcuteupdate(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
return st.executeUpdate(sql);
} public static boolean getExcute(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
return st.execute(sql);
}
} java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.Mybase.ConnectionFactory.getConnection(ConnectionFactory.java:27)
at com.Mybase.ConnectionFactory.getResultSet(ConnectionFactory.java:32)
本人换过ojdbc 14也不行,郁闷,恳请各位高人指点.
package com.myjavaconnection;
import java.sql.*;
public class myconnectionfactory
{
private static myconnectionfactory ref=new myconnectionfactory();
public myconnectionfactory()
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("加载异常");
e.printStackTrace();
}
}
public static Connection getCon() throws SQLException
{
String url="jdbc:oracle:thin:@localhost:1521:demon";
Connection con=DriverManager.getConnection(url, "scott", "tiger");
return con; }
public static ResultSet getRes(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
ResultSet set=st.executeQuery(sql);
return set;
}
public static int getExcuteupdate(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
return st.executeUpdate(sql);
} public static boolean getExcute(String sql) throws SQLException
{
Statement st=myconnectionfactory.getCon().createStatement();
return st.execute(sql);
}
} java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.Mybase.ConnectionFactory.getConnection(ConnectionFactory.java:27)
at com.Mybase.ConnectionFactory.getResultSet(ConnectionFactory.java:32)
本人换过ojdbc 14也不行,郁闷,恳请各位高人指点.
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();