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Ò³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......