从表单中提交图片到mysql_请教mysql插入图片的问题（通过表单提交到servlet，然后将图片插入mysql)...

接受数据的页面如下：

报名

Super Girl 报名

姓名：		出生地：
出生年月(如1983-12-31)：		毕业院校：
经典曲目：		特长:
照片

servlet代码如下：

public class InDatabase extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding("gbk");

Connection conn = (Connection)getServletContext().getAttribute("conn");

String sql = "insert into supergirls (name,birthplace,birthday,school,music,speciality,photo)" +

"values (?,?,?,?,?,?,?)";

PreparedStatement stmt;

try {

stmt = conn.prepareStatement(sql) ;

stmt.setString(1,request.getParameter("sname"));

stmt.setString(2,request.getParameter("birthplace"));

String birth = request.getParameter("birthday");

stmt.setDate(3,Date.valueOf(birth));

stmt.setString(4,request.getParameter("school"));

stmt.setString(5,request.getParameter("music"));

stmt.setString(6,request.getParameter("speciality"));

String data = request.getParameter("photo");

String url =data.replace("\\","\\\\");

File file = new File(url);

InputStream in = new FileInputStream(file);

stmt.setBinaryStream(7, in,in.available());

stmt.executeUpdate();

System.out.println("update");

stmt.clearParameters();

stmt.close();

in.close();

} catch (SQLException e) {

e.printStackTrace();

}

RequestDispatcher dis = request.getRequestDispatcher("/already");

dis.forward(request, response);

}

}

运行后的错误显示为：

com.mysql.jdbc.exceptions.jdbc4.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 ’?U”– ?^Nm?¨í?k?ùqàòt_????0?…?á??&\’#f§Q·:????????T?xA???òz?Y?Kw

?????H%@±.?’ at line 1

我使用的是：windows xp + Tomcat6.X + mysql5.1

先在此谢谢各位！望高人相助！

人打赏

0人 点赞

主帖获得的天涯分：0

举报 |

楼主

|

楼主发言：1次 发图：0张 | 添加到话题 |