ͼƬ¶þ½øÖÆ´æÈëORACLEºÍд³ö
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.OracleClient;
public partial class _Default : System.Web.UI.Page
{
WebService web = new WebService();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSource = web.UpLoad();
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Stream imgdatastream = FileUpload1.PostedFile.InputStream;
int imgleng = FileUpload1.PostedFile.ContentLength;
string name = FileUpload1.FileName;
byte[] imgdata = new byte[imgleng];
if (web.UP(name,imgdata,imgleng))
{
GridView1.DataSource = web.UpLoad();
GridView1.DataBind();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton linkbtn = sender as LinkButton;
Ïà¹ØÎĵµ£º
ÔÚlinuxϰ²×°oracleÊǼþ·±ËöµÄÊÂÇé¡£¾ßÌåÀ´½²·ÖΪһϼ¸´ó²½£º
1.ÐÞ¸Äϵͳ°æ±¾
vi /etc/redhat-release
×¢Ê͵ôµÚÒ»ÐУ¬Ìí¼ÓÒ»ÐУºredhat-4
2.°²×°Èí¼þ°ü
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh comp ......
ת×Ô£º http://blog.csdn.net/kongqz/archive/2009/05/15/4184415.aspx
¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º s ......
µ±OracleµÄ¶à¸ö´æ´¢¹ý³Ì¶¼Ê¹Óù«¹²µÄ³£Á¿Ê±£¬ÎÒÃÇ¿ÉÒÔ½¨Ò»¸öרÃŵÄpackageÓÃÀ´¹ÜÀíËùÓеij£Á¿¡£¶¨ÒåµÄʾÀý´óÖÂÈçÏ£º¡¡
create or replace package GLOBAL_CONSTANT is
/*ÊýÖµÀà³£Á¿*/
/*±ÈÂÊ*/
rate_tax CONSTANT NUMBER := 1.17; -- ˰ÂÊ   ......
ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐÐ ......
±¾ÎĶÔOracleÊý¾ÝµÄµ¼Èëµ¼³ö imp ,exp Á½¸öÃüÁî½øÐÐÁ˽éÉÜ, ²¢¶ÔÆäÏàÓ¦µÄ²ÎÊý½øÐÐÁË˵Ã÷,È»ºóͨ¹ýһЩʾÀý½øÐÐÑÝÁ·,¼ÓÉîÀí½â.
ÎÄÕÂ×îºó¶ÔÔËÓÃÕâÁ½¸öÃüÁî¿ÉÄܳöÏÖµÄÎÊÌâ(ÈçȨÏÞ²»¹»,²»Í¬oracle°æ±¾)½øÐÐÁË̽ÌÖ,²¢Ìá³öÁËÏàÓ¦µÄ½â¾ö·½°¸;
±¾ÎIJ¿·ÖÄÚÈÝժ¼×ÔÍøÂç,¸ÐÐ»ÍøÓѵľÑé×ܽá;
Ò».˵Ã÷
oracle µÄexp/i ......