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

MysqlͨÓòéѯ²Ù×÷Àà(Jsp+servlet+javaBean+Mysql)

ÔÚÌÚ¿ÆÅàѵÁËÓÐ1¸ö°ëÔÂÁË£¬ÖÕÓÚѧÍêJSP+SERVLET+JAVABEAN+MYSQL£¬Ñ§ÁËjavaµÄµÚÒ»Ì×web½â¾ö·½°¸¡£ÀÏʦҪÇóÎÒÃÇ6ÈËÒ»×鿪ʼ×öÒ»¸ö¶©²Íϵͳ¡£Õâ¸öϵͳûÓÐÊ²Ã´ÌØ±ðµÄ£¬¾Í¸úµç×ÓÉ̳ÇÊÇÒ»¸öÑùµÄ¡£ÓÉÓÚÒª¶ÔÊý¾Ý¿â×ö´óÁ¿µÄÔöɾ¸Ä²é£¬ÄǸö´úÂëÓֶ࣬ÎÒÏëÄܲ»Äܽ«Êý¾Ý¿â²Ù×÷µÄÕâÒ»²ã´ò°üÆðÀ´(SqlOperDao)£¬ÈÃÎÒ¶ÔÊý¾Ý¿â²Ù×÷£¬Óü¸ÐдúÂë¾Í¸ã¶¨µÄ¡£È»ºóÎÒÖ»ÐÞ¸ÄsqlÓï¾ä£¬ºÍ´«½øÀ´µÄ²ÎÊý¾Í¿ÉÒÔÁË¡£
Ôöɾ¸ÄÊôÓÚÒ»Àà²Ù×÷£¬¶¼ÊDz»·µ»Ø½á¹û¼¯µÄ£¬¶ø²éÕÒÊÇÒª·µ»Ø½á¹û¼¯µÄ
1£©ÏÈ˵Ôöɾ¸ÄµÄ²Ù×÷
public int buildConn(String sql)throws Exception{
  Connection conn=null;
  Statement stmt=null;
   int result=0;
  boolean flag;
   try{
   conn=sqlconn.conn();
   stmt=conn.createStatement();
      result=stmt.executeUpdate(sql);
   System.out.println("¹§Ï²ÄãÖ´Ðгɹ¦"+result+"Ìõ¼Ç¼£¡");
   flag=true;
  }catch(Exception e){
   System.out.println("±§Ç¸£¡Ö´ÐÐʧ°Ü£¡"+e.getMessage());
   flag=false;
  }finally{
   
   stmt.close();
   conn.close();
  }
  return result;
 }
