File file = new File ("D:\\jap.txt");
InputStream is = new FileInputStream (file);
pstmt.setAsciiStream(1, is, (int)file.length());
是这样
InputStream is = new FileInputStream (file);
pstmt.setAsciiStream(1, is, (int)file.length());
是这样
另外我怎么样用SQL*Plus看我的文件插入了没有呢？
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<html>
<head>
<title>数据库写文件</title>
</head>
<body>
<%
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:comm";
Connection Con=null;
Statement Stmt=null;
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error"+e.getMessage());
}
try{
Con=DriverManager.getConnection(sConnStr,"comm","comm123");
}
catch(SQLException e)
{
out.print(e.toString());
}
%>
<%
Stmt = Con.createStatement();
//String query="insert into filedata(data) values(70)";
String query="insert into filedata(data) values (?)";
//Stmt.executeUpdate(query);
PreparedStatement pstmt =
Con.prepareStatement (query);
File file = new File ("D:\\jap.txt");
InputStream is = new FileInputStream (file);
pstmt.setAsciiStream(1, is, (int)file.length());
int rows = pstmt.executeUpdate();
%>
</body>
</html>