1. 下载驱动: http://dev.mysql.com/downloads/file/?id=460363
2. 载入驱动
3. 使用: Class.forName("com.mysql.fabric.jdbc.FabricMySQLDriver");
4. 链接数据库: DriverManager.getConnection(this.url, this.username, this.password);
5. 访问表
6. 示例:
package p_java;
import java.sql.DriverManager;
import java.sql.SQLException;
import org.apache.commons.lang3.ObjectUtils.Null;
import com.mysql.jdbc.Connection;
public class JdbcConnection {
private String url;
private String username;
private String password;
private java.sql.Connection connection;
public JdbcConnection(String url,String username,String password){
this.url=url;
this.username=username;
this.password=password;
}
public java.sql.Connection conn(){
try {
Class.forName("com.mysql.fabric.jdbc.FabricMySQLDriver");
} catch (ClassNotFoundException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
try {
connection=DriverManager.getConnection(this.url, this.username, this.password);
} catch (SQLException e) {
// TODO 自动生成的 catch 块
System.out.println("链接数据库失败");
e.printStackTrace();
}
return connection;
}
}
/**
*
*/
package p_java;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
String url="jdbc:mysql://xxxxxxxxxxxxx:3306/xxxxxxx";
String password="root";
String username="root";
Connection connection=null;
JdbcConnection jdbcConnection = new JdbcConnection(url, username, password);
connection=jdbcConnection.conn();
if(connection!=null){
String sqlGetAllPeople="select * from tb_people";
try {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sqlGetAllPeople);
while(resultSet.next()){
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println(id+name+age);
}
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
}
}