一个简单的JDBC程序_连接mysql并显示表中记录

使用前记得引mysql的支持包

 

//静态模式

package cn.eboy.jdbc;

import java.sql.*;

public final class JdbcUtils {
    private static String url = "jdbc:mysql://127.0.0.1:3306/ssh?useUnicode=true&characterEncoding=GBK";
    private static String user = "root";
    private static String password = "123456";
    private JdbcUtils(){
        
    }
    
    static{
        
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new ExceptionInInitializerError(e);
        }
    }
    
    public static Connection getConnection() throws SQLException{
        return DriverManager.getConnection(url, user, password);
    }
    
    public static void free(ResultSet rs, Statement st, Connection conn){
        try{
            if (rs != null){
                rs.close();    
            }
        }catch (SQLException e){
                e.printStackTrace();
        }finally{
            try{
                if (st != null){
                    st.close();    
                }
            }catch (SQLException e){
                e.printStackTrace();
            }finally{
                if (conn != null){
                    try{
                        conn.close();
                    }catch (SQLException e){
                        e.printStackTrace();
                    }    
                }
            }
        }
    }    
}

 

package com.eboy.jdbc;

import cn.eboy.jdbc.JdbcUtils;

public class Test {

    /**
     * @param args
     */
    public static void main(String[] args) {
        try {
            template();
        } catch (Exception e) {            
            e.printStackTrace();
        }         
    }
    
    static void template() throws Exception{
        java.sql.Connection conn = null;
        java.sql.Statement st = null;
        java.sql.ResultSet rs = null;
        
        String sql = "select * from pv_video limit 20";
        try {            
            //2.建立连接，可选指定编码及字符集
            conn = JdbcUtils.getConnection();            
            //3.创建语句
            st = conn.createStatement();
            //4.执行语句
            rs = st.executeQuery(sql);
            //5.处理结果
            while (rs.next()){
                System.out.println(rs.getString(1) + "\t" + rs.getObject(13));
            }
        } finally {
            JdbcUtils.free(rs, st, conn);            
        }
    }
}