JAVA连接数据库

package Sumumu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class test1 {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
     //1 加载驱动
      Class.forName("com.mysql.jdbc.Driver");
         //2 获得数据库的连接
      Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Sumumu", "root", "");
     // System.out.println(con);
      //（3）准备执行语句
      String sql = "select * from student";
      PreparedStatement pst = (PreparedStatement) con.prepareStatement(sql);
      //（4）执行
      ResultSet rs = pst.executeQuery();
      while(rs.next()){
          int id = rs.getInt("id");
          String name = rs.getString("name");
          int age = rs.getInt("age");
          System.out.println("id:" + id + "    " + "name:" + name + "    " + "age:" + age);
      }
      //（5）关闭资源，关闭连接
      rs.close();
      pst.close();
      con.close();
}

}