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Êý¾Ý¿â¿ÉÒÔʹÓÃmysql_pconnect£¨ÓÀ¾ÃÁ¬½Ó£©º¯Êý£¬Ê¹ÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó¿ÉÒÔÌá¸ßЧÂÊ£¬µ«ÊÇʵ¼ÊÓ¦ÓÃÖÐÊý¾Ý¿âÓÀ¾ÃÁ¬½ÓÍùÍù»áµ¼Ö³öÏÖһЩÎÊÌ⣬ͨ³£µÄ±íÏÖ¾ÍÊÇÔÚ´ó·ÃÎÊÁ¿µÄÍøÕ¾ÉÏʱ³£·¢Éú¶Ï¶ÏÐøÐøµÄÎÞ·¨Á¬½ÓÊý¾Ý¿âµÄÇé¿ö£¬³öÏÖÀàËÆ£¢Too many connections in ...£¢µÄ´íÎóÌáʾÐÅÏ¢£¬ÖØÐÂÆô¶¯·þÎñÆ÷Ó ......
¼ÙÉèÓбí tb1
ID £ü name£ü
----+--------+
1 £ü2toon£ü
2 £ü1*xyz£ü
Óï¾ä1£º
select * from tb1 where ID='2toon' or name ='2toon';
mysql·þÎñÆ÷ÔÚijģʽÏ£¬¿ÉÒÔÖ´ÐÐÕâÌõ¾ä£¬¾Í³É¹¦·µ»ØÁ½Ìõ¼Ç¼£¬ÔÒòÔÚÓÚ ID=‘2toon’ ¼ÓÁ˵¥ÒýºÅ£¬mysql½âÊÍΪ ID=2.
Óï¾ä2
select * fro ......
Love in coding...
Free and Susan
[Òý]MySQL INNODBÀàÐͱíµÄÍâ¼ü¹ØÁªÉèÖÃ
Here is a simple example that relates parent and child tables through a single-column foreign key:
CREATE TABLE parent (id INT NOT NULL,
......
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ include file="config/config_SelfHelp.jsp"%>
<%@ include file="sh_Bookmark_Data.jsp"%>
<html xmlns:v>
<head>
<title>ÎÒµÄÊéÇ©</title>
<style type="text/css">
tabl ......