Mac 下 java 连接数据库

1、安装好mysql和java,安装好后可以在系统偏好设置里看到，点击启动mysql

2、下载mysql的jar包，http://download.****.net/detail/u010268947/6765085，然后在工程里引入jar包，右键单击工程，Build Path -> Configure Build Path，右上方有四个按钮，Source，Projects，Libraries，Order and Export  。选择Libraries，点击下面的

 Add External JARS，选择刚才下载的Jar包所在路径安装

3、代码连接数据库

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import java.sql.DriverManager;

public class student 

{

static Connectionconn = null;

static Statementst = null;

static ResultSetrs = null;

public static void main(String[] args) throws Exception

{

  Class.forName("com.mysql.jdbc.Driver");

String url ="jdbc:mysql://localhost:3306/databaseName?user=root&password=123456

&useUnicode=true&characterEncoding=utf-8

";

conn = DriverManager.getConnection(url);

st = (Statement)conn.createStatement();

String query ="select * from table";

rs = st.executeQuery(query);

 

  while(rs.next())

  {

  System.out.println(rs.getString("name"));

  }

}

}