JDBC建立连接

package com.tedu;

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.tedu.util.JdbcUtil;

/**
 * 实现JDBC快速入门程序: 查询jt_db库中account
 * 表中的所有记录, 将记录输出到控制台上。
 */
public class TestJdbc {
    @Test
    public void testFindAll() {
        Connection conn = null;
        Statement stat = null;
        ResultSet rs = null;
        try {
            //1.注册数据库驱动(Driver)
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取数据库连接
            conn = DriverManager.getConnection(
                    "jdbc:mysql:///jt_db?characterEncoding=utf-8", 
                    "root", "root");
            //3.获取传输器
            stat = conn.createStatement();
            //4.执行SQL语句,返回执行结果(rs:三行记录)
            String sql = "select * from account";
            rs = stat.executeQuery( sql );
            //5.处理结果
            while( rs.next() ) {
                //int id = rs.getInt("id");
                int id = rs.getInt( 1 );
                String name = rs.getString("name");
                double money = rs.getDouble("money");
                System.out.println(id+" : "+name+" : "+money);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //6.释放资源
            JdbcUtil.close(conn, stat, rs);
        }
    }
}