java连接mysql

package com.wangchong.study.sql;

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

public class SimpeleJdbc {

    /**
     * @param args
     */
    public static void main(String[] args) throws SQLException,
            ClassNotFoundException {
        // 加载mysql的驱动
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("Driver loaded");

        // 建立一个连接
        Connection connection = DriverManager.getConnection(
                "jdbc:mysql://localhost/test", "root", "XXXXXXXXX"); //三个引号内分别是本地数据库，mysql的用户名，密码
        System.out.println("Database connected");

        // 创建一个Statement
        Statement statement = connection.createStatement();

        // 定义sql语句
        String create_sql = "create table student(id int,name varchar(20),primary key(id))";
        String insert_sql = "insert into student values(1,'zhao')";
        String insert2_sql = "insert into student values(2,'qian')";
        String select_sql = "select * from study";

        // 执行sql语句
        // 当sql语句会更改数据库时，应该用executeUpdate方法，如果失败，返回一个-1
        // 查询用executeQuery方法
        int resultset = statement.executeUpdate(create_sql);
        System.out.println("success1");
        resultset = statement.executeUpdate(insert_sql);
        System.out.println("success2");
        resultset = statement.executeUpdate(insert2_sql);
        System.out.println("success3");
        ResultSet rs = statement.executeQuery(select_sql);
        System.out.println("success4");

        while (rs.next()) {
            System.out.println(rs.getString(1) + "\t" + rs.getString(2));
        }
        // close connection
        connection.close();
    }
}

在之前需要把mysql的驱动jar包导入到项目中，
提供下载地址：http://pan.baidu.com/s/1uPHIA