安卓 员工管理系统app

员工管理系统、

开发工具：Android Studio
数据库： sqlite

数据库

部分源码
manifest.xml配置文件

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.company">

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".SearchActivity"></activity>
        <activity android:name=".GuanliActivity" />
        <activity android:name=".GloginActivity" />
        <activity android:name=".RegisterActivity" />
        <activity android:name=".IntroductionActivity" />
        <activity android:name=".NewsActivity" />
        <activity android:name=".FirstActivity" />

        <activity android:name=".LoginActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

员工界面

package com.example.company;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.content.SharedPreferences;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.text.format.Time;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;
import android.widget.Toast;


public class FirstActivity extends AppCompatActivity {

    private Cursor cursor;
    @Override
    public void onDestroy(){
        super.onDestroy();
        cursor.close();
    }



    //定义共享优先数据及基础字段  用于签到功能实现
    private String MY_RMBCost ="MY_RMBCost";

    private String TodayTime ="TodayTime";


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_first);

        //--------------------------------------------------------------登录
        Button btnlongin = findViewById(R.id.login);
        btnlongin.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(FirstActivity.this,LoginActivity.class);
                startActivity(intent);
            }
        });

        //-------------------------------------------------------------签到
        final Button bt_qiandao = (Button)findViewById(R.id.bt_qiandao);
        final TextView tv_time = (TextView)findViewById(R.id.tv_qiandaotime);

        SharedPreferences my_rmb_data = getSharedPreferences(MY_RMBCost, 0);//读取共享数据

        Time t = new Time();
        t.setToNow();
        int lastmonth = t.month + 1 ;
        final String str =  t.year + "年" + lastmonth + "月" + t.monthDay + "日";


        final String nowtime =my_rmb_data.getString(TodayTime, "").toString();

        if(nowtime.equals(str)==true)
        {
            tv_time.setText("日期："+ nowtime +"已签到！");
            bt_qiandao.setBackgroundResource(R.drawable.yqd);
            bt_qiandao.setText("✔签到");
        }
        else
        {
            tv_time.setText("日期："+ str);
            bt_qiandao.setBackgroundResource(R.drawable.qd);
        }

        //签到功能
        bt_qiandao.setOnClickListener(new View.OnClickListener() {

            public void onClick(View v) {
                // TODO Auto-generated method stub
                SharedPreferences my_rmb_data = getSharedPreferences(MY_RMBCost, 0);
                if(my_rmb_data.getString(TodayTime, "").toString().equals(str)==true)
                {
                    Toast.makeText(FirstActivity.this , "今日已签到！", Toast.LENGTH_SHORT).show();
                }
                else
                {
                    my_rmb_data.edit()
                            .putString(TodayTime, str)
                            .commit();
                    tv_time.setText("日期："+ str +"已签到！");
                    bt_qiandao.setBackgroundResource(R.drawable.yqd);
                    bt_qiandao.setText("✔签到");
                    Toast.makeText( FirstActivity.this , "签到成功！", Toast.LENGTH_SHORT).show();
                }
            }
        });
        //-------------------------------------每日资讯
        //ArrayAdapter<News> listAdapter= new ArrayAdapter<>(this,android.R.layout.simple_list_item_1,News.news);


        ListView listnews = findViewById(R.id.list_news);
        //listnews.setAdapter(listAdapter);

        //设置游标适配器
        SQLiteOpenHelper starbuzzDatabaseHelper=new CompanyDatabaseHelper(this);
        //获得数据库引用
        try {
            SQLiteDatabase db =starbuzzDatabaseHelper.getReadableDatabase();
            cursor = db.query("NEWS",
                    new String[]{"_id","TITLE"},
                    null,null,null,null,null);
            SimpleCursorAdapter listAdapter = new SimpleCursorAdapter(this,
                    android.R.layout.simple_list_item_1,
                    cursor,
                    new String[]{"TITLE"},
                    new int[]{android.R.id.text1},
                    0);
            listnews.setAdapter(listAdapter);

        }catch (SQLException e){
            Log.e("sqlite",e.getMessage());
            Toast toast=Toast.makeText(this,"Database unavaiable",Toast.LENGTH_SHORT);
            toast.show();
        }
        //指定监听器 相应选项单击
        AdapterView.OnItemClickListener itemClickListener=new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {

                Intent intent = new Intent(FirstActivity.this,NewsActivity.class);
                intent.putExtra(NewsActivity.EXTRA_DRINKID,(int)id);
                startActivity(intent);

            }
        };
        listnews.setOnItemClickListener(itemClickListener);
        //-------------------------------------------------公司简介
        Button btnintroduction = findViewById(R.id.introduction);
        btnintroduction.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(FirstActivity.this,IntroductionActivity.class);
                startActivity(intent);
            }
        });

    }
}

