sqlexecute.java

站长好

package javastudy.function;
import java.util.Vector;
import java.util.ArrayList;
import java.util.Iterator;
import javastudy.tools.DBUtil;
//import java.sql.ResultSet;
import javastudy.database.Database;
public class SQLExecute 
{
   //Main m = new Main();
   public Vector v = Database.v;
   public void insert() 
   {
      //System.out.println("insert");
      Function.print("请输入姓名:");
      String name = Function.getInputString();
      Function.print("请输入语文成绩:");
      String chinese = Function.getInputString();
      Function.print("请输入数学成绩:");
      String math = Function.getInputString();
      Function.print("请输入英语成绩:");
      String english = Function.getInputString();
      /*
       Vector name_DB = Database.name;
       name_DB.add(name);
       Database d = new Database();
       int sult[] = d.array;
       sult[0] = Function.getID();
       sult[1] = Integer.parseInt(chinese);
       sult[2] = Integer.parseInt(math);
       sult[3] = Integer.parseInt(english);
       v.addElement(d);
       */
      String sql = "insert into tablename (name,math,chinese,english) values('" + name + "'," + Integer.parseInt(math) + "," + Integer.parseInt(chinese) + "," + Integer.parseInt(english) + ")";
      //System.out.println(sql);
      DBUtil.execute(sql);
   }
   public void delete() 
   {
      //System.out.println("delete");
      Function.print("请输入要删除学生的ID:");
      int id = Integer.parseInt(Function.getInputString());
      DBUtil.execute("delete from tablename where id=" + id);
   /*Vector db = Database.v;
    for(int i = 0; i < db.size(); i ++ )
    {
    Database oneStudent = (Database)v.get(i);
    int student[] = oneStudent.array;
    if(student[0] == id)
    db.remove(i);
    Function.println("删除成功");
    Function.println("删除的内容:\tID为:" + student[0] + "\t姓名为:" + Database.name.get(student[0] - 1));
    }*/
   }
   public void update() 
   {
      //System.out.println("update");
      Function.print("请输入要修改学生的ID:");
      int id = Integer.parseInt(Function.getInputString());
      Function.print("请输入姓名:");
      String name = Function.getInputString();
      Function.print("请输入语文成绩:");
      String chinese = Function.getInputString();
      Function.print("请输入数学成绩:");
      String math = Function.getInputString();
      Function.print("请输入英语成绩:");
      String english = Function.getInputString();
      //System.out.println("update tablename set name='"+name+"',chinese="+chinese+",math="+math+",english="+english+" where id="+id);
      DBUtil.execute("update tablename set name='" + name + "',chinese=" + chinese + ",math=" + math + ",english=" + english + " where id=" + id);
   /*
    Vector db = Database.v;
    for(int i = 0; i < db.size(); i ++ )
    {
    Database oneStudent = (Database)v.get(i);
    int student[] = oneStudent.array;
    if(student[0] == id)
    {
    Database.name.setElementAt(name, (student[0] - 1));
    student[1] = Integer.parseInt(chinese);
    student[2] = Integer.parseInt(math);
    student[3] = Integer.parseInt(english);
    Function.println("修改成功");
    Function.println("修改的内容:\tID为:" + student[0] + "\t姓名为:" + Database.name.get(student[0] - 1));
    }
    }*/
   }
   public void select()//throws Exception 
   {
      //System.out.println("select");
      Function.println("-------------------------------------------");
      Function.println("|  ID  |  姓名  |  语文  |  数学  |  英语  |");
      Function.println("-------------------------------------------");
      ArrayList rs = DBUtil.execute("select * from tablename");
      String name;
      int math, chinese, english;
      Iterator i=rs.iterator();
      while(i.hasNext())
      {
      	Vector v=(Vector)i.next();
      	System.out.println("********************************************************************");
        System.out.println("id:" + v.get(0) + "\t姓名: " + v.get(1) + "\t" + "数学= " + v.get(2) + "\t" + "语文= " + v.get(3) + "\t英语="+v.get(4));
        System.out.println("********************************************************************");    
      }
      /*
      try 
      {
         while(rs.next()) 
         {
            name = rs.getString("name");
            math = rs.getInt("math");
            chinese = rs.getInt("chinese");
            english = rs.getInt("english");
            System.out.println("***********************************************");
            System.out.println("id:" + rs.getString("id") + "\t姓名: " + name + "\t" + "数学= " + math + "\t" + "语文= " + chinese + "\t");
            //System.out.println(substance);
            System.out.println("***********************************************");
            System.out.println("");
         }
      }
      catch(Exception ex) 
      {
      	ex.printStackTrace();
      }
      finally 
      {
      	
      }*/
   /*
    for(int i = 0; i < v.size(); i ++ )
    {
    Database o = (Database)v.get(i);
    int array[] = o.array;
    Function.print("|   " + array[0] + "  |  " + Database.name.get(array[0] - 1) + "  |  " + array[1] + "   |   " + array[2] + "  |  " + array[3] + "  | \n");
    Function.println("-------------------------------------------");
    }
    */
   }
   public void analyzing(String analyzString) 
   {
      Function.println("-------------------------------------------");
      Function.println("|  ID  |  姓名  |  语文  |  数学  |  英语  |");
      Function.println("-------------------------------------------");
      DBUtil.execute(analyzString);
   }
}