//下面这一行没法编译
connection=DriverManager.getConnection(connectionStr, "", "");
没try{ } catch
啊,DriverManager.getConnection抛出SQLExeception
connection=DriverManager.getConnection(connectionStr, "", "");
没try{ } catch
啊,DriverManager.getConnection抛出SQLExeception
import java.sql.*;
public class dbConnect
{
public static void main(String[] args)
{
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connectionStr="jdbc:odbc:Products";
Connection connection=null;
String sql="SELECT * FROM Product WHERE CatalogID=002";
ResultSet rs=null;
Statement statement=null;
try
{
//加载数据库驱动
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DBconnection():"+e.getMessage());
}
//下面这一行没法编译
try
{
connection=DriverManager.getConnection(connectionStr, "", "");
}
catch(SQLException sqle)
{
}
}
}
public class dbConnect
{
public static void main(String[] args)
{
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connectionStr="jdbc:odbc:mydb";
Connection connection=null;
String sql="SELECT * FROM people";
ResultSet rs=null;
Statement statement=null;
try
{
//加载数据库驱动
Class.forName(DBDriver);
connection=DriverManager.getConnection(connectionStr);
}
catch(Exception e)
{
System.err.println("DBconnection():"+e.getMessage());
}
}
}
这样就没问题了,呵呵!
{
ResultSet res;
Statement sta;
Connection con;
String qurey;
Sql()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:DB");
sta=con.createStatement(); }catch(Exception ae)
{
System.out.println ("不能加载驱动");
}
}
}