android sqlite 数据库创建

上一个问题没写完：http://bbs.csdn.net/topics/390946056?page=1#post-398621090
补在这里！！！！

package model.cqupt;
public class Book{
private String name;
private String id;
private String price;

public Book(String id,String name,String price){
this.id=id;
this.name=name;
this.price=price;
}

public String getName(){
return name;
}
public void setName(String name){
this.name=name;
}
public String getId(){
return id;
}
public void setId(String id){
this.id=id;
}
public String getPrice(){
return price;
}
public void setPrice(String price){
this.price=price;
}
public String toString(){
return id+" "+name +" " +price;
}
}

package model.cqupt;
import java.util.ArrayList;
import android.database.Cursor;
import android.database.sqlite.*;
import db.cqupt.DBconnection;
public class BookList extends ArrayList<Book>{
private static final long serialVersionUID=1L;
private static BookList booklist=null;
private BookList(){

}
public static BookList getBookList(){
if(booklist==null){
booklist=new BookList();
DBconnection connection=new DBconnection();
SQLiteDatabase db=connection.getConnection();
Cursor cur=db.query("book",null,null,null,null,null,null);
while(cur.moveToNext()){
int idNum=cur.getColumnIndex("id");
int nameNum=cur.getColumnIndex("name");
int priceNum=cur.getColumnIndex("price");
String id=cur.getString(idNum);
String name=cur.getString(nameNum);
String price=cur.getString(priceNum);
Book book=new Book(id,name,price);
booklist.add(book);
cur.moveToNext();
}
connection.close(db);
}
return booklist;
}
private boolean checkId(String bookid){
for(int i=0;i<booklist.size();++i){
Book book=booklist.get(i);
String id=book.getId();
if(id.equals(bookid)){
return true;
}
}
return false;
}
private int getIndex(String bookid){
int i=0;
for(;i<booklist.size();++i){
Book book =booklist.get(i);
String id=book.getId();
if(id.equals(bookid)){
break;
}
}
return i;
}
private boolean checkName(String name){
for(int i=0;i<booklist.size();++i){
Book book2=booklist.get(i);
if(book2.getName().equals(name)){
booklist.remove(i);
return true;
}
}
return false;
}
public boolean insert(Book book){
if(checkId(book.getId())){
return false;
}
else{
booklist.add(book);
String id=book.getName();
String name=book.getName();
String price=book.getPrice();
DBconnection connection=new DBconnection();
SQLiteDatabase db=connection.getConnection();
String sql="INSERT INTO book(id,name,price)"
+"VALUES('"  +id+"','"  +name+"','"  +price+"')";
db.execSQL(sql);
db.close();
return true;
}

}
public boolean delete(String name){
if(checkName(name)){
DBconnection connection=new DBconnection();
SQLiteDatabase db=connection.getConnection();
String sql="DELETE FROM book WHERE name='"+name+"'";
db.execSQL(sql);
return true;
}
else{
return false;
}

}
public boolean set(Book book){
if(checkId(book.getId())){
String id=book.getName();
String name=book.getName();
String price=book.getPrice();
int index=getIndex(id);
booklist.set(index,book);
DBconnection connection=new DBconnection();
SQLiteDatabase db=connection.getConnection();
String sql="UPDATE book SET name='"+name+"',"+"price='"+price+"'WHERE id='"+id+"'";
db.execSQL(sql);
return true;
}
else{
return false;
}

}


}

package ui.cqupt;
import control.cqupt.Controller;
import android.app.Activity;  
import android.app.AlertDialog.Builder;
import android.content.DialogInterface;
import android.os.Bundle;  
import android.view.View;  
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;



public class DeleteActivity extends Activity{
private EditText name;
public void onCreate(Bundle savedInstanceState){
super.onCreate(savedInstanceState);
setContentView(R.layout.delete);
name=(EditText)findViewById(R.id.dname);
Button delete=(Button)findViewById(R.id.d_delete);
delete.setOnClickListener(new ButtonListener());
}
class ButtonListener implements OnClickListener{
public void onClick(View v){
String bookname=name.getText().toString();
Controller control=new Controller();
if(bookname.equals("")){
new Builder(DeleteActivity.this).setMessage("图书名称不能为空").show();
}
else{
if(control.deleteBook(bookname)){
name.setText("");
buildDialog();
}
else{
new Builder(DeleteActivity.this).setMessage("没有此图书").show();
}
}

}
private void buildDialog(){
Builder builder=new Builder(DeleteActivity.this);
builder.setTitle("删除成功，是否继续删除？");
builder.setNegativeButton("返回首页", 
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog,
int whichButton){
finish();
}
});
builder.setPositiveButton("继续删除", null);
builder.show();
}
}
}

