javaÔõôµ÷ÓÃmysql´´½¨µÄ±í
Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = "jdbc:mysql:///mytest";
String user = "root";
String password = "root";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String score = null;
// 1.¼ÓÔØÇý¶¯
try {
Class.forName("com.mysql.jdbc.Driver");
// 2.½¨Á¢Á¬½Ó
conn = DriverManager.getConnection(url, user, password);
// 3.½¨Á¢Óï¾ä
stmt = conn.createStatement();
// 4.Ö´ÐÐÓï¾ä
rs = stmt.executeQuery("select * from bookinfo ");
// 5.´¦Àí½á¹û
while (rs.next()) {
score = rs.getString("..");
System.out.println(rs.getString(".."));
}
} catch (Exception e) {
e.printStackTrace();
}
// 6.ÊÍ·Å×ÊÔ´
ÓÃjdbc°¡
Ïà¹ØÎÊ´ð£º
ÏÖÔÚ»¹ÓкܶàÈ˸㲻¶®PHPºÍJAVA¿ª·¢µÄÐͬOAµ½µ×ÓÐʲô²»Í¬£¬¶Ô×Ô¼ºµ½µ×ÓÐʲôӰÏ죬ÒÔÖÁÓÚ×ö³öÁË´íÎóµÄÑ¡Ôñ¶øêݺ¦ÎÞÇî¡£±ÊÕ߸ù¾ÝÁ½ÖÖ¼¼ÊõµÄÌØµãÖØÐÂÕûÀíÁËÒ»¸ö¶Ô±È£¬¸ø¹ØÐÄÐͬOA¼¼ÊõµÄ¶ÁÕß×ö¸ö²Î¿¼¡£
»ªÌ춯Á¦Ð ......
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
×Ö·ûÁ÷µÄ¶ÁºÍд×îÖÕÔڵײ㶼ÊÇͨ¹ý×Ö½ÚÁ÷À´Íê³ÉµÄÂ𣿡¡¶ÁдÎı¾Îļþ×Ö·ûÁ÷Ó¦¸Ã¾Í¿ÉÒÔÁ˰ɡ£¡£
¸÷λ´ó¸ç´ó½ã°ï°ïæ°¢
JavaÁ÷°üÀ¨×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷£¬×Ö½ÚÁ÷ͨ¹ýIOÉ豸ÒÔ×Ö½ÚÊý¾ÝµÄ·½Ê½¶ÁÈ룬¶ø×Ö·ûÁ÷ÔòÊÇͨ¹ý×Ö½ÚÁ÷ ......