+초코송송이+

사용자암호변경

ALTER USER user_name IDENTIFIED BY new_password;

user_name : 변경하고자 하는 사용자 명 
new_password : 새로운 암호

예) ALTER USER scott IDENTIFIED BY lion;

scott 사용자의 암호가 lion으로 바뀐다.

사용자 암호완료 확인

SQL>SELECT USERNAME, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE 

       FROM DBA_USERS 

       WHERE USERNAME='xxx';

ACCOUNT_STATUS에 EXPIRED이면 비밀번호 기간만료, OPEN이면 만료 해제, 숫자면 만료기간

사용자 비밀번호 만료 해제 SQL

sql>ALTER PROFILE DEFAULT PASSWORD_LIFE_TIME UNLIMITED;

1.Oracle Data Access Components for Windows를 다운로드한다.

http://www.oracle.com/technetwork/indexes/downloads/index.html?ssSourceSiteId=ocomen

=>설치할 때, 필수항목으로 Instant Client가 설치되는데 이미 설치되어 있어도 다시 하도록 되어있었음..;;

2. using Oracle.DataAccess.Client;

string oradb = "Data Source=(DESCRIPTION="              
              + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.xxx)(PORT=1521)))"
                //+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.xxxx.com)));"
                + "(CONNECT_DATA=(SERVER=DEDICATED)(SID=ORCL)));"
                + "User Id=user;Password=password;";//service_name은 전역데이터베이스이름
                       
using (OracleConnection conn = new OracleConnection(oradb))
{
    try
    {
        conn.Open();

        using (OracleCommand cmd = new OracleCommand())
        {
            cmd.Connection = conn;
            cmd.CommandText = "select * from " +  tablename;

            OracleDataReader dr = cmd.ExecuteReader();                                                             

            while(dr.Read())
            { 
                 MessageBox.Show(dr.GetString(1));

....

      }

      cmd.CommandText = "insert into " + tablename + " (column1, column2, column3)"
                                                       + " VALUES('" + val1 + "', '" + val3 + "', '" + val3 + "')";

      int Res = cmd.ExecuteNonQuery();
      if (Res == 1)
      {
          System.Diagnostics.Trace.WriteLine("insert 성공");
      }
      else
      {
          System.Diagnostics.Trace.WriteLine("insert 실패");
      }

        }

    }
    catch (OracleException ex) // catches only Oracle errors
    {
        switch (ex.Number)
        {
            case 1:
                MessageBox.Show("Error attempting to insert duplicate data.");
                break;

            case 12545:
                MessageBox.Show("The database is unavailable.");
                break;

            default:
                MessageBox.Show("Database error: " + ex.Message.ToString());
                break;
        }
    }

    catch (Exception ex) // catches any other error
    {
        MessageBox.Show(ex.Message.ToString());
    }
    finally
    {
         // Don't need conn.Close() because the using takes care of it.
    }
}

1. mysql-connector-net 설치

http://www.mysql.com/downloads/connector/net/

2. Reference에 추가 - MySql.Data

3. 소스에 적용

using MySql.Data;
using MySql.Data.MySqlClient;

static string DBConnectString = "Data Source=192.168.0.xxx;Database=db_name;" + "User Id=userid;Password=password" + ";charset=utf8";

MySqlConnection Con = new MySqlConnection();
Con.ConnectionString = DBConnectString;
            
try
{
    Con.Open();
         
    MySqlCommand Command = new MySqlCommand("SELECT * FROM table_name", Con);
    MySqlDataReader DataReader;
    DataReader = Command.ExecuteReader();

    while (DataReader.Read())
    {
         MappingTable MappingT = new MappingTable();
         MappingT.MappingNumber = string.Format("{0}", DataReader["table_column1"]);
         MappingT.UserId = string.Format("{0}", DataReader["table_column2"]);
         MappingT.SIP = string.Format("{0}", DataReader["table_column3"]);
         MappingTList.Add(MappingT);
    }
    DataReader.Close();
    Con.Close();
}

catch (MySqlException ex)
{
    MessageBox.Show(ex.ToString());
}