JDBC连接MySQL数据库的步骤
首先导入mysql的驱动程序包 :mysql-connector-java-5.1.7-bin.jar
- 加载JDBC驱动程序
- 提供JDBC连接的URL、创建数据库的连接
- 创建一个Statement语句对象
- 执行SQL语句
- 关闭JDBC对象释放资源
导入驱动包
测试连接数据库
package test;
import java.sql.Connection;
import java.sql.DriverManager;
public class testConn {
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/**?characterEncoding=utf8","root","root");
if (conn != null) {
System.out.println("数据库连接成功!");
}else{
System.out.println("数据库连接失败!");
}
}
}
测试JDBC的功能(以查询为例)
@Test
public void select() throws Exception{
//1.创建mysql的驱动对象
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库连接对象
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/**?characterEncoding=utf8","root","root");
//3.1创建sql语句的对象:statement
Statement stat = conn.createStatement();
//3.2创建sql语句:语法和数据库sql语句一样
String sql = " select * from dept ";
//4.执行查询并返回结果集
//excuteQuery:执行查询操作
//ResultSet:结果集:存放的是查询出来的dept表的数据
ResultSet rs = stat.executeQuery(sql);
//next():表示指针下移一行
while(rs.next()){
System.out.println(rs.getInt(1)+","+
rs.getString("dname")+","+
rs.getString(3));
}
//5.断开连接,释放资源
//从小往大关闭
rs.close();
stat.close();
conn.close();
}