I have a problem with this code...
any help please ?
SQL: CREATE TABLE member (sn NUMBER(6), nickname VARCHAR2(30), password
VARCHAR2(30));
Expand|Select|Wrap|Line Numbers
- using System;
- using System.Data.Odbc;
- namespace MemberODBC{
- public enum MemberType {
- UnReg, Reg, Op, Voice, Founder, Admin
- }
- public class Member {
- private int sn = 0;
- private string nickName;
- private string password;
- private MemberType memberType;
- private string connection = "Driver={Microsoft ODBC for
- Oracle};Server=orcl;UID=scott;PWD=tiger";
- public Member(string nickName)
- {
- this.nickName = nickName;
- memberType = MemberType.UnReg;
- }
- public Member(string nickName, string password) : this (nickName) {
- this.password = password;
- memberType = MemberType.UnReg;
- }
- public void EnterPassword() {
- string pass = password;
- try {
- string query = "SELECT * FROM member WHERE pass = '" + pass + "'";
- ReadData(query);
- if(pass == password) {
- memberType = MemberType.Reg;
- Console.WriteLine("The password is accepted");
- }
- else {
- Console.WriteLine("The password is not accepted");
- }
- }
- catch {
- Console.WriteLine("EnterPassword() FAILED");
- }
- }
- public void ReadData(string query) {
- OdbcConnection dbConn = new OdbcConnection(connection);
- dbConn.Open();
- try {
- string sqlString = query;
- OdbcCommand sqlCommand = new OdbcCommand(sqlString, dbConn);
- OdbcDataReader reader = sqlCommand.ExecuteReader();
- while(reader.Read()) {
- sn = reader.GetInt32(0);
- nickName = reader.GetString(1);
- password = reader.GetString(2);
- }
- reader.Close();
- dbConn.Close();
- }
- catch {
- Console.WriteLine("Member:\tConnection did not succeeed");
- }
- }
- public static void Main() {
- Member m = new Member("X", "X");
- m.EnterPassword();
- Console.ReadLine();
- }
- }
- }