java 与sqlserver 连接问题
1,ms jdbc sp3 装了 并己把Lib下的三个.jar文件放到...jre/lib/cmm/ext目录下2,sqlserver sp4补丁也装了3,我的系统是XP的4,classpath和 path变量也设置了
如classpath为.;%C:\Program Files\Java\jdk1.5.0_09\lib;%C:\Program Files\Java\jdk1.5.0_09\lib\tools.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;5,程序代码为:import java.sql.*;
public class SQLTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1445;DatabaseName=JavaDB";
String user="jondy";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="SELECT * FROM Login";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println("Your frist field is " + rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.err.println(e);
}
}
} 可不知为什么还一直不行,一直出错
在Jcreate环境下调试会出现以下异常:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver在DOS命令窗口下调试会出现以下异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis hing socket.哪位大虾能帮一下,小弟感激不尽!
(不好意思,分数不多)
1,ms jdbc sp3 装了 并己把Lib下的三个.jar文件放到...jre/lib/cmm/ext目录下2,sqlserver sp4补丁也装了3,我的系统是XP的4,classpath和 path变量也设置了
如classpath为.;%C:\Program Files\Java\jdk1.5.0_09\lib;%C:\Program Files\Java\jdk1.5.0_09\lib\tools.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;5,程序代码为:import java.sql.*;
public class SQLTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1445;DatabaseName=JavaDB";
String user="jondy";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="SELECT * FROM Login";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println("Your frist field is " + rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.err.println(e);
}
}
} 可不知为什么还一直不行,一直出错
在Jcreate环境下调试会出现以下异常:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver在DOS命令窗口下调试会出现以下异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis hing socket.哪位大虾能帮一下,小弟感激不尽!
(不好意思,分数不多)
即使要的话,我也放了,但还是老样子
要装 sp3或sp4补丁就可以
IDE环境下报java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
是JAR包的问题
而 DOS下面报
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis hing socket.这是端口的问题
建议LZ不要在DOS下面跑,既然JC报ClassNotFoundException,说明JAR包没放到CLASSPATH中
再检查下
设置为:
.;%C:\Program Files\Java\jdk1.5.0_09\lib;%C:\Program Files\Java\jdk1.5.0_09\lib\tools.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
这样应该没有错误吧???
请问工程的lib文件夹在哪里?