Android+mysql+tomcat

不写程序的程序猿

已于 2023-12-11 17:07:24 修改

阅读量45

点赞数

文章标签： android mysql tomcat

于 2023-12-07 08:29:51 首次发布

本文链接：https://blog.csdn.net/qq_17768595/article/details/134845726

版权

本文介绍了一个Android应用如何通过Java连接MySQL数据库并利用Tomcat服务器进行数据交互。涉及到的关键技术包括OkHttp库、Gson库以及数据库连接操作。在LoginServlet和apk0010Servlet中，展示了预处理SQL语句、获取ResultSet并转换成JSON对象的过程。

摘要由CSDN通过智能技术生成

java

需要的JAR
gson-2.8.9.jar
okhttp-4.2.2.jar

Utils.java
package com.sdd.utils;

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

public class DBUtils {
public static Connection conn;
public static Statement statement;
public static ResultSet resultSet;
private static final String driver = “oracle.jdbc.driver.OracleDriver”;

public static Connection somadb() {
    final String url = "";
    final String user = "";
    final String password = "";
        
    try {
        Class.forName(driver);//数据库驱动程序的加载
        conn = DriverManager.getConnection(url, user, password);
    } catch (Exception e) {
        e.printStackTrace();
    }

System.out.println(“连接成功~~~”);
return conn;
}

public static void closeConn() {
    if(conn != null) {
        try {
            conn.close();
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

}

SetJson.java
package com.sdd.servlet;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import net.sf.json.JSONArray;
import net.sf.json.JSONException;
import net.sf.json.JSONObject;

public class SetJson {

public static String resultSetToJson(ResultSet rs) throws SQLException, JSONException {
    // json数组
    JSONArray array = new JSONArray();

    // 获取列数
    ResultSetMetaData metaData = rs.getMetaData();
    int columnCount = metaData.getColumnCount(); // 获得该ResultSet所有列的数目

    // 遍历ResultSet中的每条数据
    while (rs.next()) {
        JSONObject jsonObj = new JSONObject();

        // 遍历每一列
        for (int i = 1; i <= columnCount; i++) {
            String columnName = metaData.getColumnLabel(i); // 获取列的标题
            String value = rs.getString(columnName); // 获取列标题的值
            jsonObj.put(columnName, value);
        }
        array.add(jsonObj);
    }
    return array.toString();
}

}

LoginServlet.java

package com.sdd.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
//import java.sql.Statement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

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 com.sdd.utils.DBUtils;
import net.sf.json.JSONArray;
import net.sf.json.JSONException;
import net.sf.json.JSONObject;

@WebServlet(name = “login.do”, value=“/login.do”)
public class LoginServlet extends HttpServlet {
public static Connection conn;
public static PreparedStatement pstmt;
public static ResultSet res;
public static String result = null;

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)

thro