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)); }
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)); }
public static bool del_stu(student student) { string sql = "delete from stu_info where stu_num='" + student.stu_num + "'"; return(sqlHeleper.all(sql)); }
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)); }