<?php
/*****************************
*數據庫連接
*****************************/
$conn = @mysql_connect("localhost","root","123");
if (!$conn){
  die("連接數據庫失敗：" . mysql_error());
}
mysql_select_db("test", $conn);
//字符轉換，讀庫
mysql_query("set character set utf8");
mysql_query("set names utf8");
?>

<?php 
  error_reporting(0);     //防止報錯
  include('mysql.php');
  $result=mysql_query("select * from user"); //根據前面的計算出開始的記錄和記錄數
  // 循環(huán)取出記錄
  $six;
  while($row=mysql_fetch_row($result))
  {  
  echo $row[0];
  echo $row[1];
  }
?>

package com.mysqltest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/*
 * **Mysql連接**
 * 
 * 參數：
 * conn 連接
 * url mysql數據庫連接地址
 * user 數據庫登陸賬號
 * password 數據庫登陸密碼
 * 方法：
 * conn 獲取連接
 */
public class MySQLConnection {
  public static Connection conn = null;
  public static String driver = "com.mysql.jdbc.Driver";
  public static String url = "jdbc:mysql://127.0.0.1:3306/post";
  public static String user = "root";
  public static String password = "123";
  /*
   * 創(chuàng)建Mysql數據連接 第一步：加載驅動 Class.forName（Driver） 第二步：創(chuàng)建連接
   * DriverManager.getConnection(url, user, password);
   */
  public Connection conn() {
    try {
      Class.forName(driver);
    } catch (ClassNotFoundException e) {
      System.out.println("驅動加載錯誤");
      e.printStackTrace();
    }
    try {
      conn = DriverManager.getConnection(url, user, password);
    } catch (SQLException e) {
      System.out.println("數據庫鏈接錯誤");
      e.printStackTrace();
    }
    return conn;
  }
}

package com.mysqltest;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/*
 * mysql增刪改查
 */
public class Work {
  /*
   * insert 增加
   */
  public static int insert() {
    MySQLConnection connection = new MySQLConnection();
    Connection conns; // 獲取連接
    PreparedStatement pst; // 執(zhí)行Sql語句
    int i = 0;
    String sql = "insert into user (username,password) values(?,?)";
    try {
      conns = connection.conn();
      pst = conns.prepareStatement(sql);
      pst.setString(1, "lizi");
      pst.setString(2, "123");
      i = pst.executeUpdate();
      pst.close();
      conns.close();
    } catch (SQLException e) {
      System.out.println("數據寫入失敗");
      e.printStackTrace();
    }
    return i;
  }
  /*
   * select 寫入
   */
  public static void select() {
    MySQLConnection connection = new MySQLConnection();
    Connection conns; // 獲取連接
    PreparedStatement pst; // 執(zhí)行Sql語句(Statement)
    ResultSet rs; // 獲取返回結果
    String sql = "select * from user";
    try {
      conns = connection.conn();
      pst = conns.prepareStatement(sql);
      rs = pst.executeQuery(sql);// 執(zhí)行sql語句
      System.out.println("---------------------------------------");
      System.out.println("名字    |    密碼");
      while (rs.next()) {
        System.out.println(rs.getString("username") + "    |    " + rs.getString("password"));
      }
      System.out.println("---------------------------------------");
      conns.close();
      pst.close();
      rs.close();
    } catch (SQLException e) {
      System.out.println("數據查詢失敗");
      e.printStackTrace();
    }
  }
  /*
   * update 修改
   */
  public static int update() {
    MySQLConnection connection = new MySQLConnection();
    Connection conns; // 獲取連接
    PreparedStatement pst; // 執(zhí)行Sql語句(Statement)
    int i = 0;
    String sql = "update user set password = ? where username = ?";
    try {
      conns = connection.conn();
      pst = conns.prepareStatement(sql);
      pst.setString(1, "123");
      pst.setString(2, "lizi");
      i = pst.executeUpdate();
      pst.close();
      conns.close();
    } catch (SQLException e) {
      System.out.println("數據修改失敗");
      e.printStackTrace();
    }
    return i;
  }
  /*
   * delete 刪除
   */
  public static int delete() {
    MySQLConnection connection = new MySQLConnection();
    Connection conns; // 獲取連接
    PreparedStatement pst; // 執(zhí)行Sql語句(Statement)
    int i = 0;
    String sql = "delete from user where username = ?";
    try {
      conns = connection.conn();
      pst = conns.prepareStatement(sql);
      pst.setString(1, "lizi");
      i = pst.executeUpdate();
      pst.close();
      conns.close();
    } catch (SQLException e) {
      System.out.println("數據刪除失敗");
      e.printStackTrace();
    }
    return i;
  }
  /*
   * test
   */
  public static void main(String[] args) {
    // System.out.println(insert());
     select();
    // System.out.println(update());
    // System.out.println(delete());
  }
}

<?php
 $conn=@mysql_connect("localhost","root","")or die("數據庫連接錯誤");//鏈接數據庫服務器
 mysql_select_db("messageboard",$conn);//選擇數據庫名為messageboard
 mysql_query("set names 'utf'");//使用utf編碼，這里不能寫成utf-否則將顯示亂碼，但UTF不區(qū)分大小寫
 ?>

<>$sql=mysql_query("select * from tb_book");
$info=mysql_fetch_object($sql);
<>$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'")；
$info=mysql_fetch_object($sql);

<>$sql=mysql_query("select * from tb_book");
$info=mysql_fetch_object($sql);
<>$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'");
$info=mysql_fetch_object($sql);

<>$sql=mysql_query("select * from tb_book");
$row=mysql_fetch_row($sql);
<>$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'");
$row=mysql_fetch_row($sql);

$sql=mysql_query("select * from tb_book");
......
<?php $nums=mysql_num_rows($sql);echo $nums;?>