»ùÓÚJ2EEµÄÎʾíµ÷²éϵͳµÄ±ÏÒµÉè¼Æ - ͼÎÄ ÏÂÔØ±¾ÎÄ

ÉòÑôÀí¹¤´óѧѧʿѧλÂÛÎÄ

(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ÀïÅäÖÃÈçÏ´úÂ룺

JNDIname

java.lang.Stringjdbc/survey//JNDIÃû³Æ

È»ºó£¬ÔÚ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