首先要下载Connector/J,MySQL官方提供的下载地址:http://www.mysql.com/downloads/connector/j/
这是我上传到CSDN里的jar包:http://download.csdn.net/detail/sammoye/9495082
解压后得到jar库文件,需要在工程中导入该库文件;
解压如下:
我是用的是MyEclipse:
导入库文件步骤:
1、工程名右键Build Path--->Configure Build Path;
2、Java Build Path--->Libraries--->Add Exteenal JARs,把需要的jar包添加进去;
3、
先写一个DBHelper.java类用来打开或关闭数据库:
package com.lv.Mysql;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
public class DBHelper {
public Connection conn = null;
public String sql;
// MySQL的JDBC URL编写方式:jdbc:mysql://主机名称:连接端口/数据库的名称?参数=值
// 避免中文乱码要指定useUnicode和characterEncoding
// 避免SSL警告添加useSSL=false
// 执行数据库操作之前要在数据库管理系统上创建指定的数据库
public String url = "jdbc:mysql://127.0.0.1:3306/sam?user=root&password=root&useUnicode=true&characterEncoding=UTF8&useSSL=false";
public Statement stmt = null;
public DBHelper(String sql) {
try {
Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动
conn = DriverManager.getConnection(url);// 获取连接
stmt = conn.prepareStatement(sql);// 准备执行语句
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
try {
this.conn.close();
this.stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
再写一个SelectDemo.java来执行相关查询操作:
package com.lv.Mysql;
import java.sql.ResultSet;
import java.sql.SQLException;
public class SelectDemo {
static String sql = null;
static DBHelper db1 = null;
static ResultSet ret = null;
public static void main(String[] args) {
sql = "select number,RED1,RED2,RED3,RED4,RED5,RED6,BLUE from doubleball";// SQL语句
db1 = new DBHelper(sql);// 创建DBHelper对象
try {
ret = db1.stmt.executeQuery(sql);// 执行语句,得到结果集
while (ret.next()) {
String unumber = ret.getString(1);
String uRED1 = ret.getString(2);
String uRED2 = ret.getString(3);
String uRED3 = ret.getString(4);
String uRED4 = ret.getString(5);
String uRED5 = ret.getString(6);
String uRED6 = ret.getString(7);
String uBLUE = ret.getString(8);
System.out.println(unumber + " " + uRED1 + "\t" + uRED2 + "\t"
+ uRED3 + "\t" + uRED4 + "\t" + uRED5 + "\t" + uRED6
+ "\t" + uBLUE);
}// 显示数据
ret.close();
db1.close();// 关闭连接
} catch (SQLException e) {
e.printStackTrace();
}
}
}
查询结果如下,和用Navicat For Mysql里查询的结果一致;
Navicat For Mysql里查询结果:
成功!