jdbc¡¨Ω”Œ  :: B.adams
未识别博客 · 2004-02-02
jdbc¡¨Ω”Œ Â
±º‰£∫2004-02-29
import
java.sql.*;
public
class
TestDB
{
static
public
void
main(String
args[])
throws
Exception
{
Connection
conn=getConnection();
Statement
stat=conn.createStatement();
stat.execute("CREATE
TABLE
testOne
(NAME
char(20))");
stat.execute("INSERT
INTO
testOne
VALUE
('Hello
World')");
stat.close();
conn.close();
}
static
public
Connection
getConnection()
throws
Exception
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String
url="jdbc:mysql://localhost:3306/testOne:";
Connection
connection=DriverManager.getConnection(url);
return
connection;
}
}
Exception
in
thread
"main"
java.sql.SQLException:
Communication
link
failure:
Ba
d
handshake
at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:815)
at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1585)
at
com.mysql.jdbc.Connection.<init>(Connection.java:524)
at
com.mysql.jdbc.Driver.connect(Driver.java:359)
at
java.sql.DriverManager.getConnection(DriverManager.java:512)
at
java.sql.DriverManager.getConnection(DriverManager.java:193)
at
TestDB.getConnection(TestDB.java:19)
at
TestDB.main(TestDB.java:7)
Press
any
key
to
continue...
À˘ π”√JCreator
2.5;
MySQL
Connector/J
3.1.0
Alpha;
JDK
1.4.2
xp
∑¢±Ì”⁄
2004-02-29 14:39
“˝”√Trackback(0)
|
±ýº≠
∆¿¬€
String url="jdbc:mysql://localhost:3306/testOne:";
url∫Û√Ê∫√œÒ≤ª”¶∏√”–":"¡À∞…
ªπ «ƒ„ ˝æðø‚√˚∫Û√Ê”–:?
steve
(
) ∑¢±Ì”⁄
2004-02-29 14:46
∑¢±Ì∆¿¬€
”√ªß√˚:
Email:
÷˜“≥:
◊Ó∫Û∏¸–¬
JAVA API ¡–±ÌÕº
œ¬√Ê «Œ“≤‚ ‘¡¨Ω”MySql ±µƒ¥˙¬Î
jdbc¡¨Ω”Œ Â
’‚∏ˆ∂¨ºæ°£°£°£°£°£°£
Õ˘ ¬»Á—ëȻÁ≥±
∫√≥§ ±º‰√ª”–¿¥–¥»’º«¡À£¨
◊ˆπп̑±’Ê¿€
≤ª∏√∞Æ…œƒ„
ª·¡˜—€¿·µƒƒ–»À
∏þ÷–Õ¨—ßæ€ª·µƒœ˚œ¢
原始快照:web.archive.org