java setBinaryStream error for mysql
来源:互联网 发布:java编写计算器教程 编辑:程序博客网 时间:2024/05/22 14:34
Class.forName(driver);
Connection conn=DriverManager.getConnection(url, user, password);
String sql="insert into [test] ([name],[img])values(?,?)";
InputStream is=new FileInputStream(new File("src/lsnu/lgf/saveimage/haha.jpg"));
System.out.println("len="+is.available());
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, "name");
ps.setBinaryStream(2, is,is.available());
System.out.print(ps.execute());
presentation:Exception in thread "main" java.sql.SQLException: 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 '[test] ([name],[img])values('ggggg',_binary'ertwertwederywgadfhsdfhgf
change:
String sql="insert into test (name,img)values(?,?)";
is ok;
- java setBinaryStream error for mysql
- java.lang.AbstractMethodError: com.mysql.jdbc.PreparedStatement.setBinaryStream
- cannotcreate windows service for mysql.error:0
- com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V问题原因
- mysql 高版本jdbc驱动程序 使用PreparedStatement.setBinaryStream方法报错及解决办法
- com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V问题原因
- com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V问题原因
- [异常] com.mysql.jdbc.ServerPreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V
- com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;J)V错误解决
- Error: Cannot create Windows service for MySql. Error: 0解决方案
- java.lang.AbstractMethodError: com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setBinaryStream(IL
- mysql错误:cannot create windows service for mysql.error:0
- Error: java.lang.NumberFormatException: For input string: ""
- java project build failed for javadoc error
- Error:Execution failed for task ':app:mergeDebugResources'. > Error: java.ut
- mapxtreme for java 连接Mysql
- Mysql: ERROR 1045 (28000): Access denied for user
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- Android 开机自启动应用
- 设计模式学习-----观察者模式
- Android Intent Action 大全
- android4.0 MediaPlayer的notify监听机制的全面剖析
- 总帐凭证导入EXCEL,并且批量输入(FB50)的BDC
- java setBinaryStream error for mysql
- VS2008 MFC 配置GDI+
- Hex与浮点数相互转换,支持LINUX平台
- Mac下清理软件CleanMyMac破解版
- Fatfs文件系统分析(3)-底层接口分析
- 别让抱怨毁了你的工作生活
- Linux下使用smartCOM调试串口
- MouseEvent事件
- 2012-12-06集结号【创赢操盘】周四策略