javaÁ¬½ÓmysqlÊý¾Ý¿â
Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
Ö÷Òª´úÂëÈçÏ£º
import java.sql.*;
public class Test{
private Connection conn;
private Statement stat;
public Test()
{
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//¼ÓÔØÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver"); //¼ÓÔØÇý¶¯³ÌÐò
}
catch (Exception ex)
{
System.out.println("sql exception: driver ERROR!!!!");
ex.printStackTrace();
}
try
{
conn = DriverManager.getConnection("jdbc:mysql://10.64.10.100:3306/test","root","root");//½¨Á¢Á¬½Ó£¬
stat = conn.createStatement();//´´½¨Statement¶ÔÏó
}
catch (SQLException ex)
{
//sql exception
System.out.println("sql exception: connect or driver!!!!");
ex.printStackTrace();
}
}
Ïà¹ØÎĵµ£º
1.JavaµÄ´úÂëÒ»°ã·ÖΪÁ½´óÀࣺһÖÖÊǽṹ¶¨ÒåÓï¾ä£»Ò»ÖÖÊǹ¦ÄÜÓï¾ä£¨¹¦ÄÜÓï¾äÒªÓ÷ֺŽá⣩¡£
2.ÓÃ/* ÄÚÈÝ */×¢ÊÍ£¬ÄÚÈÝÀïÃæÊDz»ÄÜ´æÔÚ/* */µÄ£»µ«ÊÇ¿ÉÒÔ´æÔÚ//£»ÒòΪÕâÑù¾Í²»»á·¢Éúϵͳ²»ÖªµÀÄĸö*/²ÅÊÇÕæµÄ½áÊø·û¡£
3.±äÁ¿Ê¹ÓÃǰ±ØÐë³õʼ»¯£¬Ê¹Óõ¥ÒýºÅµÄ×÷ÓþÍÊǰÑÀïÃæµÄ×Ö ......
JAVA Á¬½Ó SQLServer 2000 ËùÐèÒªµÄÈý¸öJAR°ü¡£
http://download.csdn.net/source/2283940
----------------
Code:
------------------------
Connection conn = null;
Statement sta = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServer ......
ʱ¼ä¹ýµÄÕæ¿ì£¬²»Öª²»¾õÀ´µ½´«ÖDz¥¿ÍÒѾһ¸ö¶àÔÂÁË£¬ÕâÒ»¸öÔÂÖ÷ҪѧϰÁËJava»ù´¡²¿·Ö£¬ËäȻÿÌì¶¼ÊÇÇôúÂëµ½ÍíÉÏ1¡¢2µã²Å˯¾õ£¬µ«ÊÇ»¹ÊǸоõʱ¼ä²»¹»Óã¬ÒòΪÐèҪѧϰ¹®¹ÌµÄ¶«Î÷Ì«¶àÌ«¶àÁË£¬×ܸоõÕÆÎյIJ»¹»ºÃ£¬ÕâÒ»¸öÔ¹ýµÄºÜÀÛµ«Ò²ºÜ³äʵ¡£
Õ⼸Ì쿪ʼ ......
ʵÑéÒªÇó£º
1.±àд»ùÓÚTCPÐÒéµÄͨÐųÌÐò£¬°üÀ¨ServerÓëClientÁ½¸ö²¿·Ö¡£ÊµÏÖ»ØÉù³ÌÐò£º¼´¿Í»§¶Ë·¢ËÍÏûÏ¢£¬·þÎñÆ÷¶Ë½«ÊÕµ½µÄÏûÏ¢ÔÑù»áË͸ø¿Í»§¶Ë¡£
2.ÔÚµ¥»úÉÏÔËÐÐËüÃÇ£¬ÑéÖ¤ÆäͨÐŽá¹û£»
3.ÔÚ¶à»úÉÏÔËÐÐËüÃÇ£¬ÑéÖ¤ÆäͨÐŽá¹û£»£¨ChatServerÖ»ÐèÔËÐÐÔÚһ̨Ö÷»úÉÏ£¬ChatClient¿ÉÔÚÆäËüÖ÷»úÉÏÔËÐУ¨ÒªÖªµÀChatServerËùÔ ......
package bag;
import java.util.*;
public class Dou {
/*
* Éú³ÉÆË¿ËÅÆ
*/
public String[] puke() {
String[] s1 = { "ºÚÌÒ", "ºìÌÒ", "÷»¨", "·½Æ¬" };
String[] s2 = { "A", "2", "3", "4", "5", "6", "7", "8", "9", "10", "J",
  ......