Ako moze mala pomoc :
Code:
public class SqlUpiti extends SQLiteOpenHelper {
public SqlUpiti(Context applicationcontext) {
super(applicationcontext, "user.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query;
query = "CREATE TABLE users ( username INTEGER, password INTEGER)";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String query;
query = "DROP TABLE IF EXISTS users";
db.execSQL(query);
onCreate(db);
}
public void insertUser(HashMap<String, String> queryValues) {
SQLiteDatabase database = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("userId", queryValues.get("userId"));
values.put("userName", queryValues.get("userName"));
database.insert("users", null, values);
database.close();
}
public class SqlUpiti extends SQLiteOpenHelper {
public SqlUpiti(Context applicationcontext) {
super(applicationcontext, "user.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query;
query = "CREATE TABLE users ( username INTEGER, password INTEGER)";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String query;
query = "DROP TABLE IF EXISTS users";
db.execSQL(query);
onCreate(db);
}
public void insertUser(HashMap<String, String> queryValues) {
SQLiteDatabase database = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("userId", queryValues.get("userId"));
values.put("userName", queryValues.get("userName"));
database.insert("users", null, values);
database.close();
}
Code:
public boolean logovanje() {
// TODO Auto-generated method stub
ResultSet reSet;
String upit = "select SIFRA_RUCNI_TERMINAL from GL_KOMERCIJALISTI where SIFRA_RUCNI_TERMINAL = ? and SIFRA_RUCNI_TERMINAL = ? ";
try {
PreparedStatement pstmt = konekcija.prepareStatement(upit);
pstmt.setString(1, edtKorisnicko.getText().toString());
pstmt.setString(2, edtPassword.getText().toString());
reSet = pstmt.executeQuery();
int count = 0;
while (reSet.next()) {
count = count + 1;
}
if (count == 1) {
Intent nasIntent = new Intent(Logovanje.this,
MainActivity.class);
startActivity(nasIntent);
edtText.setText("Korektno");
}
public boolean logovanje() {
// TODO Auto-generated method stub
ResultSet reSet;
String upit = "select SIFRA_RUCNI_TERMINAL from GL_KOMERCIJALISTI where SIFRA_RUCNI_TERMINAL = ? and SIFRA_RUCNI_TERMINAL = ? ";
try {
PreparedStatement pstmt = konekcija.prepareStatement(upit);
pstmt.setString(1, edtKorisnicko.getText().toString());
pstmt.setString(2, edtPassword.getText().toString());
reSet = pstmt.executeQuery();
int count = 0;
while (reSet.next()) {
count = count + 1;
}
if (count == 1) {
Intent nasIntent = new Intent(Logovanje.this,
MainActivity.class);
startActivity(nasIntent);
edtText.setText("Korektno");
}
Ako u metodi logovanje selektujem user i pass sada zelim te vrednosti upisati U sqlite bazu..