eclipse在mysql中执行修改，查询

使用前请先导入MySQL驱动包(官网下载)，，然后调用方法

package com.zhiyou.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.mysql.jdbc.Driver;
public class Demo_1 {
	public static void main(String[] args) {
		/*updateDate();
                 *quaryAll();
                 */
	}
	//id,name,age
	//修改过程
	public static void updateData() {
	//1.加载驱动
	try {
		Class.forName("com.mysql.jdbc.Driver");
	//2.获取连接
		String url = "jdbc:mysql://127.0.0.1:3306/student_db";
		Connection connection = DriverManager.getConnection(url,"root","123456");
	//3.获取Statement,执行sql语句
		Statement statement = connection.createStatement();
		String sql = "update student set age=19 where id=5;";
		statement.execute(sql);
	//4.关闭资源
		statement.close();
		connection.close();
		
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	}
	
	//查询
	public static void quaryAll() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://127.0.01:3306/student_db";
			Connection connection = DriverManager.getConnection(url, "root","123456");
			Statement statement = connection.createStatement();
			String sql = "select id,name,age from student";
			//执行
			ResultSet set = statement.executeQuery(sql);
			//遍历结果积
			while(set.next()) {
				//使用set获取各个字段的值
				//id
				//列的索引从1开始
				int id = set.getInt(1);
				int id2 = set.getInt("id");
				//name
				String name = set.getString("name");
				//age
				int age = set.getInt("age");
				System.out.println(id+"  "+ id2+"   "+name+"   "+age);
						 
			}
			//关闭资源
			set.close();
			statement.close();
			connection.close();
			
			
			
		} catch (ClassNotFoundException | SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}