Android source code warehouse management

Source code introduction

A simple warehouse management system, suitable for beginners to learn.
Source code screenshot

Source code snippet

 rotated void onCreate(Bundle savedInstanceState) {
 // TODO Auto-generated method stub  
 super .onCreate(savedInstanceState);
        setContentView(R.layout.userregister);
        name = (EditText) findViewById(R.id.usename);
        pass = (EditText) findViewById(R.id.password);
        passsure = (EditText) findViewById(R.id.passwordsure);
        workid = (EditText) findViewById(R.id.useide);
        db = new SqlHelpdemo(getApplicationContext(), "store.db" , null , 1 );
        sDatabase = db.getWritableDatabase(); 
  
 } 
  
 public   void sure(View v) {
        db = new SqlHelpdemo(getApplicationContext(), "store.db" , null , 1 );
        sDatabase = db.getWritableDatabase();
 if (name.getText().toString().equals( "" )
                || pass.getText().toString().equals( "" )
                || passsure.getText().toString().equals( "" )
                || workid.getText().toString().equals( "" )) { 
  
 DialogDemo.builder(UserRegister. this , "Error message" , "Please fill in the complete information!" ); 
  
 } else   if (!pass.getText().toString()
                .equals(passsure.getText().toString())) {
 DialogDemo.builder(UserRegister. this , "Error message" , "The two passwords you entered are inconsistent!" );
 } else {
            String ename = name.getText().toString();
            String epass = pass.getText().toString();
            String eid = workid.getText().toString();
 // Query statement  
            String selectStr = "select username from user_info" ;
            Cursor select_cursor = sDatabase.rawQuery(selectStr, null );
            select_cursor.moveToFirst();
            String string = null ;
 do {
 try {
                    string = select_cursor.getString( 0 );
                } catch (Exception e) {
 // TODO: handle exception  
                    string = "" ;
 }
 if (string.equals(ename)) {
 DialogDemo.builder(UserRegister. this , "error message" ,
 "The username already exists, please create another username" );
                    select_cursor.close();
 break ; 
  
 }
            } while (select_cursor.moveToNext());
 // Start without duplicate registration  
 if (!string.equals(ename)) {
 // Define ID  
 int id = 0 ;
                String select = "select max(_id) from user_info" ;
                Cursor seCursor = sDatabase.rawQuery(select, null );
 try {
                    seCursor.moveToFirst();
                    id = Integer.parseInt(seCursor.getString( 0 ));
 id += 1 ;
                } catch (Exception e) {
 // TODO: handle exception  
 id = 0 ;
 }
                sDatabase.execSQL( "insert into user_info values('" + id + "','"  
                        + ename + "','" + epass + "','"  
                        + eid + "')" );
 DialogDemo.builder(UserRegister. this , "Prompt" , "Registration successful, please return to the login interface to log in" ); 
                  
                seCursor.close(); 
              
                  
 }
 } 
  
 } 
  
 }