Java实现MySQL数据库连接

package demo;

import java.sql.*;
/**
*最原始的jdbc连接方式
*@author sy
*/
public class MysqlConnection
{
  public static void main(String[] args)
  {
    try
    {
      String url="jdbc:mysql://localhost/viscms";
      String user="root";
      String pwd="root";
      
      //加载驱动，这一句也可写为：Class.forName("com.mysql.jdbc.Driver");
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      //建立到MySQL的连接
      Connection conn = DriverManager.getConnection(url,user, pwd);
      
      //执行SQL语句
      Statement stmt = conn.createStatement();//创建语句对象，用以执行sql语言
      ResultSet rs = stmt.executeQuery("select username from jc_user");
     
      //处理结果集
      while (rs.next())
      {
        String name = rs.getString("username");
        System.out.println(name);
      }
      rs.close();//关闭数据库
      conn.close();
    }
    catch (Exception ex)
    {
      System.out.println("Error : " + ex.toString());
    }
  }
}