//数据库表名 Student
import java.sql.*;
public class JdbcTest {
//JDBC 驱动器名称 和数据库地址
static final String JDBC_DRIVER =“com.mysql.jdbc.Driver”;
// 数据库的名称 为 EXAMPLE
static final String DB_URL = “jdbc:mysql://localhost/EXAMPLE”;
// 数据库用户 密码
static final String USER = “root”;
static final String PASS = “”;
public static void main(String[] args){
Connection conn = null;
Statement stmt = null;
try{
//注册JDBC 驱动程序
Class.forName(“com.mysql.jdbc.Driver”);
//打开 连接
System.out.println(“Connection to database …”);
conn = DriverManager.getConnection(DB_URL,USER,PASS);
//执行查询
System.out.println(“Creating Statement…”);
stmt = conn.createStatement();
String sql;
sql = “SELECT id, name, age From Stud