resourcedao.java

基于jsp的固定资产管理系统,自己做的

package DAO;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ResourceDAO {

	
	//查找num号码是否可用，可用返回b=true，不可用返回false
	public boolean queryResource(String num)
	{
		boolean b=false;
		String sql="select state from resource_2 where num=?";
		ConnectTo conto=new ConnectTo();
		Connection conn=conto.connect();
		PreparedStatement pstm=null;
		if(conn!=null)
		{
			try{
				pstm=conn.prepareStatement(sql);
				pstm.setString(1,num);
				ResultSet rs=pstm.executeQuery();
				if(rs.next())
				{
					int state=rs.getInt("state");
					if(state==0)
					{
						b=true;
					}
				}
			}
			catch(Exception e)
			{
				e.printStackTrace();
				try
				{
					pstm.close();
					conn.close();
				}
				catch(Exception e1)
				{
					e1.printStackTrace();
				}
			}
		}
		return b;
	}
	
	
	//设置号码被卖出,成功返回k>0,失败k=-1
	public int setResourceState(String num)
	{
		int k=-1;
		String sql="update resource_2 set state=? where num=?";
		ConnectTo conto=new ConnectTo();
		Connection conn=conto.connect();
		PreparedStatement pstm=null;
		if(conn!=null)
		{
			try{
			pstm=conn.prepareStatement(sql);
			pstm.setInt(1,1);
			pstm.setString(2, num);
			k=pstm.executeUpdate();
			pstm.close();
			conn.close();
			}
			catch(Exception e)
			{
				e.printStackTrace();
				try
				{
					pstm.close();
					conn.close();
					return k;
				}catch(Exception e1){e1.printStackTrace();}
			}
			
		}
		return k;
	}
	
	
	
	public int insertResource(String start,String end,String type)
	{
		int k=-1;
		String sql="insert into resource_2 values(?,?,?)";
		ConnectTo conto=new ConnectTo();
		Connection conn=conto.connect();
		PreparedStatement pstm=null;
		String num=null;
		if(conn!=null)
		{
			try{
				//start=start.substring(3);
				//end=end.substring(3);
				long startnum=Long.parseLong(start);
				long endnum=Long.parseLong(end);
				for(long i=startnum;i<=endnum;i++)
				{
					/*
					if(i<10)
					{
					num="0000000"+i;
					}
					else if(i<100)
					{
					num="000000"+i;
					}
					else if(i<1000)
					{
						num="00000"+i;
					}
					else if(i<10000)
					{
						num="0000"+i;
					}
					else if(i<100000)
					{
						num="000"+i;
					}
					else if(i<1000000)
					{
						num="00"+i;
					}
					else if(i<10000000)
					{
						num="0"+i;
					}
					else if(i<100000000)
					{
						num=""+i;
					}
					 */
					pstm=conn.prepareStatement(sql);
					num=""+i;
					pstm.setString(1,num);
					pstm.setString(2,type);
					pstm.setInt(3,0);
					k=pstm.executeUpdate();
					pstm.close();
				}
				conn.close();

			}
			catch(Exception e)
			{
				e.printStackTrace();
				try
				{
					pstm.close();
					conn.close();
					k=-1;
					return k;
				}catch(Exception e1){e1.printStackTrace();}
			}
			
		}
		return k;
	}
}