Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

MySQL²éѯÓÅ»¯ Ë÷Òý

MySQLË÷Òý
    MySQL²éѯÓÅ»¯×îÖØÒªµÄµ±Êô½¨Á¢ÕýÈ·µÄË÷Òý£¬Ã»ÓÐË÷Òý£¬Ãæ¶Ôº£Á¿Êý¾Ý£¬Ò»ÇеÄÓÅ»¯´¿Êô¿Õ»°¡£Ê²Ã´ÊÇË÷Òý£¿Ë÷ÒýΪʲôÄÇÃ´ÖØÒªÄØ£¿ÕâЩÎÊÌâÕâÀï¾Í²»Ì¸ÁË£¬»¹ÊÇÏÈдÏÂÎÒÊ×´ÎÓÅ»¯MySQL²éѯº£Á¿Êý¾ÝµÄÐĵðɣ¬Êý¾Ý¿â±íÀàÐÍÊÇMyISAM¡£
    Èç¹û¼òµ¥µÄÒ»¸ö²éѯÓï¾ä£¬MySQL²éѯËÙ¶È»¹ ......

mysql Á¬½Óorcal Êý¾Ý¿â OCIDefineByName


Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
 
內È ......

MySQLÓÅ»¯×ܽá


±íÉè¼Æ·½Ã棺
1¡¢×Ö¶ÎÃû¾¡Á¿¼ò»¯£¬²»Òª³¬¹ý18¸ö×Ö·û
2¡¢Ê¹Óþ¡Á¿Ð¡µÄÊý¾ÝÀàÐÍ£¬ÀýÈ磺MEDIUMINT±ÈINTÉÙÕ¼ÓÃ25%¿Õ¼ä
3¡¢×Ö¶ÎÀàÐÍÓ¦¾¡Á¿±ÜÃâÉèÖóɿɱ䳤¶È£¬È磺VARCHAR¡¢BLOB¡¢TEXT
4¡¢ÓÃÓڱȽϵIJ»Í¬×ֶΣ¬Ó¦ÉèÖÃÏàͬµÄÀàÐͼ°³¤¶È
5¡¢¾¡¿ÉÄܽ«×Ö¶ÎÉùÃ÷ΪNOT NULL£¬²¢Ö¸¶¨DEFAULT
6¡¢Ö÷Ë÷Òý¾¡¿ÉÄܶÌ
7¡¢½ö´´½¨ÕæÕý ......

UbuntuÏÂÅäÖÃÍøÂ磬°²×°mysql£¬jdk

sudo apt-get install mysql-server mysql-client
sudo apt-get install sun-java6-jdk(°²×°³öÒâÍ⣬sudo dpkg -P sun-java6-bin£¬È»ºóÖØÐ°²×°)
sudo vi /etc/network/interfaces ÅäÖÃÍøÂç
auto eth0
iface eth0 inet dhcp(static)
address 192.168.8.108
netmask 255.255.255.0
gateway 192.168.8.1
£ºx±£´æ
sud ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