´«ÖDz¥¿ÍjavaÅàѵ java»ù´¡Ö®JDBC
×òÌì˯µÃÌ«Íí£¬ÑÏÖØÓ°ÏìÁ˽ñÌìµÄѧϰ£¬ÊµÔÚÊǵò»³¥Ê§£¡
¹ØÓÚjavaµÄ»ù´¡ÖªÊ¶»¹ÓжþÊ®Ìì¾ÍÒª½áÊøÁË£¬ÏÖÔÚÎÒÃÇÒѾ¿ªÊ¼×öһЩСµÄÁ·Ï°£¬·¢ÏÖ×Ô¼ºµÄ˼·ÓÐʱºò¸ú²»ÉÏ£¬
ÕæÉÏ»ð£¡
ѧ¶øÊµÏ°Ö®£¬²»ÄܶªÁËÎ÷¹Ï¼ñÖ¥Â飬ÉÏ¿ÎÒª½ô¸úÀÏʦ½Ú×࣬²»ÄÜ×Ô¼º×ö×Ô¼ºµÄ£¬ÀÏʦ½²ÀÏʦµÄ£¡
µ÷ÕûÐÄ̬£¬ÓúõÄѧϰ·½·¨·½ÄÜʰ빦±¶£»
JDBC£¨Java Database Connnectivity£©
JDBC±¾ÉíÊÇjavaÁ¬½ÓÊý¾Ý¿âµÄÒ»¸ö±ê×¼£¬ÊǽøÐÐÊý¾Ý¿âÁ¬½ÓµÄ³éÏó²ã£¬ÓÉjava±àдµÄÒ»×éÀà»ò½Ó¿Ú£¬
javaµÄʵÏÖÓɸ÷´óÊý¾Ý¿â³§ÉÌÀ´Íê³É¡£
±¾µØÐÒéµÄ´¿ Java Çý¶¯³ÌÐò£º
1¶àÊýÊý¾Ý¿â³§ÉÌÒѾ֧³ÖÔÊÐí¿Í»§³ÌÐòͨ¹ýÍøÂçÖ±½ÓÓëÊý¾Ý¿âͨÐŵÄÍøÂçÐÒé¡£
2ÕâÖÖÀàÐ͵ÄÇý¶¯³ÌÐòÍêȫʹÓà Java ±àд£¬Í¨¹ýÓëÊý¾Ý¿â½¨Á¢µÄ Socket Á¬½Ó£¬
²ÉÓþßÌåÓë³§É̵ÄÍøÂçÐÒé°Ñ JDBC µ÷ÓÃת»»ÎªÖ±½ÓÁ¬½ÓµÄÍøÂçµ÷ÓÃ
jbdcÇý¶¯£¬ÊµÏÖjdbc¹æ·¶µÄÀàµÄ¼¯ºÏ£¬Ò²¾ÍÊǸ÷´óÊý¾Ý¿â³§ÉÌÓÃÀ´ÊµÏÖ½Ó¿ÚºóµÄÀàµÄ·â×°°ü£¬¼´jar°ü¡£
±ÈÈçmysqlÇý¶¯£¬oralceÇý¶¯¡£
ODBC
JDBC-ODBCÇÅÊÇÓÉsun¹«Ë¾¿ª·¢£¬API×îУ¬ÐÔÄܲ»¸ß£¬²ã´ÎÌ«¶àÁË£¡
ÎÒÃÇʹÓõÄÊÇ£º
±¾µØÐÒéµÄ´¿java´úÂ룺
java´úÂë---JDBAPI---- -----Êý¾Ý¿â
ÔÚjavaÖÐ
JDBCÖ±½Ó·ÃÎÊÊý¾Ý¿â
µÚÈý·½µÄO/R¹¤¾ß£¬ÈçHIBERNATE£¬ibatisµÈ
ÔÚÒ»¸öjavaÀàÖÐÈçºÎ·ÃÎʵ½Êý¾Ý¿âÄØ£¿
×¢²áÇý¶¯£¬Çý¶¯¹ÜÀíÆ÷£¬»ñµÃconnection¶ÔÏó£¬statment¶ÔÏó
µÚÒ»ÖÖ£º
String url="jdbc:mysql://localhost:3306:/test" jdbc:<×ÓÐÒé>:<×ÓÃû³Æ>:ÊÇÒ»¸öJNI·½Ê½µÄÃüÃû
×¢£ºJNIÊÇJava Native InterfaceµÄËõд¡£´ÓJava 1.1¿ªÊ¼£¬Java Native Interface (JNI)±ê×¼³ÉΪjavaƽ̨µÄÒ»²¿·Ö£¬
ËüÔÊÐíJava´úÂëºÍÆäËûÓïÑÔдµÄ´úÂë½øÐн»»¥¡£
Class.froName("org.mysql.jdbc.Driver"); ¼ÓÔØ×Ö½ÚÂëÎļþ,»áµ÷ÓÃÀàÖеľ²Ì¬´úÂë¿é,µ«²»»áµ÷ÓÃÀàµÄ¹¹Ôì·½·¨
Connection conn=DriverManager.getConnection(url,"root","root"); »ñÈ¡Á¬½Ó
µÚ¶þÖÖ£º
String url="jdbc:mysql://localhost:3306/test"
DriverManager.registerDriver(new com.mysql.jdbc.Dri
Ïà¹ØÎĵµ£º
1£¬OCP(Open-Close Principle)¿ª±ÕÔÔò
Software entities should be open for extension,but closed for modification,(ÔÚÉè¼ÆÒ»¸öÄ£¿éµÄʱºò£¬Ó¦µ±Ê¹Õâ¸öÄ£¿é¿ÉÒÔÔÚ²»±»Ð޸ĵÄǰÌáÏÂÀ©Õ¹)¡£
&nbs ......
1. ·ç¸ñÎñ±Ø±£³ÖÒ»¹áÐÔ(Consistent)
Ç°ÃæËµµ½µÄÄǸöÅóÓѵÄÎÊÌ⣬¾ÍÊÇ·ç¸ñÒ»¹áÐÐÎÊÌâ¡£ÆäʵËûµÄ·ç¸ñ£¬±¾À´Ò²Ã»ÓÐʲô
ÎÊÌ⣬µ«ÔÚÏîÄ¿ÀºÍÆäËû³ÌÐòÔ±µÄ³ÌÐòµÄ·ç¸ñ£¬ÏÔµÃìçÒ죬ÄǾʹæÔÚÎÊÌâÁË¡£
±ÈÈçÕâ¸öËõ½ø£¬ÓÖ±ÈÈç±äÁ¿ÃüÃû·½·¨£¬²»Í¬µÄÀ࣬²»Í¬µÄMethodsÀ¸÷×Ô²»Í¬£¬
Õâ³ÌÐò¾ÍºÜÄÑ¿´ÁË¡£ËùÒÔÒ»µ©ÄãÑ¡ÔñÁ ......
package Pack;
import java.text.*;
import java.util.*;
import java.text.DecimalFormat;
import java.util.*;
public class Test {
/**
* @param args
*/
public static void main(String args[]) {
yuesef(50,3);
}
public static void yuesef(int n, int m) {
ArrayList<Integer ......
ºÜÎÒÕÒÁ˺þà ÖÕÓÚÕÒµ½ÁË.....
ÒÔÏÂÊÇתÎÄ£º
//--------------------------------------------------------------------------------------------------
·½·¨ºÜ¼òµ¥£¬µ÷ÓÃexplorer.exe¾Í¿ÉÒÔ£¬
Runtime.getRuntime().exec(
& ......
ѧϰJavaµÄѧϰ˳Ðò
µÚÒ»½×¶Î(ËĸöÔÂ)
1.j2se
ÃæÏò¶ÔÏó£·â×°¡¢¼Ì³Ð¡¢¶à̬
ÄÚ´æµÄ·ÖÎö
µÝ¹é
¼¯ºÏÀà(Set,List,MapµÄ×ÓÀà)¡¢·ºÐÍ¡¢×Ô¶¯´ò°üÓë½â°ü¡¢Annotation
IOÁ÷(IOÁ÷ºÍÏ̱߳àдһ¸öQQÁÄÌì³ÌÐò)
¶àÏ̡߳¢Ïß³Ìͬ²½
TCP/UDP
AWT¡¢Ê¼þÄ£ÐÍ¡¢ÄäÃûÀà (ÄܲéѯÊý¾Ý¿âÏÔʾÔÚJtableÉÏÃæ)
ÕýÔò± ......