javaÁ¬½ÓmysqlÊý¾Ý¿â
Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
Ö÷Òª´úÂëÈçÏ£º
import java.sql.*;
public class Test{
private Connection conn;
private Statement stat;
public Test()
{
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//¼ÓÔØÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver"); //¼ÓÔØÇý¶¯³ÌÐò
}
catch (Exception ex)
{
System.out.println("sql exception: driver ERROR!!!!");
ex.printStackTrace();
}
try
{
conn = DriverManager.getConnection("jdbc:mysql://10.64.10.100:3306/test","root","root");//½¨Á¢Á¬½Ó£¬
stat = conn.createStatement();//´´½¨Statement¶ÔÏó
}
catch (SQLException ex)
{
//sql exception
System.out.println("sql exception: connect or driver!!!!");
ex.printStackTrace();
}
}
Ïà¹ØÎĵµ£º
Design Patterns in Java
-----------------------------------------
Steven John Metsker
William C.Wake
-----------------------------------------
¹¨²¨µÈÒë
££££££££Ò»¡¢¶þÕ¶ÁÊé¼Ç¼££££££
ģʽÊǼ¯ÌåÖǻ۵Ľᾧ¡£Ëü¸ø³öÁËÏà¹ØÐÐÒµÖоÑé·á¸»µÄ´ÓÒµÕßËùÓ¦ÓõÄËùÓеĸÅÄîºÍ·½ ......
³ý °Ë¸ö»ù±¾ÀàÐÍ£¨Long ,short,int ,float,double,char,byte,boolean£©Í⣬ÆäËûµÄÊý¾ÝÀàÐͶ¼±»³ÆÎª“ÒýÓÃÀàÐÍ”£¬Ò²¼´£ºObject¡£ObjectµÄ²Ù×÷È«ÊÇͨ¹ý¶ÔÏóµÄÒýÓã¨Object references£©£¬ÒýÓÿÉÒÔÀí½âΪָÕ룬ÈÝÒ×ÈÃÈ˶ÔÓ¦µ½C£«£«µÄ´«Ö·ÉÏÃæÈ¥¡£ËùÒÔ£¬´ó¼ÒҪעÒâà¶£¡javaÀïÃæËä˵ûָÕ룬Æäʵȴ²»È»¡£ ......
<p>04¼¶ÐÂÉúÃûµ¥</p>
<table border="1" width="80%" cellpadding="0">
<tr>
<td width="10%" align="center">Id</td>
<td width="20%" align="center">Name</td>
<td width="10%" align="center">Age</td>
<td width="10%" align="cent ......
java¹¤×÷ÕßÉçÇøÖ÷°ì
1. ¡¾¸´Ñ¡¡¿ÊÕÈëÓÐÕÇ£¬ÓиÉÍ·
22.22%
2. ¡¾¸´Ñ¡¡¿ÊÕÈë²»ÀÖ¹Û£¬Ã»¸ÉÍ·
8.89%
3. ¡¾µ¥Ñ¡¡¿ÄêÊÕÈë50ÍòÒÔÉÏ
2.22%
4. ¡¾µ¥Ñ¡¡¿ÄêÊÕÈë20Íò~50Íò
4.44%
5. ¡¾µ¥Ñ¡¡¿ÄêÊÕÈë10Íò~20Íò ......
Ò».±àд¹¹ÔìÆ÷µÄÓÐЧ׼Ôò£º Óþ¡¿ÉÄܼòµ¥µÄ·½·¨Ê¹¶ÔÏó½øÈëÕý³£×´Ì¬£¬Èç¹û¿ÉÒԵϰ£¬±ÜÃâµ÷ÓÃÆäËû·½·¨¡£ÔÚ¹¹ÔìÆ÷ÄÚΨһÄܹ»°²È«µ÷ÓõÄÄÇЩ·½·¨ÊÇ»ùÀàÖеÄfinal·½·¨£¨Ò²ÊÊÓÃÓÚprivate·½·¨£¬ËüÃÇ×Ô¶¯ÊôÓÚfinal·½·¨£©¡£ ¶þ.Óü̳нøÐÐÉè¼ÆµÄ×¼Ôò£º Óü̳бí´ïÐÐΪ¼äµÄ²îÒ ......