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
Ïà¹ØÎĵµ£º
<%@ page import="java.sql.*,java.io.*" %>
<%
int intPage;//´ýÏÔʾµÄÒ³Âë
int pageSize;//ÿҳÏÔʾµÄÌõÄ¿
int pageCount;//×ÜÒ³Êý
int rowCount;//¼Ç¼×ÜÊý
String strPage;//»ñÈ¡´ýÏÔʾҳÂë
pageSize=12;//ÉèÖÃÿҳÏÔʾÌõÊý
Connection con;//Á¬½Ó¶ÔÏó
Statement stmt;//Êý¾Ý¿â¶ÔÏó
Re ......
¼ÙÉèÓбí 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,
......
MySQL·þÎñÆ÷²ÉÓÃÁËÄ£¿é»¯·ç¸ñ£¬¸÷²¿·ÖÖ®¼ä±£³ÖÏà¶Ô¶ÀÁ¢£¬ÓÈÆäÌåÏÖÔÚ´æ´¢¼Ü¹¹ÉÏ¡£´æ´¢ÒýÇ渺Ôð
¹ÜÀíÊý¾Ý´æ´¢£¬ÒÔ¼°MySQLµÄË÷Òý¹ÜÀí¡£Í¨¹ý¶¨ÒåµÄAPI£¬MySQL·þÎñÆ÷Äܹ»Óë´æ´¢ÒýÇæ½øÐÐͨÐÅ¡£Ä¿Ç°Ê¹ÓÃ×î¶àµÄÊÇMyISAMºÍInnoDB¡£
InnoDB±»OracleÊÕ¹ººó£¬MySQL×ÔÐпª·¢µÄд洢ÒýÇæFalcon½«ÔÚMySQL6.0°æ±¾Òý½ø¡£
MyISAMÒýÇæÊÇÒ ......