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