ÉòÑôÀí¹¤´óѧѧʿѧλÂÛÎÄ
(3)question£¨ÌâÄ¿±í£©
¸Ã±í´æ´¢ÁËÌâÄ¿µÄ»ù±¾ÐÅÏ¢£¬Ö÷ÒªÊÇÌâÄ¿ÐÅÏ¢µÄ¼Ç¼£¬¸Ã±íµÄ×Ö¶ÎÊôÐÔÈç±í4.3£º
±í4.3 ÌâÄ¿±í
×ֶκ¬Òå ÌâÄ¿ID ÎʾíID ÌâÄ¿ÀàÐÍ Ìâ¸É Ñ¡Ïî Óû§Ìá½»µÄÑ¡Ôñ ÌâÄ¿µÄͼƬ ½Ø¶ÏÌø×ª ÌâĿ˳ÐòºÅ
×Ö¶ÎÃû Q_id S_id Q_type Q_head Q_body Q_result Q_img Q_jdtz Q_order
Êý¾ÝÀàÐÍ numeric Numeric(18) Number(18) Varchar(1000) Varchar(8000) Varchar(1000) Varchar(1000) Varchar(1000) Numeric(18)
ÊÇ·ñΪÖ÷¼ü
Yes No No No No No No No No
¿É·ñΪ¿Õ No No No No No No No No No
(4)text£¨Îı¾ÊäÈëÏîʵÌå±í£©
¸Ã±í´æ´¢ÁËÓû§ÊäÈëµÄÎı¾£¬Ö÷ÒªÊÇÎı¾ÐÅÏ¢µÄ¼Ç¼£¬¸Ã±íµÄ×Ö¶ÎÊôÐÔÈç±í4.4£º
±í4.4 Îı¾ÊäÈëÏîʵÌå±í
×ֶκ¬Òå ¹ÜÀíÔ±Ãû ÊÇ·ñÉóºËͨ¹ý Éϴεǽʱ¼ä µÇ½´ÎÊý µÇ½IP ʱ¼ä ÓÊÏä ÐÅÏ¢
×Ö¶ÎÃû a_name a_isLock a_lastlogTime a_logTimes a_loginIP a_addtime a_email a_info
Êý¾ÝÀàÐÍ varchar(50) Bit(1) datetime Number(18) varchar(50) datetime Varchar(100) Varchar(1000)
ÊÇ·ñΪÖ÷¼ü
No No No No No No No No
¿É·ñΪ¿Õ No Yes yes No No yes No No
(5)Link£¨ÓÑÇéÁ´½Ó±í£©
¸Ã±í´æ´¢ÁËÍøÕ¾Á´½ÓµÄ»ù±¾ÐÅÏ¢£¬Ö÷ÒªÊÇÁ´½ÓÐÅÏ¢µÄ¼Ç¼£¬¸Ã±íµÄ×Ö¶ÎÊôÐÔÈç±í4.5£º
17
ÉòÑôÀí¹¤´óѧѧʿѧλÂÛÎÄ ±í4.5 ÓÑÇéÁ´½Ó±í
×ֶκ¬Òå Á´½ÓID Á´½ÓURL Á´½ÓÃû Á´½ÓͼƬ Á´½ÓÐÅÏ¢ ÊÇ·ñÉóºËͨ¹ý Ìí¼Óʱ¼ä
×Ö¶ÎÃû l_id L_url L_name L_imag L_info L_isLock L_addtime
Êý¾ÝÀàÐÍ numeric(9) varchar(500) varchar(50) varchar(500) Varchar(1000)
Bit(1) datetime
ÊÇ·ñΪÖ÷¼ü
yes No No No No No No
¿É·ñΪ¿Õ No No No No No Yes yes
(6)Config£¨ÏµÍ³ÅäÖÃ±í£©
¸Ã±í´æ´¢ÁËϵͳÅäÖõĻù±¾ÐÅÏ¢£¬Ö÷ÒªÊÇϵͳÅäÖÃÐÅÏ¢¼Ç¼¡£×Ö¶ÎÊôÐÔÃèÊöÈç±í4.6£º
±í4.6 ϵͳÅäÖñí
×ֶκ¬Òå
id ÍøÕ¾Ãû ÍøÕ¾url ÊÇ·ñ¹«¿ª ¹Ø±Õ´ÊÓï ÊÚȨ
×Ö¶ÎÃû Id c_siteName c_siteURL c_isOpen c_closeWord copyright
Êý¾ÝÀàÐÍ numeric(9) varchar(500) varchar(500) Bit(1) Varchar(1000) Varchar(500)
ÊÇ·ñΪÖ÷¼ü
yes No No No No No
¿É·ñΪ¿Õ No No No Yes No No
4.5.2 Êý¾Ý¿âÁ¬½Ó·½·¨
Ê×ÏÈ£¬ÔÚTOMCATµÄCONTEXT.XMLÀïÅäÖÃÈçÏ´úÂ룺
driverClassName=%url=\ 18 ÉòÑôÀí¹¤´óѧѧʿѧλÂÛÎÄ username=\maxWait=\ ½Ó×ÅÔÚWEB-INF/WEB.XMLÀïÅäÖÃÈçÏ´úÂ룺 È»ºó£¬ÔÚConnectionFactoryÖÐд£º public class ConnectionFactory { private ConnectionFactory(){ } public static Connection getConnection(){ try { String JNDIname=(String)new javax.naming.InitialContext().lookup(\ //ѰÕÒWEB.XMLÖеÄJNDInameµÄÖµ£¬Í¨¹ýËüÀ´ÕÒµ½Êý¾Ý¿âJNDIµÄÃû³Æ } public static Connection getConnection(String JNDIname){ try { Context initCtx = new InitialContext(); Context envCtx = (Context) return ConnectionFactory.getConnection(JNDIname); } catch (NamingException e) { e.printStackTrace(); } return null; 19 ÉòÑôÀí¹¤´óѧѧʿѧλÂÛÎÄ initCtx.lookup(\ DataSource ds = (DataSource) envCtx.lookup(JNDIname); //ͨ¹ýÖ¸¶¨µÄJNDIÃû³Æ»ñÈ¡Êý¾Ý¿âÁ¬½Ó,Èç jdbc/survey } ×ÜÌå˼·¾ÍÊÇͨ¹ýweb.xml»ñÈ¡JNDIÃû³Æ£¬È»ºóͨ¹ýJNDIÃû³ÆÈ¥²éÕÒTOMCAT³õʼÉÏÏÂÎÄÖеÄJNDIÅäÖÃÖÐÊý¾ÝÔ´£¬»ñÈ¡Õâ¸öÊý¾ÝÔ´£¬´´½¨Êý¾Ý¿âÁ¬½Ó¡£ } return ds.getConnection(); } catch (NamingException e1) { e1.printStackTrace(); return null; } catch (SQLException e) { e.printStackTrace(); return null; } 20