JSP在EBS中的开发_V1.0.docVIP

JSP在EBS中的开发 Author: 彭美 Creation Date: 2014-07-01 Last Updated: 2014-07-02 Document Ref: Document Reference Number Version: 1.0 Copy Number _____ Document Control Change Record 1 Date Author Version Change Reference 2014-07-01 PM216407 1.0 No Previous Document Reviewers Name Position Distribution Copy No. Name Location Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes. Contents Document Control 2 JSP注册教程 4 预览JSP页面 7 Open and Closed Issues for this Deliverable 9 Open Issues 9 Closed Issues 9 JSP注册教程 第一步：编辑好JSP文件，并在eclipse中试运行看是否可以通过 1.编辑 Test.jsp文件 %@ page language=java contentType=text/html; charset=GB18030 pageEncoding=GB18030% %@ page import = java.sql.* % %@ page import = java.sql.DriverManager % %@ page import = java.sql.ResultSet % %@ page import = java.sql.Statement % %@ page import = java.sql.Connection % %String sDriver = oracle.jdbc.driver.OracleDriver; String sConnStr = jdbc:oracle:thin:@:1529:UAT; Connection conn = null; try{ Class.forName(sDriver); conn = DriverManager.getConnection(sConnStr,apps,shouji); conn.setAutoCommit(true); }catch(Exception ex){ ex.printStackTrace(); }% !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd html head meta http-equiv=Content-Type content=text/html; charset=GB18030 titleORALCE-EBS/title /headbodybEBS开发JSP页面! This is a test page!/b %Statement stmt = null; ResultSet rs =null; try{ if (conn != null){ stmt = conn.createStatement(); stmt.execute(insert into hek_test_a values(1,sysdate,测试数据QQ11)); rs = stmt.executeQuery(select col1,col2,col3 from hek_test_a for update); out.println(table); while(rs.next()){ out.println(trtd); out.println(输出：+rs.getString(1)); out.println(/td/tr); } out.