Java Data Access—JDBC, JNDI, and JAXP phần 9 pptx

... to establish a database connection. Listing 17−3: DatabaseBean .java // Java Data Access: JDBC, JNDI, and JAXP // Chapter 17 − Web Applications and Data Access // DatabaseBean .java package Chapter18; import ... the JAXP 1.1 as an optional package. The JAXP 1.1 will be included in the Java 2 Platform Standard Edition (J2SE) 1.4 and in the Java 2 Platform Enterprise E...

Ngày tải lên: 14/08/2014, 06:21

... 135 ResultSetMetaData example 136 The DatabaseMetaData Interface 140 Creating DatabaseMetaData objects 141 Using DatabaseMetaData objects 141 DatabaseMetaData example 144 Summary 1 49 Part III: Using Java Data ... Concepts 89 Result set cursors 89 Result set types 90 Retrieving result set data 91 Using Standard Result Sets 93 Creating a standard result set 93 Moving data ar...

Ngày tải lên: 14/08/2014, 06:21

... Salary: $2000 .95 , HireDate: 199 9−01−11 SSN: 1234567 89, Name: Jimmy, Salary: $3080.05, HireDate: 199 7− 09 07 SSN: 98 7654321, Name: John, Salary: $4351.27, HireDate: 199 6−12−31 Goodbye! Examining ... VALUES(31265 498 7," +"’Lori’,’2000 .95 ’,{d ‘ 199 9−01−11’},300)"); stmt.executeUpdate("INSERT INTO Employees VALUES(1234567 89, " +"’Jimmy’,’3080’,{d ‘ 19...

Ngày tải lên: 14/08/2014, 06:21

... 5000.00 199 5− 09 16 100 98 7654321 John 4351.00 199 6−12−31 500 868653 391 Greg 4351.00 199 6−12−31 500 1234567 89 Jimmy 3080.00 199 7− 09 07 400 31265 498 7 Lori 2000 .95 199 9−01−11 300 4 198 76541 Larry 1500.00 ... around and viewing data in a result set• Updating data in a result set• Retrieving data from a result set• Handling data type issues• In Chapter 4, “Connecting t...

Ngày tải lên: 14/08/2014, 06:21

... 198 9− 09 16 100 4 198 76541 Larry 1500.75 2001−03−05 200 31265 498 7 Lori 2000 .95 199 9−01−11 300 1234567 89 Jimmy 3080.05 199 7− 09 07 400 98 7654321 John 4351.27 199 6−12−31 500 537642256 Andy 1400.51 ... defining and manipulating tables with data. In 198 9, the language was extended to support data integrity with referential and general constraints. SQL2, or SQL92, was adopt...

Ngày tải lên: 14/08/2014, 06:21

... DriverManager.getConnection(jdbcUrl,user,pwd); //Initialize a DatabaseMetaData object DatabaseMetaData dmd = conn.getMetaData(); //Retrieve database name and version String dbname = dmd.getDatabaseProductName(); dbname ... java. sql.Statement; import java. sql.DriverManager; import java. sql.SQLException; import java. sql.DatabaseMetaData; public class DBMetaData { public static v...

Ngày tải lên: 14/08/2014, 06:21

... with JAXP Chapter 19: Accessing Data with Enterprise JavaBeans 203 Chapter 13: Accessing Enterprise Data with JNDI In This Chapter Introducing naming and directory services• Understanding the Java ... ConnectionManager and Factory objects are implemented as a Singleton.• You can supply usernames, passwords and database IDs as parameters to control what database you connect to...

Ngày tải lên: 14/08/2014, 06:21

... InitialContext(env); //Bind the DataSource object bindDataSource(ctx, dataSourceName); //Retrieve the DataSource object DataSource ds = null; ds = (DataSource) ctx.lookup(dataSourceName); //Open ... View and update data in disconnected environments• Take advantage of JavaBean technology, for example by using standard setter and getter methods for configuring and retrieving pro...

Ngày tải lên: 14/08/2014, 06:21

... 31265 498 7, Name: Lori, Salary: $2000 .95 , HireDate: 199 9−01−11 SSN: 1234567 89, Name: Jimmy, Salary: $3080.05, HireDate: 199 7− 09 07 SSN: 98 7654321, Name: John, Salary: $4351.27, HireDate: 199 6−12−31 Goodbye! From ... logic. Java servlets and JavaServer Pages (JSP) are server−side Sun Java technologies used to develop high−performance and highly scalable enterprise Web applica...

Ngày tải lên: 14/08/2014, 06:21

... (see Listing 19 4). Listing 19 4: CustomerBean .java import java. io.Serializable; import java. util.Enumeration; import java. util.Vector; import javax.ejb.*; import javax.naming.InitialContext; import javax.naming.NamingException; import ... Customer .java file (see Listing 19 5) contains the getter and setter methods that you want to expose to the clients of the EJB. Listing 19 5: C...

Ngày tải lên: 14/08/2014, 06:21