managerdao.java

来自「图书管理系统。JSP+Struts(MVC框架)sql2000数据库」· Java 代码 · 共 137 行

package com.dao;

import java.sql.SQLException;
import java.sql.*;
import org.apache.xml.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.tool.JDBCConnection;
import com.actionForm.ManagerForm;
import java.util.*;
import com.tool.SelfRequestProcessor;

public class ManagerDao {
   private JDBCConnection connection=null;

   public   ManagerDao(){
   connection=new JDBCConnection();
   this.connection.createConnection();
    }

/***********************添加操作员***********************************/
   public boolean insertManager(ManagerForm dtmForm){
       try{
           String sql = "insert into tb_manager values('" + dtmForm.getAccount() +
                        "','" + dtmForm.getPassword() + "','" +
                        dtmForm.getManagerLevel() + "')";
           connection.executeUpdata(sql);
           connection.closeConneciton();
           return true;
       }catch(Exception e){
       return false;
       }
   }

/*******************删除**************************************/
   public boolean deleteManager(ManagerForm dtmForm){
       try{
          System.out.println("开始删除帐号......");
           String sql = "delete from tb_manager where account='" + dtmForm.getAccount() +
                        "'";
           connection.executeUpdata(sql);
           connection.closeConneciton();
           System.out.println("删除帐号成功");
           return true;
       }catch(Exception e){
           System.out.println("删除帐号出错....");
       return false;
       }
 }

 //***********************修改**********************************************//
 public boolean UpdateManager(ManagerForm tmForm){
     try{
         String sql = "update tb_manager set password='" + tmForm.getPassword() +
                      "',managerLevel='" + tmForm.getManagerLevel() +
                      "' where account='" + tmForm.getAccount() + "'";
         connection.executeUpdata(sql);
         connection.closeConneciton();
         return true;
     }catch(Exception e){
     return false;
     }
 }

   //****************************全部查询**********************************//
   public List selectManager(){
       List list = new ArrayList();
       ManagerForm tmForm=null;
       System.out.println("正在查询所有的帐号信息....................");
       String sql = "select * from tb_manager order by id";
       ResultSet rs=connection.executeQuery(sql);
      try{
       while(rs.next()){
       tmForm=new ManagerForm();
       tmForm.setId(Integer.valueOf(rs.getString("id")));
       tmForm.setAccount(rs.getString("account"));
       tmForm.setPassword(rs.getString("password"));
       tmForm.setManagerLevel(rs.getString("managerLevel"));
       list.add(tmForm);}
       System.out.println("查询帐号信息通过！！！！！");
      }catch(Exception e){
       System.out.println("查询帐号信息失败！！！！");
      }
       connection.closeConneciton();
       return list;
   }

   //以帐号为条件查询
  public ManagerForm selectManager(ManagerForm tmForm){
      System.out.println("正在bbbbbbbbbbbbb进入.......");
      ManagerForm nn=null;
      String sql="select * from tb_manager where account='"+tmForm.getAccount()+"'";
      ResultSet rs=connection.executeQuery(sql);
      System.out.println("正在进入....21222222222222222...");
      try{
         while(rs.next()){
             nn=new ManagerForm();
             nn.setId(new Integer(rs.getInt("id")));
             nn.setAccount(rs.getString("account"));
             nn.setPassword(rs.getString("password"));
             nn.setManagerLevel(rs.getString("managerLevel"));
             System.out.println("OK");
         }
      }catch(Exception e){
      System.out.println("错误11111111111");
      }
      connection.closeConneciton();
      return nn;
  }

  //操作员分页查询
      public List selectManagerList() {
          System.out.println("正在查询帐号信息...........");
          List  list = new ArrayList();
          ManagerForm nn=null;
          String sql="select * from tb_manager order by id";
          ResultSet rs=connection.executeQuery(sql);
          try {
              while(rs.next()){
              nn=new ManagerForm();
              nn.setId(Integer.valueOf(rs.getString("id")));
              nn.setAccount(rs.getString("account"));
              nn.setPassword(rs.getString("password"));
              nn.setManagerLevel(rs.getString("managerLevel"));
              System.out.println("OK");}
              list.add(nn);
          } catch(Exception ex) {
              System.out.println("查询出错咯..........");
          }
          connection.closeConneciton();
          return list;
      }


}