七郎's JavaBlog

草木竹石皆可為劒。至人之用人若鏡，不將不迎，應(yīng)而不藏，故能勝物而不傷。

posts - 60, comments - 14, trackbacks - 0, articles - 0

SQL SERVER,ORACLE,MYSQL數(shù)據(jù)庫直連

Posted on 2008-04-22 22:16 七郎歸來閱讀(244) 評論(0) 編輯收藏

//SQL_Server:

String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";

String user = "sa";

String password = "";

//Oracle:

String driver = "oracle.jdbc.driver.OracleDriver";

String url = "jdbc:oracle:thin:@localhost:1521:wanchao";

String user = "scott";

String password = "tiger";

//mysql

String driver="com.mysql.jdbc.Driver";

String url="jdbc:mysql://localhost:3306/chinabank?useUnicode=true&characterEncoding=GBK";

String user="root";

String passeord="root";

Class.forName(driver);

con = DriverManager.getConnection(url,user,password);


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理