[bigdata-074] java + maven + mysql + jdbc 示例

1. 在eclipse创建一个maven项目


2. 在pom的依赖里增加 mysql的artifact，形如
groupId = mysql
artifactId = mysql-connector-java
version = 5.1.25


3. 确认后maven会自动下载mysql的jar包


4.写一个java的mysql的例子，读取所有的table名，形式如下：

----------------------

package com.ttss.demo.mysqljdbc;


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


public class App 
{
    public static void main( String[] args ) throws SQLException
    {
        System.out.println( "Hello World!" );
        Connection conn = null;
        String sql;
        
        String conn_str = "jdbc:mysql://192.168.1.2:3306/ttss?"
                + "user=root&password=tt8&useUnicode=true&characterEncoding=UTF8";
        try {
            Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动 
            System.out.println("成功加载MySQL驱动程序");
            
            // 一个Connection代表一个数据库连接
            conn = DriverManager.getConnection(conn_str);
            Statement stmt = conn.createStatement();
            sql = "show tables;";
            ResultSet result = stmt.executeQuery(sql);
            if (result != null) {
                while (result.next()) {
                    System.out.println(result.getString(1) + "\t");
                }
            }
        } catch (SQLException e) {
            System.out.println("MySQL操作错误");
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            conn.close();
        }


    }
}

----------------------