Android(安卓)酒店客房管理简单小程序
16lz
2021-01-24
程序实现功能：用户登陆注册，客房预订，房间查询，房间报修，房间退订，以维修部身份登陆查看房间损坏情况。。。
程序运行截图：
数据库帮助类：
package com.engineer.shizhibin.myhotel2;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;public class dbHelper extends SQLiteOpenHelper {public dbHelper(Context context, String name, int version) {super(context, name, null, version);// TODO Auto-generated constructor stub}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubdb.execSQL("create table reg_manage (name varchar(255)," + "pass varchar(255),"+ "type varchar(20))");db.execSQL("create table employee (name varchar(10)," +"sex varchar(10),"+ "id varchar(18)," + "time varchar(255)," + "days varchar,"+ "room_id varchar(10)primary key," + "money varchar)");db.execSQL("create table repair (room_id varchar(10),"+ " item varchar(255),"+"finish varchar(255))");db.execSQL("create table reg_repair (name varchar(255)," + "pass varchar(255),"+ "type varchar(20))");}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stub}}登陆首页代码：
package com.engineer.shizhibin.myhotel2;import android.app.Activity;import android.content.Intent;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.support.v7.app.AppCompatActivity;import android.os.Bundle;import android.view.View;import android.widget.Button;import android.widget.EditText;import android.widget.Spinner;import android.widget.Toast;/** * ShiZhiBin * */public class Login extends Activity { private EditText name; private EditText password; private Spinner title; private Button login; private Button cancel; private Button comein; private dbHelper helper = new dbHelper(Login.this, "hotel", 1); private SQLiteDatabase sdb; private String strSpinner; String strName = ""; String strPassword = ""; @Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.login); login = (Button) findViewById(R.id.login); cancel = (Button) findViewById(R.id.cancel); comein = (Button) findViewById(R.id.reg); name = (EditText) findViewById(R.id.name); password = (EditText) findViewById(R.id.password); title = (Spinner) findViewById(R.id.Spinner); sdb = helper.getReadableDatabase(); login.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub //取得界面上的内容 strSpinner = title.getSelectedItem().toString(); strName = name.getText().toString(); strPassword = password.getText().toString(); //判断用户名和密码是否为空 if (strName.equals("") || strPassword.equals("")) { Toast.makeText(Login.this, "用户名或者密码不能为空", Toast.LENGTH_LONG) .show(); } else { //如果密码不为空，判断登录的人员是属于哪个部门的 if (strSpinner.equals("管理部")) { //以用户名为限定条件，查询密码 Cursor cursor = sdb.query("reg_manage", new String[] { "pass" }, "name=?", new String[] { strName }, null, null, null); // System.out.println("aaaaaaaaaaaaa"); //如果密码不是空，获得的密码和输入的密码判断 if (cursor.moveToNext()) { //获得的密码和输入的密码相等的情况下，执行页面跳转 if (strPassword.equals(cursor.getString(cursor .getColumnIndex("pass")))) { Intent intent = new Intent(Login.this, Manage.class); startActivity(intent); // System.out.println("bbbbbbbbbbb"); } //获得的密码和输入的密码不相等的情况下，toast显示提示信息 else { Toast.makeText(Login.this, "密码不正确", Toast.LENGTH_LONG).show(); } } //如果密码为空，则说明用户名不存在 else { Toast.makeText(Login.this, "用户名不存在", Toast.LENGTH_LONG).show(); } } //同上 else { Cursor cursor = sdb.query("reg_repair", new String[] { "pass" }, "name=?", new String[] { strName }, null, null, null); if (cursor.moveToNext()) { if (strPassword.equals(cursor.getString(cursor .getColumnIndex("pass")))) { Intent intent = new Intent(Login.this, Repair.class); startActivity(intent); } else { Toast.makeText(Login.this, "密码不正确", Toast.LENGTH_LONG).show(); } } else { Toast.makeText(Login.this, "用户名不存在", Toast.LENGTH_LONG).show(); } } } name.setText(""); password.setText(""); } }); comein.setOnClickListener(new OnClickListenercomein()); cancel.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub finish(); } }); } class OnClickListenercomein implements View.OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub Intent intent = new Intent(Login.this, Register.class); startActivity(intent); } }}入住管理类：
package com.engineer.shizhibin.myhotel2;import android.app.TabActivity;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.LayoutInflater;import android.view.View;import android.view.View.OnClickListener;import android.webkit.WebView;import android.widget.Button;import android.widget.EditText;import android.widget.RadioButton;import android.widget.TabHost;import android.widget.Toast;public class Manage extends TabActivity {private Button bnTime, bnCacul, ruzhu_commit, ruzhu_fresh, rep_sure,rep_cancel, exits_sure, exits_query, query_button;private EditText ruzhu_edTime;SQLiteDatabase db;String strCurrentTime = "";@Overridepublic void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);TabHost tabhost = getTabHost();LayoutInflater.from(this).inflate(R.layout.maneger,tabhost.getTabContentView(), true);tabhost.addTab(tabhost.newTabSpec("tab1").setIndicator("入住").setContent(R.id.ruzhu));tabhost.addTab(tabhost.newTabSpec("tab2").setIndicator("查询").setContent(R.id.query));tabhost.addTab(tabhost.newTabSpec("tab3").setIndicator("报修").setContent(R.id.repairs));tabhost.addTab(tabhost.newTabSpec("tab3").setIndicator("退房").setContent(R.id.exits));final dbHelper helper = new dbHelper(Manage.this, "hotel", 1);db = helper.getWritableDatabase();/** * 入住Java代码 */// 获取入住时间bnTime = (Button) findViewById(R.id.bntime);bnTime.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {ruzhu_edTime = (EditText) findViewById(R.id.ruzhu_edtime);strCurrentTime = new Time().currentTime();ruzhu_edTime.setText(strCurrentTime);}});// 通过入住天数来自动计算价格bnCacul = (Button) findViewById(R.id.allPrice);bnCacul.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {// TODO Auto-generated method stubString days = ((EditText) findViewById(R.id.ruzhu_days)).getText().toString();String room_id = ((EditText) findViewById(R.id.ruzhu_room_id)).getText().toString();EditText money = (EditText) findViewById(R.id.ruzhu_money);if (days.equals("") || room_id.equals("")) {Toast.makeText(Manage.this, "入住房间号和天数是必填的",Toast.LENGTH_LONG).show();} else {if (Integer.parseInt(room_id) > 20) {int APrice = Integer.parseInt(days) * 120;money.setText(String.valueOf(APrice));} else {int APrice = Integer.parseInt(days) * 80;money.setText(String.valueOf(APrice));}}}});// 刷新按钮监听事件实现ruzhu_fresh = (Button) findViewById(R.id.ruzhu_fresh);ruzhu_fresh.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {EditText name = ((EditText) findViewById(R.id.ruzhu_person_name));name.setText("");EditText id = ((EditText) findViewById(R.id.ruzhu_person_id));id.setText("");EditText days = ((EditText) findViewById(R.id.ruzhu_days));days.setText("");EditText room_id = ((EditText) findViewById(R.id.ruzhu_room_id));room_id.setText("");EditText money = ((EditText) findViewById(R.id.ruzhu_money));money.setText("");ruzhu_edTime = (EditText) findViewById(R.id.ruzhu_edtime);ruzhu_edTime.setText("");}});// 实现入住按钮监听事件ruzhu_commit = (Button) findViewById(R.id.ruzhu_commit);ruzhu_commit.setOnClickListener(new OnClickListener() {String sex = "";public void onClick(View v) {// 获取入住界面信息String name = ((EditText) findViewById(R.id.ruzhu_person_name)).getText().toString();final RadioButton radioButton1 = (RadioButton) findViewById(R.id.radioButton1);if (radioButton1.isChecked()) {sex = "男";} else {sex = "女";}String id = ((EditText) findViewById(R.id.ruzhu_person_id)).getText().toString();String days = ((EditText) findViewById(R.id.ruzhu_days)).getText().toString();String room_id = ((EditText) findViewById(R.id.ruzhu_room_id)).getText().toString();String money = ((EditText) findViewById(R.id.ruzhu_money)).getText().toString();String time = strCurrentTime;// 判断顾客信息是否为空if (name.equals("")) {Toast.makeText(Manage.this, "顾客姓名不能为空", Toast.LENGTH_LONG).show();} else if (id.equals("")) {Toast.makeText(Manage.this, "顾客身份证号不能为空", Toast.LENGTH_LONG).show();} else if (time.equals("")) {Toast.makeText(Manage.this, "入住时间不能为空", Toast.LENGTH_LONG).show();} else if (days.equals("")) {Toast.makeText(Manage.this, "入住天数不能为空", Toast.LENGTH_LONG).show();} else if (room_id.equals("")) {Toast.makeText(Manage.this, "房间号不能为空", Toast.LENGTH_LONG).show();} else if (money.equals("")) {Toast.makeText(Manage.this, "总价格不能为空", Toast.LENGTH_LONG).show();} else {// 判断想要入住的房间是否有人Cursor cursor = db.query("employee",new String[] { "name" }, "room_id= ?",new String[] { room_id }, null, null, null);if (cursor.moveToNext()) {String strName = cursor.getString(cursor.getColumnIndex("name"));System.out.println(strName);Toast.makeText(Manage.this, "该房间有顾客，请选择其它房间",Toast.LENGTH_LONG).show();} else {// 判断身份证号是否是18位if (id.length() == 18) {// 将入住信息插入数据库db.execSQL("insert into employee values(?,?,?,?,?,?,?)",new String[] { name, sex, id, time, days,room_id, money });Toast.makeText(Manage.this, "入住成功", 10000).show();} else {Toast.makeText(Manage.this, "身份证号不正确，请重新输入",Toast.LENGTH_LONG).show();((EditText) findViewById(R.id.ruzhu_person_id)).setText("");}}}}});/** * 查询java代码 */final EditText query_room_id = (EditText) findViewById(R.id.query_room_id);query_button = (Button) findViewById(R.id.query_button);final WebView wv = (WebView) findViewById(R.id.weserach);// 为查询按钮绑定监听器query_button.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {// 获得用户输入的房间号String room_id_2 = query_room_id.getText().toString();// 查询用户输入的房间号是否与数据库中的房间号匹配Cursor cursor = db.query("employee", new String[] { "name","sex", "id", "room_id", "time", "days", "money" },"room_id= ?", new String[] { room_id_2 }, null, null,null);if (cursor.moveToNext()) {// 获得数据库信息String query_room_id = cursor.getString(cursor.getColumnIndex("room_id"));String query_name = cursor.getString(cursor.getColumnIndex("name"));String sex = cursor.getString(cursor.getColumnIndex("sex"));String query_id = cursor.getString(cursor.getColumnIndex("id"));String query_time = cursor.getString(cursor.getColumnIndex("time"));String query_days = cursor.getString(cursor.getColumnIndex("days"));String query_money = cursor.getString(cursor.getColumnIndex("money"));StringBuilder sb = new StringBuilder();// 拼接HTML代码sb.append("");sb.append("");sb.append("");sb.append("");sb.append("房间号:" + query_room_id);sb.append("
");sb.append("
");sb.append("姓名:" + query_name);sb.append("
");sb.append("
");sb.append("性别:" + sex + "\n");sb.append("
");sb.append("
");sb.append("身份证:" + query_id);sb.append("
");sb.append("
");sb.append("入住时间:" + query_time);sb.append("
");sb.append("
");sb.append("入住天数:" + query_days);sb.append("
");sb.append("
");sb.append("总钱数:" + query_money);sb.append("");sb.append("");// 把内容加载到webview中让其显示查询信息wv.loadDataWithBaseURL(null, sb.toString(), "text/html","utf-8", null);} else {// 没有人入住时显示提示信息Toast.makeText(Manage.this, "该房间没有入住信息！", 5000).show();wv.loadDataWithBaseURL(null, "", "text/html", "utf-8", null);}}});/** * 报修Java代码 */rep_sure = (Button) findViewById(R.id.rep_sure);rep_cancel = (Button) findViewById(R.id.rep_cancel);final EditText rep_id = (EditText) findViewById(R.id.rep_id);final EditText rep_status = (EditText) findViewById(R.id.rep_status);rep_sure.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {// TODO Auto-generated method stubString mRep_id = (rep_id.getText()).toString();String mRep_status = (rep_status.getText()).toString();db.execSQL("insert into repair values(?,?,?)", new String[] {mRep_id, mRep_status, "no_repairs" });Toast.makeText(Manage.this, "报修成功", 10000).show();}});rep_cancel.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {rep_id.setText("");rep_status.setText("");}});// 退房代码final EditText exits_name = (EditText) findViewById(R.id.exits_name);final EditText exits_room_id = (EditText) findViewById(R.id.exits_room_id);exits_sure = (Button) findViewById(R.id.exits_sure);exits_query = (Button) findViewById(R.id.exits_query);// 取得当前房间编号的用户名exits_sure.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {String name_demo = "";String room_id1 = exits_room_id.getText().toString();String strNameid = exits_name.getText().toString();Cursor cursor = db.query("employee", new String[] { "name" },"room_id like ?", new String[] { room_id1 }, null,null, null);// cursor.moveToFirst();while (cursor.moveToNext()) {name_demo = cursor.getString(cursor.getColumnIndex("name"));}// 判断该房间的用户名是否与输入的用户名相等if (strNameid.equals(name_demo)) {// 删除该房间的登记信息db.delete("employee", "room_id like ?",new String[] { room_id1 });exits_room_id.setText("");exits_name.setText("");Toast.makeText(Manage.this, "删除成功", 10000).show();} else {Toast.makeText(Manage.this, "删除不成功", 10000).show();}cursor.close();}});exits_query.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {finish();}});}}注册类：
package com.engineer.shizhibin.myhotel2;import java.util.ArrayList;import java.util.List;import android.app.Activity;import android.app.AlertDialog;import android.content.DialogInterface;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.Spinner;import android.widget.Toast;public class Register extends Activity {private EditText name;private EditText pass;private Button reg;private Button back;private Spinner r_spinner;SQLiteDatabase db;dbHelper helper = new dbHelper(Register.this, "hotel", 1);List listName_manage = new ArrayList();List listName_repair = new ArrayList();String strName;String strSpinner;String strPass;int numTemp;@Overrideprotected void onCreate(Bundle savedInstanceState) {// TODO Auto-generated method stubsuper.onCreate(savedInstanceState);setContentView(R.layout.regis);name = (EditText) findViewById(R.id.Ereg_name);pass = (EditText) findViewById(R.id.Ereg_pass);r_spinner = (Spinner) findViewById(R.id.r_Spinner);reg = (Button) findViewById(R.id.re);back = (Button) findViewById(R.id.back);db = helper.getWritableDatabase();reg.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {// TODO Auto-generated method stubstrName = name.getText().toString();strPass = pass.getText().toString();int numTemp = 0;strSpinner = r_spinner.getSelectedItem().toString();// Toast.makeText(Register.this, strSpinner, 10000).show();if (strSpinner.equals("管理部")) {// db.execSQL("insert into reg_manage values(?,?,?)",// new String[] { strName, strPass, strSpinner });// Toast.makeText(Register.this, "注册成功", 10000).show();Cursor cursor = db.query("reg_manage",new String[] { "name" }, null, null, null, null,null);// Cursor cursor =// db.rawQuery("select name from reg_manage",// null);while (cursor.moveToNext()) {listName_manage.add(cursor.getString(cursor.getColumnIndex("name")));}for (int i = 0; i < listName_manage.size(); i++) {if (strName.equals(listName_manage.get(i))) {new AlertDialog.Builder(Register.this).setTitle("提示框").setMessage("该用户名已存在，请重新输入！").setPositiveButton(R.string.ok,new DialogInterface.OnClickListener() {@Overridepublic void onClick(DialogInterface dialog,int which) {}}).show();break;}numTemp = i;}if ((numTemp + 1) >= listName_manage.size()) {db.execSQL("insert into reg_manage values(?,?,?)",new String[] { strName, strPass, strSpinner });Toast.makeText(Register.this, "注册成功", 10000).show();}}if (strSpinner.equals("维修部")) {Cursor cursor = db.query("reg_repair",new String[] { "name" }, null, null, null, null,null);// Cursor cursor =// db.rawQuery("select name from reg_manage",// null);while (cursor.moveToNext()) {listName_repair.add(cursor.getString(cursor.getColumnIndex("name")));}for (int i = 0; i < listName_repair.size(); i++) {if (strName.equals(listName_repair.get(i))) {new AlertDialog.Builder(Register.this).setTitle("提示框").setMessage("该用户名已存在，请重新输入！").setPositiveButton(R.string.ok,new DialogInterface.OnClickListener() {@Overridepublic void onClick(DialogInterface dialog,int which) {}}).show();break;}numTemp = i;}if ((numTemp + 1) >= listName_repair.size()) {db.execSQL("insert into reg_repair values(?,?,?)",new String[] { strName, strPass, strSpinner });Toast.makeText(Register.this, "注册成功", 10000).show();}// db.execSQL("insert into reg_repair values(?,?,?)",// new String[] { strName, strPass, strSpinner });}// Toast.makeText(Register.this, "注册成功", 10000).show();}});back.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {// TODO Auto-generated method stubfinish();}});}} 报修类：
package com.engineer.shizhibin.myhotel2;import android.app.Activity;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.Spinner;import android.widget.TextView;import android.widget.Toast;public class Repair extends Activity {SQLiteDatabase db;// 维修事项TextView repMatter;EditText rep_room_id;Spinner repStatus;private Button rep_delete, rep_query;@Overrideprotected void onCreate(Bundle savedInstanceState) {// TODO Auto-generated method stubsuper.onCreate(savedInstanceState);setContentView(R.layout.repair);rep_delete = (Button) findViewById(R.id.rep_commit);rep_query = (Button) findViewById(R.id.rep_select);final dbHelper helper = new dbHelper(Repair.this, "hotel", 1);db = helper.getWritableDatabase();// 维修事项repMatter = (TextView) findViewById(R.id.repMatter);// 维修的房间号rep_room_id = (EditText) findViewById(R.id.rep_room_id);final String result_room_id = rep_room_id.getText().toString();rep_query.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {Cursor cursor = db.query("repair", new String[] { "room_id","item", "finish" }, " room_id=?",new String[] { result_room_id }, null, null, null);String strOne = cursor.getString(cursor.getColumnIndex("room_id"));String strTwo = cursor.getString(cursor.getColumnIndex("item"));rep_room_id.setText(strOne);repMatter.setText(strTwo);}});rep_delete.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {db.delete("repair", "id=?", new String[] { result_room_id });Toast.makeText(Repair.this, "删除成功", 10000).show();}});}}界面的XML代码不再贴出来了
更多相关文章
- Android输入密码密文显示
- Android移动应用开发——用户注册
- Android四方形输入框、密码框
- Node.js+Koa2+MySQL打造前后端分离精品项目《旧岛》
- Android 怎么向打开的网页中自动填充用户名和密码？
- Android社交系统
- Android使用ApacheFtpServer实现Ftp服务器(增加用户验证)
- android 仿ios数字密码解锁界面的实例
- textView 密码问题