jdbc读取mysql

import java.sql.Connection ;
import java.sql.DriverManager ;
import java.sql.Statement ;
import java.sql.ResultSet ;

public class MyTest {
    public static void main (String args []) {
        Connection con = null ;
        try {
            // 获得MySQL驱动的实例
            Class . forName ("com.mysql.jdbc.Driver" ). newInstance ();
            // 提供地址用户名密码并获得连接对象
            con = DriverManager . getConnection ("jdbc:mysql://127.0.0.1/test" , "root" , "123456" );
       
            if (! con . isClosed ())
                // 连接成功提示
                System . out . println ("Successfully connected to MySQL server using TCP/IP..." );
            // 有Connection对象创建Statement
            Statement st = con . createStatement ();
            // 运行SQL语句读取
            ResultSet rs = st . executeQuery ("SELECT * FROM emlog_blog" );
            // 循环读取数据
            while (rs . next ()) {
                // 打印数据
                System . out . println (rs . getString ("gid" ));
            }
            // 关闭
            con . close ();
        } catch (Exception e ) {
            System . err . println ("Exception: " + e . getMessage ());
        }
    }
}

要注意的东西有

这个com.mysql.jdbc.的包需要自己去MySQL哪里下载的

下载地址：

http://dev.mysql.com/downloads/connector/j/

下载后把这个包加到Eclipse的libary里面上面的代码才能运行