devicedao.java

oa办公管理系统。一些小型的企业办公管理用的系统。一个月废寝忘食的结果。

package com.soft.DAO;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.soft.util.DBConn;
import com.soft.vo.DeviceInfo;

public class DeviceDAO {

	private Connection conn=null;
	private PreparedStatement ps=null;
	private ResultSet rs=null;
	private DBConn db=new DBConn();
	
	public int insertApply(int equipmentid,int applicant,String startdate,int month)
	{
		conn=db.getConnection();
		int i=0;
		try
		{
			if(equipmentid==0)
				return i;
			conn.setAutoCommit(false);
			ps=conn.prepareStatement("insert into applyequipment values("+equipmentid+","+applicant+",to_date('"+startdate+"','yyyy-mm-dd'),add_months(to_date('"+startdate+"','yyyy-mm-dd'),"+month+"),1)");
		    i=ps.executeUpdate();
		    //System.out.println("执行结果为:"+i);
			conn.commit();
		}
		catch(SQLException e)
		{
			try
			{
				if(conn!=null)
					conn.rollback();
			}
			catch(SQLException ex)
			{
				ex.printStackTrace();
			}
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
			}
			catch(SQLException e)
			{
			e.printStackTrace();
			}
		}
		return i;
	}
	
	public int getEquipmentid(String name)
	{
		conn=db.getConnection();
		int i=0;
		try
		{
			conn.setAutoCommit(false);
			ps=conn.prepareStatement("select equipmentid from equipment where equipmentname='"+name+"'");
		    rs=ps.executeQuery();
		    while(rs.next())
		    {
		    	System.out.println("equipmentid的值为在DAO中："+rs.getInt("equipmentid"));
		    	i=rs.getInt("equipmentid");
		    }
			conn.commit();
		}
		catch(SQLException e)
		{
			try
			{
				if(conn!=null)
					conn.rollback();
			}
			catch(SQLException ex)
			{
				ex.printStackTrace();
			}
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(conn!=null)
					conn.close();
				if(ps!=null)
					ps.close();
				if(rs!=null)
				{
					rs.close();
				}
			}
			catch(SQLException e)
			{
			e.printStackTrace();
			}
		}
		return i;
	}
}