-------------------------------------AlgorithmBrief Introduction ----------------------------------------- St algorithm O (nlogn) preprocessing, the maximum value of the specified range in O (1) query (take the minimum value as an example)
Many Java operations on blob and clob fields in Oracle on the network are not comprehensive, some are inaccurate, and some are even nonsense. The recent project uses this knowledge and summarizes it here.Environment:Database: Oracle 9iAPP server:
Compile your own JDBC framework
The data used to define data is called metadata.
Metadata-databasemetadata
L metadata: Definition information of databases, tables, and columns.
L connection. getdatabasemetadata ()
L databasemetadata object
•
Simulation and handling of ORA-8102 ProblemsSQL> SELECT NAME, TYPE # FROM OBJ $ WHERE OBJ # = 49;Name type #----------------------------------------I _CON2 1SQL> SELECT TABLE_NAME FROM DBA_INDEXES WHERE INDEX_NAME = 'I _ con2 ';TABLE_NAME------------
Java Study Notes-JDBC2 (17), study notes jdbc2
1. Review: six fixed steps of jdbc * (take query as an example)
// 1. register the driver (which can be connected to the database) DriverManager. registerDriver (new Driver (); // 2. obtain the
Intent:
Allows an object to change its behavior when its internal state changes. The object seems to have modified its class.
Applicable environment:
1) the behavior of an object depends on its state, and it must change its behavior according to
Obtain the primary key instance automatically generated by the database
Public voidInsert (){
Connection con =Null;
Preparedstatement ST =Null;
Resultset rs =Null;
// Obtain the connection
Try{
Con = dbmanager.Getconnection();
String SQL = "insert
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.