6.11小测代码
以下为会议预约管理系统的部分代码
BookMeetingActivity.java
package com.example.myapplication611; import android.os.AsyncTask; import android.os.Bundle; import android.view.View; import android.widget.ArrayAdapter; import android.widget.Button; import android.widget.EditText; import android.widget.Spinner; import android.widget.Toast; import androidx.appcompat.app.AppCompatActivity; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; public class BookMeetingActivity extends AppCompatActivity { private EditText meetingTitle, meetingContent, meetingStartTime, meetingEndTime, meetingNum, meetingParticipants; private Spinner meetingRoomSpinner; private Button submitMeetingButton; private ArrayList<String> availableRooms = new ArrayList<>(); @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_book_meeting); // 手动创建一些示例数据并设置给 Spinner ArrayList<String> sampleData = new ArrayList<>(); sampleData.add("会议室A"); sampleData.add("会议室B"); sampleData.add("会议室C"); ArrayAdapter<String> adapter = new ArrayAdapter<>(this, android.R.layout.simple_spinner_item, sampleData); adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); meetingRoomSpinner = findViewById(R.id.meetingRoomSpinner); meetingRoomSpinner.setAdapter(adapter); // 获取其他视图对象 meetingTitle = findViewById(R.id.meetingTitle); meetingContent = findViewById(R.id.meetingContent); meetingStartTime = findViewById(R.id.meetingStartTime); meetingEndTime = findViewById(R.id.meetingEndTime); meetingNum = findViewById(R.id.meetingNum); meetingParticipants = findViewById(R.id.meetingParticipants); submitMeetingButton = findViewById(R.id.submitMeetingButton); // 点击按钮提交会议申请 submitMeetingButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // 检查所有相关视图对象是否为空 if (checkAllFields()) { String title = meetingTitle.getText().toString(); String content = meetingContent.getText().toString(); String startTime = meetingStartTime.getText().toString(); String endTime = meetingEndTime.getText().toString(); String num = meetingNum.getText().toString(); String participants = meetingParticipants.getText().toString(); String selectedRoom = meetingRoomSpinner.getSelectedItem().toString(); new SubmitMeetingTask().execute(title, content, startTime, endTime, num, participants, selectedRoom); } else { Toast.makeText(BookMeetingActivity.this, "有必填项为空，请填写完整", Toast.LENGTH_SHORT).show(); } } }); } // 检查所有必填字段是否为空 private boolean checkAllFields() { return !(meetingTitle.getText().toString().isEmpty() || meetingContent.getText().toString().isEmpty() || meetingStartTime.getText().toString().isEmpty() || meetingEndTime.getText().toString().isEmpty() || meetingNum.getText().toString().isEmpty() || meetingParticipants.getText().toString().isEmpty() || meetingRoomSpinner.getSelectedItem() == null); } // 异步任务：提交会议申请 private class SubmitMeetingTask extends AsyncTask<String, Void, Boolean> { @Override protected Boolean doInBackground(String... params) { String title = params[0]; String content = params[1]; String rawStartTime = params[2]; String rawEndTime = params[3]; String num = params[4]; String participants = params[5]; String selectedRoom = params[6]; // 替换错误的分隔符 String startTime = rawStartTime.replace("－", "-"); String endTime = rawEndTime.replace("－", "-"); Mysql.getconn(); try { // 检查会议室是否在该时间段内没有冲突 String checkSql = "SELECT COUNT(*) FROM Meeting WHERE MeetroomId = (SELECT MeetroomId FROM Meetroom WHERE MeetroomName = ?) " + "AND ((MeetingBegin <= ? AND MeetingEnd >= ?) OR (MeetingBegin <= ? AND MeetingEnd >= ?) OR (MeetingBegin >= ? AND MeetingEnd <= ?))"; try (PreparedStatement checkStmt = Mysql.conn.prepareStatement(checkSql)) { checkStmt.setString(1, selectedRoom); checkStmt.setString(2, startTime); checkStmt.setString(3, startTime); checkStmt.setString(4, endTime); checkStmt.setString(5, endTime); checkStmt.setString(6, startTime); checkStmt.setString(7, endTime); ResultSet rs = checkStmt.executeQuery(); if (rs.next() && rs.getInt(1) > 0) { return false; // 会议时间冲突 } } // 插入新的会议申请 String insertSql = "INSERT INTO Meeting (MeetingName, MeetingContent, MeetingBegin, MeetingEnd, MeetingNum, Participants, MeetroomId, UserID, AuditStatus, AuditMind) " + "VALUES (?, ?, ?, ?, ?, ?, (SELECT MeetroomId FROM Meetroom WHERE MeetroomName = ?), ?, '待审核', '')"; try (PreparedStatement insertStmt = Mysql.conn.prepareStatement(insertSql)) { insertStmt.setString(1, title); insertStmt.setString(2, content); insertStmt.setString(3, startTime); insertStmt.setString(4, endTime); insertStmt.setInt(5, Integer.parseInt(num)); insertStmt.setString(6, participants); insertStmt.setString(7, selectedRoom); insertStmt.setInt(8, 1); // 假设登录的用户ID为1，实际应该从登录信息中获取 insertStmt.executeUpdate(); } } catch (SQLException e) { e.printStackTrace(); return false; } finally { Mysql.close(); } return true; } @Override protected void onPostExecute(Boolean success) { if (success) { Toast.makeText(BookMeetingActivity.this, "会议申请提交成功", Toast.LENGTH_SHORT).show(); finish(); } else { Toast.makeText(BookMeetingActivity.this, "会议时间冲突或其他错误", Toast.LENGTH_SHORT).show(); } } } }
EmployeeActivity.java
package com.example.myapplication611; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.Button; import androidx.appcompat.app.AppCompatActivity; public class EmployeeActivity extends AppCompatActivity { private Button viewMeetingRoomsButton; private Button searchMeetingRoomsButton; private Button bookMeetingButton; private Button viewMeetingsButton; private String userRole; private String userName; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_employee); userRole = getIntent().getStringExtra("USER_ROLE"); userName = getIntent().getStringExtra("USERNAME"); viewMeetingRoomsButton = findViewById(R.id.viewMeetingRoomsButton); searchMeetingRoomsButton = findViewById(R.id.searchMeetingRoomsButton); bookMeetingButton = findViewById(R.id.bookMeetingButton); viewMeetingsButton = findViewById(R.id.viewMeetingsButton); viewMeetingRoomsButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent intent = new Intent(EmployeeActivity.this, ViewMeetingRoomsActivity.class); intent.putExtra("USER_ROLE", userRole); intent.putExtra("USERNAME", userName); startActivity(intent); } }); searchMeetingRoomsButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent intent = new Intent(EmployeeActivity.this, SearchMeetingRoomsActivity.class); intent.putExtra("USER_ROLE", userRole); intent.putExtra("USERNAME", userName); startActivity(intent); } }); bookMeetingButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent intent = new Intent(EmployeeActivity.this, BookMeetingActivity.class); intent.putExtra("USER_ROLE", userRole); intent.putExtra("USERNAME", userName); startActivity(intent); } }); viewMeetingsButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent intent = new Intent(EmployeeActivity.this, MeetingListActivity.class); intent.putExtra("USER_ROLE", userRole); intent.putExtra("USERNAME", userName); startActivity(intent); } }); } }
activity_book_meeting.xml
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" android:padding="16dp"> <EditText android:id="@+id/meetingTitle" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="会议主题" /> <EditText android:id="@+id/meetingContent" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="会议内容" /> <EditText android:id="@+id/meetingStartTime" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="开始时间 (格式: YYYY-MM-DD HH:MM:SS)" /> <EditText android:id="@+id/meetingEndTime" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="结束时间 (格式: YYYY-MM-DD HH:MM:SS)" /> <EditText android:id="@+id/meetingNum" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="参会人数" /> <EditText android:id="@+id/meetingParticipants" android:layout_width="match_parent" android:layout_height="wrap_content" android:hint="参会人员（姓名以逗号分隔）" /> <Spinner android:id="@+id/meetingRoomSpinner" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_marginTop="16dp" /> <Button android:id="@+id/submitMeetingButton" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_marginTop="16dp" android:text="提交申请" /> </LinearLayout>
MainActivity.java
package com.example.myapplication611; import android.content.Intent; import android.os.Bundle; import android.os.StrictMode; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; import androidx.appcompat.app.AppCompatActivity; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class MainActivity extends AppCompatActivity { private EditText usernameEditText; private EditText passwordEditText; private Button loginButton; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); // 允许主线程进行网络操作（仅用于调试，不推荐在生产环境中使用） StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder() .permitNetwork().build()); usernameEditText = findViewById(R.id.UserNameEdit); passwordEditText = findViewById(R.id.PassWordEdit); loginButton = findViewById(R.id.LoginButton); loginButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { String username = usernameEditText.getText().toString().trim(); String password = passwordEditText.getText().toString().trim(); validateLogin(username, password); } }); } private void validateLogin(String username, String password) { new Thread(new Runnable() { @Override public void run() { Mysql.getconn(); if (Mysql.conn == null) { runOnUiThread(new Runnable() { @Override public void run() { Toast.makeText(MainActivity.this, "数据库连接失败", Toast.LENGTH_SHORT).show(); } }); return; } boolean isValid = false; String role = null; String sql = "SELECT UserName, UserID, Position FROM Employee WHERE UserName = ? AND UserID = ?"; try { PreparedStatement preparedStatement = Mysql.conn.prepareStatement(sql); preparedStatement.setNString(1, username); // 使用 setNString 方法设置参数 preparedStatement.setNString(2, password); // 使用 setNString 方法设置参数 ResultSet resultSet = preparedStatement.executeQuery(); if (resultSet.next()) { isValid = true; role = resultSet.getString("Position"); } preparedStatement.close(); resultSet.close(); } catch (SQLException e) { e.printStackTrace(); } final boolean finalIsValid = isValid; final String finalRole = role; runOnUiThread(new Runnable() { @Override public void run() { if (finalIsValid) { Toast.makeText(MainActivity.this, "登录成功", Toast.LENGTH_SHORT).show(); // 根据角色跳转到相应的页面 Intent intent; if ("Manager".equals(finalRole)) { intent = new Intent(MainActivity.this, ManagerActivity.class); } else if ("Employee".equals(finalRole)) { intent = new Intent(MainActivity.this, EmployeeActivity.class); } else { Toast.makeText(MainActivity.this, "未知角色", Toast.LENGTH_SHORT).show(); return; } intent.putExtra("USER_ROLE", finalRole); startActivity(intent); } else { Toast.makeText(MainActivity.this, "用户名或密码错误", Toast.LENGTH_SHORT).show(); } } }); } }).start(); } @Override protected void onDestroy() { super.onDestroy(); // 在活动销毁时关闭数据库连接 Mysql.close(); } }
