c# 수업중 내용2

using ex0220_File_입출력.database;
using ex0220_File_입출력.file;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Systehttp://m.Threading.Tasks;
using Systehttp://m.Windows.Forms;

namespace ex0220_File_입출력
{
    public partial class Form1 : Form
    { 

        List<String> list = new List<String>();
    
        file_control fc= new file_control();
        FileTBDataBase ftdb = new FileTBDataBase();
        public Form1()
        {

            InitializeComponent();
           
            List<string> list = ftdb.read();
            listBox1.DataSource = null;
            listBox1.DataSource = list;
        }

        private void 파일쓰기(object sender, EventArgs e)
        {
            if (textBox1.Text == "") {
                MessageBox.Show("글자를 입력하세요");
                return;
            }


            //fc.write(textBox1.Text,list);

            //list.Add(textBox1.Text);

            ftdb.insert(textBox1.Text);
            List<string> list = ftdb.read();

            listBox1.DataSource = null;
            listBox1.DataSource = list;
            textBox1.Text = "";
            //listBox1.Items.Add("추가");

        }

        private void 불러오기(object sender, EventArgs e)
        {

            List<string> list = fc.read();
            listBox1.DataSource = null;
            listBox1.DataSource = list;
        }
    }
}

====================================================================== 

form 내용

 

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using Systehttp://m.Threading.Tasks;

namespace ex0220_File_입출력.file
{
    public class file_control
    {
        string filepath = "data.txt";
        public  void write(string text, List<string> list) 
        {
            Console.WriteLine($"write {text}");
            File.WriteAllText( filepath, text);
            foreach (var item in list)
            {
                Console.WriteLine(item);
            }
            File.WriteAllLines(filepath, list);
        }
        public List<string>  read() 
        {
            List<string> list = new List<string>(File.ReadAllLines(filepath));
            return list;
            Console.WriteLine("read");
            string text = File.ReadAllText(filepath);
            Console.WriteLine($"text = {text}");
        }
    }
}

===============================================================================

file_control

 

 

using System;
using System.Collections.Generic;
using Oracle.ManagedDataAccess.Client;

namespace ex0220_File_입출력.database
{
    public class FileTBDataBase
    {
        private static string connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)));User Id=hr;Password=1234;";

        private static OracleConnection con = null;

        public static  OracleConnection connect() 
        {
            if (con == null)
            {
                con = new OracleConnection(connectionString);
                con.Open();
            }
            else 
            {
                con.Open();
            }
            return con; 
        }

        public void insert(string text) 
        {
            OracleConnection con = connect();

            string sql = "insert into FILETB values (:value1)";
            using (OracleCommand cmd = new OracleCommand(sql, con)) 
            {
                cmd.Parameters.Add(":value1", text);
                int rowId = cmd.ExecuteNonQuery();
                Console.WriteLine($"{rowId} 행을 삽입하였습니다.");
            }
            con.Close();
        }

        public List<string> read() 
        {
            List<string> list = new List<string>();
            OracleConnection con = connect();
            string sql = "select * from filetb";
            using (OracleCommand cmd = new OracleCommand(sql, con)) 
            {
                OracleDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    list.Add(reader.GetString(0));
                }
            }
            con.Close();

            return list;
        }

    }
}

=======================================================================================

database