如何使用预处理语句在mysql数据库中编写AES加密查询

问题描述

<%@ page import="java.sql.*,databaseconnection.*"%>
<%
Connection con=null;
PreparedStatement psmt1=null;

String tit=request.getParameter("tit");
String min=request.getParameter("minvalue");
String max=request.getParameter("maxvalue");
String disc=request.getParameter("disc");
System.out.println(tit);
String [] title=tit.split(":");

try{
con=databasecon.getconnection();
String sql="insert into medication(tid,titname,minvalue,maxvalue,disc) values(AES_ENCRYPT(?, 'key'),AES_ENCRYPT(?, 'key'),AES_ENCRYPT(?, 'key'),AES_ENCRYPT(?,'key'),AES_ENCRYPT(?,'key'))";
System.out.println("Insert#"+sql);

psmt1=con.prepareStatement(sql);
psmt1.setString(1,title[0]);
psmt1.setString(2,title[1]);
psmt1.setString(3,min);
psmt1.setString(4,max);
psmt1.setString(5,disc);
psmt1.executeUpdate();

response.sendRedirect("providerhome.jsp?message=success");
}
catch(Exception ex)
{
out.println("Error in connection : "+ex);
}

%>

我尝试过：



这是我的代码，但没有插入表格。

What I have tried:

This is my code but which is not inserting into a table.

推荐答案

这篇关于如何使用预处理语句在mysql数据库中编写AES加密查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！