满汉楼2//model层

最新推荐文章于 2024-10-17 20:47:44 发布

laohan_

最新推荐文章于 2024-10-17 20:47:44 发布

阅读量1k

点赞数

文章标签： string vector sql exception null class

本文链接：https://blog.csdn.net/laohan_/article/details/7566611

版权

/*
* 这是用户数据模型，用它完成对用户的各种操作,主要编写项目的业务操作
*/
package com.mh1.model;
import java.nio.channels.ReadableByteChannel;
import java.sql.ResultSet;

import com.mh1.db.SqlHelp;
import com.mhl.*;
public class UserModel {
   ResultSet rs;
   SqlHelp sp;
   String zhiwei="";
   public String checkUser(String uid,String p)
   {
       try{
           //组织sql语句与参数
           String sql="select cleZw from clerkInfo,login where login.cleId=clerkInfo.cleId and login.cleId=? and login.passwd=?";
           String param[]={uid,p};
           sp=new SqlHelp();
           rs=sp.query(sql, param);
           if(rs.next())
           {
               zhiwei=rs.getString(1);

           }
       }catch(Exception e)
       {
           e.printStackTrace();
       }finally{
           if(sp!=null)
               sp.close();
       }
       return zhiwei;
   }
}

/**
* 人事数据模型
*/
package com.mh1.model;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Vector;

import javax.naming.ldap.Rdn;
import javax.swing.table.AbstractTableModel;

import com.mh1.db.SqlHelp;
import com.mhl.tools.Isql;

public class EmpModel extends AbstractTableModel {

   Vector colums;
   Vector<Vector> rows;
   ResultSetMetaData rsmd;
   Isql isql=null;

   SqlHelp sh;
   String sql;
   boolean b;
   //查询需要显示的人事信息
   public EmpModel()
   {
       //初始化列
       this.colums=new Vector();
       this.rows=new Vector<Vector>();
       b=true;
       sh=new SqlHelp();
   }
   //增删改
   public boolean zsg(Vector<String> rq )
   {



       sql="delete from clerkInfo where";
       for(int i=0;i<rq.size();++i)
       {
           if(i==0)
               sql=sql+" ?=clerkInfo.cleId";
           else
               sql=sql+" or ?=clerkInfo.cleId";
       }
       String temp[]={""};
       String param[]=rq.toArray(temp);
       sh=new SqlHelp();
       b=sh.zsg(sql,param);
       if(sh!=null)
       {
           sh.close();
       }
       return b;
   }
   public void query(String param[])
   {
       //创建sqlhealper
       ResultSet rs=null;
       if(param[0].equals("1"))
       {
           sql="select * from clerkInfo where 1=?";
           rs=sh.query(sql, param);
       }
       else
       {
           sql="select * from clerkInfo where clerkInfo.cleId like ? or clerkInfo.cleZw like ?";
           String temp=param[0];
           String []params={temp,temp};
           rs=sh.query(sql, params);
       }


       //把结果放到rows迭代器内
       try{
           rsmd=rs.getMetaData();
           for(int i=0;i<rsmd.getColumnCount();++i)
           {
               this.colums.add(rsmd.getColumnName(i+1));
           }
           while(rs.next())
           {
               Vector temp=new Vector();
               for(int i=0;i<rsmd.getColumnCount();++i)
               {
                   temp.add(rs.getString(i+1).toString());
               }
               rows.add(temp);
           }
       }catch (Exception e) {
           // TODO: handle exception
           e.printStackTrace();
       }finally{
           if(sh!=null)
           {
               sh.close();
           }
       }

   }

   @Override
   public int getColumnCount() {
       // TODO Auto-generated method stub
       return this.colums.size();
   }

   @Override
   public int getRowCount() {
       // TODO Auto-generated method stub
       return this.rows.size();// /2;/this.rows.size();
   }

   @Override
   public String getColumnName(int column) {
       // TODO Auto-generated method stub
       return this.colums.get(column).toString();
   }
   @Override
   public Object getValueAt(int arg0, int arg1) {
       // TODO Auto-generated method stub
       //返回行：rows.get(arg0)，
       // 再返回列：((Vector)(rows.get(arg0))).get(arg1)
       return ((Vector)(rows.get(arg0))).get(arg1);
   }


}