تشکر از شما
مشکل من در نوشتن کوئری جوین بود که بدین صورت نوشتم و حل شد
SELECT Tble_file.id,id_students,file_name,file_comment,st udent_name,student_family FROM Tble_file JOIN Tble_students ON Tble_file.id_students=Tble_students.id
کلاس :
public class Table_file {
int id;
int id_students;
String file_name;
String file_comment;
String student_name;
String student_family;
public Table_file(int id, int id_students, String file_name, String file_comment, String student_name, String student_family) {
this.id = id;
this.id_students = id_students;
this.file_name = file_name;
this.file_comment = file_comment;
this.student_name = student_name;
this.student_family = student_family;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getId_students() {
return id_students;
}
public void setId_students(int id_students) {
this.id_students = id_students;
}
public String getFile_name() {
return file_name;
}
public void setFile_name(String file_name) {
this.file_name = file_name;
}
public String getFile_comment() {
return file_comment;
}
public void setFile_comment(String file_comment) {
this.file_comment = file_comment;
}
public String getStudent_name() {
return student_name;
}
public void setStudent_name(String student_name) {
this.student_name = student_name;
}
public String getStudent_family() {
return student_family;
}
public void setStudent_family(String student_family) {
this.student_family = student_family;
}
}
ایجاد کلاس مدل دیتابیس رابطه ای
پاسخ با نقل قول
