[求助]jdbc 到底怎么用啊
我们刚学了jdbc 书上有个事例 可是我敲了却不能正确运行......
程序如下......我不知道怎么去建立那个数据表和数据原
运行后提示:
SQLException[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动
程序
import java.sql.*;
public class sql{
public static void main(String args[]){
String url="jdbc:odbc:stu";
String sql;
Connection con;
Statement stmt;
String num,name,sex;
int age,math,eng,spec;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e){
System.err.print("classnotfoundexception:");
System.err.println(e.getMessage());
}
try{
con=DriverManager.getConnection(url,"java","java");
stmt=con.createStatement();
sql="INSERT INTO STUDENT"+"VALUES('2008','DDD','NAN',20,71,62,76)";
stmt.executeUpdate(sql);
stmt.close();
con.close();}
catch(SQLException ex){
System.err.println("SQLException"+ex.getMessage());
}
}
}
public class sql{
public static void main(String args[]){
String url="jdbc:odbc:stu";
String sql;
Connection con;
Statement stmt;
String num,name,sex;
int age,math,eng,spec;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e){
System.err.print("classnotfoundexception:");
System.err.println(e.getMessage());
}
try{
con=DriverManager.getConnection(url,"java","java");
stmt=con.createStatement();
sql="INSERT INTO STUDENT"+"VALUES('2008','DDD','NAN',20,71,62,76)";
stmt.executeUpdate(sql);
stmt.close();
con.close();}
catch(SQLException ex){
System.err.println("SQLException"+ex.getMessage());
}
}
}
[此贴子已经被作者于2006-11-3 10:29:42编辑过]
