java连接mysql

import java.sql.*;

public class MysqlTest {
    public static void main(String[] args) {
        // 驱动程序名
        String driver = "org.gjt.mm.mysql.Driver";
        // URL指向要访问的数据库名world
        // String url = "jdbc:mysql://127.0.0.1:3306/xh";
        String url = "jdbc:mysql://localhost/xh";
        // MySQL配置时的用户名
        String user = "xiaohengdada";
        // MySQL配置时的密码
        String password = "123456";
        String name;
        try {
            // 加载驱动程序
            Class.forName(driver);
            // 连续数据库
            Connection conn = DriverManager.getConnection(url, user, password);
            if (!conn.isClosed())
                System.out.println("Succeeded connecting to the Database!");
            // statement用来执行SQL语句
            Statement statement = conn.createStatement();
            // 要执行的SQL语句
            String sql = "select * from students";

            // 结果集
            ResultSet rs = statement.executeQuery(sql);
            System.out.println(rs);
            System.out.println("Succeeded connecting to the Database!");
            while (rs.next()) {
                // 选择Name这列数据
                name = rs.getString("name");
                // 输出结果
                System.out.println(name);
            }
            rs.close();//关闭当前的结果集
            statement.close();//关闭statement对象以及所对应的结果集
            conn.close();//关闭当前的连接以及释放由它所创建的JDBC资源
        } catch (ClassNotFoundException e) {
            System.out.println("Sorry,can`t find the Driver!");
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

需要在mysql建立相关数据库及表。

连接成功，会输出如下数据。

 

具体的配置可以参考此链接;http://database.51cto.com/art/201006/204217.htm

 

 

下面是获取表中id字段：

import java.sql.*;

public class MysqlTest
{
    public static void main(String[] args)
    {
        String driver="org.gjt.mm.mysql.Driver";
        String url="jdbc:mysql://localhost/xh";
        String user="xiaohengdada";
        String password="123456";
        //int id;
        int id1;
    
    
    try
    {
        Class.forName(driver);
        Connection conn=DriverManager.getConnection(url,user,password);
        if (!conn.isClosed())
            System.out.println("Succeeded connecting to be Database!");
        
        Statement statement=conn.createStatement();
        ResultSet rs=statement.executeQuery("select * from students");
        
        System.out.println(rs);
        while(rs.next())
        {
            id1=rs.getInt("id");
            System.out.println(id1);
        }
        rs.close();
        statement.close();
        conn.close();    
    }
    catch(ClassNotFoundException e)
    {
        System.out.println("Sorry,can't find the Driver!");
        e.printStackTrace();
    }
    catch(SQLException e)
    {
        e.printStackTrace();
    }
    catch(Exception e)
    {
        e.printStackTrace();
    }
    }
}