1、创建名诗词数据表，字段主要包括：id、题名、作者姓名、全文。 2、实现添加、查询、修改、删除诗词信息的功能。

创建名诗词数据表的SQL语句如下：

CREATE TABLE poem (
id INT PRIMARY KEY,
title VARCHAR(100) NOT NULL,
author VARCHAR(50) NOT NULL,
content TEXT NOT NULL
);

其中，id为自增主键，title为题名，author为作者姓名，content为诗词全文。

添加诗词信息的SQL语句如下：

INSERT INTO poem (title, author, content) VALUES ('静夜思', '李白', '床前明月光，疑是地上霜。举头望明月，低头思故乡。');

查询诗词信息的SQL语句如下：

SELECT * FROM poem WHERE author = '李白';

修改诗词信息的SQL语句如下：

UPDATE poem SET title = '夜泊牛渚怀古', content = '牛渚西江夜，青山独归迟。浊酒一杯相送，古今多少事。' WHERE id = 1;

删除诗词信息的SQL语句如下：

DELETE FROM poem WHERE id = 1;

相关问题

使用sharepreferences 1、创建名诗词数据表，字段主要包括：id、题名、作者姓名、全文。 2、实现添加、查询、修改、删除诗词信息的功能。

以下是使用SharedPreferences实现诗词数据表的示例代码：

1. 创建名诗词数据表，字段主要包括：id、题名、作者姓名、全文。

public class Poem {
    private int id;
    private String title;
    private String author;
    private String content;

    public Poem(int id, String title, String author, String content) {
        this.id = id;
        this.title = title;
        this.author = author;
        this.content = content;
    }

    public int getId() {
        return id;
    }

    public String getTitle() {
        return title;
    }

    public String getAuthor() {
        return author;
    }

    public String getContent() {
        return content;
    }
}

2. 实现添加、查询、修改、删除诗词信息的功能。

public class PoemManager {
    private static final String POEM_PREFS_NAME = "poem_prefs";
    private static final String POEM_KEY_PREFIX = "poem_";

    private Context mContext;
    private SharedPreferences mPrefs;

    public PoemManager(Context context) {
        mContext = context;
        mPrefs = context.getSharedPreferences(POEM_PREFS_NAME, Context.MODE_PRIVATE);
    }

    public void addPoem(Poem poem) {
        SharedPreferences.Editor editor = mPrefs.edit();
        editor.putString(POEM_KEY_PREFIX + poem.getId(), poemToString(poem));
        editor.apply();
    }

    public Poem getPoem(int id) {
        String poemString = mPrefs.getString(POEM_KEY_PREFIX + id, null);
        if (poemString != null) {
            return stringToPoem(poemString);
        }
        return null;
    }

    public void updatePoem(Poem poem) {
        SharedPreferences.Editor editor = mPrefs.edit();
        editor.putString(POEM_KEY_PREFIX + poem.getId(), poemToString(poem));
        editor.apply();
    }

    public void deletePoem(int id) {
        SharedPreferences.Editor editor = mPrefs.edit();
        editor.remove(POEM_KEY_PREFIX + id);
        editor.apply();
    }

    public List<Poem> getAllPoems() {
        List<Poem> poemList = new ArrayList<>();
        Map<String, ?> allEntries = mPrefs.getAll();
        for (Map.Entry<String, ?> entry : allEntries.entrySet()) {
            if (entry.getKey().startsWith(POEM_KEY_PREFIX)) {
                Poem poem = stringToPoem((String) entry.getValue());
                if (poem != null) {
                    poemList.add(poem);
                }
            }
        }
        return poemList;
    }

    private String poemToString(Poem poem) {
        return poem.getId() + "," + poem.getTitle() + "," + poem.getAuthor() + "," + poem.getContent();
    }

    private Poem stringToPoem(String poemString) {
        String[] parts = poemString.split(",");
        if (parts.length == 4) {
            int id = Integer.parseInt(parts[0]);
            String title = parts[1];
            String author = parts[2];
            String content = parts[3];
            return new Poem(id, title, author, content);
        }
        return null;
    }
}

使用示例：

// 创建诗词管理器
PoemManager poemManager = new PoemManager(context);

// 添加诗词
Poem poem = new Poem(1, "静夜思", "李白", "床前明月光，疑是地上霜。举头望明月，低头思故乡。");
poemManager.addPoem(poem);

