连接数据库出错程序代码
import java.util.*;
import java.sql.*;public class first
{
public static void main(String args[])
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jbbc:microsoft:sqlserver://192.168.0.9:1433;DatabaseName=school";
Connection con=DriverManager.getConnection(url,"sa","sa");
if(con != null)
System.out.println("Connection Successful!"); }
catch(Exception e)
{
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " + e.getMessage());
} }
}编译通过了
但是运行的时候出错
出错提示:
java.sql.SQLException:No suitable driver
at java.sql.DriverManager.getConnection(DriverManger.java:532)
at java.sql.DriverManager.getConnection(DriverManger.java:171)
at first.main(first.java:14)
error Trace in getConnection():No suitable driver我已经装了Microsoft SQL Server 2000 Driver for JDBC
我的环境变量 CLASSPATH:
c:\j2sdk1.4.2\bin;.;c:\j2sdk1.4.2\lib;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\lib\tools.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
import java.util.*;
import java.sql.*;public class first
{
public static void main(String args[])
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jbbc:microsoft:sqlserver://192.168.0.9:1433;DatabaseName=school";
Connection con=DriverManager.getConnection(url,"sa","sa");
if(con != null)
System.out.println("Connection Successful!"); }
catch(Exception e)
{
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " + e.getMessage());
} }
}编译通过了
但是运行的时候出错
出错提示:
java.sql.SQLException:No suitable driver
at java.sql.DriverManager.getConnection(DriverManger.java:532)
at java.sql.DriverManager.getConnection(DriverManger.java:171)
at first.main(first.java:14)
error Trace in getConnection():No suitable driver我已经装了Microsoft SQL Server 2000 Driver for JDBC
我的环境变量 CLASSPATH:
c:\j2sdk1.4.2\bin;.;c:\j2sdk1.4.2\lib;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\lib\tools.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
解决方案 »
- javap忽悠了很多人。原来它并不是编译的顺序。
- 面试题
- 怎样用java调用delphi代码呢?
- 既然s数组是一个string 类型那为什么不输出System.out.println(s[i][j]+"--");的时候s[i][j]不加引号?
- JPanel中的paintComponent方法是用来做什么的?
- 求jdk源代码下载
- 请教关于JNI的问题!
- 请问什么api可以限制JTextField和JTextArea的最大输入字数?急
- 还是没解决呀!!1
- 在intranet上发布java plug-in
- 请推荐支持web端mailing list和mail archive的mail server
- 怎样合并字符串?
jdbc!!
不过我改过来了还是不行啊~~~
出错信息
java.sql.SQLException:[Microsoft][SQLServer 2000 Driver for JDBC] Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknow Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknow Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknow Source) 等。这是什么原因??
我的环境变量 CLASSPATH:
c:\j2sdk1.4.2\bin;.;c:\j2sdk1.4.2\lib;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\lib\tools.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;D:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
java.lang.ClassNotFoundException:com.microsoft.jdbc.sqlserver.SQLServerDriver
at.......