java jdbc example

:" +Age ); $System.out.print (", Author:" +author); -System.out.println (", Represent:" +represent); - } the rs.close (); - stmt.close ();Wuyi conn.close (); the}Catch(SQLException se) { - se.printstacktrace (); Wu}Catch(Exception e) { - e.printstacktrace (); About}finally{ $ Try{ - if(stmt!=NULL) - stmt.close (); -}Catch(SQLException se2) { A } + Try{ the if(conn!=NULL) - conn.close (); $}Catch(SQLException se) { the se.printstacktrace (); the } the

This cainiao is involved in Java. I am not in a rush to look at the basic syntax, the features of some Java versions, or some promotion knowledge, because there is one thing. net (OOP) programming ideas, so you can find and learn these Java syntaxes and what they are used. I can't wait to use JAVA to add, delete, modif

//ResultSet rs= ps.executequery (); Traversal//Rtn=rs.next ();//If there is data to verify through//supplemental knowledge//Call stored procedure//CallableStatement Cs=conn.preparecall ("{ Call stored procedure name (?,?)} "); Get information about the database DatabaseMetaData dm= conn.getmetadata (); System.out.println ("Url=" +dm.geturl ()); System. OUT.PRINTLN ("name =" +dm.getusername ()); SYSTEM.OUT.PRINTLN ("Product name =" +dm.getdatabaseproductname ()); Metada

; +ResultSetMetaData Rsmetadata =Resultset.getmetadata (); - for(inti = 1; I ) { theSystem.out.printf ("%-8s\t", Rsmetadata.getcolumnname (i)); * } $ System.out.println ();Panax Notoginseng - //print attribute values; the while(Resultset.next ()) { + for(inti = 1; I ) { ASystem.out.printf ("%-12s\t", resultset.getstring (i)); the } + System.out.println (); - } $ $ //close the database connection; (Connecting the databas

//Error statement: There is a syntax error near the keyword ' user '; - //user is the keyword in the SQL statement, if you want to use user as the table name, you must enclose the user in square brackets [], that is [user]; to + //processing result sets (including metadata); - //Print property name; theResultSetMetaData Rsmetadata =Resultset.getmetadata (); * for(inti = 1; I ) { $System.out.printf ("%-8s\t", Rsmetadata.getcolumnname (i));Panax N

displayed.IntPage = 1;} Else {// Converts a string to an integer.IntPage = java. lang. Integer. parseInt (strPage );If (intPage // Load the JDBC-ODBC driverClass. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");// Set the database connection stringStrCon = "jdbc: odbc: Test_DB ";// Connect to the databaseSqlCon =

Import java. SQL .*; Public class testjdbc { Public static void main (string [] ARGs ){Resultset rs = NULL;Statement stmt = NULL;Connection conn = NULL;Try {Class. forname ("oracle. JDBC. Driver. oracledriver ");// New Oracle. JDBC. Driver. oracledriver ();Conn = drivermanager. getconnection ("JDBC: oracle: thin: @ 19

so on? The answer is yes. In fact, the so-called three frameworks, which are only highly encapsulated, make development easier, more convenient, and more efficient, while the real core is the knowledge of JDBC and servlets. STRUTS2 is actually encapsulated on the basis of a servlet, and hibernate is a highly encapsulated JDBC that transforms relational-oriented data operations into object-oriented programm

to describe the beginning of a thing, just commit or roll back each transaction. However, each transaction is still explicitly ended with commit or rollback. After the connection sets the implicit transaction mode to open, an implicit transaction is automatically started when the database Engine instance executes any of the following statements for the first time: Alter Table,insert,create,open, Delete,revoke, Drop,select, Fetch, truncate table,grant,update The transaction will remain in effect

Before we know about JDBC, we can make a review of ODBC to better understand JDBC. See the name also know that these two relationships are not general, they achieve the same function, for the application connection and operation of the database support. So, let's start with ODBC. Odbc ODBC (Open Database Connectivity) is a short name for open databases interconnection, an application interface that uses S

, Simply write the program once to make it run on any platform. Such as: How do you use JDBC?The main functions of JDBC are as follows: Establish a connection to a database or other data source Sending SQL commands to the database Processing the returned results of the database Here is an example of a