ODBC和JDBC有什么区别
ODBC和JDBC都是客户端应用程序访问服务器端数据库所需的编程接口。基本上,两者都被称为连接数据库的驱动程序,由RDBMS的供应商提供。
以下是ODBC和JDBC之间的重要区别。
ODBC与JDBC的示例
C#中的ODBC连接
using System; using System.Windows.Forms; using System.Data.Odbc; namespace WindowsApplication1{ public partial class Form1 : Form{ public Form1(){ InitializeComponent(); } private void button1_Click(object sender, EventArgs e){ string connetionString = null; OdbcConnection cnn ; connetionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=yourdatabasename.mdb;"; cnn = new OdbcConnection(connetionString); try{ cnn.Open(); MessageBox.Show ("Connection Open ! "); cnn.Close(); } catch (Exception ex){ MessageBox.Show("Can not open connection ! "); } } } }
示例
Java中的JDBC连接
import java.sql.*; class JavaTester{ public static void main(String args[]){ try{ Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection( "jdbc:mysql://localhost:3306/'yourDBname'","username","userpassword"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from emp"); while(rs.next()) System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)); con.close(); } catch(Exception e){ System.out.println(e);} } }