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

»ù´¡ JAVA¶ÔMysql½øÐÐÁ¬½Ó¡¢²åÈë¡¢Ð޸ġ¢É¾³ý²Ù×÷

Êý¾Ý¿â±íµ¥µÄ´´½¨
mysql> create database shuishengmu;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| shuishengmu        |
| test               |
+--------------------+
4 rows in set (0.00 sec)
mysql> use shuishengmu;
Database changed
mysql> create table user(
    -> userid int(8) unsigned not null auto_increment,
    -> username varchar(20) not null default'',
    -> password varchar(40) not null default'',
    -> email varchar(40) not null default'',
    -> primary key(userid)
    -> )
    -> type=myisam;
Query OK, 0 rows affected, 1 warning (0.00 sec)
******************************************************************************
ÏÂÃæµÄÀàÊÇÁ¬½Ó¡¢²åÈë¡¢Ð޸ġ¢É¾³ý²Ù×÷
package shuishengmu;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class ConnectDatabase {
    String drivename="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost/shuishengmu";
    String user="root";
    String password="111111";
    String insql;
    String upsql;
    String delsql;
    String sql="select * from user";
    String name;
    Connection conn;
    ResultSet rs=null;
    public Connection ConnectMysql(){
                try{
      &n


Ïà¹ØÎĵµ£º

Java µ÷ÓÃEXE

ʹÓÃRuntime.getRuntime().exec()·½·¨¿ÉÒÔÔÚjava³ÌÐòÀïÔËÐÐÍⲿ³ÌÐò.  
  ¸Ã·½·¨ÓÐ6¸ö¿É·ÃÎʰ汾:  
  1.exec(String   command)  
  2.exec(String   command,   String   envp[],   File   dir)    
  3.exec(String   cmd, &n ......

Java ME Mapdigit UI Toolkit ¼ò½é

ÔÚSUNÍÆ³ö LWUIT¿ª·¢°ü֮ǰ£¬ÔÚJava MEƽ̨ÉÏ¿ª·¢Óû§½çÃæ²¢²»ÊÇÒ»¼þÈÝÒ×µÄÊ£¬ÓÈÆäÊÇÏë×ö³öºÜÑ£µÄ½çÃæ£¬¸üÊÇÄÑÉϼÓÄÑ£¬ÕâÊÇÒòΪÓÉMIDP±¾ÉíÌṩµÄÓû§½çÃæÔªËØ£¬°üjavax.microedition.lcdui
ÖÐÌṩµÄ×é¼þ¹¦ÄÜÏà¶Ô¼òµ¥¡£
ʹÓà LWUIT ¿ª·¢°ü£¬¿ª·¢ÈËÔ±²»ÔÙÐèÒª±àдÓëÉ豸ÆÁÄ»´óСÏà¹ØµÄ´úÂ룬Ëü²ÉÓÃÁËÓëSwing ÏàËÆµÄ¸ÅÄîÌá ......

MYSQLÓÅ»¯ÐĵÃ

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½Óɿͻ§¶Ë·¢À´µÄSQLÓï¾äºó£¬ Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ ......

ÀûÓÃMySQLµÄÒ»¸öÌØÐÔʵÏÖMySQL²éѯ½á¹ûµÄ·ÖÒ³ÏÔʾ

ÔÚmysqlÖÐÀûÓÃselectÓï¾äµÄÒ»¸öÌØÐԾͿÉÒԺܷ½±ãµØÊµÏÖ²éѯ½á¹ûµÄ·ÖÒ³£¬selectÓï¾äµÄÓï·¨£º
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO OUTFILE 'file_name'&nb ......

MySQLÈçºÎÀûÓÃË÷ÒýÓÅ»¯ORDER BYÅÅÐòÓï¾ä


MySQLË÷Òýͨ³£ÊDZ»ÓÃÓÚÌá¸ßWHEREÌõ¼þµÄÊý¾ÝÐÐÆ¥Åä»òÕßÖ´ÐÐÁª½á²Ù×÷ʱƥÅäÆäËü±íµÄÊý¾ÝÐеÄËÑË÷ËÙ¶È¡£
MySQLÒ²ÄÜÀûÓÃË÷ÒýÀ´¿ìËÙµØÖ´ÐÐORDER BYºÍGROUP BYÓï¾äµÄÅÅÐòºÍ·Ö×é²Ù×÷¡£
ͨ¹ýË÷ÒýÓÅ»¯À´ÊµÏÖMySQLµÄORDER BYÓï¾äÓÅ»¯£º
1¡¢ORDER BYµÄË÷ÒýÓÅ»¯¡£Èç¹ûÒ»¸öSQLÓï¾äÐÎÈ磺
SELECT [column1],[column2],…. fro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