assetinfo.java

管理系统

package com.aptech.cdjj.sex.action;

import com.aptech.cdjj.sex.database.SDBManager;
import java.util.Vector;
import java.sql.*;


public class AssetInfo {
    Connection con = null;
    Statement s = null;
    ResultSet rs = null;

    public boolean info5() throws SQLException {

       String sql = "select aname from asset";
       SDBManager.executeQuery(sql);
       while(SDBManager.executeQuery(sql).next()){
           System.out.print(SDBManager.executeQuery(sql).getString(1)+"\t");
           System.out.println("");
       }
       SDBManager.closeObj();
        return true;
    }
    //增加数据
    public boolean info(String id,String name,String math,String num,String txtBox2,String txtBox1,String txtBox3,String txtbox4,String rest,String price,String price2,String time,String add){

       String sql = "insert into asset values('"+id+"','"+name+"','"+math+"','"+num+"','"+txtBox2+"','"+txtBox1+"','"+txtBox3+"','"+txtbox4+"','"+rest+"','"+price+"','"+price2+"','"+time+"','"+add+"')";
       SDBManager.executeUpdate(sql);
       SDBManager.closeObj();
        return true;
    }

    //删除数据
    public boolean info1(String id){
        SDBManager.ConnToDB();
        String sql = "delete  from asset where aid = '"+id+"'";
        SDBManager.executeUpdate(sql);
       SDBManager.closeObj();

        return true;

    }
  //对编号排序
  public boolean info2(){
      String sql = "select * from asset  order by aname";
      SDBManager.executeQuery(sql);
      SDBManager.closeObj();

      return true;
  }
//对原始价格排序
  public boolean info3(){

      String sql = "select * from asset  order by acost";
      SDBManager.executeQuery(sql);
      SDBManager.closeObj();
      return true;
}

    public Vector vector() throws SQLException {
        SDBManager.ConnToDB();
        String sql = "select * from asset order by aid";
        rs = SDBManager.executeQuery(sql);
        Vector vect = new Vector();
       while(rs.next()){
            Vector vec = new Vector();
            vec.add(rs.getString(1));
            vec.add(rs.getString(2));
            vec.add(rs.getString(3));
            vec.add(rs.getString(4));
            vec.add(rs.getString(5));
            vec.add(rs.getString(6));
            vec.add(rs.getString(7));
            vec.add(rs.getString(8));
            vec.add(rs.getString(9));
            vec.add(rs.getString(10));
            vec.add(rs.getString(11));
            vec.add(rs.getString(12));
            vec.add(rs.getString(13));
            vect.add(vec);
            vec = null;
        }
        SDBManager.closeObj();
        return vect;
    }

}