连接mysql数据库(4)

import java.sql.*;

public class Mysql
{
public static void main(String[] args)
{
    try {
      String driver = "org.gjt.mm.mysql.Driver";
      String url = "jdbc:mysql://localhost:3306/server";//server是数据库名
      String user = "root";
      String password = "74376";

      Connection conn = null;
      ResultSet rs = null;
      Statement stmt = null;

      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url, user, password);

//这两句就已经连接了数据库了加载驱动然后通过用户名(url)密码(password)连接到相应的数据库(url),后面是对数据库的操作了.

      stmt = conn.createStatement();
      rs = stmt.executeQuery("select * from agenthost");
      while (rs.next()) {
        System.out.println("" + rs.getInt(1) + "");
        System.out.println(":" + "
");
      }
      rs.close();
      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
}