Java连接Mysql

一、Java 连接 Mysql 语句

String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/school";
String user = "sa";
String password = "123";

二、JAVA连接Mysql都要用到驱动程序 

Mysql需要一个jar包：mysql-connector-java-5.1.18-bin.jar   下载链接： 点击打开链接

三、mysql-connector-java-5.1.18-bin.jar包需要添加到项目的lib文件下，同时需要构建引用的库，如下图显示

四、一个具体的例子

import java.sql.*; 

public class JavaConnectMysql {

	public static void main(String[] args) {		
		// TODO 自动生成的方法存根
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/school";
		String user = "sa";
		String password = "123";
		Connection dbConn;
		
		try{
			Class.forName(driver);
			dbConn = DriverManager.getConnection(url,user,password);
			System.out.print("Connection Successful !");
		}catch(Exception e)
		{
			e.printStackTrace();
			
		}		
	}
}

import java.sql.*; 

public class JavaConnectMysql {

	public static void main(String[] args) {		
		// TODO 自动生成的方法存根
		
		Connection dbConn;
		//声明Connection对象
		
		/**
		 * 驱动程序名
		 * URL指向要访问的数据库名school
		 * MySQL配置时的用户名
		 * MySQL配置时的密码
		 */
		String driver = "com.mysql.jdbc.Driver";          
		String url = "jdbc:mysql://localhost:3306/school";
		String user = "sa";
		String password = "123";
		
		try{
			Class.forName(driver);
			//加载驱动程序
			dbConn = DriverManager.getConnection(url,user,password);
			//getConnection()方法，连接MySQL数据库！
			System.out.print("Connection Successful !");
			System.out.println();
			
			Statement statement = dbConn.createStatement();
			//创建statement类对象，用来执行SQL语句！
			String sql = "select * from students";
			ResultSet rs = statement.executeQuery(sql);
			//ResultSet类，用来存放获取的结果集！
			
			System.out.println("-----------------------");
            System.out.println("执行结果如下所示:");  
            System.out.println("-----------------------");  
            System.out.println("编号" + "\t" + " 姓名" + "\t" + "年龄");  
            System.out.println("-----------------------");  
            
			String ID = null;
			String name = null;
			String age = null;
			
			while(rs.next()){
				ID = rs.getString("ID");
				name = rs.getString("name");
				age = rs.getString("age");
				
				System.out.print(ID + "\t" + name + "\t" + age);
				System.out.println();
			}
			rs.close();
			dbConn.close();
						 
		}catch(Exception e)
		{
			e.printStackTrace();
			
		}		
	}
}