£¨µÚÒ»Ìû£©Asp.netÁ¬½ÓoracleµÄͨÓÃÀ࣡£¨É¢ÈËÆø£©
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.OracleClient;
namespace Com2000888.Utility
{
/// <summary>
/// Copyright (C) 2004-2008 LiTianPing
/// Êý¾Ý·ÃÎÊ»ù´¡Àà(»ùÓÚOracleServer)
/// Óû§¿ÉÒÔÐÞ¸ÄÂú×ã×Ô¼ºÏîÄ¿µÄÐèÒª¡£
/// </summary>
///
public abstract class DbHelperOracle
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®(web.configÀ´ÅäÖÃ)
//<add key="ConnectionString" value="server=127.0.0.1;database=DATABASE;uid=sa;pwd=" />
public static string connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
public DbHelperOracle()
{
}
#region Ö´Ðмòµ¥OracleÓï¾ä
/// <summary>
/// Ö´ÐÐOracleÓï¾ä£¬·µ»ØÓ°ÏìµÄ¼Ç¼Êý
/// </summary>
/// <param name="OracleString">OracleÓï¾ä</param>
/// <returns>Ó°ÏìµÄ¼Ç¼Êý</returns>
public static int ExecuteOracle(string OracleString)
{
&n
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......