xiugai.java

来自「该程序采用web平台的方案实现了灵活的车辆监控。」· Java 代码 · 共 61 行

package bean;
import java.sql.*;
public class xiugai {

    String tablename="";//数据库表名
    String result;//查询结果
    String str[];
    String sign;
    int num;
    public void setTablename(String s)
   {
       tablename=s;
   }//置表名
   public String getTablename()
   {
       return tablename;
   }
   public void setSign(String s)
   {
   sign=s;
   StringTokenizer fenxi=new StringTokenizer(sign,",");
    num=fenxi.countTokens();
    int i=0;
    while(fenxi.hasMoreTokens())
    {
      String temp=fenxi.nextToken();
      try{
      byte b[]=temp.getBytes("ISO-8859-1");
      temp=new String(b);
      }
      catch(Exception ee){}
      str[i]=temp;
      i++;
    }
   }
    public xiugai() {
        try{
           Connection con=DriverManager.getConnection("jdbc:odbc:bishe","sa","726");
           Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,Result.CONCUR_UPDATABLE);
          ResultSet rs=sql.executeQuery("SELECT * FROM"+tablename);
          for(int i=0;i<num;i++)
          {
           rs.updateString(num,str[num]);
          }
          if(rs.next()){
             
          while(rs.getString(1)==str[1]){
              rs.updateRow();
          }}
             else
             {
              rs.insertRow();
          }
        } 
         catch(SQLException e) 
         {}
        }
     
}