JDBC连接mysql的简单DEMO程序

import java.sql.*;

public class Mysql_Demo {
	public static void main(String[] args) throws Exception{
		//驱动程序名
		String driver = "com.mysql.jdbc.Driver";
		//URL指向要访问的数据库
		String url = "jdbc:mysql://localhost/world";
		//MySQL配置时的用户名
		String user = "root";
		//MySQL配置时的密码
		String password = "password";
		
		try{
			//加载驱动程序
			Class.forName(driver);
			//连接数据库
			Connection con = DriverManager.getConnection(url, user, password);
			
			if(!con.isClosed())
				System.out.println("数据库连接成功！");
			
			//创建statement来执行SQL语句
			Statement statement = con.createStatement();
			
			//创建要执行的SQL语句
			String sql = "select * from city";
			//创建集合来保存结果
			ResultSet rs = statement.executeQuery(sql);
			
			System.out.println("查询结果显示如下");
			
			while(rs.next()) {
				//获取表中对应列的数据
				int id = rs.getInt("ID");
				String name = rs.getString("Name");
				//显示数据
				System.out.println("ID:" + id + " Name:" + name);
			}
			
			//关闭数据库环境
			rs.close();
			statement.close();
			con.close();
		} catch(ClassNotFoundException e){
			e.printStackTrace();
		}
	}
}