ʵÏÖJavaÁ¬½Ómysql£¨Ô´Â룩£¡
JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno char[7] NO NULL Primary Key;
sname varchar[8] NO NULL;
sex char[2] NO NULL;
bdate date NO NULL;
height decimal[10,0] ;
-------------------------------------------------------------------------
java³ÌÐò£º
import java.sql.*;
public class JDBCTest {
public static void main(String[] args){
String driver = "com.mysql.jdbc.Driver"; // Çý¶¯³ÌÐòÃû
String url = "jdbc:mysql://localhost/scutcs"; // URLÖ¸ÏòÒª·ÃÎʵÄÊý¾Ý¿âÃûscutcs
String user = "........"; // MySQLÅäÖÃʱµÄÓû§Ãû
String password = "........"; // MySQLÅäÖÃʱµÄÃÜÂë
try {
Class.forName(driver); // ¼ÓÔØÇý¶¯³ÌÐò
Connection conn = DriverManager.getConnection(url, user, password); // Á¬ÐøÊý¾Ý¿â
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!"); //ÑéÖ¤ÊÇ·ñÁ¬½Ó³É¹¦
Statement statement = conn.createStatement(); &
Ïà¹ØÎĵµ£º
66. EJBÈÝÆ÷ÌṩµÄ·þÎñ
Ö÷ÒªÌṩÉùÃ÷ÖÜÆÚ¹ÜÀí¡¢´úÂë²úÉú¡¢³ÖÐøÐÔ¹ÜÀí¡¢°²È«¡¢ÊÂÎñ¹ÜÀí¡¢ËøºÍ²¢·¢ÐйÜÀíµÈ·þÎñ¡£
67. EJB¹æ·¶¹æ¶¨EJBÖнûÖ¹µÄ²Ù×÷ÓÐÄÄЩ£¿
1.²»ÄܲÙ×÷Ï̺߳ÍÏß³ÌAPI(Ïß³ÌAPIÖ¸·ÇÏ̶߳ÔÏóµÄ·½·¨Èçn ......
MysqlÖÐÎÄÂÒÂëÎÊÌâ
֮ǰ±»mysqlÖÐ×ÜÊdzöÏÖÖÐÎÄÂÒÂë¸ãµÃÔÆÀïÎíÀÔÚÍøÉÏÒ²ËÑÁËЩÏà¹Ø×ÊÁÏ£¬¿É½á¹û¸üÈÃÎÒ¾õµÃ×Ö·û¼¯µÄת»»ÊÇÏ൱¸´ÔÓ£¬ÉõÖÁÓÐÁ˵ִ¥ÐÄÀí£¬²»¹ý»¹ºÃÔÚ×îºóËѵ½¼¸Æª¾µäµÄÎÄÕ£¬¾¹ýÑжÁ×ÜËãÃ÷°×¹ýÀ´£¡ºÃÎÄÕ£¬²»¸Ò¶ÀÏí£¬ÏÖ½«ÎÄÕÂÉÔ×÷ÕûÀíÓë´ó¼Ò·ÖÏí¡£
×Ö·û¼¯»ù±¾¸ÅÄ
http://home.phpchina.com/space.php ......
µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db device_info_table > /home/eric/ta ......
±¾ÎÄÀ´×Ô: ITÔËάר¼ÒÍø ×÷Õß: NetSeek ÈÕÆÚ: 2009-3-8 19:52 ÔĶÁ: 742 ÈË ´òÓ¡ ÊÕ²Ø DNS, Bind, DLZ, ÖÇÄÜ, MySQL ×÷Õß:NetSeek http://www.linuxtone.org
ÈÕÆÚ:2009-3-7 gmail:cnseek@gmail.com
ÍÆ¼öÏÂÔØPDF°æ£¨·½±ã²éÔÄ):http://www.linuxtone.org/project/cdn/bind-dlz-view.pdf
¡¾Ìâ ¸Ù¡ ......
URLµÄopenConnection()·½·¨½«·µ»ØÒ»¸öURLConnection¶ÔÏ󣬸öÔÏó±íʾӦÓóÌÐòºÍ URL Ö®¼äµÄͨÐÅÁ´½Ó¡£³ÌÐò¿ÉÒÔͨ¹ýURLConnectionʵÀýÏò¸ÃURL·¢ËÍÇëÇó¡¢¶ÁÈ¡URLÒýÓõÄ×ÊÔ´¡£
ͨ³£´´½¨Ò»¸öºÍ URL µÄÁ¬½Ó£¬²¢·¢ËÍÇëÇó¡¢¶ÁÈ¡´Ë URL ÒýÓõÄ×ÊÔ´ÐèÒªÈçϼ¸¸ö²½Ö裺
£¨1£©Í¨¹ýµ÷ÓÃURL¶ÔÏóopenConnection()·½·¨À´´´½¨URLConnectio ......