softdevelopprocess.java

java版虚拟社区,在mysql上运行.

			String id = new String(mm.GetMes(0));
			stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from login where type='softsell'");
			if(!rs.next())
			{
				System.out.println("No softsell Corp existed");//will not
				mm.SetType("false");
				mm.SetNum(0);
				rs.close();
				stat.close();
				return true;
			}
			else{
				rs.last();
				int num=rs.getRow();
				int i=0;
				rs.beforeFirst();
				mm.SetNum(num*2);
				while(rs.next())
				{
					
					mm.SetMes(rs.getString("name"), i++);
					mm.SetMes(rs.getString("id"), i++);
					
				}
				rs.close();
				stat.close();
				mm.SetType("true");
				System.out.println(id+"SoftDevelopChooseSell success");
				mo.appendmessage(id+" SoftDevelopChooseSell success"+"\n");
				return true;
			}
		}
		catch(SQLException e)
		{
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
	public boolean SoftDevelopCarryOn(MyMessage mm)
	{
		try{
			String id = new String(mm.GetMes(0));
			String cmd=("select * from softdevelop_all_".concat(mm.GetMes(0))).concat(" where softname=?");
			PreparedStatement pstat=conn.prepareStatement(cmd,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			pstat.setString(1,mm.GetMes(1));
			ResultSet rs=pstat.executeQuery();
			if(!rs.next())
			{
				System.out.println ("No such soft existed!");//will not excute
				mm.SetType("false");
				mm.SetNum(0);
				rs.close();
				pstat.close();
				return true;
			}
			else{
				float cost=Float.parseFloat(rs.getString("cost"));
				stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
				ResultSet rss=stat.executeQuery("select * from bank_account where id='"+mm.GetMes(0)+"'");
				if(!rss.next())
				{
					System.out.println(id+" SoftDev Corp has no account");
					mo.appendmessage(id+" SoftDev Corp has no account"+"\n");
					mm.SetType("noaccount");
					mm.SetNum(0);
					rss.close();
					stat.close();
					rs.close();
					pstat.close();
					return true;
				}
				else{
				float account=Float.parseFloat(rss.getString("account"));
				if(account<cost)
				{
					System.out.println(id+" SoftDev funds inadequate");
					mo.appendmessage(id+" SoftDev funds inadequate"+"\n");
					mm.SetType("notenough");
					mm.SetNum(0);
					rss.close();
					stat.close();
					rs.close();
					pstat.close();
					return true;
				}
				else{
					account-=cost;
					rs.updateString("if_done","Y");
					rs.updateRow();
					rss.updateString("account",Float.toString(account));
					rss.updateRow();
					if("Y".equals(rs.getString("if_invested")))
					{
						Statement statOfInvest=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
						Statement statOfInvestLogin=conn.createStatement();
						ResultSet rsOfInvestLogin=statOfInvestLogin.executeQuery("select * from login where type='investcorp' and name='"+rs.getString("investor")+"'");
						rsOfInvestLogin.first();
						ResultSet rsOfInvest=statOfInvest.executeQuery(("select * from investcorp_myinvest_".concat(rsOfInvestLogin.getString("id"))).concat(" where softname='"+mm.GetMes(1)+"'"));
						rsOfInvest.first();
						rsOfInvest.updateString("if_done","Y");
						rsOfInvest.updateRow();
						rsOfInvest.close();
						rsOfInvestLogin.close();
						statOfInvest.close();
						statOfInvestLogin.close();
					}
					rss.close();
					stat.close();
					rs.close();
					pstat.close();
					System.out.println(id+" SoftDevCarryOn success");
					mo.appendmessage(id+" SoftDevCarryOn success"+"\n");
					mm.SetType("true");
					mm.SetNum(0);
					return true;
				}
				}
			}
		}
		catch(SQLException e){
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
		
	public boolean SoftDevelopNew(MyMessage mm)
	{
		
	    try{
	    	String id = new String(mm.GetMes(0));
	    	String cmd="select * from softdevelop_all_".concat(mm.GetMes(0));
			cmd=cmd.concat(" where softname='"+mm.GetMes(1)+"'");
		    PreparedStatement pstat=conn.prepareStatement(cmd,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		    Statement stat1=conn.createStatement();
		    Statement stat2=conn.createStatement();
		    Statement stat3=conn.createStatement();
	    	ResultSet rsOfDevelopLogin=stat1.executeQuery("select * from login where type='softdevelop'");
	    	while(rsOfDevelopLogin.next())
	    	{
	    		ResultSet rsOfDevelop=stat2.executeQuery(("select * from softdevelop_all_".concat(rsOfDevelopLogin.getString("id"))).concat(" where softname='"+mm.GetMes(1)+"'"));
	    		if(rsOfDevelop.next())
	    		{
	    			System.out.println("soft name already exist");
	    			System.out.println(id+" soft name already exist");
					mo.appendmessage(id+" soft name already exist"+"\n");
	    			mm.SetType("samename");
	    			mm.SetNum(0);
	    			rsOfDevelopLogin.close();
	    			rsOfDevelop.close();
	    			pstat.close();
	    			stat1.close();
	    			stat2.close();
	    			stat3.close();
	    			return true;
	    		}
	    	}
	    	ResultSet rsOfBid=stat3.executeQuery("select * from bid where soft_name='"+mm.GetMes(1)+"'");
	        if(rsOfBid.next())
	        {
	        	System.out.println(id+" soft name already exist");
				mo.appendmessage(id+" soft name already exist"+"\n");
    			mm.SetType("samename");
    			mm.SetNum(0);
    			rsOfDevelopLogin.close();
    		    rsOfBid.close();
    			pstat.close();
    			stat1.close();
    			stat2.close();
    			stat3.close();
    			return true;
	        }
	        else{
	    		ResultSet rs=pstat.executeQuery();
		    	rs.moveToInsertRow();
		    	rs.updateString("softname",mm.GetMes(1));
		    	rs.updateString("description",mm.GetMes(2));
		    	rs.updateFloat("cost",Float.parseFloat(mm.GetMes(3)));
		    	rs.updateFloat("retail",Float.parseFloat(mm.GetMes(4)));
		    	rs.updateNull("time");
		    	rs.updateString("if_done","N");
		    	rs.updateInt("ordered",0);
		    	rs.updateInt("sold",0);
		    	rs.updateFloat("profit",0);
		    	rs.updateString("if_invested","N");
		    	rs.updateString("investor","No one");
		    	rs.insertRow();
		    	rs.close();
		    	rsOfDevelopLogin.close();
		    	stat1.close();
		    	stat2.close();
		    	stat3.close();
		    	pstat.close();
		    	mm.SetType("true");
		    	System.out.println(id+" SoftDevelopNew success");
				mo.appendmessage(id+" SoftDevelopNew success"+"\n");
		    	return true;
	        }
	    }
	    catch(SQLException e)
	    {
	    	System.out.println("SQLException!");
	    	e.printStackTrace();
	    }
		return false;
	}

	public boolean SoftDevelopedView(MyMessage mm)
	{
		try{
			String id = new String(mm.GetMes(0));
			String cmd="select * from softdevelop_all_";
			cmd=cmd.concat(mm.GetMes(0));
			PreparedStatement pstat=conn.prepareStatement(cmd);
			ResultSet rs=pstat.executeQuery();
			if(!rs.next())
			{
				mm.SetType("false");
				mm.SetNum(0);
				System.out.println(id+" no project finished");
				mo.appendmessage(id+" no project finished"+"\n");
				rs.close();
				pstat.close();
				return true;
			}
			else{
			rs.last();
			mm.SetNum(rs.getRow()*11);
			rs.beforeFirst();
			int i=0,j=1;
			while(rs.next())
			{
				j=2;
				for(;j<=12;j++,i++)
					if( j==5 || j==6 || j==10)
					{
						mm.SetMes(df.format(rs.getFloat(j)), i);
					}
					else
					{
						mm.SetMes(rs.getString(j), i);
					}
			}	
			rs.close();
			pstat.close();
			mm.SetType("true");
			System.out.println(id+" SoftDevelopedView success");
			mo.appendmessage(id+" SoftDevelopedView success"+"\n");
			return true;
			}
		}
		catch(SQLException e){
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}

}