JavaÈçºÎÁ¬½ÓmysqlÊý¾Ý¿â£¿ - Java / Java SE
JavaÈçºÎÁ¬½ÓmysqlÊý¾Ý¿â£¿²¢ÇÒÈ¥µÃ±íÖеÄÄÚÈÝ?
лл¡£
À´È˾ÈÃü°¡ ÔÚÏߵȰ¡
ÓÃjdbcÇÅÁ¬£¬ÔÚeclipseϱàºÃÔÚÁ¬½Ó£¡
×Ô¼ºËÑ£¬¶àµÄºÜ¡£È磺http://www.xue5.com/itedu/200707/134068.html
²»»áд£¬²Åѧ£º
import java.sql.*;
Java code:
public class TestJdbc01 {
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","admin");
Statement s = conn.createStatement();
ResultSet rs = s.executeQuery("show tables;");
while(rs.next()){
System.out.println("hah");
System.out.println(rs.getInt("compy"));
}
rs.close();
s.close();
conn.close();
}
}
µ½µ×ÊÇÓÃsqlÓï·¨µÄselect »¹ÊÇmysql µÄshow tables; £¿
s.executeQuery("show tables;");
ÕâÀïдsql
select * from ±íÃû
show tablesÊÇÏÔʾµ±Ç°Êý¾Ý¿âµÄËùÓбíÃ÷
ҪȡÊý¾ÝÓÃselect
ÏÖÔÚµÄjdbcÒѾ±äΪorg.gjt.mm.mysql.Driver¶ø²»ÔÙÊÇcom.mysql.jdbc.Driver
¿â²»°üº¬ÔÚjdkÖÐÐèÒªÄãÏÂÔز¢ÉèÖú÷¾¶
µ«ÊÇÈç¹ûдselect ¾ÍÖ´Ðв»ÁËwhileÁË£¿
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ã潫²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
´ó¼ÒºÃ£¬ÎÒÏÖÔÚÓÐÒ»¸öÓÃaspдµÄÁÄÌìÊÒ£¬ÏÖÔÚµÄÏëÌí¼ÓÒ»¸ö¹¦ÄÜ£¬¾ÍÊǵ±ÓÐÈËÉÏÏßµÄʱºò£¬·¢³öÌáʾ£¬±ÈÈçÉùÒôÏìһϣ¬ÏÖÔÚÏëÓÃjavaʵÏÖÕâ¸ö¹¦ÄÜ£¬ÇëÎÊ´ó¼ÒÔõôʵÏÖ£¿
ллÁË£¬ÎÒ»á¼Ó·ÖµÄ
aspºÍjavaÕûºÏµ½Ò»ÆðÈ¥£¿ºÎ±Ø ......