typereaderdao.java~3~

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

package com.dao;

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

public class TypeReaderDao{
    private JDBCConnection con=null;

    public TypeReaderDao() {
     con=new JDBCConnection();
     this.con.createConnection();
    }

//***********************************增加读者类型*******************************
    public boolean insertTypeReader(TypeReaderForm bookForm) {
        System.out.println("开始增加读者类型~~~~~~~~~");
    try{
        String sql = "insert into tb_typeReader values('"+bookForm.getTypeName()+"','"+bookForm.getPrice()+"','"+bookForm.getSaveTime()+"','"+bookForm.getRemark()+"','"+bookForm.getNumber()+"')";
        con.executeQuery(sql);
        System.out.println("增加读者类型信息成功！！！");
        con.closeConneciton();
        return true;
     }catch(Exception e){
    System.out.println("增加读者类型信息失败！！！");
    return false;
     }
   }

   //************************************删除******************************
   public boolean delectTypeReader(TypeReaderForm bookForm) {
       String typeName=bookForm.getTypeName();
   try{
       String sql ="delete from tb_typeReader where typeName='"+typeName+"'";
       con.executeQuery(sql);
       System.out.println("删除读者类型信息成功！！！");
       con.closeConneciton();
       return true;
     }catch(Exception e){
       System.out.println("删除读者类型信息失败！！！");
       return false;
     }
   }

   //******************************修改**************************************
   public void UpdateTypeReader(TypeReaderForm bookForm){
       try{
           String sql = "update tb_typeReader set price='"+bookForm.getPrice()+"',saveTime='"+bookForm.getSaveTime()+"',remark='"+bookForm.getRemark()+"',number='"+bookForm.getNumber()+"' where typeName='"+bookForm.getTypeName()+"'";
           con.executeUpdata(sql);
           System.out.println("修改读者类型信息成功！！！");
           con.closeConneciton();
       }catch(Exception e){
       System.out.println("修改读者类型信息失败！！！");
       }
     }
//***************************************************************************
     //以读者类别信息为条件，查询一组数据
   public TypeReaderForm selectOneTypeReader(TypeReaderForm form) {
     String typeName=form.getTypeName();
     String sql = "select * from tb_typeReader where typeName='"+typeName+"'";
     ResultSet rs = con.executeQuery(sql);
     try {
         while(rs.next()){
         form=new TypeReaderForm();
         form.setTypeName(rs.getString("typeName"));
         form.setPrice(rs.getFloat("price"));
         form.setSaveTime(rs.getString("saveTime"));
         form.setRemark(rs.getString("remark"));
         form.setNumber(Integer.valueOf(rs.getString("number")));
         }
     }catch(Exception ex) {
     }
       return form;
 }

    //查询读者类别的全部信息
   public List selectOneTypeReader() {
    List list=new ArrayList();
    TypeReaderForm typeReaderForm = null;
    String sql = "select * from tb_typeReader";
    ResultSet rs=con.executeQuery(sql);
    try {
        while(rs.next()){
            typeReaderForm = new TypeReaderForm();
            typeReaderForm.setTypeName(rs.getString("typeName"));
            typeReaderForm.setPrice(rs.getFloat("price"));
            typeReaderForm.setSaveTime(rs.getString("saveTime"));
            typeReaderForm.setRemark(rs.getString("remark"));
            typeReaderForm.setNumber(Integer.valueOf(rs.getString("number")));
            list.add(typeReaderForm);
        }
        int number=list.size();
        if(number*13==0){
        number = number*13;
       } else {
      number = number*13 + 1;
       }
      } catch (Exception ex) {}
    return list;
  }



}