java Jdbc连接数据库案例

package com.mybatisLearn.jdbcDao;

import java.sql.*;

class BaseDao {
    //URL
    private static String url = "jdbc:mysql://127.0.0.1:3306/test_data";
    //username
    private static String userName = "root";
    //password
    private static String userPwd = "165177";

    public Connection conn() {
        //数据库连接初始化
        Connection con = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");      //6上面的驱动包:com.mysql.jdbc.cj.Driver
            con = DriverManager.getConnection(url, userName, userPwd);
        } catch (SQLException e) {
            System.out.println("数据库连接失败！");
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            System.out.println("找不到驱动程序类 ，加载驱动失败！");
            e.printStackTrace();
        }
        return con;
    }

    //关闭资源方法
    public void close(ResultSet rs, PreparedStatement stmt, Connection conn) {
        if (rs != null) {   // 关闭记录集
            try {
                rs.close();
                System.out.println("记录集关闭！");
            } catch (SQLException e) {
                System.out.println("记录集关闭失败！");
                e.printStackTrace();
            }
        }
        if (stmt != null) {   // 关闭声明
            try {
                stmt.close();
                System.out.println("预处理关闭！");
            } catch (SQLException e) {
                System.out.println("预处理关闭失败！");
                e.printStackTrace();
            }
        }
        if (conn != null) {  // 关闭连接对象
            try {
                conn.close();
                System.out.println("数据库关闭！");
            } catch (SQLException e) {
                System.out.println("数据库关闭失败！");
                e.printStackTrace();
            }
        }
    }

    //查询测试
    public void test() throws SQLException {
        BaseDao bd = new BaseDao();
        Connection con = bd.conn();
        String sql = "select * from user";
        //预编译
        PreparedStatement pre = con.prepareStatement(sql);
        //结果集
        ResultSet res = pre.executeQuery(sql);
        while (res.next()) {
            System.out.println("["+res.getString(1) + ":" + res.getString(2) + ":" + res.getString(3) + ":" + res.getString(4)+":"+ res.getString(5)+"]");
        }
        bd.close(res,pre,con);   //实际开发中不关数据库
    }

    public static void main(String[] args) throws SQLException {
        BaseDao bd = new BaseDao();
        bd.test();
    }
}

 /* 例子所用数据库表
  CREATE TABLE `user` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `username` varchar(32) NOT NULL COMMENT '用户名称',
        `birthday` date DEFAULT NULL COMMENT '生日',
        `sex` char(1) DEFAULT NULL COMMENT '性别',
        `address` varchar(256) DEFAULT NULL COMMENT '地址',
        PRIMARY KEY (`id`)
        ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;*/


 /*运行结果:
 [1:王五:2014-07-10:2:北京市]
         [10:张三:2014-07-10:1:北京市]
         [16:张小明:2014-07-10:1:河南郑州]
         [22:陈小明:2014-07-10:1:河南郑州]
         [24:张三丰:2014-07-10:1:河南郑州]
         [25:陈小明:2014-07-10:1:河南郑州]
         [26:王五:2014-07-10:2:河南郑州]
         记录集关闭！
         预处理关闭！
         数据库关闭！
*/