登录注册

package com.example.company;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.RelativeLayout;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;

public class LoginActivity extends AppCompatActivity implements View.OnClickListener {

//    @Override
//    protected void onCreate(Bundle savedInstanceState) {
//        super.onCreate(savedInstanceState);
//        setContentView(R.layout.activity_login);
//
//        Button mbtnlogin = findViewById(R.id.btn_login);
//        mbtnlogin.setOnClickListener(new View.OnClickListener() {
//            @Override
//            public void onClick(View v) {
//
//                Toast.makeText(LoginActivity.this, "登录成功", Toast.LENGTH_SHORT).show();
//                Intent intent = new Intent(LoginActivity.this,FirstActivity.class);
//                startActivity(intent);
//            }
//        });
//
//        Button btnback = findViewById(R.id.btn_back);
//        btnback.setOnClickListener(new View.OnClickListener() {
//            @Override
//            public void onClick(View v) {
//                Intent intent = new Intent(LoginActivity.this,FirstActivity.class);
//                startActivity(intent);
//            }
//        });
//    }
    private CompanyDatabaseHelper mDBOpenHelper;

    private EditText mEtLoginactivityUsername;
    private EditText mEtLoginactivityPassword;
    private Button mBtLonginactivittRegister;
    private Button mBtLoginactivityLogin;
    private Button mBtLoginactivityGl;
    private String rname;
    private String rpassword;


    /**
     * 创建 Activity 时先来重写 onCreate() 方法
     * 保存实例状态
     * super.onCreate(savedInstanceState);
     * 设置视图内容的配置文件
     * setContentView(R.layout.activity_login);
     * 上面这行代码真正实现了把视图层 View 也就是 layout 的内容放到 Activity 中进行显示
     * 初始化视图中的控件对象 initView()
     * 实例化 DBOpenHelper，待会进行登录验证的时候要用来进行数据查询
     * mDBOpenHelper = new DBOpenHelper(this);
     */
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);

        initView();
        rpassword();

        mDBOpenHelper = new CompanyDatabaseHelper(this);
    }

   //记住密码
    private void rpassword(){
        if(rname!=null && rpassword!=null)
        {
            mEtLoginactivityUsername.setText(rname);
            mEtLoginactivityPassword.setText(rpassword);
        }
    }
    /**
     * onCreae()中大的布局已经摆放好了，接下来就该把layout里的东西
     * 声明、实例化对象然后有行为的赋予其行为
     * 这样就可以把视图层View也就是layout 与 控制层 Java 结合起来了
     */
    private void initView() {
        // 初始化控件
        mBtLoginactivityLogin = findViewById(R.id.bt_loginactivity_login);
        mBtLoginactivityGl = findViewById(R.id.bt_loginactivityGl);
       mBtLonginactivittRegister = findViewById(R.id.bt_loginactivity_register);
        mEtLoginactivityUsername = findViewById(R.id.et_loginactivity_username);
        mEtLoginactivityPassword = findViewById(R.id.et_loginactivity_password);




        // 设置点击事件监听器
        mBtLoginactivityLogin.setOnClickListener(this);
        mBtLonginactivittRegister.setOnClickListener(this);
        mBtLoginactivityGl.setOnClickListener(this);
    }

    public void onClick(View view) {
        switch (view.getId()) {
            // 跳转到注册界面
            case R.id.bt_loginactivity_register:
                startActivity(new Intent(this, RegisterActivity.class));
                finish();
                break;
            case R.id.bt_loginactivityGl:
                startActivity(new Intent(this,GloginActivity.class));
                finish();
                break;
                /**
             * 登录验证：
             *
             * 从EditText的对象上获取文本编辑框输入的数据，并把左右两边的空格去掉
             *  String name = mEtLoginactivityUsername.getText().toString().trim();
             *  String password = mEtLoginactivityPassword.getText().toString().trim();
             *  进行匹配验证,先判断一下用户名密码是否为空，
             *  if (!TextUtils.isEmpty(name) && !TextUtils.isEmpty(password))
             *  再进而for循环判断是否与数据库中的数据相匹配
             *  if (name.equals(user.getName()) && password.equals(user.getPassword()))
             *  一旦匹配，立即将match = true；break；
             *  否则 一直匹配到结束 match = false；
             *
             *  登录成功之后，进行页面跳转：
             *
             *  Intent intent = new Intent(this, MainActivity.class);
             *  startActivity(intent);
             *  finish();//销毁此Activity
             */
            case R.id.bt_loginactivity_login:
                String name = mEtLoginactivityUsername.getText().toString().trim();
                String password = mEtLoginactivityPassword.getText().toString().trim();
                 rname = name;
                 rpassword = password;

                if (!TextUtils.isEmpty(name) && !TextUtils.isEmpty(password)) {
                    ArrayList<User> data = mDBOpenHelper.getAllData();
                    boolean match = false;
                    for (int i = 0; i < data.size(); i++) {
                        User user = data.get(i);
                        if (name.equals(user.getName()) && password.equals(user.getPassword())) {
                            match = true;
                            break;
                        } else {
                            match = false;
                        }
                    }
                    if (match) {

                        Toast.makeText(this, "登录成功", Toast.LENGTH_SHORT).show();
                        Intent intent = new Intent(this, FirstActivity.class);
                        startActivity(intent);
                        finish();//销毁此Activity
                    } else {
                        Toast.makeText(this, "用户名或密码不正确，请重新输入", Toast.LENGTH_SHORT).show();
                    }
                } else {
                    Toast.makeText(this, "请输入你的用户名或密码", Toast.LENGTH_SHORT).show();
                }
                break;
        }
    }
}
package com.example.company;

