本講內(nèi)容首先講解jQuery對ajax的支持，分別講解$.post,$.get,$.ajax等方法，這些方法的參數(shù)，使用方法及區(qū)別。最后對ajax的綜合應(yīng)用舉例：在同一個頁面實現(xiàn)新增，修改，刪除學(xué)校資料，分頁列表等功能，前端使用html靜態(tài)頁面，使用MySQL數(shù)據(jù)庫，后臺使用servlet技術(shù)實現(xiàn)。文章來源地址http://www.zghlxwxcb.cn/news/detail-507545.html

基礎(chǔ)環(huán)境要求

?數(shù)據(jù)表結(jié)構(gòu)

CREATE TABLE `college`  (
  `collegeId` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
  `collegeName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '學(xué)校名稱',
  `collegeAddr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '學(xué)校地址',
  `pic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '學(xué)校圖片',
  `contact` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '聯(lián)系人',
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '電話',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '說明',
  PRIMARY KEY (`collegeId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '學(xué)校表' ROW_FORMAT = Dynamic;

CollegeVo.java

package com.bean;

import java.io.Serializable;


public class CollegeVo implements Serializable {

    private int collegeId;
    private String collegeName;
    private String pic;
    private String collegeAddr;
    private String contact;
    private String tel;
    private String remark;


    public int getCollegeId() {
        return collegeId;
    }

    public void setCollegeId(int collegeId) {
        this.collegeId = collegeId;
    }

    public String getCollegeName() {
        return collegeName;
    }

    public void setCollegeName(String collegeName) {
        this.collegeName = collegeName;
    }

    public String getPic() {
        return pic;
    }

    public void setPic(String pic) {
        this.pic = pic;
    }

    public String getCollegeAddr() {
        return collegeAddr;
    }

    public void setCollegeAddr(String collegeAddr) {
        this.collegeAddr = collegeAddr;
    }

    public String getContact() {
        return contact;
    }

    public void setContact(String contact) {
        this.contact = contact;
    }

    public String getTel() {
        return tel;
    }

    public void setTel(String tel) {
        this.tel = tel;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }
}

?數(shù)據(jù)庫連接類（DBConn.java）

package com.dao;

import java.sql.Connection;
import java.sql.DriverManager;

/*
* MySQL數(shù)據(jù)庫的連接類
* */
public class DBConn {
    /*
    驅(qū)動
    mysql-connector-java-5.1.48.jar(支持mysql5.7,8.0等版本,字符集utf-8)
     */
    //必須導(dǎo)入mysql-connector-java-5.1.48.jar，才能找到com.mysql.jdbc.Driver驅(qū)動類
    static String driver="com.mysql.jdbc.Driver";
    //連接字符串,localhost(127.0.0.1)表示本機(jī),3306是MySQL的默認(rèn)端口,qq是數(shù)據(jù)庫名稱
    static String url= "jdbc:mysql://localhost:3306/practice?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true";
    //登錄名稱
    static String username = "root";
    //登錄密碼
    static String password = "1234";
    //靜態(tài)變量
    static Connection conn;

    //靜態(tài)代碼塊，程序啟動不需要調(diào)用該代碼，系統(tǒng)會自動執(zhí)行,并且只會執(zhí)行一次
    static {
        try {
            //1.加載驅(qū)動
            Class.forName(driver);
            //2.創(chuàng)建連接,執(zhí)行該語句，如果沒有異常出現(xiàn)，則數(shù)據(jù)庫連接成功
            conn = DriverManager.getConnection(url, username, password);
        }catch (Exception ex){
            ex.printStackTrace();
        }
    }

    //創(chuàng)建連接的函數(shù)
    public static Connection open(){
        try {
            //如果conn沒有連接到數(shù)據(jù)庫，或者說斷開了與數(shù)據(jù)庫連接，則重新連接一次
            if (conn == null || conn.isClosed()) {

                //如果斷開了與數(shù)據(jù)庫的連接，再重新建立連接
                conn = DriverManager.getConnection(url,username,password);

            }else{
                return conn;  //如果正常連接，直接返回
            }
        }catch (Exception e){
            e.printStackTrace();
        }

        return conn;
    }

    //關(guān)閉連接
    public static void close(){
        try{
            if(conn != null || !conn.isClosed()){
                conn.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

?數(shù)據(jù)庫操作類（CollegeDAO.java）

package com.dao;

import com.bean.CollegeVo;
import com.bean.PageObject;
import com.bean.ProvinceVo;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


public class CollegeDAO {

    //新增學(xué)校
    public boolean add(CollegeVo t) {
        try {
            Connection conn = DBConn.open();
            Statement stmt = conn.createStatement();
            String sql = "insert into college(collegeName,contact,tel,collegeAddr,remark,pic) values('";
            sql += t.getCollegeName() + "','";
            sql += t.getContact() + "','";
            sql += t.getTel() + "','";
            sql += t.getCollegeAddr() + "','";
            sql += t.getRemark() + "'

到了這里，關(guān)于第9講：使用ajax技術(shù)實現(xiàn)增刪改查及分頁顯示功能（jQuery）的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！