我已经把msbase.jar那3个JAR拷贝到C:\Java\jdk1.6.0\lib了
并且也在CLASSPATH里加了C:\Java\jdk1.6.0\lib,可是还是找不到驱动
import java.sql.*;
//import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.io.*;public class JDBCDemo {
public static void main(String args[]) {
//Connection conn = null;
//Statement stmt = null;
try{
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e){
System.out.println ("驱动类找不到");
}
}
}
并且也在CLASSPATH里加了C:\Java\jdk1.6.0\lib,可是还是找不到驱动
import java.sql.*;
//import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.io.*;public class JDBCDemo {
public static void main(String args[]) {
//Connection conn = null;
//Statement stmt = null;
try{
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e){
System.out.println ("驱动类找不到");
}
}
}
解决方案 »
- d.width和d.getWidth()什么关系?
- java如何发送事件
- 关于java获取操作系统路径的问题
- java调用c++函数的问题,请高手帮忙看看
- java.long.* ;java.util.* 在哪呢? 也就是java基础类在哪?? 找jdk没找到 !!
- 用什么来写啊!!!jdk还是jbuilder
- java如何联接到mysql
- 关于javamail.
- tomct启动的问题?
- ¥我做的APPLET中按钮的TOOLSTIPTEXT属性已经设置好,但鼠标移到按钮上时,没有出现提示,请教各位高手!!!(SWING做的按钮)¥
- 帮我找一下错误好吗?
- 从List转换到数组报ClassCastException
public static void main(String[] args){
String userName = "sa";
String userPwd = "xiaosan";
Connection dbConn;
try{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("success!");
Statement stmt=dbConn.createStatement();
String sql="select * from pub_info";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
rs.close();
stmt.close();
dbConn.close();
}catch(SQLException sqle){
System.out.println("can't connection db:"+sqle);
//return null;
} catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
//return null;
}
}}
//帮楼主贴个例子
2、“CLASSPATH里加了C:\Java\jdk1.6.0\lib”是不行的,应该像这样加入:
C:\Java\jdk1.6.0\lib\msbase.jar;C:\Java\jdk1.6.0\lib\mssqlserver.jar;C:\Java\jdk1.6.0\lib\msutil.jar;
-----------------------
import java.sql.*; public class TestDB {
public static void main(String[] args){
String userName = "sa";
String userPwd = "";
Connection dbConn;
try{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("success!");
Statement stmt=dbConn.createStatement();
String sql="select * from pub_info";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
rs.close();
stmt.close();
dbConn.close();
}catch(SQLException sqle){
System.out.println("can't connection db:"+sqle);
//return null;
} catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
//return null;
}
}
}
------------------------------
提示:Failed to load JDBC/ODBC driver.
还是不行 :(
改成这样:
} catch (Exception e) {
e.printStackTrace();
//return null;
}
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 TestDB.main(TestDB.java:11)
jdk 1.6.0 ec 3.2 myec 5.1GA
那3个jar是我同学的机子上拷来的 他的可以 SQL是SP4的(SQL SP4是金碟的安装目录里的)
project>properties>Java Build Path>Libraries>Add External JARs:
把三个jar文件加到里面就行了。
project>properties>Java Build Path>Libraries>Add External JARs:
把三个jar文件加到里面就行了。================
OK了, 可是不能每次都这样ADD近来吧 也太累了点 还有没别的什么法子?
给后面来的兄弟留个例子:
-----------------------------------------
//SQL要SP3以上的,project>properties>Java Build Path>Libraries>Add External JARs:
//把三个jar文件加到里面就行了。import java.sql.*;
public class TestDB {
public static void main(String[] args){
String userName = "sa";
String userPwd = ""; //这里密码根据你的SQL
Connection dbConn;
try{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=Northwind";
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("success!");
Statement stmt=dbConn.createStatement();
String sql="select * from sysobjects";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
rs.close();
stmt.close();
dbConn.close();
}catch(SQLException sqle){
System.out.println("can't connection db:"+sqle);
//return null;
} catch (Exception e) {
e.printStackTrace();
//return null;
}
}
}
你一定要加在服务启动里面