예제 #1
0
        public static DataSet select_stu_name(student student)
        {
            string sql = "select stu_name from stu_info where stu_num='" + student.stu_num + "'";

            return(sqlHeleper.selectAll(sql));
        }
예제 #2
0
        public static bool insert_stu(student student)
        {
            string sql = "insert into stu_info(stu_num,stu_name,class,pwd) values('" + student.stu_num + "','" + student.stu_name + "','" + student.className + "','" + student.pwd + "')";

            return(sqlHeleper.all(sql));
        }
예제 #3
0
        public static bool del_stu(student student)
        {
            string sql = "delete from stu_info where stu_num='" + student.stu_num + "'";

            return(sqlHeleper.all(sql));
        }
예제 #4
0
        public static bool update_pwd(student student)
        {
            string sql = "update stu_info set pwd='" + student.pwd + "'where stu_num='" + student.stu_num + "'";

            return(sqlHeleper.all(sql));
        }