jsp²åͼƬµ½MySQL - Web ¿ª·¢ / ÆäËû
¸ãÁËÒ»¸öÏÂÎçÁË£¬ËÑË÷ÁËÍøÂ绹Êǽâ¾ö²»ÁË...Ï£Íû¸ßÊÖ°ïæ½â¾öÏÂ
Ô´´úÂ룺
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??¡
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ËÑË÷ÁËһϣºhttp://so.csdn.net/bbsSearchResult.aspx?q=jsp+%e4%bc%a0%e9%80%92&p=1£¬Ã»Óз¢ÏÖÄÜÓõġ£ÒòΪÎÒÊdzõѧjsp£¬Òò´ËÓÐЩҲÐíÄÜÓã¬Ö»ÊÇÎÒ¿´²»Ã÷°×£¿
Ò»¡¢ÎÒµÄÇéÐΣº
a.html ͨ¹ý<form action=&q ......
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& ......