java.sql.sqlexception:没有为参数3指定值

uinbv5nw 于 2021-06-18 发布在 Mysql

关注(0)|答案(2)|浏览(380)

我编写了一个简单的jsp代码，将pdf文件上传到mysql blob数据库中
我的html代码是

<form method="post" action="uploadfile.jsp" enctype="multipart/form-data">
        <center>
            <table border="1" width="25%" cellpadding="5">
                <thead> 
                        <th colspan="3">Upload File</th>        
                </thead>
                <tbody>
                    <tr>    
                        <td>Title : </td>
                        <td><input type="text" name="title" size="30"></td>
                    </tr>
                    <tr>
                        <td>Choose File : </td>
                        <td><input type="file" name="file_uploaded" /></td>
                    </tr>
                    <tr>
                        <td colspan="3"><center><input type="submit" value="Upload"></center></td>
                    </tr>
                </tbody>             
            </table>
        </center>
    </form>

我的jsp代码是

<%@page import="java.io.*" %>
<%@page import="java.sql.*" %>
<% 
            response.setContentType("text/html;charset=UTF-8");

            InputStream inputStream = null;

           Connection conn=null;
           PreparedStatement st=null;
           ResultSet rs=null;

            String title=(request.getParameter("title"));
            Part filePart = request.getPart("file_uploaded");

            if (filePart != null) 
            {
                out.println(filePart.getName());
                out.println(filePart.getSize());
                out.println(filePart.getContentType());

                inputStream = filePart.getInputStream();
            }

            try 
            {
                String idTemp="1";
                 Class.forName("com.mysql.jdbc.Driver");

  conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fileupload","root","password");

                String sql = "INSERT INTO files (id, title, file) values (?, ?, ?)";
                st = conn.prepareStatement(sql);
                st.setString(1, idTemp);
                st.setString(2, title);

                if (inputStream != null) 
                {
                    st.setBinaryStream(3, inputStream, (int) filePart.getSize());
                }

                int row = st.executeUpdate();
                if (row > 0) 
                {
                    out.println("File uploaded!!!");

                    conn.close();

                    RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                    rd.include(request, response);
                }
                else
                {
                    out.println("Couldn't upload your file!!!");

                    conn.close();

                    RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                    rd.include(request, response);
                }    

            }catch(Exception e){out.print(e);}     
%>

执行此代码之后。我得到错误“java.sql.sqlexception:没有为参数3指定值”
这个代码有什么问题。我的数据库表是空的，我不能上传任何pdf数据
我的数据库sql是

create table files(id int(4),title varchar(20),file mediumblob,primary key(id)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

sql mysql jsp

来源：https://stackoverflow.com/questions/53027058/java-sql-sqlexception-no-value-specified-for-parameter-3

2条答案

按热度按时间

qnyhuwrf1#

我刚刚创建了一个servlet代码。现在它运行良好

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;

@WebServlet("/uploadServlet")
@MultipartConfig(maxFileSize = 16177215)

public class UploadFileController extends HttpServlet 
{
    /**
     * 
     */
private static final long serialVersionUID = 1L;

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException 
{
            response.setContentType("text/html;charset=UTF-8");
            PrintWriter out = response.getWriter();

            InputStream inputStream = null;
            Connection conn=null;
            PreparedStatement st=null;
            ResultSet rs=null;
            String idTemp=request.getParameter("id");
            String title=(request.getParameter("title"));
            String site=request.getParameter("site");
            Part filePart = request.getPart("file_uploaded");

            HttpSession hs=request.getSession(true);
            hs.setAttribute("site", site);

            if (filePart != null) 
            {
                System.out.println(filePart.getName());
                System.out.println(filePart.getSize());
                System.out.println(filePart.getContentType());

                inputStream = filePart.getInputStream();
            }

            try 
            {
                 Class.forName("com.mysql.jdbc.Driver");

                 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database","root","password");
                String sql = "INSERT INTO files (id, title,file) values (?, ?, ?)";
                st = conn.prepareStatement(sql);
                st.setString(1, idTemp);
                st.setString(2, title);
                //st.setString(3, site);

                if (inputStream != null) 
                {
                    st.setBinaryStream(3, inputStream, (int) filePart.getSize());
                }

                int row = st.executeUpdate();
                if (row > 0) 
                {
                    String fileuploaded="fileuploaded";
                    out.println("<script> alert("+fileuploaded+")</script>");

                    conn.close();

                    RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                    rd.include(request, response);
                }
                else
                {
                    out.println("Couldn't upload your file!!!");

                    conn.close();

                    RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
                    rd.include(request, response);
                }    

            }catch(Exception e){out.println(e);}
}

}

赞(0）回复(0）举报 2021-06-18

mspsb9vt2#

您在这一部分遇到了错误。

String sql = "INSERT INTO files (id, title, file) values (?, ?, ?)";
                st = conn.prepareStatement(sql);
                st.setString(1, idTemp);
                st.setString(2, title);

这里需要添加另一个参数。只添加了两个参数，但在查询中声明了三个参数 values (?, ?, ?)

赞(0）回复(0）举报 2021-06-18

我来回答

java.sql.sqlexception:没有为参数3指定值

2条答案

相关问题

热门标签

最新问答