Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jdbcÁ¬½ÓmysqlÎÊÌâ

Java code:
import java.sql.*;

public class DBTester1 {
public static void main(String[] args) throws Exception {
Connection con;
Statement stmt;
ResultSet rs;

Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl =
"jdbc:mysql://localhost:3306/STOREDB?useUnicode=true&characterEncoding=GB2312";
String dbUser = "dbuser";
String dbPwd ="1234";
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt= con.createStatement();

stmt.executeUpdate("insert into CUSTOMERS (NAME,AGE,ADDRESS)"
+"VALUES('СÍõ',20,'ÉϺ£')");
rs = stmt.executeQuery("SELECT ID,NAME,AGE,ADDRESS from CUSTOEMRS");
while(rs.next())
{
long id = rs.getLong(1);
String name = rs.getString(2);
int age = rs.getInt(3);
String address = rs.getString(4);

System.out.println("id="+id+",name="+name+",age="+age+",address="+address);
}
stmt.executeUpdate("delete from CUSTOMERS where name='СÍõ'");
rs.close();
stmt.close();
con.close();


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

hibernate mysql ÈÕÎÄ


±í½á¹¹

mysqlÊý¾Ý


ÍøÒ³ÏÔʾµÄÊý¾Ý

ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£

ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»


ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

MYSQLÐÂÊÖÎÊÌ⣬

SQL code:

--½¨Á¢ÁÙʱ±í£¬ÎÊÌâ1
create TEMPORARY table tmp_table(s1 int,s2 varchar(30))
--select * from tmp_table
--½¨Á¢ÁÙʱ±äÁ¿£¬ÎÊÌâ2
set @v=0;
--Ñ­»·Ö´ÐвåÈë²Ù×÷£¬ÎÊÌâ3
while @v<20 do
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