mybatis中各种数据的映射类型

		   Mybatis	 			java                                     			SQL

           integer              int OR Integer                              		INTEGER

           long        			long OR java.lang.Long               				BIGINT

           short   				short OR java.lang.Short             				SMALLINT

           float        		float OR java.lang.Float               				FLOAT

           double      			double OR java.lang.Double        					DOUBLE

           big_decimal          java.math.BigDecimal                  				NUMERIC

           character            java.lang.String                            		CHAR(1)

           string            	java.lang.String                             		VARCHAR

           byte                	byte OR java.lang.Byte                 				TINYINT

           boolean      		boolean OR java.lang.Boolean     					BIT

           yes_no         		boolean OR java.lang.Boolean     					CHAR(1) ('Y' OR 'N')

           true_false          	boolean OR java.lang.Boolean     					CHAR(1) ('Y' OR 'N')

           date      			java.util.Date OR java.sql.Date     				DATE

           time              	java.util.Date OR java.sql.Time     				TIME

           timestamp      		java.util.Date OR java.sql.TimeStamp    			TIMESTAMP

           calendar             java.util.Calendar                           		TIMESTAMP   

           calendar_date   		java.util.Calendar                          	 	DTAE

           binary               byte[]                                             	VARBINARY OR BLOB

           text           		java.lang.String                              		CLOB

           serializable   		java.io.Seriailzable                         		VARBINARY OR BLOB

           clob             	java.sql.Clob                                   	CLOB

           blob            		java.sql.Blob                                   	BLOB

           class              	java.lang.Class                               		VARCHAR                                

           locale          		java.util.Locale                               		VARCHAR 

           timezone        		java.util.TimeZone                          		VARCHAR  

           currency            	java.util.Currency                           		VARCHAR