package cn.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.Test;
import com.mysql.jdbc.Driver;
/**
* 功能:实现使用JDBC操作mysql数据库
*/
public class TestJDBC {
@Test
public void testA() throws SQLException{
//1.注册数据库驱动
DriverManager.registerDriver(new Driver());
//2.获取数据库连接
Connection conn = DriverManager.getConnection("jdbc:mysql:///shujuku", "root", "root");
//3.创建传输器
Statement stat = conn.createStatement();
//4.执行SQL
ResultSet rs = stat.executeQuery("select * from tb_table");
//5.遍历结果集
while(rs.next()){
String id = rs.getString(1);
String name = rs.getString(2);
System.out.println(id+name);
}
//6.释放资源
rs.close();
stat.close();
conn.close();
}
}