private void Submit_Click(object sender, RoutedEventArgs e)
{
try
{
using (conn = new MySqlConnection(dbInfo()))
{
conn.Open();
if (conn.State == ConnectionState.Open) // System.Data
{
MessageBox.Show("서버에 연결");
}
// MySql DB Table 생성 (없으면)
string create_sql = "Create table if not exists " + dbTable + " ("
+ "id int NOT NULL AUTO_INCREMENT PRIMARY KEY,"
+ "date Date NOT NULL,"
+ "title Varchar(45) NOT NULL,"
+ "amount int NOT NULL,"
+ "source Varchar(45) NOT NULL,"
+ "remarks Varchar(45)"
+ ");";
MySqlCommand create_cmd = new MySqlCommand(create_sql, conn);
create_cmd.ExecuteNonQuery();
//MessageBox.Show("테이블 생성 성공");
// MySql DB Table 값 입력
string insert_sql = "";
if (Remarks.ToString() != "")
{
insert_sql = "insert into " + dbTable
+ "(date, title, amount, source, remarks)"
+ " values "
+ "(\'" + Date.Text + "\', \'" + Title.Text + "\', " + Amount.Text + ", \'" + Source.Text + "\', \'" + Remarks.Text + "\');";
}
else
{
insert_sql = "insert into " + dbTable
+ "(date, title, amount, source)"
+ " values "
+ "(\'" + Date.Text + "\', \'" + Title.Text + "\', " + Amount.Text + ", \'" + Source.Text + "\');";
}
MySqlCommand insert_cmd = new MySqlCommand(insert_sql, conn);
insert_cmd.ExecuteNonQuery();
MessageBox.Show("입력 성공!");
conn.Close(); // 연결 종료
finance1.Finance_Reloaded();
Close(); // 윈도우 종료
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
