Вернуться

Листинг

Script: /* logon.java: Вывод формы Logon 
    Author : Debu Panda
*/

import java.sql.*;
import java.io.*;
import oracle.html.*;

public class logon {

public static void main(String args[])
       throws SQLException, ClassNotFoundException, HtmlException {

HtmlHead hd = new HtmlHead("LOGON PAGE");
HtmlBody bd = new HtmlBody();
HtmlPage hp = new HtmlPage(hd, bd);
Form Myform = new Form("POST","debuemp");
Myform.addItem(new SimpleItem("Logon Page").setHeading(1));
Myform.addItem(new SimpleItem().LineBreak);
Myform.addItem(new SimpleItem("Username:").setBold());
Myform.addItem(new TextField("UserName",10,10,""));
Myform.addItem(new SimpleItem().LineBreak);
Myform.addItem(new SimpleItem("Password: ").setBold());
Myform.addItem(new PasswordField("PassWord",10,10,""));
Myform.addItem(new SimpleItem().LineBreak);
Myform.addItem(new SimpleItem().LineBreak);
Myform.addItem(new Submit("Submit1","Logon"));
Myform.addItem(new Reset("Clear"));
hp.addItem(Myform);
hp.printHeader();
hp.print();
}
}

/* debuemp.java: Прием URL-параметров, переданных приложением logon.java
   соединение (logon) с базой данных и отображение записей о служащих
   Author : Debu Panda  */

import java.sql.*;
import java.io.*;
import oracle.owas.wrb.services.http.*;
import oracle.html.*;

public class debuemp {

public static void main(String argv[])
       throws SQLException, ClassNotFoundException, HtmlException {
Class.forName("oracle.jdbc.driver.OracleDriver");

HTTP request = HTTP.getRequest();
String uname = request.getURLParameter("UserName");
String pwd  = request.getURLParameter("PassWord");
Connection conn =
DriverManager.getConnection("jdbc:oracle:oci8:@oweb",uname,pwd);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select empno,ename from EMP");
HtmlHead hd = new HtmlHead("Employee Listing");
HtmlBody bd = new HtmlBody();
HtmlPage hp = new HtmlPage(hd, bd);

DynamicTable tab = new DynamicTable(2);
TableRow row = new TableRow();
row.addCell(new TableHeaderCell("Emp#"))
   .addCell(new TableHeaderCell("Name"));
tab.addRow(row);
while (rset.next()) {
      row.addCell(new TableDataCell(String.valueOf(rset.getInt(1))))
          .addCell(new TableDataCell(rset.getString(2)));

       tab.addRow();
        }
hp.addItem(tab);
hp.printHeader();
hp.print();
}
}

Вернуться