首页 / SERVLET / 如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像

如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含10135字，纯文字阅读大概需要15分钟。

内容图文

我正在尝试在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像.单击“保存”按钮时,它显示为空.我没有任何错误.

我也设置commons-fileupload.jar文件和commons-io.jar文件.如果您有一些演示代码,请给我.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
      <title>File Upload to Database Demo</title>
    </head>
    <body>
      <center>
        <h1>File Upload to Database Demo</h1>
        <form method="post" action="FileUploadDBServlet" enctype="multipart/form-data">
        <table border="0">
            <tr>
                <td>First Name: </td>
                <td><input type="text" name="firstName" size="50"/></td>
            </tr>
            <tr>
                <td>Last Name: </td>
                <td><input type="text" name="lastName" size="50"/></td>
            </tr>
            <tr>
                <td>Portrait Photo: </td>
                <td><input type="file" name="photo" size="50"/></td>
            </tr>
            <tr>
                <td colspan="2">
                    <input type="submit" value="Save">
                </td>
            </tr>
        </table
      </form>
    </center>
  </body>
</html>

FileUploadDBServlet.java：

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;

@WebServlet("/FileUploadDBServlet")
@MultipartConfig(maxFileSize = 16177215)    // upload file's size up to 16MB
public class FileUploadDBServlet extends HttpServlet {

    // database connection settings
    private String dbURL = "jdbc:mysql://localhost:3306/AppDB";
    private String dbUser = "root";
    private String dbPass = "root";

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        // gets values of text fields
        String firstName = request.getParameter("firstName");
        String lastName = request.getParameter("lastName");

        InputStream inputStream = null; // input stream of the upload file

        // obtains the upload file part in this multipart request
        Part filePart = request.getPart("photo");
        if (filePart != null) {
            // prints out some information for debugging
            System.out.println(filePart.getName());
            System.out.println(filePart.getSize());
            System.out.println(filePart.getContentType());

            // obtains input stream of the upload file
            inputStream = filePart.getInputStream();
        }

        Connection conn = null; // connection to the database
        String message = null;  // message will be sent back to client