2£©¶ø¶ÔÓÚ²éѯ²Ù×÷µÄ¾Í±È½ÏÂé·³Ò»µã£¬Í¨³£ÎÒÃǶ¼½«²éѯµÄ½á¹û¼¯´ò°üµ½Ò»¸öjavabean×éºÏÖУ¬ÀýÈçÎÒÓÐÒ»¸öµÇ½µÄjavabeanÀïÃæÖ»ÓÐnameºÍpassword£¬¶ÔÓ¦µÄ±íÖÐuser_listµÄÁ½ÁÐname,password.ÏÖÔÚÒª½«user_listÖеÄËùÓÐÊý¾Ý¶Á³öÀ´£¬¶Á³öÒ»Ìõ£¬¾Í·Åµ½Ò»¸öjavabeanÖУ¬¶àÌõÊý¾Ý¾Í·Åµ½List<javabean>ÖС£Ê×ÏÈÎÒÃÇ¿ÉÒÔ½²Êý¾Ý¿âÖеÄËùÓÐÊý¾Ý¶¼ÓöÁÈ¡×Ö·û´®µÄÐÎʽgetStringµÄ·½·¨¶Á³öÀ´£¬µ±È»Èç¹ûÊý¾Ý¿âÖбíµÄÁеÄÊôÐÔ²»ÊÇvarcharÀàÐÍ£¬¾Í²»¿ÉÒÔÓôËÀà·½·¨¡£
±¾Í¨ÓòéѯֻÕë¶Ô¶¼ÊÇStringÀàÐÍµÄ±í¡£
 /**
  * ͨÓòéѯ£¬´«ÈëÒª²éѯµÄsqlÓï¾ä
  * ·µ»ØÒ»¸öList<String[]>
  */
 public List<String[]> query(String sql) throws Exception{
  this.queryList=new ArrayList<String[]>();
  Statement stmt = null;
  ResultSet rs = null;
     Connection conn=null;
&n


Ïà¹ØÎĵµ£º

PHPʹÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó·½Ê½²Ù×÷MySQLµÄÊÇÓë·Ç

PHP³ÌÐòÔ±Ó¦¸Ã¶¼ÖªµÀÁ¬½ÓMySQLÊý¾Ý¿â¿ÉÒÔʹÓÃmysql_pconnect£¨ÓÀ¾ÃÁ¬½Ó£©º¯Êý£¬Ê¹ÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó¿ÉÒÔÌá¸ßЧÂÊ£¬µ«ÊÇʵ¼ÊÓ¦ÓÃÖÐÊý¾Ý¿âÓÀ¾ÃÁ¬½ÓÍùÍù»áµ¼Ö³öÏÖһЩÎÊÌ⣬ͨ³£µÄ±íÏÖ¾ÍÊÇÔÚ´ó·ÃÎÊÁ¿µÄÍøÕ¾ÉÏʱ³£·¢Éú¶Ï¶ÏÐøÐøµÄÎÞ·¨Á¬½ÓÊý¾Ý¿âµÄÇé¿ö£¬³öÏÖÀàËÆ£¢Too many connections in ...£¢µÄ´íÎóÌáʾÐÅÏ¢£¬ÖØÐÂÆô¶¯·þÎñÆ÷Ó ......

mysql ʱ¼äº¯Êý

ÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º 
¡¡¡¡mysql> SELECT something from table 
¡¡¡¡WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30; 
   select   TO_DAYS(NOW());
   select now() ;
¡¡¡¡DAYOFWEEK( ......

ÈçºÎÐÞ¸ÄMYSQLÊý¾Ý¿âÃÜÂë


Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬
ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
·½·¨Ò»
ʹÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
·½·¨¶þ
ʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£
mysqladmin -u root -p password mypas ......

mysqlºÍsqlserverÖв鿴µ±Ç°¿âÖÐËùÓбíºÍ×Ö¶ÎÐÅÏ¢

>>mysql:
1¡¢²é¿´ËùÓбíÃû£º
show tables [from db_name];
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SHOW FULL COLUMNS from db_name.table_name
»ñÈ¡ÒÔÏÂÐÅÏ¢
Field £º×Ö¶ÎÃû
Type£º×Ö¶ÎÀàÐÍ
Collation£º×Ö·û¼¯ £¨mysql 5.0ÒÔÉÏÓУ©
Null £ºÊÇ·ñ¿ÉÒÔΪNULL
Key£ºË÷Òý£¨PRI,unique,index)
Default£ºÈ±Ê¡Öµ
Extra£º¶îÍ⣨ÊÇ·ñ aut ......

Java/JSPÖÐÎÄÂÒÂëÎÊÌâ½â¾öÐĵÃ

Java/JSPÖÐÎÄÂÒÂëÎÊÌâ½â¾öÐĵÃ
×Ô´Ó½Ó´¥JavaºÍJSPÒÔÀ´£¬¾Í²»¶ÏÓëJavaµÄÖÐÎÄÂÒÂëÎÊÌâ´ò½»µÀ£¬ÏÖÔÚÖÕÓڵõ½Á˳¹µ×µÄ½â¾ö£¬ÏÖ½«ÎÒÃǵĽâ¾öÐĵÃÓë´ó¼Ò¹²Ïí¡£
Ò»¡¢JavaÖÐÎÄÎÊÌâµÄÓÉÀ´
JavaµÄÄں˺ÍclassÎļþÊÇ»ùÓÚunicodeµÄ£¬ÕâʹJava³ÌÐò¾ßÓÐÁ¼ºÃµÄ¿çƽ̨ÐÔ£¬µ«Ò²´øÀ´ÁËһЩÖÐÎÄÂÒÂëÎÊÌâµÄÂé·³¡£Ô­ÒòÖ÷ÒªÓÐÁ½·½Ã棬JavaºÍJS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