java连接mysql数据库

原文链接：http://blog.csdn.net/motian06/article/details/17378189

sdk安装略过

mysql安装略过

eclipse安装略过

java连接mysql数据库 需要对应的jdbc驱动（下载地址http://dev.mysql.com/downloads/connector/j/，mysql-connector-java-5.1.27.zip）

解压放置在相应位置，以下为我的路径

D:\MySQL\jdbc\mysql-connector-java-5.1.27-bin.jar

环境变量CLASSPATH追加以上路径

java代码：

package test;  
  
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
  
public class JDBCMySQL {  
      
    //DBDRIVER  驱动-固定  
    public static final String DBDRIVER = "com.mysql.jdbc.Driver";  
    //DBURL     IP地址、端口号、数据库  
    public static final String DBURL = "jdbc:mysql://127.0.0.1:3306/test";  
    //DBUSER    MySQL用户名  
    public static final String DBUSER = "root";  
    //DBPASSWORD    MySQL密码  
    public static final String DBPASSWORD = "root";  
  
    public static void main(String[] args) {  
        // TODO Auto-generated method stub  
          
        //数据库的连接对象  
        Connection conn = null;  
        //PreparedStatement 预处理  
        PreparedStatement pstmt = null;  
        //ResultSet 结果集  
        ResultSet result = null;  
          
        //sql  
        String sql = "select * from jdbc_mysql";  
          
        try {  
            //使用Class类加载驱动  
            Class.forName(DBDRIVER);  
            //连接数据库  
            conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);  
            //实例化PreparedStatement  
            pstmt = conn.prepareStatement(sql);  
            //返回结果集  
            result = pstmt.executeQuery();  
            //输出结果集  
            while (result.next()) {  
                String content = result.getString("content");  
                System.out.println(content);  
            }  
              
        } catch (ClassNotFoundException e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        } catch (SQLException e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        }  
          
    }  
  
}