insert.jsp

来自「J2EE 技术 源码 书籍源代码（j2ee编程技术）」· JSP 代码 · 共 37 行

<%@ page contentType="text/html;charset=gb2312" %> 
<%@ page import = "java.io.*"%>
<% 
java.sql.Connection conn; 
java.lang.String strConn; 
java.sql.PreparedStatement preparedStmt; //语句对象 
java.sql.ResultSet sqlRst; //结果集对象 

try{
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/MySqlDS");
       
conn = ds.getConnection();
String filelocation =request.getParameter("file");
File files = new File(filelocation);
 FileInputStream 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();
 fis.close();
 preparedStmt.close (); 
conn.close();
out.println("操作成功！");
%>

<%
 
} catch (java.sql.SQLException e){
out.println(e.toString());

}

%>