Java连接MySQL方法

首先，MySQL肯定是要安装的，然后呢，下载一个关键驱动：mysql-connector-java-5.1.20-bin.jar;

注意要在程序里面，把这个库引用进来：

import java.sql.*;
public class Main {

	/**
	 * @author ZJC
	 * Java连接MySQL示例
	 */
	//mysql配置时的用户名
	static String userName = "root";
	//mysql配置时的密码
	static String Password = "643872dx";
	private static String driverName = "com.mysql.jdbc.Driver";
	//url指向要访问的数据库名mydb
	static private String url = "jdbc:mysql://127.0.0.1:3306/mydb";
	static Connection dbConn;
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		System.out.println("dwfewf");
		Connection temp = OpenDB();

	}
	static Connection OpenDB()
	{
		
		try
		{
			//加载驱动程序
			Class.forName(driverName);
			dbConn = DriverManager.getConnection(url,userName,Password);
			if(!dbConn.isClosed())
				System.out.println("success!");
			// statement用来执行SQL语句
			Statement statement = dbConn.createStatement();
			// 要执行的SQL语句
			ResultSet rs = statement.executeQuery("select * from mydb");
			System.out.println("dqd");
			while(rs.next())
			{
				System.out.println(rs.getString("id"));
			}
			System.out.println("dhwed");
			//数据库切换
			rs = statement.executeQuery("use test_navi");
			rs = statement.executeQuery("select * from test_navi");
			
			while(rs.next())
			{
				System.out.println(rs.getString("attack"));
			}
		
		}
		catch(Exception e)
		{
			System.out.print(e);
		}
		return dbConn;
	}

}

运行结果：