mysql连接数据库

在程序中引入mysql的驱动包mysql-connector-java-5.0.5-bin.jar

完整的程序如下：
package mysql;

import java.sql.*;

public class MysqlTest {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO 自动生成方法存根
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   conn = DriverManager.getConnection("jdbc:mysql://localhost/test?"
     + "user=root&password=520wjb");
   stmt = conn.createStatement();
   String str = "Select * from users;";
   rs = stmt.executeQuery(str);
   while (rs.next()) {
    System.out.println(rs.getInt(1));
    System.out.println(rs.getString(2));

   }

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
   System.out.println("SQLException: " + ex.getMessage());
   System.out.println("SQLState: " + ex.getSQLState());
   System.out.println("VendorError: " + ex.getErrorCode());
  } finally {
   try {
    if (rs != null) {
     rs.close();
     rs = null;
    }

    if (stmt != null) {
     stmt.close();
     stmt = null;
    }

    if (conn != null) {
     conn.close();
     conn = null;
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }

 }

}