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' 카테고리의 다른 글
SOA란 무엇인가? (1) | 2008.01.25 |
---|---|
Service Oriented Architecture(SOA) 란? (0) | 2008.01.25 |
여자친구 관리 (1) | 2008.01.17 |
Active Directory의 새로운 기능 - Windows Server 2003 R2 (0) | 2008.01.04 |
Team Foundation Server -2 (1) | 2007.12.27 |
Team Foundation Server (1) | 2007.12.27 |
우수한과 아주 도움이 되는!