insert.jsp

来自「介绍了j2ee开发常用的学习知识,如servlet,javamail,EJB等知」· JSP 代码 · 共 39 行

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import = "java.io.*"%>
<%@ page import="java.sql.*, javax.sql.*, java.io.*, javax.naming.*" %>
<% 
Connection conn=null;
java.lang.String strConn;
PreparedStatement preparedStmt=null; //语句对象
ResultSet sqlRst; //结果集对象
InitialContext context=null;
FileInputStream fis=null;
        try{
    context = new InitialContext();
    DataSource dataSource =
            (DataSource) context.lookup("java:comp/env/sample");
    
    conn = dataSource.getConnection();
    String filelocation =request.getParameter("file");
    File files = new File(filelocation);
    fis=new FileInputStream(files);
    preparedStmt = conn.prepareStatement(
            "INSERT INTO album (name,data)" +"VALUES (?, ?)");  //预编译SQL语句
    preparedStmt.setString(1, request.getParameter("name"));
    preparedStmt.setBinaryStream(2, fis,(int)files.length());
    preparedStmt.executeUpdate();
    
    out.println("操作成功！");
%>
<%
} catch (java.sql.SQLException e){
    out.println(e.toString());
}finally{
    if(fis!=null)  fis.close();
    if(preparedStmt!=null)preparedStmt.close();
    if(conn!=null)conn.close();
    if(context!=null)context.close();
}
%>