// 查询诗词
Poem queriedPoem = poemManager.getPoem(1);

// 修改诗词
if (queriedPoem != null) {
    queriedPoem.setTitle("静夜思（改）");
    poemManager.updatePoem(queriedPoem);
}

// 删除诗词
poemManager.deletePoem(1);

// 获取所有诗词
List<Poem> poemList = poemManager.getAllPoems();

使用sharedpreferences 1、创建名诗词数据表，字段主要包括：id、题名、作者姓名、全文。 2、实现添加、查询、修改、删除诗词信息的功能。

首先，我们需要创建一个Poetry类来存储诗词信息，包括id、题名、作者姓名和全文：

public class Poetry {
    private int id;
    private String title;
    private String author;
    private String content;

    public Poetry(int id, String title, String author, String content) {
        this.id = id;
        this.title = title;
        this.author = author;
        this.content = content;
    }

    public int getId() {
        return id;
    }

    public String getTitle() {
        return title;
    }

    public String getAuthor() {
        return author;
    }

    public String getContent() {
        return content;
    }
}

接下来，我们需要创建一个PoetryDatabase类来管理诗词数据表，包括添加、查询、修改、删除等操作：

public class PoetryDatabase {
    private static final String PREF_NAME = "poetry_database";
    private static final String KEY_NEXT_ID = "next_id";

    private SharedPreferences preferences;
    private int nextId;

    public PoetryDatabase(Context context) {
        preferences = context.getSharedPreferences(PREF_NAME, Context.MODE_PRIVATE);
        nextId = preferences.getInt(KEY_NEXT_ID, 1);
    }

    public List<Poetry> getAllPoetries() {
        List<Poetry> poetries = new ArrayList<>();
        Map<String, ?> allEntries = preferences.getAll();
        for (Map.Entry<String, ?> entry : allEntries.entrySet()) {
            String key = entry.getKey();
            if (key.startsWith("poetry_")) {
                String[] parts = key.split("_");
                int id = Integer.parseInt(parts[1]);
                String[] values = ((String) entry.getValue()).split(",");
                String title = values[0];
                String author = values[1];
                String content = values[2];
                Poetry poetry = new Poetry(id, title, author, content);
                poetries.add(poetry);
            }
        }
        return poetries;
    }

    public Poetry getPoetryById(int id) {
        String key = "poetry_" + id;
        String value = preferences.getString(key, null);
        if (value != null) {
            String[] values = value.split(",");
            String title = values[0];
            String author = values[1];
            String content = values[2];
            return new Poetry(id, title, author, content);
        } else {
            return null;
        }
    }

    public void addPoetry(Poetry poetry) {
        String key = "poetry_" + poetry.getId();
        String value = poetry.getTitle() + "," + poetry.getAuthor() + "," + poetry.getContent();
        preferences.edit().putString(key, value).apply();
        nextId++;
        preferences.edit().putInt(KEY_NEXT_ID, nextId).apply();
    }

    public void updatePoetry(Poetry poetry) {
        String key = "poetry_" + poetry.getId();
        String value = poetry.getTitle() + "," + poetry.getAuthor() + "," + poetry.getContent();
        preferences.edit().putString(key, value).apply();
    }

    public void deletePoetry(Poetry poetry) {
        String key = "poetry_" + poetry.getId();
        preferences.edit().remove(key).apply();
    }
}

在PoetryDatabase中，我们使用SharedPreferences来存储诗词数据表，并提供了一些操作，如getAllPoetries、getPoetryById、addPoetry、updatePoetry和deletePoetry等。

具体使用方法如下：

// 创建PoetryDatabase对象
PoetryDatabase db = new PoetryDatabase(context);

// 添加一首诗词
Poetry poetry = new Poetry(1, "静夜思", "李白", "床前明月光，疑是地上霜。举头望明月，低头思故乡。");
db.addPoetry(poetry);

// 查询所有诗词
List<Poetry> allPoetries = db.getAllPoetries();

// 查询指定id的诗词
Poetry poetry = db.getPoetryById(1);

// 修改诗词
poetry.setTitle("将进酒");
db.updatePoetry(poetry);

// 删除诗词
db.deletePoetry(poetry);