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

<?php 
  error_reporting(0);     //防止報(bào)錯(cuò)
  include('mysql.php');
  $result=mysql_query("select * from user"); //根據(jù)前面的計(jì)算出開始的記錄和記錄數(shù)
  // 循環(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連接**
 * 
 * 參數(shù)：
 * conn 連接
 * url mysql數(shù)據(jù)庫連接地址
 * user 數(shù)據(jù)庫登陸賬號(hào)
 * password 數(shù)據(jù)庫登陸暗碼
 * 方法：
 * 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數(shù)據(jù)連接 第一步：加載驅(qū)動(dòng) Class.forName(Driver) 第二步：創(chuàng)建連接
   * DriverManager.getConnection(url, user, password);
   */
  public Connection conn() {
    try {
      Class.forName(driver);
    } catch (ClassNotFoundException e) {
      System.out.println("驅(qū)動(dòng)加載錯(cuò)誤");
      e.printStackTrace();
    }
    try {
      conn = DriverManager.getConnection(url, user, password);
    } catch (SQLException e) {
      System.out.println("數(shù)據(jù)庫鏈接錯(cuò)誤");
      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("數(shù)據(jù)寫入失敗");
      e.printStackTrace();
    }
    return i;
  }
  /*
   * select 寫入
   */
  public static void select() {
    MySQLConnection connection = new MySQLConnection();
    Connection conns; // 獲取連接
    PreparedStatement pst; // 執(zhí)行Sql語句(Statement)
    ResultSet rs; // 獲取返回結(jié)果
    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("數(shù)據(jù)查詢失敗");
      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("數(shù)據(jù)修改失敗");
      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("數(shù)據(jù)刪除失敗");
      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("數(shù)據(jù)庫連接錯(cuò)誤");//鏈接數(shù)據(jù)庫服務(wù)器
 mysql_select_db("messageboard",$conn);//選擇數(shù)據(jù)庫名為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;?>