        try {

              Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(dbURL,dbUser,dbPass);


            String sql =("INSERT INTO contacts (first_name, last_name, photo) values (?, ?, ?)");
            PreparedStatement statement = conn.prepareStatement(sql);
            statement.setString(1, firstName);
            statement.setString(2, lastName);

            if (inputStream != null) {
                // fetches input stream of the upload file for the blob column
                statement.setBlob(3, inputStream);
            }

            // sends the statement to the database server
            int row = statement.executeUpdate();
            if (row > 0) {
                message = "File uploaded and saved into database";
            }
        } catch (Exception  ex) {
            message = "ERROR: " + ex.getMessage();
             ex.printStackTrace();
        } finally {
            if (conn != null) {
                // closes the database connection
                try {
                    conn.close();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
            // sets the message in request scope
            request.setAttribute("Message", message);

            // forwards to the message page
            getServletContext().getRequestDispatcher("/Message.jsp").forward(request, response);
        }
    }
}

web.xml中：

<web-app>
  <servlet>
    <servlet-name>FileUploadDBServlet</servlet-name>
    <servlet-class>FileUploadDBServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>FileUploadDBServlet</servlet-name>
    <url-pattern>/FileUploadDBServlet</url-pattern>
  </servlet-mapping>
</web-app>

解决方法:

以下代码说明了如何向db存储图像或从db获取图像.

首先使用以下代码在数据库中创建一个表

CREATE TABLE contacts (
    contact_id int PRIMARY KEY AUTO_INCREMENT,
    first_name varchar(45) DEFAULT NULL,
    last_name varchar(45) DEFAULT NULL,
    photo` mediumblob);

为输入参数创建一个jsp文件.

Upload.jsp：

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
                    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
        <title>File Upload to Database</title>
    </head>
    <body>
        <h1>File Upload to Database</h1>
        <form name="fileform" method="post" action="uploadServlet" enctype="multipart/form-data">
            <label for="firstName">First Name:</label>
            <input type="text" name="firstName" size="50" placeholder="Enter Your FirstName" required/><br><br>
            <label for="lastName">Last Name: </label>
            <input type="text" name="lastName" size="50" placeholder="Enter Your LastName" required/><br><br>
            <label for="photo"> Portrait Photo:  </label>
            <input type="file" name="photo" size="50" placeholder="Upload Your Image" required/><br><br>
            <input type="submit" value="Save">
        </form>
    </body>
</html>

接下来创建用于上传图像的控制器.在这种情况下,我正在使用servlet.

FileUploadDbServlet.java：

package com.fileupload.attach;

import java.io.IOException;
import java.io.InputStream;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;

@MultipartConfig(maxFileSize = 16177215)
// upload file's size up to 16MB
public class FileUploadDBServlet extends HttpServlet {
    private static final int BUFFER_SIZE = 4096;
    // database connection settings
    private String dbURL = "jdbc:mysql://localhost:3306/mysql";
    private String dbUser = "root";
    private String dbPass = "arun";

    //naive way to obtain a connection to database
    //this MUST be improved, shown for 
    private Connection getConnection() {
        Connection conn = null;
        try {
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            conn = DriverManager.getConnection(dbURL, dbUser, dbPass);
        } catch (Exception e) {
            //wrapping any exception and rethrowing it
            //inside a RuntimeException
            //so the method is silent to exceptions
            throw new RuntimeException("Failed to obtain database connection.", e);
        }
        return conn;
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
        //get values of text fields
        String firstName = request.getParameter("firstName");
        String lastName = request.getParameter("lastName");
        InputStream inputStream = null; // input stream of the upload file
        // obtains the upload file part in this multipart request
        Part filePart = request.getPart("photo");
        if (filePart != null) {
            // prints out some information for debugging
            System.out.println(filePart.getName());
            System.out.println(filePart.getSize());
            System.out.println(filePart.getContentType());

            //obtains input stream of the upload file
            //the InputStream will point to a stream that contains
            //the contents of the file
            inputStream = filePart.getInputStream();
        }

        Connection conn = null; // connection to the database
        String message = null; // message will be sent back to client
        try {
            // connects to the database
            conn = getConnection();
            // constructs SQL statement
            String sql = "INSERT INTO contacts (first_name, last_name, photo) values (?, ?, ?)";
            //Using a PreparedStatement to save the file
            PreparedStatement pstmtSave = conn.prepareStatement(sql);
            pstmtSave.setString(1, firstName);
            pstmtSave.setString(2, lastName);

            if (inputStream != null) {
                //files are treated as BLOB objects in database
                //here we're letting the JDBC driver
                //create a blob object based on the
                //input stream that contains the data of the file
                pstmtSave.setBlob(3, inputStream);
            }
            //sends the statement to the database server
            int row = pstmtSave.executeUpdate();
            if (row > 0) {
                message = "File uploaded and saved into database";
            }

            String filepath = "D:/Dev/JavaWorkSpaceNew/FileUploadDatabase/WebContent/FromDb.jpg";
            //Obtaining the file from database
            //Using a second statement
            String sql1 = "SELECT photo FROM contacts WHERE first_name=? AND last_name=?";
            PreparedStatement pstmtSelect = conn.prepareStatement(sql1);
            pstmtSelect.setString(1, firstName);
            pstmtSelect.setString(2, lastName);
            ResultSet result = statement1.executeQuery();
            if (result.next()) {
                Blob blob = result.getBlob("photo");
                InputStream inputStream1 = blob.getBinaryStream();
                OutputStream outputStream = new FileOutputStream(filepath);
                int bytesRead = -1;
                byte[] buffer = new byte[BUFFER_SIZE];
                while ((bytesRead = inputStream1.read(buffer)) != -1) {
                    outputStream.write(buffer, 0, bytesRead);
                }
                inputStream1.close();
                outputStream.close();
                System.out.println("File saved");
            }
        } catch (SQLException ex) {
            message = "ERROR: " + ex.getMessage();
            ex.printStackTrace();
        } finally {
            if (conn != null) {
                // closes the database connection
                try {
                    conn.close();
                } catch (SQLException ex) {
                    //silent
                }
            }
            // sets the message in request scope
            request.setAttribute("message", message);

            // forwards to the message page
            getServletContext().getRequestDispatcher("/Message.jsp")
                .include(request, response);
        }
    }
}

web.xml中：

<?xml version="1.0" encoding="UTF-8"?>
<web-app>
    <display-name>servletFileUpload</display-name>
    <welcome-file-list>
        <welcome-file>Upload.jsp</welcome-file>
    </welcome-file-list>
    <servlet>
        <description></description>
        <display-name>FileUploadDBServlet</display-name>
        <servlet-name>FileUploadDBServlet</servlet-name>
    <servlet-class>com.fileupload.attach.FileUploadDBServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>FileUploadDBServlet</servlet-name>
        <url-pattern>/uploadServlet</url-pattern>
    </servlet-mapping>
</web-app>

Message.jsp：

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
        pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
        <title>Message</title>
    </head>
    <body>
        <h3>Result of the operation: ${message}</h3>
    </body>
</html>

内容总结

以上是互联网集市为您收集整理的如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像全部内容，希望文章能够帮你解决如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/886979.html

来源：【匿名】

【上一篇】mysql-javax.servlet.jsp.JspException：无法建立连接,数据源无效：“ java.sql.SQLException：未找到合适的驱动程序”【下一篇】CGI和servlet运行方式本质的区别是什么?PHP和Java在Web开发的原理有哪些本质不同？

更多 ►

【如何在Tomcat 7中使用Servlet和JSP在MySQL数据库中插入图像】教程文章相关的互联网学习教程文章

如何使用servlet访问mysql数据库【代码】【图】

import javax.servlet.ServletException;2 import javax.servlet.http.HttpServlet;3 import javax.servlet.http.HttpServletRequest;4 import javax.servlet.http.HttpServletResponse;5 6 public class ShowRs extends HttpServlet {7 8 @Override9 protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { 10 11 Connection conn = null; 12 ...

Servlet 连接mysql数据库【图】

package com.servlet.datalink;2 3 import java.io.IOException;4 import java.io.PrintWriter;5 import java.sql.Connection;6 import java.sql.DriverManager;7 import java.sql.ResultSet;8 import java.sql.Statement;9 10 import javax.servlet.ServletException; 11 import javax.servlet.http.HttpServlet; 12 import javax.servlet.http.HttpServletRequest; 13 import javax.servlet.http.HttpServletResponse; 14 15 p...

jsp-2 简单的servlet连接mysql数据库增删改查【代码】

补：后来我才发现这玩意应该有高手写到jar包里面的..... 其实里面的意思也不是数据查询和数据操作而是得到一个结果和多个结果的区别对数据的Dao的处理package com.javaweb.dao;import java.util.ArrayList; import java.util.List;import org.apache.commons.lang3.StringUtils;import com.javaweb.dao.DBDao; import com.javaweb.bean.User;public class UserDao {private DBDao dao=new DBDao();public List<User> findAll(){L...

html文件调用servlet连接mysql数据库实例【代码】【图】

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"version="2.5"><servlet><servlet-name>FootballTeam</servlet-name><servlet-class>FindFootOrPk<...

Jsp连接Mysql数据库：利用Servlet监听器【代码】

本例程所使用的运行环境及资源： 1. Tomcat 5.5 2. Mysql 4.1 3. mysql jdbc驱动：3.1.13 (以上程序可以直接到相关官方网站下载到) step1：首先创建一个监听器servlet，这个监听器用来初始化共享资源，本例中主要用来在应用中创建数据源，把这个类置于WEB-I本例程所使用的运行环境及资源： 1. Tomcat 5.5 2. Mysql 4.13. mysql jdbc驱动：3.1.13 (以上程序可以直接到相关官方网站下载到) ste...

servlet连接mysql数据库，通过查询语句得到的结果集，打印之后发现不正确。

mysqlservletjavaresultset 具体代码如下，传入的date是D2014，数据库中真实存在的应该是4个元素，格式应该是这样【数学.20:30-21:20】，但是，通过该代码得到的结果集，打印之后显示4个D2014。求大神能够指出问题所在。public ArrayList queryLesson(String date){ ArrayList lessonInfos=new ArrayList(); Connection con = null; PreparedStatement pre = null; ResultSet rs=null; DBco...

Jsp连接Mysql数据库：利用Servlet监听器_MySQL

本例程所使用的运行环境及资源：　　1. Tomcat 5.5　　　　　　　　　　　　　　　　　　　　2. Mysql 4.1　　3.　mysql jdbc驱动：3.1.13　　(以上程序可以直接到相关官方网站下载到)　　step1：首先创建一个监听器servlet，这个监听器用来初始化共享资源，本例中主要用来在应用中创建数据源，把这个类置于WEB-INF/classes/kinglong/jmediasoft/servlets/目录下，代码如下：/** */ /*** @(#)ResourceManagerListener.java** 资源初...

JSP_实现Servlet登陆，注册，链接Mysql数据库。_MySQL

本文http://blog.csdn.net/svitter也是一个MVC的实例源码：http://download.csdn.net/detail/svitter/7532621user.sql:-- phpMyAdmin SQL Dump-- version phpStudy 2014-- http://www.phpmyadmin.net---- 主机: localhost-- 生成日期: 2014 年 06 月 21 日 17:42-- 服务器版本: 5.5.38-- PHP 版本: 5.3.28SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_...

【Mysql】Mysql数据库处理Servlet中的汉字传递_MySQL

许多Mysql的默认的编码是latin1，如果Mysql在安装的时候没有改变编码，直接对其录入中文是不行的，会乱码的，首先把要存中文的那个字段的编码从latin1改成utf-8。如果使用MySQLQueryBrowser可以打开要修改的表，点击要修改的字段，在Column details那里的 Column Charset中修改成utf-8 在Servlet的Java文件中，连接数据库必须带参数连接?useUnicode=true&characterEncoding=utf8&useOldAliasMetadataBehavior=true 同时，Servlet在...

MVC jsp+servlet+javabean 连接Mysql数据库測试demo【图】

首先我们应该了解什么是MVC： MVC包含三个部分： ①View：由各种JSP页面组成。 ②Controller：由各种Servlet组成，Controller就是将View和Model来进行匹配，用什么Model实现，调用哪个View来显示。 ③Model：由各种javabean组成，也是MVC的核心，以下就是简单的用MVC架构去实现一个JSP（View）+Servlet（Controller）+javabean（Model）实现MySql查询功能的Demo。创建Web Project 1.打开MyEclipse -> File-> new -> Web Proj...