import android.content.Intent;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

import android.widget.Toast;

import androidx.appcompat.app.AppCompatActivity;
/**

 */
/**
 * 此类 implements View.OnClickListener 之后，
 * 就可以把onClick事件写到onCreate()方法之外
 * 这样，onCreate()方法中的代码就不会显得很冗余
 */
public class RegisterActivity extends AppCompatActivity implements View.OnClickListener {


    private CompanyDatabaseHelper mDBOpenHelper;
    private Button mBtRegisteractivityRegister;

    private EditText mEtRegisteractivityUsername;
    private EditText mEtRegisteractivityPassword1;
    private EditText mEtRegisteractivityPassword2;
    private Button mBtRegisteractivityBack;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_register);

        initView();

        mDBOpenHelper = new CompanyDatabaseHelper(this);


    }

    private void initView(){
        mBtRegisteractivityRegister = findViewById(R.id.bt_registeractivity_register);

        mBtRegisteractivityBack = findViewById(R.id.bt_registeractivity_back);

        mEtRegisteractivityUsername = findViewById(R.id.et_registeractivity_username);
        mEtRegisteractivityPassword1 = findViewById(R.id.et_registeractivity_password1);
        mEtRegisteractivityPassword2 = findViewById(R.id.et_registeractivity_password2);



        /**
         * 注册页面能点击的就三个地方
         * top处返回箭头、刷新验证码图片、注册按钮
         */
        mBtRegisteractivityBack.setOnClickListener(this);

        mBtRegisteractivityRegister.setOnClickListener(this);
    }

    public void onClick(View view) {
        switch (view.getId()) {
            case R.id.bt_registeractivity_back: //返回登录页面
                Intent intent1 = new Intent(this, LoginActivity.class);
                startActivity(intent1);
                finish();
                break;

            case R.id.bt_registeractivity_register:    //注册按钮
                //获取用户输入的用户名、密码、验证码
                String username = mEtRegisteractivityUsername.getText().toString().trim();
                String password1 = mEtRegisteractivityPassword1.getText().toString().trim();
                String password2 = mEtRegisteractivityPassword2.getText().toString().trim();

                //注册验证
                if (!TextUtils.isEmpty(username) && !TextUtils.isEmpty(password1) && !TextUtils.isEmpty(password2) ) {
                    if (password1.equals(password2)) {
                        //将用户名和密码加入到数据库中
                        mDBOpenHelper.login_add(username, password1);
                        Intent intent2 = new Intent(this, FirstActivity.class);
                        startActivity(intent2);
                        finish();
                        Toast.makeText(this,  "验证通过，注册成功", Toast.LENGTH_SHORT).show();
                    } else {
                        Toast.makeText(this, "密码不一致,注册失败", Toast.LENGTH_SHORT).show();
                    }
                }else {
                    Toast.makeText(this, "未完善信息，注册失败", Toast.LENGTH_SHORT).show();
                }
                break;
        }
    }
}

