📄 insert_tscript_f.jsp

📁 java jsp教程

💻 JSP

字号:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE> insert_tscript_finance </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY>
<table>
<tr><td cosplan="2" align="center">the result</td></tr>
<tr><td>aaa</td><td>bbb</td></tr>
<%
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@192.9.101.181:1521:am";
    
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(strUrl, "ucnpc", "ucnpc");
	System.out.println("[check@stored_procedure]---->1");
    //String procedure = "{call ucnpc.insert_table () }";
	String procedure = "{call insert_auths(?,?,?,?,?) }";
    CallableStatement cstmt = conn.prepareCall(procedure);
    cstmt.setString(1,"a00022");
	cstmt.setString(2,"董方卓");
	cstmt.setInt(3,1);
	cstmt.setString(4,"10-jun-65");
	cstmt.setString(5,"10-jun-99");
    cstmt.executeUpdate();
	System.out.println("[check@stored_procedure]---->2");
    Statement stmt = conn.createStatement();
    //ResultSet rs = stmt.executeQuery("select * from tscript where projectno='sjxm0010012006034'");
	ResultSet rs = stmt.executeQuery("select * from zone_auths");

    while(rs.next())
    {
        out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>");
    }

    rs.close();
    stmt.close();
    conn.close();
%>
</table>
<p>
<%
out.print(conn.isClosed());
%>

</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -