这是mainavtivity.java
package com.example.shuakayz;
import com.newland.dev.HighRFID;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;public class MainActivity<activity_main> extends Activity { private data selectdatabase;
private data mydata;
private HighRFID hf;
private Button Buttonsk,Buttonqk,Buttonzc,buttontc;
private void conn(){
hf=new HighRFID();
hf.openAndConnect(2, 0, 6);
mydata=new data(this);
try {
mydata.initdata();
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
@SuppressWarnings("deprecation")
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
/**
* 连接设备初始化数据库
*/
conn();
//刷卡验证
Buttonsk=(Button)findViewById(R.id.skyz);
Buttonsk.setOnClickListener(new OnClickListener(){
public void onClick(View v) {
String[] cardID=new String[1];
//寻卡
if(hf.selectCard(1, cardID)<0)
{
Toast.makeText(MainActivity.this, "读卡失败,请重试!", Toast.LENGTH_SHORT).show();
return;
}
if(mydata.selectdatabase(cardID[0]))
{
return;
}
else
{
Toast.makeText(MainActivity.this, "无用户",Toast.LENGTH_SHORT).show();
}
}});
} @Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}}
这是数据库代码
package com.example.shuakayz;import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;
import android.widget.Toast;public class data {
private String databasepath;
private String databasename;
private Activity activity;
public static SQLiteDatabase sqLiteDatabase;
public data(Activity activity){
this.activity=activity;
databasepath=Environment.getDataDirectory().getPath()+"/data/"+"/da123/";//数据库文件存储路径
databasename="DORM,db3";//数据库文件名
}
//数据库初始化public SQLiteDatabase initdata() throws Exception {
if (!new File(databasepath).exists())
{ new File(databasepath).mkdir();
}
File databasefile = new File(databasepath + databasename);
if (!databasefile.exists()) {
System.out.println(databasepath);
databasefile.createNewFile();
InputStream inputStream = null;
FileOutputStream outputStream = null;
inputStream = activity.getResources().getAssets()
.open(databasename);
outputStream = new FileOutputStream(databasepath + databasename);
byte[] buffer = new byte[1024];
int length;
while ((length = inputStream.read(buffer)) > 0) {
outputStream.write(buffer, 0, length);
buffer = new byte[1024];// 一次写入128B的数据
System.out.println("write over!");
}
// Close the streams
outputStream.flush();
outputStream.close();
sqLiteDatabase = null;
sqLiteDatabase = SQLiteDatabase.openDatabase(databasepath
+ databasename, null, SQLiteDatabase.OPEN_READWRITE);
Toast.makeText(activity, "位于本地的数据库初始化完成!", Toast.LENGTH_LONG)
.show();
sqLiteDatabase = SQLiteDatabase.openDatabase(databasepath
+ databasename, null, SQLiteDatabase.OPEN_READWRITE);
return sqLiteDatabase;
}
return sqLiteDatabase;
}
//查找
public boolean registerdata(String dataa) {
// TODO 自动生成的方法存根
boolean issuccess = false;
if (sqLiteDatabase != null) {
try {
if (!selectdatabase(dataa)) {
ContentValues myContentValues = new ContentValues();
myContentValues.put("STUDENTSCARD_ID", dataa);
sqLiteDatabase
.insert("STUDENTSCARD", null, myContentValues);
issuccess = true;
} else
issuccess = false; } catch (Exception e) {
// TODO: handle exception
issuccess = false;
} } return issuccess;
}
//查找
public boolean selectdatabase(String dataforselect) {
boolean isSuccess = true;
Cursor cursor;
String str_sql = "select * from STUDENTSCARD where STUDENTSCARD_ID = '"
+ dataforselect + "'";
cursor = sqLiteDatabase.rawQuery(str_sql, null);//rawQuery 调用sql语句
if (cursor.moveToFirst())
isSuccess = true;
else
isSuccess = false;
if (cursor != null) {
cursor.close();
}
return isSuccess;
}
//删除
public boolean deletealldata() {
String str_sql = "delete from STUDENTSCARD";
sqLiteDatabase.execSQL(str_sql);
return true;
}
/**
* 关闭数据库
*/
public void closedatabase() {
sqLiteDatabase.close();
} }
有谁能帮忙看看呢数据库
package com.example.shuakayz;
import com.newland.dev.HighRFID;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;public class MainActivity<activity_main> extends Activity { private data selectdatabase;
private data mydata;
private HighRFID hf;
private Button Buttonsk,Buttonqk,Buttonzc,buttontc;
private void conn(){
hf=new HighRFID();
hf.openAndConnect(2, 0, 6);
mydata=new data(this);
try {
mydata.initdata();
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
@SuppressWarnings("deprecation")
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
/**
* 连接设备初始化数据库
*/
conn();
//刷卡验证
Buttonsk=(Button)findViewById(R.id.skyz);
Buttonsk.setOnClickListener(new OnClickListener(){
public void onClick(View v) {
String[] cardID=new String[1];
//寻卡
if(hf.selectCard(1, cardID)<0)
{
Toast.makeText(MainActivity.this, "读卡失败,请重试!", Toast.LENGTH_SHORT).show();
return;
}
if(mydata.selectdatabase(cardID[0]))
{
return;
}
else
{
Toast.makeText(MainActivity.this, "无用户",Toast.LENGTH_SHORT).show();
}
}});
} @Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}}
这是数据库代码
package com.example.shuakayz;import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;
import android.widget.Toast;public class data {
private String databasepath;
private String databasename;
private Activity activity;
public static SQLiteDatabase sqLiteDatabase;
public data(Activity activity){
this.activity=activity;
databasepath=Environment.getDataDirectory().getPath()+"/data/"+"/da123/";//数据库文件存储路径
databasename="DORM,db3";//数据库文件名
}
//数据库初始化public SQLiteDatabase initdata() throws Exception {
if (!new File(databasepath).exists())
{ new File(databasepath).mkdir();
}
File databasefile = new File(databasepath + databasename);
if (!databasefile.exists()) {
System.out.println(databasepath);
databasefile.createNewFile();
InputStream inputStream = null;
FileOutputStream outputStream = null;
inputStream = activity.getResources().getAssets()
.open(databasename);
outputStream = new FileOutputStream(databasepath + databasename);
byte[] buffer = new byte[1024];
int length;
while ((length = inputStream.read(buffer)) > 0) {
outputStream.write(buffer, 0, length);
buffer = new byte[1024];// 一次写入128B的数据
System.out.println("write over!");
}
// Close the streams
outputStream.flush();
outputStream.close();
sqLiteDatabase = null;
sqLiteDatabase = SQLiteDatabase.openDatabase(databasepath
+ databasename, null, SQLiteDatabase.OPEN_READWRITE);
Toast.makeText(activity, "位于本地的数据库初始化完成!", Toast.LENGTH_LONG)
.show();
sqLiteDatabase = SQLiteDatabase.openDatabase(databasepath
+ databasename, null, SQLiteDatabase.OPEN_READWRITE);
return sqLiteDatabase;
}
return sqLiteDatabase;
}
//查找
public boolean registerdata(String dataa) {
// TODO 自动生成的方法存根
boolean issuccess = false;
if (sqLiteDatabase != null) {
try {
if (!selectdatabase(dataa)) {
ContentValues myContentValues = new ContentValues();
myContentValues.put("STUDENTSCARD_ID", dataa);
sqLiteDatabase
.insert("STUDENTSCARD", null, myContentValues);
issuccess = true;
} else
issuccess = false; } catch (Exception e) {
// TODO: handle exception
issuccess = false;
} } return issuccess;
}
//查找
public boolean selectdatabase(String dataforselect) {
boolean isSuccess = true;
Cursor cursor;
String str_sql = "select * from STUDENTSCARD where STUDENTSCARD_ID = '"
+ dataforselect + "'";
cursor = sqLiteDatabase.rawQuery(str_sql, null);//rawQuery 调用sql语句
if (cursor.moveToFirst())
isSuccess = true;
else
isSuccess = false;
if (cursor != null) {
cursor.close();
}
return isSuccess;
}
//删除
public boolean deletealldata() {
String str_sql = "delete from STUDENTSCARD";
sqLiteDatabase.execSQL(str_sql);
return true;
}
/**
* 关闭数据库
*/
public void closedatabase() {
sqLiteDatabase.close();
} }
有谁能帮忙看看呢数据库
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货