javaÅúÁ¿µ¼Èëexcelµ½MysqlÊý¾Ý¿â
package com.google.i_sales.service.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Set;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
import org.extremecomponents.table.limit.Limit;
import org.hibernate.Criteria;
import org.hibernate.JDBCException;
import org.hibernate.criterion.CriteriaSpecification;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.impl.CriteriaImpl;
import org.springframework.util.Assert;
import org.springside.core.dao.HibernateEntityDao;
import org.springside.core.dao.support.Page;
import org.springside.core.utils.BeanUtils;
import com.google.i_sales.components.acegi.domain.User;
import com.google.i_sales.domain.Business;
import com.google.i_sales.domain.Dcompany;
import com.google.i_sales.domain.MsalesCompany;
import com.google.i_sales.domain.Reject;
import com.google.i_sales.domain.SalesCompany;
import com.google.i_sales.domain.Service;
import com.google.i_sales.domain.TelephoneCompany;
import com.google.i_sales.domain.TradeType;
import com.google.i_sales.domain.UnitInfo;
import com.google.i_sales.domain.Vcompany;
import com.google.i_sales.service.common.BusinessManager;
import com.google.i_sales.service.common.RejectManager;
import com.google.i_sales.service.common.ServiceManager;
import com.google.i_sales.service.common.TradeTypeManager;
import com.google.i_sales.service.msales.MsalesCompanyManager;
import com.google.i_sales.service.sales.DcompanyManager;
import com.google.i_sales.service.sales.SalesCompanyManager;
import com.google.i_sales.service.securit
Ïà¹ØÎĵµ£º
1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
MySQL
¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«
±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬É ......
±íÉè¼Æ·½Ã棺
1¡¢×Ö¶ÎÃû¾¡Á¿¼ò»¯£¬²»Òª³¬¹ý18¸ö×Ö·û
2¡¢Ê¹Óþ¡Á¿Ð¡µÄÊý¾ÝÀàÐÍ£¬ÀýÈ磺MEDIUMINT±ÈINTÉÙÕ¼ÓÃ25%¿Õ¼ä
3¡¢×Ö¶ÎÀàÐÍÓ¦¾¡Á¿±ÜÃâÉèÖóɿɱ䳤¶È£¬È磺VARCHAR¡¢BLOB¡¢TEXT
4¡¢ÓÃÓڱȽϵIJ»Í¬×ֶΣ¬Ó¦ÉèÖÃÏàͬµÄÀàÐͼ°³¤¶È
5¡¢¾¡¿ÉÄܽ«×Ö¶ÎÉùÃ÷ΪNOT NULL£¬²¢Ö¸¶¨DEFAULT
6¡¢Ö÷Ë÷Òý¾¡¿ÉÄܶÌ
7¡¢½ö´´½¨ÕæÕý ......
²éѯÓï¾ä:
SELECT ×Ö¶ÎÃû from ±íÃû.
ÅÅÐò order by ÒªÅÅÐòµÄ×Ö¶ÎÃû desc :ÒÔµ¹Ðò²éѯ.
limit ´ÓµÚ¼¸¸ö¿ªÊ¼ ²éÕÒ¶àÉÙ¸ö :²éÕÒÖ¸¶¨¸öÊý.
ͬʱ²éѯ¶à¸ö×Ö¶ÎÓÃ","¸ô¿ª.
Èç²éѯ±íÀïÃæµÄËùÓÐÊý¾ÝÔÚ×Ö¶ÎÃû´¦Ìî"*".
ÈçÖ»ÏëÏÔʾij×ֶεÄǰ¼¸Î»×Ö·û¿ÉÒÔʹÓÃLEFTº¯Êý.
SELECT ×Ö¶ÎÃû,LEFT(×Ö¶ÎÃû,λÊý),×Ö¶ÎÃû from ±íÃû.
COU ......
Èý. mysql server°²×°
------------------ÒÔÏÂΪÀ©Õ¹£ºÉ¾³ýmysql----------------
ɾ³ý mysql
sudo apt-get autoremove --purge mysql-server-5.0
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql- ......
PHPеÄÁ¬½ÓMySQL·½·¨mysqli
1. ¿ªÆôPHPµÄAPIÖ§³Ö
£¨1£©Ê×ÏÈÐÞ¸ÄÄúµÄphp.iniµÄÅäÖÃÎļþ¡£
²éÕÒÏÂÃæµÄÓï¾ä£º
;extension=php_mysqli.dll
½«ÆäÐÞ¸ÄΪ£º
extension=php_mysqli.dll
......