java ´ÓmysqlÖжÁȡͼƬ¼°Ïà¹ØÐÅÏ¢ÎÊÌ⣿£¿
mysqlÖÐÓм¸¸ö×Ö¶Î
id
name
img(ÒÔ¶þ½øÖƵķ½Ê½´æÈëmysqlÖÐ)
ÎÒÄܹ»µ¥¶À¶ÁȡͼƬ(Ö»ÄܶÁÈ¡ÆäÖÐÒ»¸öͼƬ)
µ«Êǵ±ÎÒ°ÑËùÓÐÐÅÏ¢¶¼·Åµ½requestÖеÄʱºò
ͼƬÄܶÁÈ¡³öÀ´µ«ÊÇÆäËû¶«Î÷£¨name,id£©È´¶Á²»³öÀ´
(
¶ÁȡͼƬÎÒÓõÄÊÇÒÔÏ´úÂ룺
InputStream in=dao.getImg();
OutputStream out = response.getOutputStream();
byte[] b = new byte[1024];
while(in.read(b) != -1){
out.write(b);
}
in.close();
out.flush();
out.close();
)
ÇëÎʸ÷λ´ó¸ç£¬´ó½ã
Õâ¸öÎÊÌâ¸ÃÔõô½â¾ö°¢£¿£¿
id name img
id name img
id name img ¡¡
Êý¾Ý¿âÖÐÊÇÕâÑùÂð£¿
д¸öbean ÀýÈçMyBean
È»ºó´ÓÊý¾Ý¿âÖаÑËüÃǶ¼¶Á³öÀ´·Åµ½¼¯ºÏÀïÃæ²»¾Í¿ÉÒÔÁËÂð£¿
È»ºóMyBean obj=list.get(i);
obj.getId()¡¢obj.getName£¨£©¡¡
¶÷
ÄÇÈý¸ö×Ö¶ÎÊÇÊý¾Ý¿âÀïµÄ
ÆäÖÐ
img¾ÍÊÇ´æÈëµÄͼƬ
´ÓmysqlÖжÁÈ¡Êý¾ÝÏÔʾµ½Ò³Ãæ
ͼƬÄܹ»³É¹¦
µ«ÊÇÆäËûÊý¾Ý¾Í²»ÐÐ
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
<?xml version="1.0" encoding="utf-8" ?>
- <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......
ÒªÇóÊÇÊäÈëÒ»¸öÊý×Ö£¬È»ºó°´ÕÕÏÂÃæµÄ·½Ê½Êä³ö£¨Ë³Ê±ÕëÐýת£©
±ÈÈç ÊäÈë 2
ÔòÊä³öΪ
1 2 3
8 9 4
7 6 5
ÊäÈë 6
ÔòÊä³öΪ
1 2 3 4 5 6
20 21 22 23 24 7
19 32 33 34 25 8
18 31 36 ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......