package ui.cqupt;
import ui.cqupt.R;
import control.cqupt.Controller;
import android.app.Activity;   
import android.app.AlertDialog.Builder;
import android.content.DialogInterface;
import android.os.Bundle;  
import android.view.View;  
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class InsertActivity extends Activity{
private EditText name;
private EditText id;
private EditText price;
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.insert);
name = (EditText)findViewById(R.id.name);
id = (EditText)findViewById(R.id.id);
price = (EditText)findViewById(R.id.price);
Button insert = (Button)findViewById(R.id.i_insert);
insert.setOnClickListener(new ButtonListener());
}
class ButtonListener implements OnClickListener{
public void onClick(View v){
String bookname = name.getText().toString();
String bookid = id.getText().toString();
String bookprice = price.getText().toString();
Controller control = new Controller();
if(control.addBook(bookid,bookname,bookprice)){
id.setText("");
name.setText("");
price.setText("");
buildDialog();
}
else{
new Builder(InsertActivity.this).setMessage("已有此图书").show();
}
}
private void buildDialog(){
Builder builder = new Builder(InsertActivity.this);
builder.setTitle("插入成功，是否继续插入");
builder.setNegativeButton("返回首页",
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int whicButton){
finish();
}
});
builder.setPositiveButton("继续插入", null);
builder.show();
}
}
}

package ui.cqupt;
import control.cqupt.Controller;
import model.cqupt.Book;
import model.cqupt.BookList;
import android.app.Activity;   
import android.os.Bundle;  
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;  

public class selectActivity extends Activity{
public void onCreate(Bundle savedInstanceState){
super.onCreate(savedInstanceState);
setContentView(R.layout.select);
Controller control=new Controller();
BookList booklist=control.searchBook();
CreateTable(booklist);
}
//显示
private void CreateTable(BookList booklist) {
TableLayout table=(TableLayout)findViewById(R.id.SELECT_ACTIVITY_TableLayout);
for(int i=0;i<booklist.size();++i){
Book book=booklist.get(i);
String id=book.getId();
String name=book.getName();
String price=book.getPrice();
TableRow row=new TableRow(this);
TextView tid=new TextView(this);
TextView tname=new TextView(this);
TextView tprice=new TextView(this);
tid.setText(id);
tname.setText(name);
tprice.setText(price);
row.addView(tid);
row.addView(tname);
row.addView(tprice);
table.addView(row);
}
}
}

package ui.cqupt;
import ui.cqupt.R;
import control.cqupt.Controller;
import android.app.Activity;   
import android.app.AlertDialog.Builder;
import android.content.DialogInterface;
import android.os.Bundle;  
import android.view.View;  
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class setActivity extends Activity{
private EditText name;
private EditText id;
private EditText price;
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.set);
name = (EditText)findViewById(R.id.sname);
id = (EditText)findViewById(R.id.sid);
price = (EditText)findViewById(R.id.sprice);
Button insert = (Button)findViewById(R.id.s_set);
insert.setOnClickListener(new ButtonListener());
}
class ButtonListener implements OnClickListener{
public void onClick(View v){
String bookname = name.getText().toString();
String bookid = id.getText().toString();
String bookprice = price.getText().toString();
Controller control = new Controller();
if(bookname.equals("")||bookid.equals("")||bookprice.equals("")){
new Builder(setActivity.this).setMessage("图书信息不能为空").show();
}
else{
if(control.setBook(bookid, bookname, bookprice)){
id.setText("");
name.setText("");
price.setText("");
buildDialog();
}
else{
new Builder(setActivity.this).setMessage("没有此编号的图书，请重新输入").show();
}
}
}
private void buildDialog(){
Builder builder = new Builder(setActivity.this);
builder.setTitle("修改成功，是否继续修改");
builder.setNegativeButton("返回首页",
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int whicButton){
finish();
}
});
builder.setPositiveButton("继续修改", null);
builder.show();
}
}
}