搞了一个下午了，搜索了网络还是解决不了...希望高手帮忙解决下
源代码：
private void SendPhoto(HttpServletRequest request,
HttpServletResponse response) {
String name=request.getParameter("image"); //获取图片路径，测试后没有问题
String filename=name.replace("\\", "\\\\");
File file=new File(filename);
InputStream str = null;
try {
str = new BufferedInputStream(new FileInputStream(file));
} catch (FileNotFoundException e1) {
e1.printStackTrace();
}
String sql= "insert into photos(image) values(null,now(),?)";//null对应的为自动增加的id,image的类型为blob
Connection conn=DB.getConn();//DB是封装的链接数据库的类
PreparedStatement pstmt=DB.prepareStmt(conn, sql);
try {
pstmt.setBinaryStream(1,str,str.available());
result=pstmt.executeUpdate();
pstmt.close();
str.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
错误如下：com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?:?v·é-??± ???ü??zq?5*?we,V·Zd?I?ùQ??ü] ???
z???#?o>?l6? (??Rz?*?o??§???Wu??�
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
