http://www.mybdqn.com/
JDBC
杩炴帴鏁版嵁搴撳父瑙侀敊璇?/p>
1
銆?/p>
com.microsoft.sqlserver.jdbc.SQLServerException
:
閫?/p>
杩?/p>
绔?/p>
鍙?/p>
1433
杩炴帴鍒颁富鏈?/p>
teacher
鐨?/p>
TCP/IP
杩炴帴澶辫触銆傞敊璇?/p>
:鈥渘ull
銆傝楠岃瘉杩炴帴灞炴�э紝骞?/p>
妫�鏌?/p>
SQL Server
鐨勫疄渚嬫鍦ㄤ富鏈轰笂杩愯锛屼笖鍦ㄦ绔彛鎺ュ彈
TCP/IP
杩炴帴锛岃繕瑕?/p>
纭繚闃茬伀澧欐病鏈夐樆姝㈠埌姝ょ鍙ｇ殑
TCP
杩炴帴銆?/p>
鈥?/p>
閿欒鍘熷洜锛氭槸璁＄畻鍚嶉敊璇垨鑰呯鍙ｅ彿閿欒
瑙ｅ喅鍔炴硶锛氭垜鐨勭數鑴?/p>
-
銆嬪彸閿?/p>
-
銆嬪睘鎬э紝鏌ョ湅璁＄畻鏈哄悕绉帮紱
SQLServer
寰楅厤缃鐞嗗櫒涓
鎵炬湇鍔″櫒鐨?/p>
TCP/IP
锛屽彸閿煡鐪?/p>
IPALL
锛岀湅
tcp
绔彛鍙凤紝涓嶆槸
TCP
鍔ㄦ�佺鍙ｅ彿
2
銆?/p>
com.microsoft.sqlserver.jdbc.SQLServerException:
瀵?/p>
璞?/p>
鍚?/p>
'UserInfo'
鏃犳晥銆?/p>
閿欒鍘熷洜锛?/p>
UserInfo
杩欎釜琛ㄥ悕娌℃壘鍒?/p>
瑙?/p>
鍐?/p>
鍔?/p>
娉?/p>
锛?/p>
1
锛?/p>
鏌?/p>
鐪?/p>
琛?/p>
鍚?/p>
鏄?/p>
鍚?/p>
閿?/p>
浜?/p>
锛?/p>
閿?/p>
浜?/p>
鍒?/p>
鏀?/p>
姝?/p>
2
锛?/p>
杩?/p>
搴?/p>
瀛?/p>
绗?/p>
涓?/p>
涓?/p>
鏁?/p>
鎹?/p>
搴?/p>
閿?/p>
浜?/p>
databaseName=Userdb
3
銆?/p>
java.sql.SQLException:
No suitable driver found for jdbc:
sqlsever
://localhost:1433;databasename=userdb
閿欒鍘熷洜锛氭槸杩炲簱瀛楃涓叉牸寮忛棶棰?/p>
4
銆?/p>
com.microsoft.sqlserver.jdbc.SQLServerException:
绔彛鍙?/p>
1433
:
databaseName=userdb
鏃犳晥銆?/p>
閿欒鍘熷洜锛氳繛搴撳瓧绗︿覆鏍煎紡闂
5
銆?/p>
com.microsoft.sqlserver.jdbc.SQLServerException:
鏃犳硶鎵撳紑鐧诲綍鎵�璇锋眰鐨勬暟鎹簱
"userInfo"
銆傜櫥褰曞け璐ャ�?/p>
閿欒鍘熷洜锛氭暟鎹簱鍚嶅啓閿欎簡
6
銆?/p>
com.microsoft.sqlserver.jdbc.SQLServerException:
缁撴灉闆嗘病鏈夊綋鍓嶈銆?/p>
閿欒鍘熷洜锛氱粨鏋滈泦涓鸿皟鐢?/p>
next()
鏂规硶绉诲姩锛屽氨鍙栧�间簡
7
銆?/p>
.java.sql.SQLException:
Listener
refused
the
connection
with
the
following
error:
ORA-12505,
TNS:listener
does
not
currently
know
of
SID
given
in
connect descriptor
銆?/p>
閿欒鍘熷洜锛氭暟鎹簱鐨?/p>
sid
鍗虫暟鎹簱鍚嶇О娌℃湁閰嶇疆姝ｇ‘銆?/p>
8
銆?/p>
.java.sql.SQLException: ORA-00942: table or view does not exist
閿欒鍘熷洜锛氬お鏄庢樉浜嗭紝浣犱竴瀹氳妫�鏌ヤ綘鐨?/p>
SQL
璇彞锛?/p>
from
鐨勮〃鎴栬鍥句竴瀹氭槸鍚嶇О鎼為敊
浜嗐�?/p>
9
銆?/p>
java.sql.SQLException:
鏃犳晥鐨勫垪绱㈠紩
閿欒鍘熷洜锛氬彲鑳芥槸
SQL
璇彞涓弬鍏ヤ簡涓枃鐨勭鍙凤紝涔熷彲鑳芥槸浠ｇ爜涓殑
statement
涓?