import java.sql.*;
import java.net.URL;
public class ConnectSQL{
public static void main(String[] args){
String url="jdbc:microsft:sqlserver://127.0.0.1:1433;DatabaseName=experiment;user=sa;password=;";
String sql="create table student(name char(20),sex char(2),age int,address char(30))";
try{
try{
Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println("Can not load Jdbc driver");
System.out.println("ClassNotFoundException:");
System.out.println(e.getMessage());
}
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.out.println("SQLException:");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
ex=ex.getNextException();
}
}
}
}
编译时,出现以下错误:package com.microsoft.jdbc does not exit
我装了microsoft sql 2000 driver for jdbc,
为什么会出现以上错误 ?
谢谢
import java.net.URL;
public class ConnectSQL{
public static void main(String[] args){
String url="jdbc:microsft:sqlserver://127.0.0.1:1433;DatabaseName=experiment;user=sa;password=;";
String sql="create table student(name char(20),sex char(2),age int,address char(30))";
try{
try{
Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println("Can not load Jdbc driver");
System.out.println("ClassNotFoundException:");
System.out.println(e.getMessage());
}
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.out.println("SQLException:");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
ex=ex.getNextException();
}
}
}
}
编译时,出现以下错误:package com.microsoft.jdbc does not exit
我装了microsoft sql 2000 driver for jdbc,
为什么会出现以上错误 ?
谢谢
//注册驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection sqlCon = DriverManager.getConnection(url,"sa","");
Statement sqlStmt =sqlCon.createStatement(); 上面的代码是我写的。我还是第一次看见想你那么写代码的。