【微信小程序企业级开发教程】后台用Java操作MySQL表

最新推荐文章于 2024-05-11 03:23:44 发布

理想不闪火

最新推荐文章于 2024-05-11 03:23:44 发布

阅读量540

点赞数

分类专栏：微信小程序企业级开发教程

本文链接：https://blog.csdn.net/weixin_43838785/article/details/112799452

版权

微信小程序企业级开发教程专栏收录该内容

16 篇文章 10 订阅

订阅专栏

文章目录

1 表
2 后端
- 2.1 目录
- 2.2 代码
3 前端

1 表

在这里插入图片描述

2 后端

2.1 目录

在这里插入图片描述

2.2 代码

chaun.java

package top.lixiang007.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;


import net.sf.json.JSON;
import top.lixiang007.bean.place;
import top.lixiang007.utils.DButils;

public class chaxun {

    public static  List<place> chaxun(){
        Connection conn = null;
        ResultSet res =null;
        List<place> palceList = new ArrayList<place>();

        DButils db = new DButils();

        try {
            conn = db.getConnection();
            String sql = "select * from place";
            res = db.eSelect(sql);

            while(res.next()){
                place place = new place();
                place.setName(res.getString(1));
                place.setPosition01(res.getString(2));
                place.setPosition02(res.getString(3));
                place.setPosition03(res.getString(4));
                //
                palceList.add(place);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        try {
            if (conn!=null) {
                conn.close();
                System.out.println("连接关闭");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        try {
            if (res!=null) {
                res.close();
                System.out.println("结果关闭");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        System.out.println(palceList.toString());
        return palceList;
    }




}

上述代码做了一次查询，并且将查询的每一条结果存储到palceList中。
每一个palceList中是一个place对象。
DButils.java

package top.lixiang007.utils;


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



public class DButils {
    private static String dbDriver = "com.mysql.jdbc.Driver";
    private static String serverName = "localhost";
    private static String port = "3306";
    private static String dbName = "wx";
    private static String connURL = "jdbc:mysql://" + serverName + ":" + port + "/" + dbName;
    private static String user1 = "root";
    private static String password = "lixiang666";
    private static Connection conn=null;
    private ResultSet res=null;

    public static Connection getConnection() {
        try {
            Class.forName(dbDriver); //
            conn = DriverManager.getConnection(connURL,user1, password);
            System.out.println("数据库连接成功");
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        return conn;
    }

    // 查询
    public ResultSet eSelect(String sql) {
        try {
            Statement stmt=conn.createStatement();
            res = stmt.executeQuery(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return res;
    }

    //插入数据
    public void insert(String name,String position01,String position02,String position03) throws SQLException {

        try {
            conn =getConnection();
            String sql = "insert into place(name,position01,position02,position03) values"
                    + "('" +name+"','"+position01+"','"+position02+"','"+position03+"')";
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);


        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            conn.close();
        }

    }




}

提供数据库连接方法、查询和插入方法。
server.java

package top.lixiang007.server;
/**
 * 转化成json字符串
 */

import java.util.List;


import net.sf.json.JSONArray;
import top.lixiang007.bean.place;
import top.lixiang007.dao.chaxun;

public class server {
    public String json() {
        JSONArray js = new JSONArray();
        List<place> list = chaxun.chaxun();
        System.out.println(list);
        js = JSONArray.fromObject(list);
        String json = js.toString();
        return json;
    }

}

调用插入

package top.lixiang007.servlet;

import top.lixiang007.utils.DButils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;

@WebServlet("/servlet02")
public class servlet02 extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        response.setContentType("text/html");
        request.setCharacterEncoding("utf-8");//这里是设置一下编码格式

        //获取数据存入数据库
        DButils db = new DButils();

        String name = request.getParameter("name");
        String position01 = request.getParameter("address01");
        String position02 = request.getParameter("address02");
        String position03 = request.getParameter("address03");
        try {
            db.insert( name, position01, position02, position03);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
//http://localhost:8080/wx_background_war_exploded/servlet02?name=wxq&address01=1&address02=1&address03=3
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

调用查询

package top.lixiang007.servlet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

import sun.lwawt.macosx.CSystemTray;
import top.lixiang007.server.*;

@WebServlet("/servlet01")
public class servlet01 extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        response.setContentType("text/html");
        request.setCharacterEncoding("utf-8");//这里是设置一下编码格式
        server s = new server();
        String jsList = s.json();
        System.out.println(jsList);
        response.getWriter().print(jsList);

        //  String id = request.getParameter("lx");
    //    System.out.println(id);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

在这里插入图片描述

3 前端

// pages/sqltest.js
Page({

  /**
   * 页面的初始数据
   */
  data: {
      UserList:null,
  },

  /**
   * 生命周期函数--监听页面加载
   */
  onLoad: function (options) {

  },

  /**
   * 生命周期函数--监听页面初次渲染完成
   */
  onReady: function () {

  },

  /**
   * 生命周期函数--监听页面显示
   */
  onShow: function () {

  },

  /**
   * 生命周期函数--监听页面隐藏
   */
  onHide: function () {

  },

  /**
   * 生命周期函数--监听页面卸载
   */
  onUnload: function () {

  },

  /**
   * 页面相关事件处理函数--监听用户下拉动作
   */
  onPullDownRefresh: function () {

  },

  /**
   * 页面上拉触底事件的处理函数
   */
  onReachBottom: function () {

  },

  /**
   * 用户点击右上角分享
   */
  onShareAppMessage: function () {

  },
  click:function(){
    var that=this
    wx.request({
      url: 'http://localhost:8080/wx_background_war_exploded/servlet01', //仅为示例，并非真实的接口地址
      data: {
    
      },
      header: {
        'content-type': 'application/json' // 默认值
      },
      success (res) {
        console.log(res.data)
        that.setData({UserList:res.data})
      }
    })
  }
})

<!--pages/sqltest.wxml-->
<text>pages/sqltest.wxml</text>
<button type="primary" plain="true" bindtap="click">按钮</button>
<view wx:for="{{UserList}}" wx:key="UserList">
  <view>{{item.id}}</view>
  <view>{{item.name}}</view>
  <view>{{item.position01}}</view>
</view>