java连接mysql数据库

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();
		}
		
	}

}