c鿴2020Կ(lin)W(wng)(sh)(j)֪RcR
JDBCĸ
JDBCһAPIԓO(sh)SSJavaBӔ(sh)(j)ĿJDBCijЩ濴ODBCһ^(q)eODBCJavaֱӌF(xin)ԭODBCCZԌȻJDBCṩJDBC/ODBC֮gĘJDBCLJ@X/Open Call Level Interface(CLI)O(sh)ӋģһCLIζֱSQLԃ(sh)(j)첢õһнY(ji)
JDBCṩBӔ(sh)(j)ĎN
1)c(sh)(j)ԴֱͨţʹJDBC͔(sh)(j)ƶąf(xi)hrʹһ(q)ӳֱc(sh)(j)ԴͨšȿԽԼ(q)ӳҲһõġ
2)ͨ^JDBC(q)ӳͨţBӵһߘ˜ʵ(q)ӳԓ(q)ӳcһc(sh)(j)ԴͨŵČ(q)ӳͨš
3)cODBC(sh)(j)Դͨţһ_õČ(q)ӳJDBC/ODBC(q)ӳJavasoft˾_l(f)SócODBC(sh)(j)ԴB
JDBCĻܺc
1)JDBCĻܰac(sh)(j)B;bl(f)SQLZ;c̎Y(ji)
2)JDBCǵͼAPIǸAPIĻA(ch)JDBCһNͼĽӿֱ{(dio)SQLֿ阋(gu)ӿںߵĻA(ch)ڈ(zh)ЕrAPIȱgJDBC@ӵĵͼӿڡ
3)JDBCcODBCAPIı^
JavaֱʹODBCODBCʹCZԽӿJava{(dio)ñCCaڰȫõĿֲԵȷ控y
ڲϣODBC APIַgJava APIODBCʹ˴ڳeָJavaȡ@Nȫָ
ODBCyԌWѺιܻܺsһǺεIJԃҲsxJDBCO(sh)ӋʹúεúεHڱҪrÑʹø
JDBCJava APIṩJavaĽQʹODBCrODBC(q)c(q)ֹb뵽ÿ_͑CJDBC(q)ȫJavaJDBCaJavaƽ_ԄӰbǿֲĺͰȫ
JDBCStatement
java apiڈ(zh)oB(ti) SQL Z䲢ɽY(ji)Č
ĬJr£ͬһrgÿ Statement ֻܴ_һ ResultSet ˣxȡһ ResultSet cxȡһt@ɂɲͬ Statement ɵijZĴ_Įǰ ResultSet t Statement ӿеЈ(zh)з[ʽP(gun)] java apiڈ(zh)oB(ti) SQL Z䲢ɽY(ji)Č
ĬJrͬһrgÿ Statement ֻܴ_һ ResultSet ˣxȡһ ResultSet cxȡһt@ɂɲͬ Statement ɵijZĴ_Įǰ ResultSet t Statement ӿеЈ(zh)з[ʽP(gun)]
P(gun)朽ӣ