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
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ã潫²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
<head>
<title> ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......