管理员

package com.example.company;

import androidx.appcompat.app.AppCompatActivity;

import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class GuanliActivity extends AppCompatActivity implements View.OnClickListener {

    private Cursor cursor;

    private CompanyDatabaseHelper mDBOpenHelper;
    private Button mbtadd;
    private Button mbtdelete;
    private  Button mbtupdate;
    private Button mbtsearch;
    private Button mbtback;

    private EditText medtname;
    private EditText medtsex;
    private EditText medttel;
    private EditText medtposition;
    private EditText medttime;



    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_guanli);
        initView();

        mDBOpenHelper = new CompanyDatabaseHelper(this);
    }

    private void initView(){
        mbtadd = findViewById(R.id.bt_add);
        mbtdelete = findViewById(R.id.bt_delete);
        mbtupdate = findViewById(R.id.bt_update);
        mbtsearch = findViewById(R.id.bt_search);
        mbtback = findViewById(R.id.bt_guanliback);

        medtname = findViewById(R.id.edt_name);
        medtsex = findViewById(R.id.edt_sex);
        medttel = findViewById(R.id.edt_tel);
        medtposition = findViewById(R.id.edt_position);
        medttime = findViewById(R.id.edt_time);

        mbtadd.setOnClickListener(this);
        mbtdelete.setOnClickListener(this);
        mbtupdate.setOnClickListener(this);
        mbtsearch.setOnClickListener(this);
        mbtback.setOnClickListener(this);
    }

    public void onClick(View view){
        switch (view.getId()){
            case R.id.bt_add:
//                int mid =Integer.parseInt (medtid.getText().toString());
                String name = medtname.getText().toString().trim();
                String sex = medtsex.getText().toString().trim();
                String tel = medttel.getText().toString().trim();
                String position = medtposition.getText().toString().trim();
                String time = medttime.getText().toString().trim();
                mDBOpenHelper.yuangong_add(name,sex,tel,position,time);
                Toast.makeText(this,  "添加成功", Toast.LENGTH_SHORT).show();
                medtname.setText("");
                medtsex.setText("");
                medttel.setText("");
                medtposition.setText("");
                medttime.setText("");
                break;
            case R.id.bt_delete:
                AlertDialog alertDialog = new AlertDialog.Builder(this)
                        .setTitle("删除员工信息")
                        .setMessage("是否删除")
                        .setPositiveButton("确定", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {
                                String name = medtname.getText().toString().trim();
                                String position = medtposition.getText().toString().trim();
                                mDBOpenHelper.yuangong_delete(name);
                                medtname.setText("");
                                medtsex.setText("");
                                medttel.setText("");
                                medtposition.setText("");
                                medttime.setText("");

                            }
                        })
                        .setNegativeButton("取消", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {
                                return;
                            }
                        }).create();
                alertDialog.show();
                break;
            case R.id.bt_update:
                String uname = medtname.getText().toString().trim();
                String utel = medttel.getText().toString().trim();
                String uposition = medtposition.getText().toString().trim();
                mDBOpenHelper.yuangong_updata(uname,uposition,utel);
                Toast.makeText(this,"更新成功",Toast.LENGTH_SHORT).show();
                medtname.setText("");
                medtsex.setText("");
                medttel.setText("");
                medtposition.setText("");
                medttime.setText("");
                break;
            case R.id.bt_search:
                startActivity(new Intent(GuanliActivity.this, SearchActivity.class));
                finish();//销毁此Activity

                break;

            case R.id.bt_guanliback:
                startActivity(new Intent(GuanliActivity.this, GloginActivity.class));
                finish();//销毁此Activity
                break;
        }

    }
}

数据库

