myeclipse用jdbc连接mysql数据库

Question

package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBTest {
/**

• @param args
  */

  private static final String url="jdbc:mysql://localhost:3306/db_shop";
  private static final String name="root";
  private static final String password="root";

  static{
  try {
  //加载驱动程序；
  Class.forName("com.mysql.jdbc.Driver");
  //获得数据库连接；
  }catch(ClassNotFoundException e){
  e.printStackTrace();
  }
  }
  public static void main(String[] args){
  try{
  Connection conn=DriverManager.getConnection(url,name,password);
  System.out.println("数据库连接成功"+conn);
  }catch(SQLException e){
  e.printStackTrace();
  }
  }

  New Database Connection Driver中Test Driver出现Error while performing database login with the db_shop driver:Unable to create connection.Check your URL.

Answer 1

public class JdbcDemo
{

public static void main(String[] args) 
{   
    ResultSet result = null;
    Statement statement = null;
    //在这里为了减少代码量，便于阅读，就把所有代码块都放在一个tyr catch语句里面了，实际开发中应该不提倡这样做。
    try {
        //第一步，加载jdbc驱动
        Class.forName("com.mysql.jdbc.Driver");
        //第二步，获得数据库的地址，用户名，密码
        String url = "jdbc:mysql://localhost:3306/android";
        String username = "root";
        String password = "";
        //第三步，获得地址，用户名，密码后，给我一个与该数据库的连接
        Connection connection = null;
        connection = (Connection) DriverManager.getConnection(url,username,password);
        //第四步，获得连接实例connection的目的是对数据库进行操作，这就要用到Statement,
        statement = (Statement) connection.createStatement();
        //第五步，执行查询操作，鉴于连接是否成功
        String query = "SELECT * FROM test";//test是表名
        result = statement.executeQuery(query); 
            while(result.next())
            {
                int id = result.getInt(1);
                String s1 = result.getString(2);
                String s2 = result.getString(3);
                String s3 = result.getString(4);
                System.out.println("id="+id+"s1="+s1+"s2="+s2+"s3="+s3);
            }
        } 
    catch (Exception e) 
        {
            System.out.println(e.getMessage());
        }
}

}