public void searchMembers(string nameOrId, string searchWord) { Console.Clear(); conn = new MySqlConnection(strConn); // conncet MySQL conn.Open(); ShareClass.getShareClass().getDisplay().membershipBar(); String sql = "select * from member where " + nameOrId + " like '" + searchWord + "%" + "';"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { memberid = reader["memberid"].ToString(); password = reader["password"].ToString(); name = reader["name"].ToString(); birth = reader["birth"].ToString(); if (name.Contains(searchWord) || memberid.Contains(searchWord)) { Console.SetCursorPosition(8, count); Console.Write(memberid); Console.SetCursorPosition(28, count); Console.Write(password); Console.SetCursorPosition(48, count); Console.Write(name); Console.SetCursorPosition(70, count); Console.Write(birth); count += 2; ShareClass.getShareClass().getException().goBack("membersearch"); } } reader.Close(); conn.Close(); }
public void memberAllSearchOfDB() //DB 내 저장한 데이터들 모두 출력 { Console.Clear(); conn = new MySqlConnection(strConn); conn.Open(); String sql = "select * from member;"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); ShareClass.getShareClass().getDisplay().membershipBar(); while (reader.Read()) { memberid = reader["memberid"].ToString(); password = reader["password"].ToString(); name = reader["name"].ToString(); birth = reader["birth"].ToString(); Console.SetCursorPosition(8, count); Console.Write(memberid); Console.SetCursorPosition(28, count); Console.Write(password); Console.SetCursorPosition(48, count); Console.Write(name); Console.SetCursorPosition(70, count); Console.Write(birth); count += 2; } reader.Close(); conn.Close(); }
public int rentCount(string userid) //뭘 빌렸는지 개수를 세서 대출 제한을 둘 수 있게 한다 { Console.Clear(); conn = new MySqlConnection(strConn); conn.Open(); String sql = "select * from rent where memberid ='" + userid + "';"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); ShareClass.getShareClass().getDisplay().rentBookBar(); while (reader.Read()) { id = reader["memberid"].ToString(); no = reader["no"].ToString(); title = reader["bookname"].ToString(); rentDay = reader["rentday"].ToString(); returnDay = reader["returnday"].ToString(); cnt++; } reader.Close(); conn.Close(); return(cnt); }
public bool checkRentBookNo(string bookNo) //rent 테이블 내 데이터들을 비교해서 빌린 책 넘버가 맞는지 확인 { conn = new MySqlConnection(strConn); bool isMatchNo = false; conn.Open(); string sql = "select * from rent where memberid ='" + ShareClass.getShareClass().getLoginId() + "';"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string memberid = reader["memberid"].ToString(); string no = reader["no"].ToString(); string bookName = reader["bookname"].ToString(); if (ShareClass.getShareClass().getLoginId() == memberid) { if (bookNo == no) { isMatchNo = true; break; } else { isMatchNo = false; } } } reader.Close(); conn.Close(); return(isMatchNo); }
public static ShareClass getShareClass() { if (shareclass == null) { shareclass = new ShareClass(); } return(shareclass); }
public void loginUsingDB(string input, string input2) { conn = new MySqlConnection(strConn); // conncet MySQL bool login = true; conn.Open(); String sql = "select * from member;"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { memberid = reader["memberid"].ToString(); password = reader["password"].ToString(); name = reader["name"].ToString(); if (input == memberid) { if (input2 == password) { Console.Clear(); saveMemberID(memberid); login = true; Console.WriteLine("\n\n\t\t" + name + "님 로그인되셨습니다."); //로그인 성공! 로그인시 뜨는 화면으로 들어간다 Thread.Sleep(800); ShareClass.getShareClass().getMenu().menuOnLogin(); break; } else { Console.WriteLine("\n\n\t 비밀번호 오류"); Thread.Sleep(800); ShareClass.getShareClass().getLogin().login(); //다시한번 로그인 창 } } else { login = false; } } if (login.Equals(false)) { Console.WriteLine("\n\n\t 아이디가 존재하지 않습니다"); Thread.Sleep(800); ShareClass.getShareClass().getMenu().mainMenu(); } reader.Close(); conn.Close(); }
public void rentSearch(string userid, string message) //뭘 빌렸는지 로그인 한 본인 아이디에 관해서 출력 { Console.Clear(); conn = new MySqlConnection(strConn); conn.Open(); String sql = "select * from rent where memberid ='" + userid + "';"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); ShareClass.getShareClass().getDisplay().rentBookBar(); while (reader.Read()) { id = reader["memberid"].ToString(); no = reader["no"].ToString(); title = reader["bookname"].ToString(); rentDay = reader["rentday"].ToString(); returnDay = reader["returnday"].ToString(); Console.SetCursorPosition(8, count); Console.Write(id); Console.SetCursorPosition(30, count); Console.Write(no); Console.SetCursorPosition(40, count); Console.Write(title); Console.SetCursorPosition(68, count); Console.Write(rentDay); Console.SetCursorPosition(95, count); Console.Write(returnDay); count += 2; cnt++; } if (cnt == 0) { Console.Clear(); Console.WriteLine("\n\t\t {0} 책이 없습니다", message); Thread.Sleep(800); } reader.Close(); conn.Close(); }
public void addRentTable(string bookNo, string bookTitle) //대출 시 rent 테이블에 들어갈 데이터 추가 쿼리문 { conn = new MySqlConnection(strConn); conn.Open(); string sql = "insert into rent values('" + ShareClass.getShareClass().getLoginId() + "','" + bookNo + "','" + bookTitle + "','" + DateTime.Now + "','" + DateTime.Now.AddDays(7) + "' ); "; MySqlCommand cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { Console.Clear(); Console.WriteLine("\n\n\n\n"); Console.WriteLine("\t\t" + bookTitle + " 대여되셨습니다."); Thread.Sleep(1000); } else { Console.Clear(); Console.WriteLine("Database Error!!"); Thread.Sleep(1000); } conn.Close(); }
internal void saveMemberID(string userId) { ShareClass.getShareClass().setLoginId(userId); }