Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.
Tutorial Details:
ASP Database Related Connections, Commands and Procedures
In the previous chapter, we looked at the basics of ADO, concerning ourselves mainly with the Recordset object and the manipulation of data. In most of the examples, we obtained data by simply specifying the name of a database table, but as you've seen from the object model, ADO has other objects that allow data to be accessed.
In this chapter we are going to look at some of these in more detail. In particular, we shall examine:
1.The Connection object, and how it can be used to retrieve data and run commands.
2.The Command object, why it is necessary, and what facilities it has.
3.How to run stored procedures, especially those that require parameters.
4.Some simple optimization techniques for improving ADO performance.
5.What Data Shaping is, and how it can be used.
Read
Tutorial at: Click here to view the tutorial
Rate Tutorial: ASP Database Related Connections, Commands and Procedures Tutorial
View Tutorial: ASP Database Related Connections, Commands and Procedures Tutorial
Related
Tutorials:
 Integrating Databases
Integrating Databases
|
Commercial applications with Java
Commercial applications with Java
|
Which Java VM scales best? - JavaWorld - August
1998
Which Java VM scales best? - JavaWorld - August
1998
|
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
|
Use JDBC for
industrial-strength performance, Part 1 - JavaWorld January
2000
Use JDBC for
industrial-strength performance, Part 1 - JavaWorld January
2000
|
XSL gives your
XML some style - JavaWorld June 2000
XSL gives your
XML some style - JavaWorld June 2000
|
Get disconnected with CachedRowSet , This allows for ResultSet s to be serialized, sent to remote clients, updated
The new J2EE RowSet implementation provides updateable disconnected ResultSets in your JSPs
|
Implement a J2EE-aware application console in Swing
Implement a J2EE-aware application console in Swing
|
I want my AOP!, Part 1
I want my AOP!, Part 1
|
Test email components in your software
Test email components in your software
|
SQL Database Access with DBTags
SQL Database Access with DBTags
In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
|
eva/3 Application Builder supports eclipse 3
What is eva/3 Application Builder?
eva/3 Application Builder assumes responsibility for the design of
forms and reports via an integrated GUI Builder, the execution
of procedures and the handling of diverse relational SQL databases
through JDBC int
|
Daffodil DB - Your complete Java RDBMS
Daffodil DB - Cross Platform Java Database Products...
Daffodil DB is a J2EE-certified, SQL-99 and JDBC standards compliant Java RDBMS, made available in both Embedded and Network Editions .
|
Accessing the Database from Servlet
This article shows you how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server.
|
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
|
Overview of JDBC and its use with Microsoft Access
JDBC provides a set of classes for Java with a standard SQL database access interface. Goal is uniform access to a wide range of relational databases.
|
Welcome to Java Developers paradise!
Welcome to Java Developers paradise!
T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java
|
JSP FUNDAMENTALS
JSP FUNDAMENTALS
JSP FUNDAMENTALS
By: Hrishikesh Deshpande
Introduction :
JSP termed as Java Server Pages is a technology introduced by Sun Microsystems Inc. to develop the web application in more efficient way than Servlets. It has got many
|
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets.
MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it
|
Connecting to MySQL database and retrieving and displaying data in JSP
page
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page
This tutorial shows you how to connect to MySQL database and retrieve the data from the
|
|
|
|
