booksortdao.java

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

package com.dao;

import java.sql.*;
import java.sql.SQLException;
import java.util.*;
import com.actionForm.BookSortForm;
import com.tool.*;

public class BookSortDao {
    private JDBCConnection con=null;

    public BookSortDao() {
        System.out.println("正在建立数据库连接.......");
        try{
            con = new JDBCConnection();
            this.con.createConnection();
         System.out.println("数据库连接成功！！！");
        }catch(Exception e){
        System.out.println("建立数据库连接失败！！！");
        }
    }
/************增加图书类别**********************************************/
    public boolean insertBookSort(BookSortForm bookForm) {
        try{
            String sql = "insert into tb_bookSort values('"+bookForm.getPlaceName() +"','" + bookForm.getSortNumber() + "','"+bookForm.getSortName()+"')";
            con.executeUpdata(sql);
            con.closeConneciton();
            System.out.println("增加图书类别成功！！！");
            return true;
        }catch(Exception e){
        System.out.println("增加图书类别失败！！！");
         return false;
        }
      }

 /*********************删除图书类别***************************************/
      public boolean deleteBookSort(BookSortForm bookForm){
          try{
              String sql = "delete from tb_bookSort where sortNumber='" +
                           bookForm.getSortNumber() + "'";
              con.executeUpdata(sql);
              con.closeConneciton();
              return true;
          }catch(Exception e){
          return false;
          }
      }

/***************************************修改图书类别**************************/
      public boolean UpdateBookSort(BookSortForm tmForm){
          try{
              String sql = "update tb_bookSort set placeName='" +
                           tmForm.getPlaceName() + "',sortName='" +
                           tmForm.getSortName() + "' where sortNumber='" +
                           tmForm.getSortNumber() + "'";
              con.executeUpdata(sql);
              con.closeConneciton();
              return true;
          }catch(Exception e){
          return false;
          }
      }

/***************************自动编号的方法****************************************/
   public String selectMaxIdSort() {
       List list=new ArrayList();
      String sort = null;
      BookSortForm form = null;
      String sql="select * from tb_bookSort where id=(select Max(id) from tb_bookSort)";
      ResultSet rs=con.executeQuery(sql);
      try {
                 while (rs.next()) {
                     form = new BookSortForm();
                     form.setId(Integer.valueOf(rs.getString("id")));
                     form.setPlaceName(rs.getString("placeName"));
                     form.setSortNumber(rs.getString("sortNumber"));
                     form.setSortName(rs.getString("sortName"));
                     list.add(form);
                 }
      } catch (Exception ex) {
          System.out.println("图书类别自动编号出错误咯！！！");
      }
      if (form != null) {
          sort = form.getSortNumber();
      }
      sort = DealwithString.maxNumberString(sort, "S-", 2);
      return sort;
  }

/***********************************条件查询操作*********************************/
     //以图书类别编号为条件查询
  public BookSortForm selectbookSort(BookSortForm form) {
           System.out.println("正在查询中1234...........");
           String sql = "select * from tb_bookSort where sortNumber='"+form.getSortNumber()+"'";
           ResultSet rs = con.executeQuery(sql);
           try {
               while (rs.next()) {
                  form = new BookSortForm();
                  form.setId(Integer.valueOf(rs.getString("id")));
                  form.setPlaceName(rs.getString("placeName"));
                  form.setSortNumber(rs.getString("sortNumber"));
                  form.setSortName(rs.getString("sortName"));

               }
           } catch (SQLException ex) {
               System.out.println("错误4..........");
           }
           con.closeConneciton();
           return form;
      }

  //全部查询分页显示
 public List selectbookSort() {
     System.out.println("正在查询中123...........");
     List list = new ArrayList();
     BookSortForm tmForm=null;
     String sql="select * from tb_bookSort order by id";
     System.out.println("1111111111111111111");
     ResultSet rs=con.executeQuery(sql);
     System.out.println("22222222222222222222");
     try {
         while (rs.next()) {
                  tmForm = new BookSortForm();
                  System.out.println("33333333333333333");
                  tmForm.setId(Integer.valueOf(rs.getString("id")));
                  System.out.println("33333333333333333555555");
                   tmForm.setPlaceName(rs.getString("placeName"));
                  System.out.println("3333333333333333311111");
                 tmForm.setSortNumber(rs.getString("sortNumber"));
                 System.out.println("33333333333333333222222");
                  tmForm.setSortName(rs.getString("sortName"));
                  System.out.println("4444444444444444444");
                  list.add(tmForm);
              }
     } catch (Exception ex) {
         System.out.println("错误1..........");
     }
     con.closeConneciton();
     return list;
   }

   //以图书类别存放架为条件查询
   public BookSortForm selectBooksortplace(BookSortForm form) {
                        BookSortForm bookForm=null;
                        String sql = "select * from tb_bookSort where placeName='"+form.getPlaceName()+"'";
                        ResultSet rs = con.executeQuery(sql);
                        try {
                           while (rs.next()) {
                             bookForm = new BookSortForm();
                             bookForm.setId(Integer.valueOf(rs.getString("id")));
                             bookForm.setPlaceName(rs.getString("placeName"));
                             bookForm.setSortNumber(rs.getString("sortNumber"));
                             bookForm.setSortName(rs.getString("sortName"));

                             }
                             } catch (SQLException ex) {
                             }
                                  System.out.println(rs);
                             con.closeConneciton();
                                 return bookForm;
             }



}