accessÖÐreplaceÎÊÌâ
ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
ID UnistsName
UN1 ºÚÁú½¶«·½Ñ§Ôº
UN2 ÖйúÒÆ¶¯Í¨Ðż¯ÍźÚÁú½ÓÐÏÞ¹«Ë¾
UN3 Áìµ¼¸É²¿ÃñÖ÷²âÆÀ(¼ò)
ÎÒдÁËÒ»¸ö²éѯÓï¾ä:select ID,UnitsName from Units order by (replace(Ltrim(Rtrim(ID)),'UN','')+0)
Õâ¸öÓï¾äÊǰ´"UN"ºóÃæµÄÊý×Ö´óСÅÅÐò.
ÎÊÌâÊÇÕâ¸öÓï¾äÎÒÔÚaccessÖеIJéѯÖÐÔËÐÐûÓÐÎÊÌâ,µ«ÊÇÔÚ OleDbDataAdapter ÖÐÒ»Ö±ÐоÍ˵:
"±í´ïʽÖÐ 'replace' º¯Êý䶨Òå".ÕâÊÇΪʲô?
ÕâÊÇÖ´ÐÐÕâ¸ö²éѯÓï¾äµÄ·½·¨:
public static DataSet Query(string SQLString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connecti
Ïà¹ØÎÊ´ð£º
accessÊý¾Ý¿â¡£ÓÐÁ½¸ö±ía£¬b
a±í±£´æÁ˺ܶàѧУµÄÐÅÏ¢
b±í±£´æÁËѧУ±¨ÃûµÄÐÅÏ¢£¬Ò»¸öѧУ¿ÉÒÔ±¨nÌõ
ÒªÇóÊä³öËùÓÐѧУµÄ±¨Ãû¼Ç¼ÊýÁ¿È磺
¼×У 25
ÒÒУ 50
±ûУ 50
¶¡Ð£ 70
.
.
.
......
´ó¶àÊýµÄÃâ·ÑJSPÍøÕ¾¿Õ¼ä¶¼Ö»Ö§³ÖMYSQL£¬ÔÏÈ×öºÃµÄÍøÕ¾ÊÇACCESS£¬Ö»ºÃ¿¼ÂÇ»»³ÉMYSQLÁË£¬µ«ÊÇÕûÕûŪÁËÒ»Ìì¶¼×°²»ÉÏMYSQL£¬Í·¶¼ÔÎÁË¡£
JSPÍøÕ¾¿Õ¼äÖ§³ÖACCESSºÃÏñÊÇûÓн¨¹ýµÄ£¬JspÒ»°ãÖ§³ÖMysql£¬Ora ......
¸÷λ´óÏÀ£º
ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔÀ´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......
ϵͳÿÌì²úÉúÒ»¸öexcelÎļþ£¬¸ñʽÏàͬ£¬ÄÚÈÝÓÃÎļþÃû£¨ÓòúÉúµÄʱ¼äÃüÃû£©Çø·Ö¡£ÎÒ×öÁËÒ»¸öaccessÊý¾Ý¿â£¬µ¼ÈëexcelµÄÊý¾Ý£¬ÎÒÏë¼ÓÒ»Ïî¼Í¼ÎļþÃûÀ´Çø·ÖÄÚÈÝ£¬¿ÉÊÇÔõô×öÄØ£¿ÓÖ»òÕßÓÃʲôÆäËû·½·¨¿ÉÒÔ°ìµ½£¿Ð»ÁË
Äã ......