package com.example.company;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import java.util.ArrayList;

public class CompanyDatabaseHelper extends SQLiteOpenHelper {
    private static final String DB_NAME="company.db";
    private static final int DB_VER=1;
    private SQLiteDatabase db;

    public CompanyDatabaseHelper(Context context){
        super(context,DB_NAME,null,DB_VER);
        db = getReadableDatabase();
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        //建每日讯息表
        db.execSQL("CREATE TABLE NEWS(_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "TITLE TEXT," +
                "IMAGE_RESOURCE_ID INTEGER," +
                "CONTENT TEXT);");
        //建立登录表
        db.execSQL("CREATE TABLE  USER( _id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "name TEXT," +
                "password TEXT);");
        //建立管理员登录表
        db.execSQL("CREATE TABLE  GUSER( _id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "gname TEXT," +
                "password TEXT);");
        db.execSQL("INSERT INTO guser (gname,password) VALUES('zzz','123')");
        //建立用户信息表
        db.execSQL("CREATE TABLE  YUANGONG( _id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "name TEXT," +
                "sex TEXT,"+
                "tel TEXT,"+
                "position TEXT,"+
                "TIME DATE);");

        //插入每日讯息
        insertNews(db,"通知1",R.drawable.news01,"aaaaaaaaaaaaaaaaaaaaaaaa");
        insertNews(db,"通知2",R.drawable.news02,"bbbbbbbbbbbbbbbbbbbbbbbbbb");
    }
    private static void insertNews(SQLiteDatabase db,String title,int resourceId,String content){
        ContentValues newsValues = new ContentValues();
        newsValues.put("TITLE",title);
        newsValues.put("IMAGE_RESOURCE_ID",resourceId);
        newsValues.put("CONTENT",content);

        long result = db.insert("NEWS",null,newsValues);
        //日志插入结果
        Log.d("sqlite","insert"+title+"_id"+result);
    }
//登录表的相关操作
    public void login_add(String name,String password){
        db.execSQL("INSERT INTO user (name,password) VALUES(?,?)",new Object[]{name,password});
    }
    public void login_delete(String name,String password){
        db.execSQL("DELETE FROM user WHERE name = AND password ="+name+password);
    }
    public void login_updata(String password){
        db.execSQL("UPDATE user SET password = ?",new Object[]{password});
    }

    //管理员登录表的操作
    public void glogin_add(String name,String password){
        db.execSQL("INSERT INTO user (name,password) VALUES(?,?)",new Object[]{name,password});
    }
    public void glogin_delete(String name,String password){
        db.execSQL("DELETE FROM user WHERE name = AND password ="+name+password);
    }
    public void glogin_updata(String password){
        db.execSQL("UPDATE user SET password = ?",new Object[]{password});
    }

    public ArrayList<User> getAllData2(){

        ArrayList<User> list = new ArrayList<User>();
        Cursor cursor = db.query("guser",null,null,null,null,null,"gname DESC");
        while(cursor.moveToNext()){
            String gname = cursor.getString(cursor.getColumnIndex("gname"));
            String password = cursor.getString(cursor.getColumnIndex("password"));
            list.add(new User(gname,password));
        }
        cursor.close();
        return list;
    }

    public ArrayList<User> getAllData(){

        ArrayList<User> list = new ArrayList<User>();
        Cursor cursor = db.query("user",null,null,null,null,null,"name DESC");
        while(cursor.moveToNext()){
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String password = cursor.getString(cursor.getColumnIndex("password"));
            list.add(new User(name,password));
        }
        cursor.close();
        return list;
    }

    //员工表的相关操作
    public void yuangong_add(String name,String sex,String tel,String position,String time){
        db.execSQL("INSERT INTO yuangong (name,sex,tel,position,time) VALUES(?,?,?,?,?)",new Object[]{name,sex,tel,position,time});
    }
    public void yuangong_delete(String name){
        db.execSQL("DELETE FROM yuangong WHERE name = ? ", new Object[]{name});
    }
    public void yuangong_updata(String name,String tel,String position){

        db.execSQL("update yuangong set tel=?,position=? where name=?", new Object[]{tel,position,name});
    }
    @Override
    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){

    }

}

本文地址：https://blog.csdn.net/Kiven_zhou/article/details/107212214