sql.java

现代社会离不开手机和电话

import java.sql.ResultSet;

public class SQL
{

    public SQL()
    {
        db = new DB();
    }

    public void insertinto(String s, String s1, String s2)
    {
        String s3 = (new StringBuilder()).append("INSERT INTO Ttel(name,add,tel) VALUES('").append(s).append("','").append(s1).append("','").append(s2).append("')").toString();
        db.AddInfo(s3);
    }

    public void delete(String s)
    {
        String s1 = (new StringBuilder()).append("DELETE FROM Ttel WHERE name='").append(s).append("'").toString();
        db.DelInfo(s1);
    }

    public ResultSet selectallname()
    {
        String s = "SELECT name FROM Ttel";
        ResultSet resultset = db.SelectInfo(s);
        return resultset;
    }

    public void update(String s, String s1, String s2, String s3)
    {
        String s4 = (new StringBuilder()).append("UPDATE Ttel SET name='").append(s1).append("',add='").append(s2).append("',tel='").append(s3).append("' WHERE name='").append(s).append("'").toString();
        db.UpdInfo(s4);
    }

    public ResultSet selectname4all(String s)
    {
        String s1 = (new StringBuilder()).append("SELECT * FROM Ttel WHERE name='").append(s).append("'").toString();
        ResultSet resultset = db.SelectInfo(s1);
        return resultset;
    }

    public ResultSet selectall()
    {
        String s = "SELECT * FROM Ttel";
        ResultSet resultset = db.SelectInfo(s);
        return resultset;
    }

    DB db;
}