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ÁË£¿

---

ÒýÓÃ

ÏÖÔÚµÄjdbcÒѾ­±äΪor