错误提示:
java.lang.ClassNotFoundException: com.internetcds.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at MyPackage.JdbcApplication.main(JdbcApplication.java:7)
源程:
package MyPackage;
import java.sql.*;
import java.io.*;
public class JdbcApplication {
public static void main(String args[]){
try{
Class.forName(
"com.internetcds.jdbc.Driver").newInstance();
String url="jdbc:odbc:sample";
//String user="administrator";
//String pwd="hbj";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
//staff表内的7个字段名称依序为:
//id name dept job years salary comm.
String qstr="select * from staff";
ResultSet rs=stmt.executeQuery(qstr);
while(rs.next()){
String name=rs.getString("name");//仅取name字段数据
System.out.println(name);
}
rs.close();
stmt.close();
conn.close();
}catch(SQLException sqle){
System.out.println(sqle.getMessage());
System.out.println(sqle.getSQLState());
}catch(Exception e){
e.printStackTrace();
}
}
}
java.lang.ClassNotFoundException: com.internetcds.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at MyPackage.JdbcApplication.main(JdbcApplication.java:7)
源程:
package MyPackage;
import java.sql.*;
import java.io.*;
public class JdbcApplication {
public static void main(String args[]){
try{
Class.forName(
"com.internetcds.jdbc.Driver").newInstance();
String url="jdbc:odbc:sample";
//String user="administrator";
//String pwd="hbj";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
//staff表内的7个字段名称依序为:
//id name dept job years salary comm.
String qstr="select * from staff";
ResultSet rs=stmt.executeQuery(qstr);
while(rs.next()){
String name=rs.getString("name");//仅取name字段数据
System.out.println(name);
}
rs.close();
stmt.close();
conn.close();
}catch(SQLException sqle){
System.out.println(sqle.getMessage());
System.out.println(sqle.getSQLState());
}catch(Exception e){
e.printStackTrace();
}
}
}
* <p>Title: </p>
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
import java.sql.*;
public class DBTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Test","sa","password");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from userinfo");
while(rs.next())
{
System.out.println(rs.getString("userid")+" "+rs.getString("userpws"));
}
rs.beforeFirst();
while(rs.next())
{
System.out.println(rs.getString("userid")+" "+rs.getString("userpws"));
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sample";
Connection con=DriverManager.getConnection(url,"sa","password");如果你用的数据源 那么
String url="jdbc:odbc:sample";
Connection con=DriverManager.getConnection(url,"sa","password");
这里提示你了这个包找不到,最好把他先放到classpath这样最保险了。
2、确定它在你的构建路径下。
2、确定它在你的构建路径下。驱动写错了,
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sample";
Connection con=DriverManager.getConnection(url,"sa","password");如果你用的数据源 那么
String url="jdbc:odbc:sample";
Connection con=DriverManager.getConnection(url,"sa","password");