Chinacyber.com
Web Basics
Web Data Access
Sun
Microsystem
Netscape
Sun JDBC Course
Microsoft
PERL
Cold
Fusion
|
Internet Basics |
|
Web Basics
Web Browsers
Programs that
display Web pages. Two major browsers are
Internet
Explorer
Netscape Navigator
Web Servers
Internet
Information Server : Manages Web
sites with multiple Web servers. Used to deploy intra- and inter-net
sites.
O'reilly Web Site Pro
Netscape Enterprise
Server
Chili'Asp
HTML Editors
HomeSite 4.0
FrontPage
98
Netscape Composer
Image Editors
PaintShop Pro: a shareware
program from JASC Incorporated.
Image Composer: comes with MS
FrontPage, MS Publisher, and some versions of MS Office
97.
Adobe PhotoShop:
a high-end commercial editor popular with graphics
professionals.
Document
Languages
HTML
: Development tool used to connect
multimedia content (graphics, text, images). This coding allows files to
appear as formatted pages on the Web.
Cascading Style Sheets
: Enable you to precisely control the position and
appearance of all the elements on dozens or even hundreds of pages on your
site. In addition to letting you apply a consistent look and feel to all
your pages, CSS enables you to quickly change this aesthetic scheme in the
future. Can manipulate and control the text, layout, and graphics of your
pages so that they will look attractive in both Netscape Communicator and
Microsoft Internet Explorer.
Client Scripting Languages
JavaScript : Allows Web page developers to incorporate GUI (Graphic User
Interface) actions into Web pages. This is based on HTML and is used to
develop CGI (Common Gateway Interface) scripts and interactive Web
pages.
VBScript : Scripting languageused to develop interactive applications for the Web. It's Microsoft's answer to JavaScript.
Dynamic HTML : An extended version of HTML and JavaScript. It includes improved animation. Allows the content of a page to change each time the user clicks, drags, or points to elements on the page.XML : An extension to HTML that gives more control of content. Formats data by using document tags to catalog information. Used in EDI (Electronic Data Interchange) Internet systems.
Server Scripting
Languages
Active Server
Pages : An application
development tool which allows developers to embed programs in HTML pages
to create dynamic web pages.
Java Server Pages: create
server-side scripts in Java, e.g., Drumbeat 2000 has a JSP
version.
Perl
: Scripting language used in Unix
systems. Combines elements of C language and Unix shell commands. Popular
in creating CGI (Common Gateway Interface) scripts on the
Internet.
Other Languages
Distributed Visual Basic: provides a full-featured development environment with features like
IntelliSense.
Distributed Visual C++:
provides a great deal of functionality to
your component
Java : Enables the creation of platform independent
middleware and applications. Java is one
of the world's most popular languages.
Web Data Access
SQL BASICS
SQL can be broken into three categories:
QML [Query Manipulation Language]->Select command
e.g., select * from myTable
DML [Data Manipulation Language]->Insert, Update, Delete
commands
e.g., insert phoneList ( fullName, PhoneNum
)
values (Jason Wang,
312-999-9918)
update
student_eval
set instructor_rate =
'10'
where
studentID="15678"
delete from
student_enroll
where
studentID='15678'
DDL [Data Definition Language]->Create, Drop commands
e.g.,
create employee
(empID int not
null,
lname varchar(30) not
null,
fname varchar(20)
null)
drop table employee
A Perl ODBC example:
use Win32 :: ODBC;
my ($db) = new Win32 ::
ODBC('pubs');
$db->Sql("select * from publishers");
while
($db->FetchRow()) {
my(%data) =
$db->DataHash();
print
HTML"<tr><td>$data{'pub_id'}";
print HTML"
<td>$data{'pub_name'}";
print HTML"
<td>$data{'city'}";
print HTML"
<td>$data{'state'}";
print HTML"
<td>$data{'country'}";
}
$db->Close( );
/* This sample shows how to list all the names from the EMP table
* It uses the JDBC OCI8 driver. See the same program in the
* thin or oci7 samples directories to see how to use the other drivers.*/
// You need to import the java.sql package to use JDBC
import java.sql.*;
class Employee
{ public static void main (String args [])
throws SQLException, ClassNotFoundException
{
// Load the Oracle JDBC driver
Class.forName ("oracle.jdbc.driver.OracleDriver");
// Connect to the database
// You can put a database name after the @ sign in the connection URL.
Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci8:@", "scott", "tiger");
// Create a Statement
Statement stmt = conn.createStatement ();
// Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
// Iterate through the result and print the employee names
while (rset.next ())
System.out.println (rset.getString (1)); }}
|
|