java如何使用jdbc-odbc桥连接access数据库

Question

数据库连接代码
class database
{
    Connection con=null;
    Statement state=null;
    ResultSet result=null;    public database()
    {
        try
        {
           String JDriver="sun.jdbc.odbc.JdbcOdbcDriver"; 
           Class.forName(JDriver);
        }
        catch(java.lang.ClassNotFoundException e)
        {
            System.out.println("ForName:"+e.getMessage());
        }
        try
        {
            String conURL="jdbc:odbc:你的数据库";
            con=DriverManager.getConnection(conURL);
            state=con.createStatement();
        }
        catch(SQLException e)
        {
            System.out.println("SQLException:"+e.getMessage());
        }
    }
}

Answer 1

先在ODBC中设个数据库连接连接对象,然后
import java.io.*;
import java.sql.*;
class BookQuery
  {
    public static void main(String args[])
      {
        try
         {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }
        catch(ClassNotFoundException ce)
          {
            System.out.println("SQLException: "+ce.getMessage());
          }
        try
          {
            Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
            Statement stmt=con.createStatement();
            ResultSet rs=stmt.executeQuery("select * from bookTab");
            while(rs.next())
              {
                System.out.println(
                        "书号: "+rs.getInt(1)+"\t"+
                        "书名: "+rs.getString(2)+"\t"+
                        "作者: "+rs.getString(3)+"\t"+
                        "单价: "+rs.getFloat(4));
              }
           stmt.close();
           con.close();
          }
        catch(SQLException e)
          {
            System.out.println("SQLException: "+e.getMessage());
           }
       }
   }

Answer 2

Java一般连数据库不是会都用ODBC吧?有没有象ASP或ASP.NET的那种直接连接??有的话,请举个例子好吗

Answer 3

用odbc,配置一下，基础的数据库书里都有写