Alibabacloud.com offers a wide variety of articles about java text table formatter, easily find your java text table formatter information here online.
Label:
Type name
Display length
Database type
Java type
VARCHAR
L+n
VARCHAR
Java.lang.String
CHAR
N
CHAR
Java.lang.String
Blob
L+n
Blob
Java.lang.byte[]
TEXT
65535
VARCHAR
Java.lang.String
INTEGER
4
INTEGER UNSIGNED
Java.lang.Long
type, also can not write, write to specify the download file format, do not write, what file format, download is what format, according to project needs.
suffix-name MIME name*.3GPP AUDIO/3GPP, VIDEO/3GPP*.AC3 AUDIO/AC3*.ASF allpication/vnd.ms-asf*.au Audio/basic*.css Text/css*.csv Text/csv*.doc Application/msword*.dot Application/msword*.DTD APPLICATION/XML-DTD*.DWG IMAGE/VND.DWG*.DXF IMAGE/VND.DXF*.g
SQL Server type
JDBC type (java.sql.Types)
Java language Type
bigint
BIGINT
Long
TimestampBinary
BINARY
Byte[]
Bit
BIT
Boolean
Char
CHAR
String
DecimalMoneySmallMoney
DECIMAL
Java.math.BigDecimal
Float
DOUBLE
Double
Int
INTEGER
Int
Imagevarbinary (max)
LongV
for the warehouse
@Repository @Validated public class Eventrepository {private static final Logger log = Logmanager.getlogger ();
private static final Gson Gson = new Gson ();
@PersistenceContext private Entitymanager Entitymanager;
@Inject private DataSource DataSource; private static final String Create_table_sqlformat = "CREATE TABLE IF not EXISTS '%s ' (" + "' ID ' bigint () unsigned not
NULL auto_increment, "+" ' Data '
BrowserJSP:javaserverpage.java Server PageModel: ModelsView: ViewsC:controller: ControllerTomcat: A Web server for JSPsWebmodule:web ModuleServlet: Small Service ProgramRequest: RequestsResponse: ResponseInit:initialize, initializingService: ServicesDestroy: DestructionStartup: StartMapping: MappingPattern: ModeGetParameter: Get ParametersSession: SessionsPplication: ApplicationContext: ContextsRedirect: redirectDispatch: DistributionForward: TransferSetAttribute: Setting propertiesGetAttribute
java MySQL data type comparison
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
Label:Process Description:The user sends the text message "a" to 12329, the sending record is stored in the SQL Server 2005 record table T, we need to do is according to the user sends the code "a" to return the corresponding information to the user.Considering the use of triggers, unfortunately SQL Server triggers are not able to execute Java code like Oracle do
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
-4
TEXT
65535
/A
REAL
Java.lang.Float
REAL
REAL
REAL
REAL
REAL
Dk_cm_double
SMALLINT
Java.lang.Integer
SMALLINT
SMALLINT
SMALLINT
SMALLINT
SMALLINT
Dk_cm_integer
Time
Java.sql.Time
Time
DATE
Time
Time
DATETIME HOUR to SECOND
Dk_cm_time
TIMESTAMP
Java.sql.Timestamp
TIMESTAMP
DATE
DATETIME, smalldatetime
Symbol
Meaning
Presentation
Example
G
ERA designator
Text
AD
Y
Year
Number
2009
M
Month in year
Text Number
July 07
D
Day in month
Number
10
H
Hour in am/pm (1-12)
Number
12
H
Hour in Day (0-23)
Number
0
M
Ava MySQL data type comparison
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
-4
Label:Java MySQL data type comparison
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
-4
As we all know, in the process of development, it is inevitable to encounter the need to match, find, replace, infer the occurrence of strings, and these circumstances are sometimes more complex, assuming that the pure coding method of solving, often wasting the time and energy of the program ape. Therefore, the study and use of the principle of the form, it has become the main means to solve this contradiction.As we all know, the canonical form is a specification that can be used for pattern ma
: Three large objects (lobs) to hold large graphics files or formatted text files, such as Word documents, and audio, video, and other non text files, the maximum length is 4GB. Halo Some data is stored inside the database.
bfile: Large binary object files stored outside the database with a maximum length of 4GB, an external LOB type that records changes through the database, but the data is stored outside
0. PrefaceUnderstanding the JVM virtual machine principle is a necessary step for every Java programmer to practice. But because there are a lot of things in the JVM virtual machine to tell the relatively broad, in the current exposure to the JVM virtual machine principle of the tutorial or blog, the vast majority of the text-based description, it is difficult to give people a visual perception, after readi
Java MySQL data type comparison
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
)));Cellright.setcolspan (2);Cellright.sethorizontalalignment (Element.align_center);Table.addcell (Cellright);Receipt and order person information, table body contentsTable.addcell (New Phrase ("name", Fontsong));Table.addcell (New Phrase ("John", Fontsong));Table.addcell (New Phrase ("name", Fontsong));Table.addcell (New Phrase ("Dick", Fontsong));
Table.addcell (New Phrase ("Telephone", Fontsong));Table.addcell (New Phrase ("23456789", Fontsong));T
YEAR[(2|4)]
YEAR
If yearIsDateType Configuration Property false was set to and then the returned object type is java.sql.Short . If set true to (the default) and then the returned object was of type java.sql.Date with the date set to January 1st, at midnight.
CHAR(M)
CHAR
java.lang.String(unless the character set BINARY for the column are, then byte[] is returned.)
VARCHAR(M) [BINARY]
VARCHAR
java.lang.String(unless the
This article describes the Java data type and MySQL data type comparison table. Share to everyone for your reference, specific as follows:
Type name
Display length
Database type
Java type
JDBC Type index (int)
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
Label:
Type name
Display length
Database type
Java type
JDBC Type index (int)
Describe
VARCHAR
L+n
VARCHAR
Java.lang.String
12
CHAR
N
CHAR
Java.lang.String
1
Blob
L+n
Blob
Java.lang.byte[]
-4
TEXT
65535
VARCHAR
Java.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.