代码如下:import java.io.*;
import java.sql.*;
import bean.DBClass;public class Test{
ResultSet rs;
String strurl="jdbc:odbc:bookshop";
public Test(){
}
public ResultSet getResult(String sql){
try{
Class.forName("sun.jdbc:odbc:JdbcOdbcDriver");
Connection con =DriverManager.getConnection(strurl);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rst=stmt.executeQuery(sql);
return rst;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return null;
}
}
public boolean exeutesql(String sql){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement stmt=con.createStatement();
stmt.execute(sql);
con.commit();
return true;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return false;
}
}
public static void main(String args[]){
Test t=new Test();
String command="insert into user values(a,c,a,a,a,a,c,a,a)";
t.exeutesql(command);
}
}编译通过,但执行时出现错误:import java.io.*;
import java.sql.*;
import bean.DBClass;public class Test{
ResultSet rs;
String strurl="jdbc:odbc:bookshop";
public Test(){
}
public ResultSet getResult(String sql){
try{
Class.forName("sun.jdbc:odbc:JdbcOdbcDriver");
Connection con =DriverManager.getConnection(strurl);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rst=stmt.executeQuery(sql);
return rst;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return null;
}
}
public boolean exeutesql(String sql){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement stmt=con.createStatement();
stmt.execute(sql);
con.commit();
return true;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return false;
}
}
编译通过,但执行时出错:操作数据库出错:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数
据源名称并且未指定默认驱动程序
Press any key to continue...
import java.sql.*;
import bean.DBClass;public class Test{
ResultSet rs;
String strurl="jdbc:odbc:bookshop";
public Test(){
}
public ResultSet getResult(String sql){
try{
Class.forName("sun.jdbc:odbc:JdbcOdbcDriver");
Connection con =DriverManager.getConnection(strurl);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rst=stmt.executeQuery(sql);
return rst;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return null;
}
}
public boolean exeutesql(String sql){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement stmt=con.createStatement();
stmt.execute(sql);
con.commit();
return true;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return false;
}
}
public static void main(String args[]){
Test t=new Test();
String command="insert into user values(a,c,a,a,a,a,c,a,a)";
t.exeutesql(command);
}
}编译通过,但执行时出现错误:import java.io.*;
import java.sql.*;
import bean.DBClass;public class Test{
ResultSet rs;
String strurl="jdbc:odbc:bookshop";
public Test(){
}
public ResultSet getResult(String sql){
try{
Class.forName("sun.jdbc:odbc:JdbcOdbcDriver");
Connection con =DriverManager.getConnection(strurl);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rst=stmt.executeQuery(sql);
return rst;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return null;
}
}
public boolean exeutesql(String sql){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement stmt=con.createStatement();
stmt.execute(sql);
con.commit();
return true;
}catch(Exception e){
System.out.println("操作数据库出错:"+e.toString());
return false;
}
}
编译通过,但执行时出错:操作数据库出错:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数
据源名称并且未指定默认驱动程序
Press any key to continue...
操作数据库出错:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
参数不足,期待是 2。
Press any key to continue...