Tutorials to .com

Tutorials to .com » Jsp » Database » Jsp And Database

Jsp And Database Articles


101: jsp in the application at the same time "stored procedure" and "javabean" example
Storage process and the application of javabean Stored procedure sp_shop_base: Create Procedure sp_shop_base (@ shop_id int, @ msg char (50) output) As SELECT shop_name, shop_phone, shop_email, shop_cash, shop_address FROM shop_shop WHERE shop...

102: Servlet using connection pooling to improve the efficiency of access to the database (
Java Servlet as the preferred server-side data-processing technology, is rapidly replacing CGI script. Servlet beyond one of the strengths of CGI is that a number of requests not only to share common resources, but also between different user reques...

103: db pool of simple example
public class OracleConnectionManager ( private DBConnectionManager connMgr; private final String poolName = "Oracle"; private Connection conn; public OracleConnectionManager () ( String userID = "system"; String password = ...

104: JDBC Connection Pool
About the database connection pool in the traditional two-tier structure, the client program at startup to open the database connection, in the process to withdraw from the closure of the database connection. In this way, the operation of the entire...

105: Example of a connection pool (note)
The connection pool is taken directly from out of JIVE, a bit modified to make a direct connection parameters set in the procedure rather than read from the document properties. Usage: Connect to set their own parameters, DbConnectionDefaultPool.j...

106: Example of a connection pool (from JIVE) (6)
/ / File: PropertyManager.java / / This class in fact, no use, and can be removed, but removed in front of several types of reference of this type. package com.qingtuo.db.pool; import java.util .*; import java.io. *; / ** * Manages properties ...

107: Example of a connection pool (from JIVE) (5)
/ / File: DbConnectionProvider.java package com.qingtuo.db.pool; import java.sql .*; import java.util .*; public abstract class DbConnectionProvider ( / ** Dummy values. Override in subclasses. ** / private static final String NAME = "&qu...

108: oracle full version of the CLOB handling
/ ** * * Operation oracle database CLOB field, both written and spoken * Authors: the master * * / package com.nes.common.sql.lob; import java.sql .*; import java.io. *; import oracle.jdbc.OracleResultSet; import oracle.sql .*; public clas...

109: weblogic under way to write clob
CLOB to write the code fragment: String SqlStr = "update TextInfo set Content = empty_clob () where TextInfoKey =" + Integer.toString (textinfokey); myConn.setAutoCommit (false); java.sql.PreparedStatement pstmt = myConn.prepareStatemen...

110: JDBC Study Notes
jdbc performance of procedures decided by two factors, first, the nature of the database itself, and the other is relatively independent with the jdbc database application programming interface (api) use. here is how the proper use of jdbc programmi...

111: Directly in the browser how to run SQL command
This article demonstrated how to use a Java Servlet, a JSP page and a static Java type of structure a SQL gateway application. Take advantage of this application, you can direct the browser to implement SQL command, the browser will be submitted to ...

112: Establish a connection
And database links Would like to establish a link with the DBMS you must do the following two tasks: (1) to load the driver (2) the establishment of links Load driver \ r Load driver very simple, only need a code. For example, you want to use JDB...

113: Example of a connection pool (from JIVE) (3)
/ / File: DbConnectionDefaultPool.java the third part of / ** * Returns the age of a connection - the time since it was handed out to * An application. * / public long getAge (Connection conn) (/ / Returns the age of the connection in millisec....

114: Example of a connection pool (from JIVE) (4)
/ / File: DbConnectionManager.java package com.qingtuo.db.pool; import java.sql .*; import java.io. *; import java.util .*; / ** * Central manager of database connections. * / public class DbConnectionManager ( private static DbConnectionPr...


Page 6 of 6
[1]   [2]   [3]   [4]   [5]   [6]