連½ÓOracle數據庫
֮ǰÎÒÒ²ÓÐ談論過.netÖÐ對²»Í¬數據庫µÄ連½Ó²Ù×÷£¬這´Î單談談Oracle£¬Æä實ÄãÒª連½Óµ½Oracle數據庫ÊÇÒªÒªÇóÓÐ個Oracle.DataAccess.dll¡£¿ÉÒÔµ½Oracle網Õ¾ÏÂ載¡£Èç¹ûÄã°²裝ÁËOracleÁË£¬Ò²會ÓÐ這個dllÁË¡£ÒýÈë¾ÍOK
Òò為ÊÇ測試£¬學習¡£ËùÒÔ´ú碼Ò²簡單¡£
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;
using System.Windows.Forms;
namespace OraWinApp
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.14)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=lab)));" + "User Id=adte;Password=adte123;";
OracleConnection conn = new OracleConnection(oradb);
try
{
conn.Open();
string sql = "select * from TB_ZCTYPE";
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
DataSet ds = new DataSet();
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
catch (Exception ex) // catches any error
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}
}
Æä實ºÜ¶à¶¼ÊǸúsqlÊÇÒ»樣µÄģʽ¡£ÎÒÒ²ÊÇ學Ň
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧÉúÔÚѧϰjdbcµÄʱºò£¬»áÎʵ½Ôõôµ÷Óô洢¹ý³Ì£¬ÏÖÔÚ½«javaµ÷ÓÃoracle´æ´¢¹ý³ÌµÄʾÀý×ܽáÈçÏ¡££¨¹ØÓÚµ÷ÓÃsqlserverµÄ´æ´¢¹ý³Ì½«ÔÚÏ´νøÐÐС½áÇë¹Ø×¢£©
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
• create or replace procedure adddept(deptno number,dname varc ......
Æô¶¯“OracleDBConsole”ʱ£££³öÏÖ“Agent process exited abnormally during initialization.”
ÔÚÔËÐÐ"emctl start dbconsole "¡¡·¢ÏÖÊÇÕÒ²»µ½Ö¸¶¨Îļþ,ÔÚÍøÉÏÕÒÁËÒ»ÏÂÔÒò, ¸ü¸ÄµÄÖ¸¶¨Îļþ¼ÐµÄÃû³Æ£¬µ«»¹ÊDz»ÄÜÆô¶¯·þÎñ£¬½á¹ûÈÏÕæ¿´ÁËһϣ¬ÊÇCTRL+C,CTRL+V È»ºó²ÅÆô¶¯³É¹¦£¬ËùÒÔÌØ¶¨Ð´ÏÂÀ´£¬¼Ç ......
ÈçºÎʹexpµÄ°ïÖúÒÔ²»Í¬µÄ×Ö·û¼¯ÏÔʾ:
ÖÐÎÄÏÔʾ£ºset nls_lang=simplified chinese_china.zhs16gbk
Ó¢ÎÄÏÔʾ£ºset nls_lang=American_america
EXPµÄËùÓвÎÊý£¨À¨ºÅÖÐΪ²ÎÊýµÄĬÈÏÖµ£©£º
USERID Óû§Ãû/¿ÚÁî È磺 USERID=duanl/duanl &nbs ......
ʹÓÃOracle 9i Êý¾Ý¿â
°²×°Íê±ÏºóOracleÊý¾Ý¿â»á×Ô¶¯Æô¶¯£¬ÏÂÃæÎÒÃÇÓÃʵ¼Ê³¬×÷À´ËµÃ÷Ò»ÏÂOracle 9iÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ¡£
ÒÔOracleÓû§µÇ½Êý¾Ý¿â£¬¿ª¸ö¿ØÖÆÌ¨´°¿Ú£»
¹Ø±ÕOracle 9i Êý¾Ý¿â
-------------Ç¿ÖÆ¹Ø±ÕÊý¾Ý¿â
-------------shutdown abort
[Oracle@wing /Oracle]$ sqlplus " / as sysdba" //ÒÔsysdbaÓû ......