여친 관리하기 윈폼 ..
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace GirlFriendProject
{
public class GirlDao
{
private static string CONNSTR =
@"Data Source=DARKNESS;Initial Catalog=teststu;Persist Security Info=True;User ID=sa;pwd=1234";
private static string INSERTAGIRL = "insert into girlfriend(name,tel,grade,characters) values("
+ " @name, @tel, @grade, @characters)";
private static string GETALLGIRLS = "select * from girlfriend";
private SqlConnection conn;
//private SqlDataAdapter sd;
private SqlCommand incomm;
/// <summary>
/// DB에 연결
/// </summary>
/// <returns>연결된 SqlConnection</returns>
public SqlConnection GetConnection()
{
conn = null;
try
{
conn = new SqlConnection(CONNSTR);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch
{
throw new Exception("실패!!");
}
return conn;
}//GetConnection
/// <summary>
/// 여친추가
/// </summary>
/// <param name="name"></param>
/// <param name="tel"></param>
/// <param name="grade"></param>
/// <param name="characters"></param>
/// <returns></returns>
public bool InsertGirl(string name, string tel, string grade, string characters)
{
bool isIns = false;
conn = this.GetConnection();
int count = 0;
using (incomm = new SqlCommand(INSERTAGIRL,conn))
{
incomm.Parameters.AddWithValue("@name", name);
incomm.Parameters.AddWithValue("@tel", tel);
incomm.Parameters.AddWithValue("@grade", grade);
incomm.Parameters.AddWithValue("@characters", characters);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
count = incomm.ExecuteNonQuery();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (count > 0)
{
isIns = true;
}
}
return isIns;
}//InsertGirl
/// <summary>
/// 여친보기
/// </summary>
/// <returns></returns>
public string GetAllGirls()
{
StringBuilder sb = new StringBuilder();
//XML 파일
sb.AppendLine(@"<?xml version='1.0' encoding='euc-kr' ?>");
conn = this.GetConnection();
SqlDataReader reader = null;
using (incomm = new SqlCommand(GETALLGIRLS, conn))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
reader = incomm.ExecuteReader();
//XML
sb.AppendLine("\r\n<girlfriends>");
while (reader.Read())
{
string id = reader["id"].ToString().Trim();
string name = reader["name"].ToString().Trim();
string tel = reader["tel"].ToString().Trim();
string grade = reader["grade"].ToString().Trim();
string characters = reader["characters"].ToString().Trim();
sb.AppendLine("\t<girlfriend>");
sb.AppendFormat("\t\t<id>{0}</id>\r\n", id);
sb.AppendFormat("\t\t<name>{0}</name>\r\n", name);
sb.AppendFormat("\t\t<tel>{0}</tel>\r\n", tel);
sb.AppendFormat("\t\t<grade>{0}</grade>\r\n", grade);
sb.AppendFormat("\t\t<characters>{0}</characters>\r\n", characters);
sb.AppendLine("\t</girlfriend>\r\n");
}
sb.AppendLine("</girlfriends>");
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return sb.ToString();
}//GetAllGirls
}//class GirlDao
}
윈폼 여친관리하기
'.NET' 카테고리의 다른 글
| css 화면 클릭 => 새로운 레이어 띄우기 (2) | 2007.08.18 |
|---|---|
| 1~100까지 소수 구하기 (0) | 2007.08.17 |
| 오버로딩과 오버라이딩 (0) | 2007.08.17 |
| 3X3 마방진 (1) | 2007.08.14 |
| Delegate (0) | 2007.08.14 |
| 윈폼 제작 (0) | 2007.08.14 |