jdbc

关于JDBC链接数据库
原料： my eclipse10，Navicat

代码
package geek99;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class DBHelper {

private static final String URL = "jdbc:mysql://localhost:3306/hhhhhh?useUnicode=true&characterEncoding=utf-8&useSSL=false";
private static final String USER = "root";
private static final String PASSWORD = "123";

public static void main(String[] args) throws ClassNotFoundException,
        SQLException {

    // 1.加载驱动程序
    Class.forName("com.mysql.jdbc.Driver");
    // 2.获得数据库的连接
    Connection conn = (Connection) DriverManager.getConnection(URL, USER,
            PASSWORD);
    // 3.通过数据库的连接操作数据库，实现增删改查
    Statement stmt = (Statement) conn.createStatement();
    ResultSet rs = stmt.executeQuery("select YK,MI from AC");

    while (rs.next()) {
        System.out.println(rs.getString("YK") + " " + rs.getInt("MI"));
    }
}

public Object pst;

}

* URL = “jdbc:mysql://localhost:3306/hhhhhh?useUnicode=true&characterEncoding=utf-8&useSSL=false”*

hhhhhh是我的库名，欢迎大家浏览和交流