第一天:
总结我需要做的事:(用户注册页面,登录页面),(忘记需要个人冲刺,现在补上,请谅解)
主菜单页面,错误消息对话框,数据库连接。
查询入库页面,查询图书页面,查询库存页面,查询客户页面,查询供应商页面,查询出库页面;
修改入库页面,修改图书页面,修改库存页面,修改客户页面,修改供应商页面,修改出库页面;
添加入库页面,添加图书页面,添加库存页面,添加客户页面,添加供应商页面,添加出库页面;
删除入库页面,删除图书页面,删除库存页面,删除客户页面,删除供应商页面,删除出库页面。
第二天:主页面
昨天总结任务,今天写主页面,难题按钮初始化
package tian.shu; import tian.biye.R; import android.app.TabActivity; import android.content.Intent; import android.graphics.Color; import android.opengl.Visibility; import android.os.Bundle; import android.view.LayoutInflater; import android.view.View; import android.widget.Button; import android.widget.TabHost; /** * 主菜单页面 * */ public class MenuDemo extends TabActivity { /** * 添加用户键 */ private Button tianjia1; /** * 修改用户键 */ private Button xiugai1; /** * 删除用户键 */ private Button shanchu1; /** * 查询用户键 */ private Button chaxun1; /** * 添加书商品键 */ private Button tianjia2; /** * 修改书商品键 */ private Button xiugai2; /** * 删除书商品键 */ private Button shanchu2; /** * 查询书商品键 */ private Button chaxun2; /** * 添加提供者供应商键 */ private Button tianjia3; /** * 修改提供者供应商键 */ private Button xiugai3; /** * 删除提供者供应商键 */ private Button shanchu3; /** * 查询提供者供应商键 */ private Button chaxun3; /** * 添加入库键 */ private Button tianjia4; /** * 修改入库键 */ private Button xiugai4; /** * 删除入库键 */ private Button shanchu4; /** * 查询入库键 */ private Button chaxun4; /** * 添加出库键 */ private Button tianjia5; /** * 修改出库键 */ private Button xiugai5; /** * 删除出库键 */ private Button shanchu5; /** * 查询出库键 */ private Button chaxun5; /** * 用户管理键 */ private Button yonghu; /** * 修改密码键 */ private Button mima; String names=null; protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); TabHost tab=getTabHost(); tab.setPadding(0, -20, 0, 0); tab.setDrawingCacheBackgroundColor(Color.BLUE); LayoutInflater inf=getLayoutInflater(); inf.inflate(R.layout.menudemo, tab.getTabContentView()); Bundle name=getIntent().getExtras(); names=name.getString("username"); System.out.println(names); /** * 所有按钮初始化 */ tianjia1=(Button) findViewById(R.id.tianjia1); xiugai1=(Button) findViewById(R.id.xiugai1); shanchu1=(Button) findViewById(R.id.shanchu1); chaxun1=(Button) findViewById(R.id.chaxun1); tianjia2=(Button) findViewById(R.id.tianjia2); xiugai2=(Button) findViewById(R.id.xiugai2); shanchu2=(Button) findViewById(R.id.shanchu2); chaxun2=(Button) findViewById(R.id.chaxun2); tianjia3=(Button) findViewById(R.id.tianjia3); xiugai3=(Button) findViewById(R.id.xiugai3); shanchu3=(Button) findViewById(R.id.shanchu3); chaxun3=(Button) findViewById(R.id.chaxun3); tianjia4=(Button) findViewById(R.id.tianjia4); xiugai4=(Button) findViewById(R.id.xiugai4); shanchu4=(Button) findViewById(R.id.shanchu4); chaxun4=(Button) findViewById(R.id.chaxun4); tianjia5=(Button) findViewById(R.id.tianjia5); xiugai5=(Button) findViewById(R.id.xiugai5); shanchu5=(Button) findViewById(R.id.shanchu5); chaxun5=(Button) findViewById(R.id.chaxun5); yonghu=(Button) findViewById(R.id.yonghu); mima=(Button) findViewById(R.id.mima); if(!names.equals("ceshi")){ System.out.println("111111111111111111"); yonghu.setVisibility(View.INVISIBLE);} /** * tabhost.tabspec创建 */ final TabHost.TabSpec tabs1 = tab.newTabSpec("基本信息"); tabs1.setContent(R.id.li1); tabs1.setIndicator("基本信息", null); final TabHost.TabSpec tabs2 = tab.newTabSpec("库存管理"); tabs2.setContent(R.id.li2); tabs2.setIndicator("库存管理", null); final TabHost.TabSpec tabs3 = tab.newTabSpec("信息查询"); tabs3.setContent(R.id.li3); tabs3.setIndicator("信息查询", null); final TabHost.TabSpec tabs4 = tab.newTabSpec("关于"); tabs4.setContent(R.id.li4); tabs4.setIndicator("关于", null); final TabHost.TabSpec tabs5 = tab.newTabSpec("用户管理"); tabs5.setContent(R.id.li5); tabs5.setIndicator("用户管理", null); tab.addTab(tabs1); tab.addTab(tabs2); tab.addTab(tabs3); tab.addTab(tabs5); tab.addTab(tabs4); } /** * 商品信息按钮监听 * @param v */ public void onshangpin(View v){ tianjia1.setVisibility(View.VISIBLE); xiugai1.setVisibility(View.VISIBLE); shanchu1.setVisibility(View.VISIBLE); chaxun1.setVisibility(View.VISIBLE); tianjia2.setVisibility(View.INVISIBLE); xiugai2.setVisibility(View.INVISIBLE); shanchu2.setVisibility(View.INVISIBLE); chaxun2.setVisibility(View.INVISIBLE); tianjia3.setVisibility(View.INVISIBLE); xiugai3.setVisibility(View.INVISIBLE); shanchu3.setVisibility(View.INVISIBLE); chaxun3.setVisibility(View.INVISIBLE); } /** * 供应商信息按钮监听 * @param v */ public void ongongyingshang(View v){ tianjia3.setVisibility(View.VISIBLE); xiugai3.setVisibility(View.VISIBLE); shanchu3.setVisibility(View.VISIBLE); chaxun3.setVisibility(View.VISIBLE); tianjia2.setVisibility(View.INVISIBLE); xiugai2.setVisibility(View.INVISIBLE); shanchu2.setVisibility(View.INVISIBLE); chaxun2.setVisibility(View.INVISIBLE); tianjia1.setVisibility(View.INVISIBLE); xiugai1.setVisibility(View.INVISIBLE); shanchu1.setVisibility(View.INVISIBLE); chaxun1.setVisibility(View.INVISIBLE); } /** * 客户信息按钮监听 * @param v */ public void onkehu(View v){ tianjia2.setVisibility(View.VISIBLE); xiugai2.setVisibility(View.VISIBLE); shanchu2.setVisibility(View.VISIBLE); chaxun2.setVisibility(View.VISIBLE); tianjia1.setVisibility(View.INVISIBLE); xiugai1.setVisibility(View.INVISIBLE); shanchu1.setVisibility(View.INVISIBLE); chaxun1.setVisibility(View.INVISIBLE); tianjia3.setVisibility(View.INVISIBLE); xiugai3.setVisibility(View.INVISIBLE); shanchu3.setVisibility(View.INVISIBLE); chaxun3.setVisibility(View.INVISIBLE); } /** * 商品入库信息按钮监听 * @param v */ public void onruku(View v){ tianjia4.setVisibility(View.VISIBLE); xiugai4.setVisibility(View.VISIBLE); shanchu4.setVisibility(View.VISIBLE); chaxun4.setVisibility(View.VISIBLE); tianjia5.setVisibility(View.INVISIBLE); xiugai5.setVisibility(View.INVISIBLE); shanchu5.setVisibility(View.INVISIBLE); chaxun5.setVisibility(View.INVISIBLE); } /** * 商品出库信息按钮监听 * @param v */ public void onchuku(View v){ tianjia5.setVisibility(View.VISIBLE); xiugai5.setVisibility(View.VISIBLE); shanchu5.setVisibility(View.VISIBLE); chaxun5.setVisibility(View.VISIBLE); tianjia4.setVisibility(View.INVISIBLE); xiugai4.setVisibility(View.INVISIBLE); shanchu4.setVisibility(View.INVISIBLE); chaxun4.setVisibility(View.INVISIBLE); } /** * 添加供应商按钮监听 * @param v */ public void tianjiag(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Tianjiag.class); startActivity(intent); } /** * 查询供应商按钮监听 * @param v */ public void chaxung(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Chaxung.class); startActivity(intent); } /** * 添加入库信息按钮监听 * @param v */ public void tianjiar(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Tianjiar.class); startActivity(intent); } /** * 查询入库信息按钮监听 * @param v */ public void chaxunruku(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Chaxunr.class); startActivity(intent); } /** * 添加商品信息按钮监听 * @param v */ public void ontianjias(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Tianjias.class); startActivity(intent); } /** * 添加客户信息按钮监听 * @param v */ public void tianjiak(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Tianjiak.class); startActivity(intent); } /** * 查询客户信息按钮监听 * @param v */ public void chaxunk(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Chaxunk.class); startActivity(intent); } /** * 添加出库按钮监听 * @param v */ public void tianjiac(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Tianjiac.class); startActivity(intent); } /** * 查询出库按钮监听 * @param v */ public void chaxunc(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(), Chaxunc.class); startActivity(intent); } /** * 修改密码按钮监听 * @param v */ public void mima(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(),Xiugai.class); startActivity(intent); } /** * 用户管理按钮监听 * @param v */ public void yonghu(View v){ Intent intent=new Intent(); Bundle bundle = new Bundle(); bundle.putString("username",names); intent.putExtras(bundle); intent.setClass(getApplicationContext(),Yonghu.class); startActivity(intent); } /** * 删除商品按钮监听 * @param v */ public void shanchus(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Shanchus.class); startActivity(intent); } /** * 删除客户按钮监听 * @param v */ public void shanchuk(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Shanchuk.class); startActivity(intent); } /** * 查询商品按钮监听 * @param v */ public void chaxuns(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Chaxuns.class); startActivity(intent); } /** * 删除供应商按钮监听 * @param v */ public void shanchug(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Shanchug.class); startActivity(intent); } /** * 修改商品按钮监听 * @param v */ public void xiugais(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Xiugais.class); startActivity(intent); } /** * 修改客户按钮监听 * @param v */ public void xiugaik(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Xiugaik.class); startActivity(intent); } /** * 修改供应商按钮监听 * @param v */ public void xiugaig(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Xiugaig.class); startActivity(intent); } /** * 删除出库按钮监听 * @param v */ public void shanchuc(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Shanchuc.class); startActivity(intent); } /** * 删除入库按钮监听 * @param v */ public void shanchur(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Shanchur.class); startActivity(intent); } /** * 修改入库按钮监听 * @param v */ public void xiugair(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Xiugair.class); startActivity(intent); } /** * 修改出库按钮监听 * @param v */ public void xiugaic(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Xiugaic.class); startActivity(intent); } /** * 库存信息查询按钮监听 * @param v */ public void kucun(View v){ Intent intent=new Intent(); intent.setClass(MenuDemo.this, Kucun.class); startActivity(intent); } }
第三天:
数据库连接
昨天主界面,今天数据库连接, 难题连接数据库
package tian.shu; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; public class SqlHelpdemo extends SQLiteOpenHelper{ /* * 创建语句 */ // 创建学生用户表 String createUserTable = "create table user_info(_id int auto_increment,username char(20)," + "password char(20),num char(20),primary key('_id'));"; // 创建书商品表 String creatproductsTable = "create Table products(_id int auto_increment," + "pname char(40),pguige char(20),pdanwei char(20),primary key('_id'));"; // 创建学生顾客表 String createguke = "create table guke(_id int auto_increment," + "comname char(40),pername char(40),addr char(40)," + "city char(20),diqu char(40),youbian char(20),tel char(20)," + "chuangzhen char(20),web char(40),primary key('_id'));"; // 创建提供者供应商表 String creategongyings = "create table gongys(_id int auto_increment," + "comname char(40),pername char(40),addr char(40)," + "city char(20),diqu char(40),youbian char(20),tel char(20)," + "chuangzhen char(20),web char(40),primary key('_id'));"; //创建出库表 String createruku = "create table ruku(_id int auto_increment," + "comname char(40),pername char(40),tel char(40)," + "products char(40),guige char(40),danwei char(20),danjia int," + "num int,date char(40),primary key('_id'));"; //创建入库表 String createchuku = "create table chuku(_id int auto_increment," + "comname char(40),pername char(40),tel char(40)," + "products char(40),guige char(40),danwei char(20),danjia int," + "num int,date char(40),primary key('_id'));"; //创建库存表 String createkucun = "create Table kucun(_id int auto_increment," + "pname char(40),pguige char(20),pdanwei char(20),num int,primary key('_id'));"; // 定义用户表插入语句 String insertStr = "insert into user_info(_id,username,password,num) values(?,?,?,?)"; // 定义书商品表插入语句 String insertproducts = "insert into products values(?,?,?,?);"; // 定义学生顾客表插入语句 String insertguke = "insert into guke values(?,?,?,?,?,?,?,?,?,?);"; // 定义提供商供应商表插入语句 String insertgys = "insert into gongys values(?,?,?,?,?,?,?,?,?,?);"; //定义入库表插入语句 String insertruku = "insert into ruku values(?,?,?,?,?,?,?,?,?,?);"; //定义出库表插入语句 String insertchuku = "insert into chuku values(?,?,?,?,?,?,?,?,?,?);"; //定义库存表插入语句 String insertkucun = "insert into kucun values(?,?,?,?,?);"; public SqlHelpdemo(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } @Override public void onCreate(SQLiteDatabase arg0) { // 设置ID int _id = 0; // 创建用户表,用书商品表,学生顾客表,入库表,出库表 arg0.execSQL(createUserTable); arg0.execSQL(creatproductsTable); arg0.execSQL(createguke); arg0.execSQL(creategongyings); arg0.execSQL(createruku); arg0.execSQL(createchuku); arg0.execSQL(createkucun); // 插入测试data String[] insertValue = { "0", "ceshi", "ceshi", "001", }; String[] insertValue1 = { "0", "ceshi", "ceshi", "001","453" }; String[] insguke={"1","da","das","dadd","sss","aaa","dddd","22","22","eee"}; arg0.execSQL(insertStr, insertValue); arg0.execSQL(insertproducts, insertValue); arg0.execSQL(insertguke, insguke); arg0.execSQL(insertgys, insguke); arg0.execSQL(insertruku, insguke); arg0.execSQL(insertchuku, insguke); arg0.execSQL(insertkucun, insertValue1); } @Override public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) { // TODO Auto-generated method stub } }
第四天:昨天数据库连接
今天查询图书页面;
第五天:查询图书页面
查询入库页面,,查询库存页面,查询客户页面,查询供应商页面,查询出库页面;
第六天:
查询入库页面,查询库存页面,查询客户页面,查询供应商页面,查询出库页面;
修改图书页面;
第七天:修改图书页面
修改入库页面,修改库存页面,修改客户页面,修改供应商页面,修改出库页面;
第八天:
昨天修改入库页面,修改库存页面,修改客户页面,修改供应商页面,修改出库页面;
今天添加图书页面;
第九天:添加图书页面
添加入库页面,添加库存页面,添加客户页面,添加供应商页面,添加出库页面;
第十天:
添加入库页面,添加库存页面,添加客户页面,添加供应商页面,添加出库页面;
删除图书页面;
第十一天:删除图书页面;
删除入库页面,删除库存页面,删除客户页面,删除供应商页面,删除出库页面。