mysql, oracle, sqlserver, sybase database data simulator java, supports various databases, boasts platforms
Tool download address: http://download.csdn.net/detail/downloads_zip/9080339 1. Add support for more databases 1. Add driver package \bin\simulator_No.1_lib\ 2. Modify the driver, connection, user name, and password 2. Configuration file parameter description 1. Database configuration file \resource\dataBaseConfig.properties 2. Table field configuration file \[tableName]. Properties #/%INT(1,1000)%/%VARCHAR(\u1234\u1234)% 1.%INT(1,1000)% Represents a random number from 1 to 1000 2. %VARCHAR(\u1234\u1234)% Represents a random character of length 2 3.%RANDOM(a,b,c)% Indicates that one of a, b, and c is randomly selected Note: Nesting %INT(%INT(1,2)%)%… is not supported Example: For example, a field: age.INT=%int(20,25)%; A random number between 20 and 25 will be generated date.VARCHAR=2015-%INT(1,12)%-%INT(1-28)%; Same as above: Only the values between %% will change randomly After the configuration is completed, just enter OK More [email protected]
JAVA connects ACCESS, MYSQL, SQLSEVER, and ORACLE databases
. Overview 1.1 JDBC concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to support SQL functions to connect to the database. JDBC includes a set of tools written in the (Java) language. Interfaces and classes are independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBC . Overview 1.1 JDBCConcept JDBC (Java Database Connectivity) is theJava language in order to supportSQL The function provides a user interface for connecting to the database. JDBC includes a set of (Java) language, they are independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBCPurpose JDBC consists of a set of classes and interfaces written in Java language, using embedded SQL, mainly realizes three functions: establishing a link to the database, executing SQL statement and processing SQL Execution results;JDBC supports basic SQL functions, which can be used conveniently Establish connections with different relational databases and perform related operations without having to write separate programs for different DBMS. Accessing databases through Java before JDBC The only way is to use the Java input and output stream to access the iruwuqi end’s CGIprogram, access and operate the database through CGIprogram…
Connection methods between Java and SQLServer, MySql, Oracle, Access and some differences
I. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to support SQL functions to connect to the database. JDBC includes a set of tools written in the (Java) language The interfaces and classes are independent of a specific DBMS, or they can be associated with various databases. 1.2 Purpose of JDBC JDBC consists of one I. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to connect to the database in order to support the SQL function. JDBC includes a set of interfaces and classes written in the (Java) language, which are all Independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBC purpose JDBC is composed of a set of classes and interfaces written in Java language. It uses embedded SQL to mainly implement three functions: establishing a link to the database, executing SQL statements and processing SQL execution results; JDBC supports basic SQL function, you can use it to easily establish connections with different relational databases and perform related operations without having to write separate programs for different DBMS. Before the emergence of JDBC, the only…
Mysql, Oracle, Java data type correspondence_MySQL
Mysql Oracle Java BIGINT NUMBER(19,0) java.lang.Long BIT RAW byte[] BLOB BLOB RAW byte[] CHAR CHAR java.lang.String DATE DATE java.sql.Date DATETIME DATE java.sql.Timestamp DECIMAL FLOAT (24) java.math.BigDecimal DOUBLE FLOAT (24) java.lang.Double DOUBLE PRECISION FLOAT (24) java.lang.Double ENUM VARCHAR2 java.lang.String FLOAT FLOAT java.lang.Float INT NUMBER(10,0) java.lang.Integer INTEGER NUMBER(10,0) java.lang.Integer LONGBLOB BLOB RAW byte[] LONGTEXT CLOB RAW java.lang.String MEDIUMBLOB BLOB RAW byte[] MEDIUMINT NUMBER(7,0) java.lang.Integer MEDIUMTEXT CLOB RAW java.lang.String NUMERIC NUMBER REAL FLOAT (24) td> SET VARCHAR2 java.lang.String SMALLINT NUMBER(5,0) java.lang.Integer TEXT VARCHAR2 CLOB java.lang.String TIME DATE java.sql.Time TIMESTAMP DATE java.sql.Timestamp TINYBLOB RAW byte[] TINYINT NUMBER(3,0) java. lang.Boolean TINYTEXT VARCHAR2 java.lang.String VARCHAR VARCHAR2 CLOB java.lang.String YEAR NUMBER java.sql.Date (the date is set to 2 p.m. on February 1 points) //The number of bytes and the corresponding relationship The number of bytes occupied by Java Data type size (binary digits) range default value byte (word section) 8 -128 – 127 0shot (short integer) 16 -32768 – 32768 0int (integer) 32 -2147483648-2147483648 0long (long integer) 64 -9233372036854477808-9233372036854477808 0 float (floating point type) 32 -3.40292347E +38-3.40292347e+38 0.0fdouble (dual -precision) 64 -1.79769313486231570e+308-1.797693131570e+308 0.0dChar (character) 16 ‘/u/ffff’/u/u/u/u 0000 ‘/pre> boolean (Boolean) 1 true/falsefalse What is the number of bytes occupied by JAVA basic data types? byte1 byte short2…
JAVA connects ACCESS, MYSQL, SQLSEVER, ORACLE database_MySQL-mysql tutorial
. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to connect to the database in order to support the SQL function. JDBC includes a set of interfaces and classes written in the (Java) language, which are independent of a specific DBMS, or they can be associated with various databases. 1.2 Purpose of JDBC JDBC consists of a set of classes and interfaces written in Java language. It uses embedded SQL to mainly implement three functions: establishing a link to the database, executing SQL declaration and processing of SQL execution results; JDBC supports basic SQL functions, which can be used to easily establish connections with different relational databases and perform related operations without the need to write separate programs for different DBMSs. Before the emergence of JDBC, the only way to access the database through Java was to use the Java input and output stream to access the CGI program on the iruwuqi side, access and operate the database through the CGI program, and obtain the results. Each access will cause the web server to start a new CGI process to establish a connection with the database. In this way, the access…
JAVA connects ACCESS, MYSQL, SQLSEVER, ORACLE database_MySQL
. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to connect to the database in order to support the SQL function. JDBC includes a set of interfaces and classes written in the (Java) language, which are independent of a specific DBMS, or they can be associated with various databases. 1.2 Purpose of JDBC JDBC consists of a set of classes and interfaces written in Java language. It uses embedded SQL to mainly implement three functions: establishing a link to the database, executing SQL declaration and processing of SQL execution results; JDBC supports basic SQL functions, which can be used to easily establish connections with different relational databases and perform related operations without the need to write separate programs for different DBMSs. Before the emergence of JDBC, the only way to access the database through Java was to use the Java input and output stream to access the CGI program on the iruwuqi side, access and operate the database through the CGI program, and obtain the results. Each access will cause the web server to start a new CGI process to establish a connection with the database. In this way, the access…
Mysql, Oracle, Java data type correspondence_MySQL
Mysql Oracle Java BIGINT NUMBER(19,0) java.lang.Long BIT RAW byte[] BLOB BLOB RAW byte[] CHAR CHAR java.lang.String DATE DATE java.sql.Date DATETIME DATE java.sql.Timestamp DECIMAL FLOAT (24) java.math.BigDecimal DOUBLE FLOAT (24) java.lang.Double DOUBLE PRECISION FLOAT (24) java.lang.Double ENUM VARCHAR2 java.lang.String FLOAT FLOAT java.lang.Float INT NUMBER(10,0) java.lang.Integer INTEGER NUMBER(10,0) java.lang.Integer LONGBLOB BLOB RAW byte[] LONGTEXT CLOB RAW java.lang.String MEDIUMBLOB BLOB RAW byte[] MEDIUMINT NUMBER(7,0) java.lang.Integer MEDIUMTEXT CLOB RAW java.lang.String NUMERIC NUMBER REAL FLOAT (24) td> SET VARCHAR2 java.lang.String SMALLINT NUMBER(5,0) java.lang.Integer TEXT VARCHAR2 CLOB java.lang.String TIME DATE java.sql.Time TIMESTAMP DATE java.sql.Timestamp TINYBLOB RAW byte[] TINYINT NUMBER(3,0) java. lang.Boolean TINYTEXT VARCHAR2 java.lang.String VARCHAR VARCHAR2 CLOB java.lang.String YEAR NUMBER java.sql.Date (the date is set to 2 p.m. on February 1 points) //The number of bytes and the corresponding relationship The number of bytes occupied by Java Data type size (binary digits) range default value byte (word section) 8 -128 – 127 0shot (short integer) 16 -32768 – 32768 0int (integer) 32 -2147483648-2147483648 0long (long integer) 64 -9233372036854477808-9233372036854477808 0 float (floating point type) 32 -3.40292347E +38-3.40292347e+38 0.0fdouble (dual -precision) 64 -1.79769313486231570e+308-1.797693131570e+308 0.0dChar (character) 16 ‘/u/ffff’/u/u/u/u 0000 ‘/pre> boolean (Boolean) 1 true/falsefalse What is the number of bytes occupied by JAVA basic data types? byte1 byte short2…
Connection methods between Java and SQLServer, MySql, Oracle, Access and some differences
I. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to support SQL functions to connect to the database. JDBC includes a set of tools written in the (Java) language The interfaces and classes are independent of a specific DBMS, or they can be associated with various databases. 1.2 Purpose of JDBC JDBC consists of one I. Overview 1.1 JDBC Concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to connect to the database in order to support the SQL function. JDBC includes a set of interfaces and classes written in the (Java) language, which are all Independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBC purpose JDBC is composed of a set of classes and interfaces written in Java language. It uses embedded SQL to mainly implement three functions: establishing a link to the database, executing SQL statements and processing SQL execution results; JDBC supports basic SQL function, you can use it to easily establish connections with different relational databases and perform related operations without having to write separate programs for different DBMS. Before the emergence of JDBC, the only…
JAVA connects ACCESS, MYSQL, SQLSEVER, and ORACLE databases
. Overview 1.1 JDBC concept JDBC (Java Database Connectivity) is a user interface provided by the Java language to support SQL functions to connect to the database. JDBC includes a set of tools written in the (Java) language. Interfaces and classes are independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBC . Overview 1.1 JDBCConcept JDBC (Java Database Connectivity) is theJava language in order to supportSQL The function provides a user interface for connecting to the database. JDBC includes a set of (Java) language, they are independent of a specific DBMS, or they can be associated with various databases. 1.2 JDBCPurpose JDBC consists of a set of classes and interfaces written in Java language, using embedded SQL, mainly realizes three functions: establishing a link to the database, executing SQL statement and processing SQL Execution results;JDBC supports basic SQL functions, which can be used conveniently Establish connections with different relational databases and perform related operations without having to write separate programs for different DBMS. Accessing databases through Java before JDBC The only way is to use the Java input and output stream to access the iruwuqi end’s CGIprogram, access and operate the database through CGIprogram…
Analysis of steps to connect to database in Java (Oracle, MySQL)
1.java connects to Oracle database Use the following three steps of code: Download the ojdbc.jar package and import it into the project. Place the following code where you think it should go. Modify the code: Change MyDbComputerNameOrIP to the IP of the computer where the Oracle database is located, and change UserName and Password to the previously defined username and password. Then, you can use it. Connection cOnnect= null; Class.forName(“oracle.jdbc.driver.OracleDriver”);//Add the oracle driver, “” is the path of the driver String url = “jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:myorcl”;// Database connection, oracle represents the oracle database connected; thin:@MyDbComputerNameOrIP represents the IP address of the database (thin: can be retained); 1521 represents the port number to connect to the database; myorcl represents the database name String UserName = “******”;//Database user login name String Password = “******”;//Password cOnnect= DriverManager.getConnection(url, UserName, Password); 2. Java connects to MySQL database Use the following three steps of code: Download the mysql-jdbc.jar package and import it into the project. Still place the following code where you think it should be. Modify the code: Change localhost to the IP of the computer where the MySQL database is located, change test to the database name, and change root and root to the previously defined…
