package lm;
import java.sql.*;
public class Example10_1 { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub String JDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String conURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDB";
String USER="sa";
String PWD="maxthon";
try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("ForName:"+e.getMessage());
}
try
{
Connection con=DriverManager.getConnection(conURL,USER,PWD);
Statement s=con.createStatement();
String query ="create table student("
+"id char(10),"
+"name char(15),"
+"score integer"
+")";
s.executeUpdate(query);
s.close();
con.close();
}
catch(SQLException e)
{
System.out.println("SQLException:"+e.getMessage());
}
}}
出现了如下的异常:
ForName:com.microsoft.jdbc.sqlserver.SQLServerDriver
SQLException:No suitable driver
我已安装了sql server 2000 sp4;
sql server driver for jdbc sp3;
环境变量:D:\Java\jdk1.6.0_02\lib;.;C:\Program Files\MySQL\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar;D:\Java\jdk1.6.0_02\lib\msutil.jar;D:\Java\jdk1.6.0_02\lib\msbase.jar;D:\Java\jdk1.6.0_02\lib\mssqlserver.jar
希望大家看一下是什么原因?
import java.sql.*;
public class Example10_1 { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub String JDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String conURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDB";
String USER="sa";
String PWD="maxthon";
try{
Class.forName(JDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("ForName:"+e.getMessage());
}
try
{
Connection con=DriverManager.getConnection(conURL,USER,PWD);
Statement s=con.createStatement();
String query ="create table student("
+"id char(10),"
+"name char(15),"
+"score integer"
+")";
s.executeUpdate(query);
s.close();
con.close();
}
catch(SQLException e)
{
System.out.println("SQLException:"+e.getMessage());
}
}}
出现了如下的异常:
ForName:com.microsoft.jdbc.sqlserver.SQLServerDriver
SQLException:No suitable driver
我已安装了sql server 2000 sp4;
sql server driver for jdbc sp3;
环境变量:D:\Java\jdk1.6.0_02\lib;.;C:\Program Files\MySQL\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar;D:\Java\jdk1.6.0_02\lib\msutil.jar;D:\Java\jdk1.6.0_02\lib\msbase.jar;D:\Java\jdk1.6.0_02\lib\mssqlserver.jar
希望大家看一下是什么原因?
\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;1.6jdk有这三个jar包?
要安装SQL SERVER 2000 SP3(chs_sql2ksp3.exe自解压后的SETUP。BAT,重启服务后才能打开1433)
SQL SERVER 2000 DRIVER FOR JDBC SP3
如果用SUN的JDK,就把MSBASE。JAR,MSSQLSRVER。JAR,MSUTIL。JAR,加到CLASSPATH,
如果用IDE,就加到工程中: 在JCreator中 配置 选项 JDK配置文件 编辑 添加存档路径 添加三个包
在Eclipse中 选择项目的构建路径——库—— 添加外部JAR 将这三个添加进去