首先，我们需要在Andro
id Studio中创建一个新项目。然后，在项目中创建三个Java类：Person.java、Course.java、Relation.java，并且创建一个名为DBOpenHelper.java的SQLiteOpenHelper类。
Person.java类定义：
```java
public class Person {
private int
id;
private String myname;
private String myclass;
public Person(int
id, String myname, String myclass) {
this.
id =
id;
this.myname = myname;
this.myclass = myclass;
}
public int get
Id() {
return
id;
}
public vo
id set
Id(int
id) {
this.
id =
id;
}
public String getMyname() {
return myname;
}
public vo
id setMyname(String myname) {
this.myname = myname;
}
public String getMyclass() {
return myclass;
}
public vo
id setMyclass(String myclass) {
this.myclass = myclass;
}
}
```
Course.java类定义：
```java
public class Course {
private int
id;
private String name;
private String obj;
private String phone;
public Course(int
id, String name, String obj, String phone) {
this.
id =
id;
this.name = name;
this.obj = obj;
this.phone = phone;
}
public int get
Id() {
return
id;
}
public vo
id set
Id(int
id) {
this.
id =
id;
}
public String getName() {
return name;
}
public vo
id setName(String name) {
this.name = name;
}
public String getObj() {
return obj;
}
public vo
id setObj(String obj) {
this.obj = obj;
}
public String getPhone() {
return phone;
}
public vo
id setPhone(String phone) {
this.phone = phone;
}
}
```
Relation.java类定义：
```java
public class Relation {
private int student
Id;
private int course
Id;
public Relation(int student
Id, int course
Id) {
this.student
Id = student
Id;
this.course
Id = course
Id;
}
public int getStudent
Id() {
return student
Id;
}
public vo
id setStudent
Id(int student
Id) {
this.student
Id = student
Id;
}
public int getCourse
Id() {
return course
Id;
}
public vo
id setCourse
Id(int course
Id) {
this.course
Id = course
Id;
}
}
```
DBOpenHelper.java类定义：
```java
public class DBOpenHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "select_course.db";// 数据库名
private static final int DATABASE_VERSION = 1;// 数据库版本号
public static final String TABLE_STUDENT = "student";// 学生表
public static final String TABLE_COURSE = "course";// 课程表
public static final String TABLE_RELATIONS = "relations";// 学生与课程关系表
// 学生表字段
public static final String STUDENT_
ID = "
id";
public static final String STUDENT_NAME = "myname";
public static final String STUDENT_CLASS = "myclass";
// 课程表字段
public static final String COURSE_
ID = "
id";
public static final String COURSE_NAME = "name";
public static final String COURSE_OBJ = "obj";
public static final String COURSE_PHONE = "phone";
// 学生与课程关系表字段
public static final String RELATIONS_STUDENT_
ID = "student
Id";
public static final String RELATIONS_COURSE_
ID = "course
Id";
// 创建学生表
private static final String CREATE_TABLE_STUDENT = "create table "
+ TABLE_STUDENT + "(" + STUDENT_
ID
+ " integer primary key autoincrement, " + STUDENT_NAME
+ " varchar(20), " + STUDENT_CLASS + " varchar(20))";
// 创建课程表
private static final String CREATE_TABLE_COURSE = "create table "
+ TABLE_COURSE + "(" + COURSE_
ID
+ " integer primary key autoincrement, " + COURSE_NAME
+ " varchar(20), " + COURSE_OBJ + " varchar(20), "
+ COURSE_PHONE + " varchar(20))";
// 创建学生与课程关系表
private static final String CREATE_TABLE_RELATIONS = "create table "
+ TABLE_RELATIONS + "(" + RELATIONS_STUDENT_
ID
+ " integer, " + RELATIONS_COURSE_
ID + " integer)";
public DBOpenHelper(Context context) {
super(context, DATABASE_NAME,
null, DATABASE_VERSION);
}
@Overr
ide
public vo
id onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_TABLE_STUDENT);// 创建学生表
db.execSQL(CREATE_TABLE_COURSE);// 创建课程表
db.execSQL(CREATE_TABLE_RELATIONS);// 创建学生与课程关系表
}
@Overr
ide
public vo
id onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_STUDENT);// 删除学生表
db.execSQL("DROP TABLE IF EXISTS " + TABLE_COURSE);// 删除课程表
db.execSQL("DROP TABLE IF EXISTS " + TABLE_RELATIONS);// 删除学生与课程关系表
onCreate(db);
}
}
```
接下来，我们需要创建两个Activity：CourseActivity和PersonActivity。
CourseActivity.java代码：
```java
public class CourseActivity extends AppCompatActivity {
private
ListView listView;
private SQLiteDatabase database;
private DBOpenHelper dbOpenHelper;
private List<Course> courseList = new ArrayList<>();
@Overr
ide
protected vo
id onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContent
View(R.layout.activity_course);
listView = find
ViewById(R.
id.course_list_
view);
dbOpenHelper = new DBOpenHelper(this);
database = dbOpenHelper.getWritableDatabase();
Button addButton = find
ViewById(R.
id.add_course_button);
addButton.setOnClickListener(new
View.OnClickListener() {
@Overr
ide
public vo
id onClick(
View v) {
Intent intent = new Intent(CourseActivity.this, AddCourseActivity.class);
startActivity(intent);
}
});
Button personButton = find
ViewById(R.
id.person_button);
personButton.setOnClickListener(new
View.OnClickListener() {
@Overr
ide
public vo
id onClick(
View v) {
Intent intent = new Intent(CourseActivity.this, PersonActivity.class);
startActivity(intent);
}
});
}
@Overr
ide
protected vo
id onResume() {
super.onResume();
courseList.clear();
Cursor cursor = database.query(DBOpenHelper.TABLE_COURSE,
null,
null,
null,
null,
null,
null);
while (cursor.moveToNext()) {
int
id = cursor.getInt(cursor.getColumnIndex(DBOpenHelper.COURSE_
ID));
String name = cursor.getString(cursor.getColumnIndex(DBOpenHelper.COURSE_NAME));
String obj = cursor.getString(cursor.getColumnIndex(DBOpenHelper.COURSE_OBJ));
String phone = cursor.getString(cursor.getColumnIndex(DBOpenHelper.COURSE_PHONE));
Course course = new Course(
id, name, obj, phone);
courseList.add(course);
}
cursor.close();
CourseAdapter adapter = new CourseAdapter(CourseActivity.this, courseList);
listView.setAdapter(adapter);
}
private class CourseAdapter extends BaseAdapter {
private Context context;
private List<Course> list;
public CourseAdapter(Context context, List<Course> list) {
this.context = context;
this.list = list;
}
@Overr
ide
public int getCount() {
return list.size();
}
@Overr
ide
public Object getItem(int position) {
return list.get(position);
}
@Overr
ide
public long getItem
Id(int position) {
return position;
}
@Overr
ide
public
View get
View(int position,
View convert
View,
ViewGroup parent) {
View view = LayoutInflater.from(context).inflate(R.layout.course_item,
null);
Text
View name
View =
view.find
ViewById(R.
id.course_name_
view);
Text
View obj
View =
view.find
ViewById(R.
id.course_obj_
view);
Text
View phone
View =
view.find
ViewById(R.
id.course_phone_
view);
Course course = list.get(position);
name
View.setText(course.getName());
obj
View.setText(course.getObj());
phone
View.setText(course.getPhone());
return
view;
}
}
}
```
PersonActivity.java代码：
```java
public class PersonActivity extends AppCompatActivity {
private
ListView listView;
private SQLiteDatabase database;
private DBOpenHelper dbOpenHelper;
private List<Person> personList = new ArrayList<>();
@Overr
ide
protected vo
id onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContent
View(R.layout.activity_person);
listView = find
ViewById(R.
id.person_list_
view);
dbOpenHelper = new DBOpenHelper(this);
database = dbOpenHelper.getWritableDatabase();
Button addButton = find
ViewById(R.
id.add_person_button);
addButton.setOnClickListener(new
View.OnClickListener() {
@Overr
ide
public vo
id onClick(
View v) {
Intent intent = new Intent(PersonActivity.this, AddPersonActivity.class);
startActivity(intent);
}
});
}
@Overr
ide
protected vo
id onResume() {
super.onResume();
personList.clear();
Cursor cursor = database.query(DBOpenHelper.TABLE_STUDENT,
null,
null,
null,
null,
null,
null);
while (cursor.moveToNext()) {
int
id = cursor.getInt(cursor.getColumnIndex(DBOpenHelper.STUDENT_
ID));
String name = cursor.getString(cursor.getColumnIndex(DBOpenHelper.STUDENT_NAME));
String myclass = cursor.getString(cursor.getColumnIndex(DBOpenHelper.STUDENT_CLASS));
Person person = new Person(
id, name, myclass);
personList.add(person);
}
cursor.close();
PersonAdapter adapter = new PersonAdapter(PersonActivity.this, personList);
listView.setAdapter(adapter);
}
private class PersonAdapter extends BaseAdapter {
private Context context;
private List<Person> list;
public PersonAdapter(Context context, List<Person> list) {
this.context = context;
this.list = list;
}
@Overr
ide
public int getCount() {
return list.size();
}
@Overr
ide
public Object getItem(int position) {
return list.get(position);
}
@Overr
ide
public long getItem
Id(int position) {
return position;
}
@Overr
ide
public
View get
View(int position,
View convert
View,
ViewGroup parent) {
View view = LayoutInflater.from(context).inflate(R.layout.person_item,
null);
Text
View name
View =
view.find
ViewById(R.
id.person_name_
view);
Text
View class
View =
view.find
ViewById(R.
id.person_class_
view);
Person person = list.get(position);
name
View.setText(person.getMyname());
class
View.setText(person.getMyclass());
return
view;
}
}
}
```
接下来，我们需要创建两个添加数据的Activity：AddCourseActivity和AddPersonActivity。
AddCourseActivity.java代码：
```java
public class AddCourseActivity extends AppCompatActivity {
private SQLiteDatabase database;
private DBOpenHelper dbOpenHelper;
@Overr
ide
protected vo
id onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContent
View(R.layout.activity_add_course);
dbOpenHelper = new DBOpenHelper(this);
database = dbOpenHelper.getWritableDatabase();
Button addButton = find
ViewById(R.
id.add_course_button);
addButton.setOnClickListener(new
View.OnClickListener() {
@Overr
ide
public vo
id onClick(
View v) {
EditText nameEdit = find
ViewById(R.
id.course_name_edit);
EditText objEdit = find
ViewById(R.
id.course_obj_edit);
EditText phoneEdit = find
ViewById(R.
id.course_phone_edit);
String name = nameEdit.getText().toString().trim();
String obj = objEdit.getText().toString().trim();
String phone = phoneEdit.getText().toString().trim();
ContentValues values = new ContentValues();
values.put(DBOpenHelper.COURSE_NAME, name);
values.put(DBOpenHelper.COURSE_OBJ, obj);
values.put(DBOpenHelper.COURSE_PHONE, phone);
database.insert(DBOpenHelper.TABLE_COURSE,
null, values);
finish();
}
});
}
}
```
AddPersonActivity.java代码：
```java
public class AddPersonActivity extends AppCompatActivity {
private SQLiteDatabase database;
private DBOpenHelper dbOpenHelper;
@Overr
ide
protected vo
id onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContent
View(R.layout.activity_add_person);
dbOpenHelper = new DBOpenHelper(this);
database = dbOpenHelper.getWritableDatabase();
Button addButton = find
ViewById(R.
id.add_person_button);
addButton.setOnClickListener(new
View.OnClickListener() {
@Overr
ide
public vo
id onClick(
View v) {
EditText nameEdit = find
ViewById(R.
id.person_name_edit);
EditText classEdit = find
ViewById(R.
id.person_class_edit);
String name = nameEdit.getText().toString().trim();
String myclass = classEdit.getText().toString().trim();
ContentValues values = new ContentValues();
values.put(DBOpenHelper.STUDENT_NAME, name);
values.put(DBOpenHelper.STUDENT_CLASS, myclass);
database.insert(DBOpenHelper.TABLE_STUDENT,
null, values);
finish();
}
});
}
}
```
最后，我们需要在Andro
idManifest.xml文件中注册这些Activity：
```xml
<manifest xmlns:andro
id="http://schemas.andro
id.com/apk/res/andro
id"
package="com.example.selectcourse">
<appli
cation
andro
id:allowBackup="true"
andro
id:icon="@mipmap/ic_launcher"
andro
id:label="@string/app_name"
andro
id:roundIcon="@mipmap/ic_launcher_round"
andro
id:supportsRtl="true"
andro
id:theme="@style/AppTheme">
<activity andro
id:name=".AddCourseActivity"></activity>
<activity andro
id:name=".AddPersonActivity"></activity>
<activity andro
id:name=".CourseActivity"></activity>
<activity andro
id:name=".PersonActivity"></activity>
<activity
andro
id:name=".MainActivity"
andro
id:label="@string/app_name"
andro
id:theme="@style/AppTheme.NoActionBar">
<intent-filter>
<action andro
id:name="andro
id.intent.action.MAIN" />
<
category andro
id:name="andro
id.intent.
category.LAUNCHER" />
</intent-filter>
</activity>
</appli
cation>
</manifest>
```
以上就是一个简单的学生选课系统的代码实现，希望能对您有所帮助。
扫一扫
1255
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
