TestMySql

package com.jasonhuang.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import org.apache.log4j.Level;
import org.apache.log4j.Logger;

//import com.mysql.jdbc.Driver;

/**//*
 * 测试基础MySQL JDBC代码
 */
public class TestMySql ...{

    /** *//**
     * Log4j日志
     */
    private static Logger logger = Logger.getLogger(TestNIO.class);

    /** *//**
     * @param args
     * @throws ClassNotFoundException 
     */
    public static void main(String[] args) ...{
        // 设置日志记录级别为INFO
        logger.setLevel(Level.INFO);

        Connection conn = null; 
        Statement stmt = null;
        ResultSet rs = null;

        try ...{
            Properties props = new Properties();

            // 设置数据库用户名和密码
            props.put("user", "root");
            props.put("password", "");
            // 设置数据库连接使用中文字符集
            props.put("useUnicode", "true");
            props.put("characterEncoding", "GBK");

            // 非标准写法
            //Driver driver = new Driver();
            //conn = driver.connect("jdbc:mysql://localhost:3306/mysql", props);
            // 标准JDBC写法
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", props);
            // 设置为只读（只允许select）
            conn.setReadOnly(true);

            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM user");
            int n = 0;
            while (rs.next()) ...{
                logger.info("记录" + ++n + ", " + rs.getString("User"));
            }
            logger.info("记录总数：" + n);
        } catch (Exception e) ...{
            e.printStackTrace();
        } finally ...{
            // 依次关闭数据库资源
            if (rs != null) ...{
                try ...{
                    rs.close();
                } catch (SQLException e) ...{
                    e.printStackTrace();
                }
                rs = null;
            }
            if (stmt != null) ...{
                try ...{
                    stmt.close();
                } catch (SQLException e) ...{
                    e.printStackTrace();
                }
                stmt = null;
            }
            if (conn != null) ...{
                try ...{
                    conn.close();
                } catch (SQLException e) ...{
                    e.printStackTrace();
                }
                conn = null;
            }
        }
    }

}