h_a_m_i_d
جمعه 28 فروردین 1394, 21:42 عصر
با سلام من از کلاس زیر که از یک پروژه دیگه کپی کردم برای اتصال به دیتا بیس استفاده میکنم ولی متاسفانه خطا میده کسی میتونه کمکم کنه خیلی ضروری هست
package com.example.thehamidandroid;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDatabase extends SQLiteOpenHelper {
public final String path = "data/data/com.example.thehamidandroid/databases/";
public final String Name = "dbapp";
public SQLiteDatabase mydb;
private final Context mycontext;
public MyDatabase(Context context) {
super(context, "dbapp", null, 1);
mycontext = context;
}
@Override
public void onCreate(SQLiteDatabase arg0) {
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
}
public void useable() {
boolean checkdb = checkdb();
if (checkdb) {
} else {
this.getReadableDatabase();
try {
copydatabase();
}
catch (IOException e) {
}
}
}
public void open() {
mydb = SQLiteDatabase.openDatabase(path + Name, null, SQLiteDatabase.OPEN_READWRITE);
}
@Override
public void close() {
mydb.close();
}
public boolean checkdb() {
SQLiteDatabase db = null;
try {
db = SQLiteDatabase.openDatabase(path + Name, null, SQLiteDatabase.OPEN_READONLY);
}
catch (SQLException e) {
}
return db != null ? true : false;
}
public void copydatabase() throws IOException {
OutputStream myOutput = new FileOutputStream(path + Name);
byte[] buffer = new byte[1024];
int lenght;
InputStream myInput = mycontext.getAssets().open(Name);
while ((lenght = myInput.read(buffer)) > 0) {
myOutput.write(buffer, 0, lenght);
}
myInput.close();
myOutput.flush();
myOutput.close();
}
public String namayesh(int row , int field , String table){
android.database.Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table , null);
Cursor.moveToPosition(row);
String str = Cursor.getString(field);
return str;
}
public Integer shomaresh_field(String table,String field){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by "+field, null);
int i = Cursor.getCount();
return i ;
}
public String namayesh_fasl(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s ;
}
public Integer shomaresh_dastan (String table , String season){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+season+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public String namayesh_dastan (String table , int row , String season , int field){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' group by name",null);
Cursor.moveToPosition(row);
String save = Cursor.getString(field);
return save;
}
public Integer shomaresh_safhe_dastan (String table , String season , String story){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+story+"'",null);
int save = Cursor.getCount();
return save;
}
public String namayesh_matn (String table,String season,String name,int page){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+name+"' and page="+page,null);
Cursor.moveToFirst();
String save = Cursor.getString(2);
return save;
}
public String jostojoo(int row , int col , String word , String field){
Cursor cursor;
if (field.equals("name")) {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%' group by name", null);
}else {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%'", null);
}
cursor.moveToPosition(row);
String save = cursor.getString(col);
return save;
}
public Integer shmaresh_jostojoo(String word , String field){
Cursor cursor;
if (field.equals("name")) {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%' group by name", null);
}else {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%'", null);
}
int save = cursor.getCount();
return save;
}
public void beroozresani_doostdashtaniha (String table , String season , String name , String value){
ContentValues cv = new ContentValues();
cv.put("star", value);
mydb.update(table, cv, "season='"+season+"' and name='"+name+"'", null);
}
public Integer shomaresh_doosrdashtaniha(String table){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where star=1 group by name", null);
int save = Cursor.getCount();
return save;
}
public String namayesh_doosrdashtaniha(String table , int row , int field){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where star=1 group by name", null);
Cursor.moveToPosition(row);
String save = Cursor.getString(field);
return save;
}
}
package com.example.thehamidandroid;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDatabase extends SQLiteOpenHelper {
public final String path = "data/data/com.example.thehamidandroid/databases/";
public final String Name = "dbapp";
public SQLiteDatabase mydb;
private final Context mycontext;
public MyDatabase(Context context) {
super(context, "dbapp", null, 1);
mycontext = context;
}
@Override
public void onCreate(SQLiteDatabase arg0) {
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
}
public void useable() {
boolean checkdb = checkdb();
if (checkdb) {
} else {
this.getReadableDatabase();
try {
copydatabase();
}
catch (IOException e) {
}
}
}
public void open() {
mydb = SQLiteDatabase.openDatabase(path + Name, null, SQLiteDatabase.OPEN_READWRITE);
}
@Override
public void close() {
mydb.close();
}
public boolean checkdb() {
SQLiteDatabase db = null;
try {
db = SQLiteDatabase.openDatabase(path + Name, null, SQLiteDatabase.OPEN_READONLY);
}
catch (SQLException e) {
}
return db != null ? true : false;
}
public void copydatabase() throws IOException {
OutputStream myOutput = new FileOutputStream(path + Name);
byte[] buffer = new byte[1024];
int lenght;
InputStream myInput = mycontext.getAssets().open(Name);
while ((lenght = myInput.read(buffer)) > 0) {
myOutput.write(buffer, 0, lenght);
}
myInput.close();
myOutput.flush();
myOutput.close();
}
public String namayesh(int row , int field , String table){
android.database.Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table , null);
Cursor.moveToPosition(row);
String str = Cursor.getString(field);
return str;
}
public Integer shomaresh_field(String table,String field){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by "+field, null);
int i = Cursor.getCount();
return i ;
}
public String namayesh_fasl(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s ;
}
public Integer shomaresh_dastan (String table , String season){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+season+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public String namayesh_dastan (String table , int row , String season , int field){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' group by name",null);
Cursor.moveToPosition(row);
String save = Cursor.getString(field);
return save;
}
public Integer shomaresh_safhe_dastan (String table , String season , String story){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+story+"'",null);
int save = Cursor.getCount();
return save;
}
public String namayesh_matn (String table,String season,String name,int page){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+name+"' and page="+page,null);
Cursor.moveToFirst();
String save = Cursor.getString(2);
return save;
}
public String jostojoo(int row , int col , String word , String field){
Cursor cursor;
if (field.equals("name")) {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%' group by name", null);
}else {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%'", null);
}
cursor.moveToPosition(row);
String save = cursor.getString(col);
return save;
}
public Integer shmaresh_jostojoo(String word , String field){
Cursor cursor;
if (field.equals("name")) {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%' group by name", null);
}else {
cursor = mydb.rawQuery("select * from datastorys where "+field+" like '%"+word+"%'", null);
}
int save = cursor.getCount();
return save;
}
public void beroozresani_doostdashtaniha (String table , String season , String name , String value){
ContentValues cv = new ContentValues();
cv.put("star", value);
mydb.update(table, cv, "season='"+season+"' and name='"+name+"'", null);
}
public Integer shomaresh_doosrdashtaniha(String table){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where star=1 group by name", null);
int save = Cursor.getCount();
return save;
}
public String namayesh_doosrdashtaniha(String table , int row , int field){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where star=1 group by name", null);
Cursor.moveToPosition(row);
String save = Cursor.getString(field);
return save;
}
}