package link;
 import java.sql.*;
 /**
 * 使用JDBC連接數(shù)據(jù)庫(kù)MySQL的過(guò)程
 * DataBase：fuck， table：person；
 * 使用myeclipse對(duì)mysql數(shù)據(jù)庫(kù)進(jìn)行增刪改查的基本操作。
 */
 public class JDBCTest {
  public static Connection getConnection() throws SQLException,
  java.lang.ClassNotFoundException
  {
  //第一步：加載MySQL的JDBC的驅(qū)動(dòng)
  Class.forName("com.mysql.jdbc.Driver");
  //取得連接的url,能訪(fǎng)問(wèn)MySQL數(shù)據(jù)庫(kù)的用戶(hù)名,密碼；jsj：數(shù)據(jù)庫(kù)名
  String url = "jdbc:mysql://localhost:/fuck";
  String username = "root";
  String password = "";
  //第二步：創(chuàng)建與MySQL數(shù)據(jù)庫(kù)的連接類(lèi)的實(shí)例
  Connection con = DriverManager.getConnection(url, username, password);
  return con;
  }
  public static void main(String args[]) {
  try
  {
  //第三步：獲取連接類(lèi)實(shí)例con，用con創(chuàng)建Statement對(duì)象類(lèi)實(shí)例 sql_statement
  Connection con = getConnection();
  Statement sql_statement = con.createStatement();
  //如果同名數(shù)據(jù)庫(kù)存在，刪除
  //sql_statement.executeUpdate("drop table if exists student");
  //執(zhí)行了一個(gè)sql語(yǔ)句生成了一個(gè)名為student的表
  //sql_statement.executeUpdate("create table student (id int not null auto_increment, name varchar() not null default 'name', math int not null default , primary key (id) ); ");
  //向person表中插入數(shù)據(jù)
  sql_statement.executeUpdate("insert person values(, 'liying', )");
  sql_statement.executeUpdate("insert person values(, 'jiangshan', )");
  sql_statement.executeUpdate("insert person values(, 'wangjiawu', )");
  sql_statement.executeUpdate("insert person values(, 'duchangfeng', )");
  //第四步：執(zhí)行查詢(xún)，用ResultSet類(lèi)的對(duì)象，返回查詢(xún)的結(jié)果
  String query = "select * from person";
  ResultSet result = sql_statement.executeQuery(query);
  //顯示數(shù)據(jù)中person表中的內(nèi)容：
  System.out.println("person表中的數(shù)據(jù)如下:");
  System.out.println("------------------------");
  System.out.println("序號(hào)" + " " + "姓名" + " " + "分?jǐn)?shù)");
  System.out.println("------------------------");
  //對(duì)獲得的查詢(xún)結(jié)果進(jìn)行處理，對(duì)Result類(lèi)的對(duì)象進(jìn)行操作
  while (result.next())
  {
  int number = result.getInt("number");
  String name = result.getString("name");
  String mathsorce = result.getString("mathsorce");
  //取得數(shù)據(jù)庫(kù)中的數(shù)據(jù)
  System.out.println(" " + number + " " + name + " " + mathsorce);
  }
  //關(guān)閉連接和聲明
  sql_statement.close();
  con.close();
  } catch(java.lang.ClassNotFoundException e) {
  System.err.print("ClassNotFoundException");
  System.err.println(e.getMessage());
  } catch (SQLException ex) {
  System.err.println("SQLException: " + ex.getMessage());
  }
  }
  }