2023年7月7日发(作者：)

安卓员⼯管理系统app（源码）员⼯管理系统、数据库部分源码配置⽂件 员⼯界⾯package y;import patActivity;import ;import Preferences;import ;import eption;import Database;import OpenHelper;import ;import ;import ;import ;import rView;import ;import ew;import CursorAdapter;import ew;import ;public class FirstActivity extends AppCompatActivity { private Cursor cursor; @Override public void onDestroy(){ roy(); (); } //定义共享优先数据及基础字段 ⽤于签到功能实现 private String MY_RMBCost ="MY_RMBCost"; private String TodayTime ="TodayTime"; @Override protected void onCreate(Bundle savedInstanceState) { te(savedInstanceState); setContentView(ty_first); //--------------------------------------------------------------登录 Button btnlongin = findViewById(); lickListener(new kListener() { @Override public void onClick(View v) { Intent intent = new Intent(,); startActivity(intent); } }); //-------------------------------------------------------------签到 final Button bt_qiandao = (Button)findViewById(_qiandao); final TextView tv_time = (TextView)findViewById(_qiandaotime); SharedPreferences my_rmb_data = getSharedPreferences(MY_RMBCost, 0);//读取共享数据 Time t = new Time(); ow(); int lastmonth = + 1 ; final String str = + "年" + lastmonth + "⽉" + ay + "⽇"; final String nowtime =my_rmb_ing(TodayTime, "").toString(); if((str)==true) { tv_t("⽇期："+ nowtime +"已签到！"); bt_kgroundResource(); bt_t("✔签到"); } else { tv_t("⽇期："+ str); bt_kgroundResource(); } //签到功能 bt_lickListener(new kListener() { public void onClick(View v) { // TODO Auto-generated method stub SharedPreferences my_rmb_data = getSharedPreferences(MY_RMBCost, 0); if(my_rmb_ing(TodayTime, "").toString().equals(str)==true) { xt( , "今⽇已签到！", _SHORT).show(); } else { my_rmb_() .putString(TodayTime, str) .commit(); tv_t("⽇期："+ str +"已签到！"); bt_kgroundResource(); bt_t("✔签到"); xt( , "签到成功！", _SHORT).show(); } } }); //-------------------------------------每⽇资讯 //ArrayAdapter listAdapter= new ArrayAdapter<>(this,_list_item_1,); ListView listnews = findViewById(_news); //pter(listAdapter); //设置游标适配器 SQLiteOpenHelper starbuzzDatabaseHelper=new CompanyDatabaseHelper(this); //获得数据库引⽤ try { SQLiteDatabase db =dableDatabase(); cursor = ("NEWS", new String[]{"_id","TITLE"}, null,null,null,null,null); SimpleCursorAdapter listAdapter = new SimpleCursorAdapter(this, _list_item_1, cursor, new String[]{"TITLE"}, new int[]{1}, 0); pter(listAdapter); }catch (SQLException e){ Log.e("sqlite",sage()); Toast toast=xt(this,"Database unavaiable",_SHORT); (); } //指定监听器 相应选项单击 ClickListener itemClickListener=new ClickListener() { @Override public void onItemClick(AdapterView parent, View view, int position, long id) { Intent intent = new Intent(,); ra(_DRINKID,(int)id); startActivity(intent); } }; temClickListener(itemClickListener); //-------------------------------------------------公司简介 Button btnintroduction = findViewById(uction); lickListener(new kListener() { @Override public void onClick(View v) { Intent intent = new Intent(,); startActivity(intent); } }); }}登录注册package y;import patActivity;import ;import ;import ;import ils;import ;import ;import xt;import Layout;import veLayout;import ew;import ;import ist;public class LoginActivity extends AppCompatActivity implements kListener {// @Override// protected void onCreate(Bundle savedInstanceState) {// te(savedInstanceState);// setContentView(ty_login);//// Button mbtnlogin = findViewById(_login);// lickListener(new kListener() {// @Override// public void onClick(View v) {//// xt(, "登录成功", _SHORT).show();// Intent intent = new Intent(,);// startActivity(intent);// }// });//// Button btnback = findViewById(_back);// lickListener(new kListener() {// @Override// public void onClick(View v) {// Intent intent = new Intent(,);// 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() ⽅法 * 保存实例状态 * te(savedInstanceState); * 设置视图内容的配置⽂件 * setContentView(ty_login); * 上⾯这⾏代码真正实现了把视图层 View 也就是 layout 的内容放到 Activity 中进⾏显⽰ * 初始化视图中的控件对象 initView() * 实例化 DBOpenHelper，待会进⾏登录验证的时候要⽤来进⾏数据查询 * mDBOpenHelper = new DBOpenHelper(this); */ @Override protected void onCreate(Bundle savedInstanceState) { te(savedInstanceState); setContentView(ty_login); initView(); rpassword(); mDBOpenHelper = new CompanyDatabaseHelper(this); } //记住密码 private void rpassword(){ if(rname!=null && rpassword!=null) { t(rname); t(rpassword); } } /** * onCreae()中⼤的布局已经摆放好了，接下来就该把layout⾥的东西 * 声明、实例化对象然后有⾏为的赋予其⾏为 * 这样就可以把视图层View也就是layout 与 控制层 Java 结合起来了 */ private void initView() { // 初始化控件 mBtLoginactivityLogin = findViewById(_loginactivity_login); mBtLoginactivityGl = findViewById(_loginactivityGl); mBtLonginactivittRegister = findViewById(_loginactivity_register); mEtLoginactivityUsername = findViewById(_loginactivity_username); mEtLoginactivityPassword = findViewById(_loginactivity_password); // 设置点击事件监听器 lickListener(this); lickListener(this); lickListener(this); } public void onClick(View view) { switch (()) { // 跳转到注册界⾯ case _loginactivity_register: startActivity(new Intent(this, )); finish(); break; case _loginactivityGl: startActivity(new Intent(this,)); finish(); break; /** * 登录验证： * * 从EditText的对象上获取⽂本编辑框输⼊的数据，并把左右两边的空格去掉 * String name = t().toString().trim(); * String password = t().toString().trim(); * 进⾏匹配验证,先判断⼀下⽤户名密码是否为空， * if (!y(name) && !y(password)) * 再进⽽for循环判断是否与数据库中的数据相匹配 * if ((e()) && (sword())) * ⼀旦匹配，⽴即将match = true；break； * 否则 ⼀直匹配到结束 match = false； * * 登录成功之后，进⾏页⾯跳转： * * Intent intent = new Intent(this, ); * startActivity(intent); * finish();//销毁此Activity * finish();//销毁此Activity */ case _loginactivity_login: String name = t().toString().trim(); String password = t().toString().trim(); rname = name; rpassword = password; if (!y(name) && !y(password)) { ArrayList data = Data(); boolean match = false; for (int i = 0; i < (); i++) { User user = (i); if ((e()) && (sword())) { match = true; break; } else { match = false; } } if (match) { xt(this, "登录成功", _SHORT).show(); Intent intent = new Intent(this, ); startActivity(intent); finish();//销毁此Activity } else { xt(this, "⽤户名或密码不正确，请重新输⼊", _SHORT).show(); } } else { xt(this, "请输⼊你的⽤户名或密码", _SHORT).show(); } break; } }}package y;import ;import ;import ils;import ;import ;import xt;import ;import patActivity;/** *//** * 此类 implements kListener 之后， * 就可以把onClick事件写到onCreate()⽅法之外 * 这样，onCreate()⽅法中的代码就不会显得很冗余 */public class RegisterActivity extends AppCompatActivity implements kListener { private CompanyDatabaseHelper mDBOpenHelper; private Button mBtRegisteractivityRegister; private EditText mEtRegisteractivityUsername; private EditText mEtRegisteractivityPassword1; private EditText mEtRegisteractivityPassword2; private Button mBtRegisteractivityBack; private Button mBtRegisteractivityBack; @Override protected void onCreate(Bundle savedInstanceState) { te(savedInstanceState); setContentView(ty_register); initView(); mDBOpenHelper = new CompanyDatabaseHelper(this); } private void initView(){ mBtRegisteractivityRegister = findViewById(_registeractivity_register); mBtRegisteractivityBack = findViewById(_registeractivity_back); mEtRegisteractivityUsername = findViewById(_registeractivity_username); mEtRegisteractivityPassword1 = findViewById(_registeractivity_password1); mEtRegisteractivityPassword2 = findViewById(_registeractivity_password2); /** * 注册页⾯能点击的就三个地⽅ * top处返回箭头、刷新验证码图⽚、注册按钮 */ lickListener(this); lickListener(this); } public void onClick(View view) { switch (()) { case _registeractivity_back: //返回登录页⾯ Intent intent1 = new Intent(this, ); startActivity(intent1); finish(); break; case _registeractivity_register: //注册按钮 //获取⽤户输⼊的⽤户名、密码、验证码 String username = t().toString().trim(); String password1 = t().toString().trim(); String password2 = t().toString().trim(); //注册验证 if (!y(username) && !y(password1) && !y(password2) ) { if ((password2)) { //将⽤户名和密码加⼊到数据库中 _add(username, password1); Intent intent2 = new Intent(this, ); startActivity(intent2); finish(); xt(this, "验证通过，注册成功", _SHORT).show(); } else { xt(this, "密码不⼀致,注册失败", _SHORT).show(); } }else { xt(this, "未完善信息，注册失败", _SHORT).show(); } break; } } }}管理员package y;import patActivity;import ialog;import Interface;import ;import ;import ;import ;import ;import xt;import ;public class GuanliActivity extends AppCompatActivity implements kListener { 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) { te(savedInstanceState); setContentView(ty_guanli); initView(); mDBOpenHelper = new CompanyDatabaseHelper(this); } private void initView(){ mbtadd = findViewById(_add); mbtdelete = findViewById(_delete); mbtupdate = findViewById(_update); mbtsearch = findViewById(_search); mbtback = findViewById(_guanliback); medtname = findViewById(_name); medtsex = findViewById(_sex); medttel = findViewById(_tel); medtposition = findViewById(_position); medttime = findViewById(_time); lickListener(this); lickListener(this); lickListener(this); lickListener(this); lickListener(this); lickListener(this); } public void onClick(View view){ switch (()){ case _add:// int mid =nt (t().toString()); String name = t().toString().trim(); String sex = t().toString().trim(); String tel = t().toString().trim(); String position = t().toString().trim(); String time = t().toString().trim(); ng_add(name,sex,tel,position,time); xt(this, "添加成功", _SHORT).show(); t(""); t(""); t(""); t(""); t(""); break; case _delete: AlertDialog alertDialog = new r(this) .setTitle("删除员⼯信息") .setMessage("是否删除") .setPositiveButton("确定", new kListener() { @Override public void onClick(DialogInterface dialogInterface, int i) { String name = t().toString().trim(); String position = t().toString().trim(); ng_delete(name); t(""); t(""); t(""); t(""); t(""); } }) .setNegativeButton("取消", new kListener() { @Override public void onClick(DialogInterface dialogInterface, int i) { return; } }).create(); (); break; case _update: String uname = t().toString().trim(); String utel = t().toString().trim(); String uposition = t().toString().trim(); ng_updata(uname,uposition,utel); xt(this,"更新成功",_SHORT).show(); t(""); t(""); t(""); t(""); t(""); break; case _search: startActivity(new Intent(, )); finish();//销毁此Activity break; case _guanliback: case _guanliback: startActivity(new Intent(, )); finish();//销毁此Activity break; } }}数据库package y;import tValues;import t;import ;import Database;import OpenHelper;import ;import ist;public class CompanyDatabaseHelper extends SQLiteOpenHelper { private static final String DB_NAME=""; 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) { //建每⽇讯息表 L("CREATE TABLE NEWS(_id INTEGER PRIMARY KEY AUTOINCREMENT," + "TITLE TEXT," + "IMAGE_RESOURCE_ID INTEGER," + "CONTENT TEXT);"); //建⽴登录表 L("CREATE TABLE USER( _id INTEGER PRIMARY KEY AUTOINCREMENT," + "name TEXT," + "password TEXT);"); //建⽴管理员登录表 L("CREATE TABLE GUSER( _id INTEGER PRIMARY KEY AUTOINCREMENT," + "gname TEXT," + "password TEXT);"); L("INSERT INTO guser (gname,password) VALUES('zzz','123')"); //建⽴⽤户信息表 L("CREATE TABLE YUANGONG( _id INTEGER PRIMARY KEY AUTOINCREMENT," + "name TEXT," + "sex TEXT,"+ "tel TEXT,"+ "position TEXT,"+ "TIME DATE);"); //插⼊每⽇讯息 insertNews(db,"通知1",01,"aaaaaaaaaaaaaaaaaaaaaaaa"); insertNews(db,"通知2",02,"bbbbbbbbbbbbbbbbbbbbbbbbbb"); } private static void insertNews(SQLiteDatabase db,String title,int resourceId,String content){ ContentValues newsValues = new ContentValues(); ("TITLE",title); ("IMAGE_RESOURCE_ID",resourceId); ("CONTENT",content); long result = ("NEWS",null,newsValues); //⽇志插⼊结果 Log.d("sqlite","insert"+title+"_id"+result); }//登录表的相关操作 public void login_add(String name,String password){ L("INSERT INTO user (name,password) VALUES(?,?)",new Object[]{name,password}); } public void login_delete(String name,String password){ L("DELETE FROM user WHERE name = AND password ="+name+password); } public void login_updata(String password){ L("UPDATE user SET password = ?",new Object[]{password}); } //管理员登录表的操作 public void glogin_add(String name,String password){ L("INSERT INTO user (name,password) VALUES(?,?)",new Object[]{name,password}); } public void glogin_delete(String name,String password){ L("DELETE FROM user WHERE name = AND password ="+name+password); } public void glogin_updata(String password){ L("UPDATE user SET password = ?",new Object[]{password}); } public ArrayList getAllData2(){ ArrayList list = new ArrayList(); Cursor cursor = ("guser",null,null,null,null,null,"gname DESC"); while(Next()){ String gname = ing(umnIndex("gname")); String password = ing(umnIndex("password")); (new User(gname,password)); } (); return list; } public ArrayList getAllData(){ ArrayList list = new ArrayList(); Cursor cursor = ("user",null,null,null,null,null,"name DESC"); while(Next()){ String name = ing(umnIndex("name")); String password = ing(umnIndex("password")); (new User(name,password)); } (); return list; } //员⼯表的相关操作 public void yuangong_add(String name,String sex,String tel,String position,String time){ L("INSERT INTO yuangong (name,sex,tel,position,time) VALUES(?,?,?,?,?)",new Object[]{name,sex,tel,position,time}); } public void yuangong_delete(String name){ L("DELETE FROM yuangong WHERE name = ? ", new Object[]{name}); } public void yuangong_updata(String name,String tel,String position){ L("update yuangong set tel=?,position=? where name=?", new Object[]{tel,position,name}); } @Override public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){ public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){ }}