softdevelopprocess.java

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

package serverpack;

import java.sql.*;
import java.text.DecimalFormat;

public class SoftDevelopProcess {
	private Connection conn;
	private Statement stat;
	private Monitor mo;
	private DecimalFormat df;
	
	public SoftDevelopProcess(Connection c,Monitor m){conn = c;mo = m;df = new DecimalFormat("#,###,###,###.00");}
	
	public boolean SoftDevelopFinanceView(MyMessage mm)
	{
		try{
			String id = new String(mm.GetMes(0));
		    String cmd="select * from softdevelop_all_".concat(mm.GetMes(0));
			PreparedStatement pstat=conn.prepareStatement(cmd);
			ResultSet rs=pstat.executeQuery();
			float soldall=0;
			float costall=0;
			float invest_amount=0;
			while(rs.next())
			{
				soldall+=rs.getInt("sold")*rs.getFloat("retail");
				if("N".equals(rs.getString("if_done")))
				{
				}
				else
				{costall+=rs.getFloat("cost");}
				if("N".equals(rs.getString("if_invested")))
				{
				}
				else{invest_amount+=rs.getFloat("cost");}
			}
			mm.SetNum(4);
			mm.SetType("true");
			mm.SetMes(df.format(soldall), 0);
			mm.SetMes(df.format(costall), 1);
			mm.SetMes(df.format(invest_amount), 2);
			mm.SetMes(df.format(soldall*0.4), 3);
			System.out.println(id+" SoftDevelopFinanceView success");
			mo.appendmessage(id+" SoftDevelopFinanceView success"+"\n");
			rs.close();
			pstat.close();
			return true;
		}
		catch(SQLException e)
		{
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
	public boolean SoftDevelopFeedbackView(MyMessage mm)
	{
		try
		{
			String id = new String(mm.GetMes(0));
			int count=0;
			stat=conn.createStatement();
			Statement stat2=conn.createStatement();
			Statement stat3=conn.createStatement();
			ResultSet rsOfLogin=stat.executeQuery("select * from login where type='softsell'");
			if(!rsOfLogin.next())
			{
				System.out.println("there is no soft sell company!");//will not
				mm.SetType("false");//no sell corp
				mm.SetNum(0);
				rsOfLogin.close();
				stat.close();
				stat2.close();
				stat3.close();
				return true;
			}
			else
			{
				do
				{
					ResultSet rsOfFeedback=stat2.executeQuery(("select * from softsell_feedback_".concat(rsOfLogin.getString("id"))).concat(" where develop_id='"+mm.GetMes(0)+"'"));
					while(rsOfFeedback.next())
					{
						mm.SetMes(rsOfFeedback.getString("softname"), count++);
						mm.SetMes(rsOfFeedback.getString("feedback"),count++);
						mm.SetMes(rsOfFeedback.getString("customer_name"),count++);
					}
					rsOfFeedback.close();
				}while(rsOfLogin.next());
				mm.SetNum(count);
				if(count==0)
				{
					System.out.println(id+" no feedback information");
					mo.appendmessage(id+" no feedback information"+"\n");
					mm.SetType("false");//No feedback for this softdevelop company
					mm.SetNum(0);
					rsOfLogin.close();
					stat.close();
					stat2.close();
					stat3.close();
					return true;
				}
				else
				{
					System.out.println(id+" SoftDevelopFeedbackView success");
					mo.appendmessage(id+" SoftDevelopFeedbackView success"+"\n");
					mm.SetType("true");
					mm.SetNum(count);
					rsOfLogin.close();
					stat.close();
					stat2.close();
					stat3.close();
					return true;
				}
			}

		}
		catch(SQLException e){
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
	public boolean SoftDevelopBid(MyMessage mm)
	{
		try
		{
			String id = new String(mm.GetMes(0));
			stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			ResultSet rs=stat.executeQuery("select * from bid where if_got ='Y'" +
					"AND soft_name ='"+mm.GetMes(1)+"'");
			if(rs.next())
			{
				System.out.println(id+" project has already been got by other");
				mo.appendmessage(id+" project has already been got by other"+"\n");
				mm.SetType("alreadygot");
				mm.SetNum(0);
				rs.close();
				stat.close();
				return true;
			}
			rs=stat.executeQuery("select * from bider where bider_id ='"+mm.GetMes(0)+"'" +
					"AND softname ='"+mm.GetMes(1)+"'");
			Statement stat1=conn.createStatement();
			if(rs.next())
			{
				System.out.println(id+" have already joined the biding");
				mo.appendmessage(id+" have already joined the biding"+"\n");
				mm.SetType("alreadybid");
				mm.SetNum(0);
				rs.close();
				stat.close();
				stat1.close();
				return true;
			}
			else{
				rs.moveToInsertRow();
				rs.updateString("softname",mm.GetMes(1));
				rs.updateString("bider_id",mm.GetMes(0));
				ResultSet temp=stat1.executeQuery("select name from login where id='"+mm.GetMes(0)+"'");
				temp.next();
				rs.updateString("bider_name",temp.getString("name"));
				rs.insertRow();
				temp.close();
				rs.close();
				stat1.close();
				stat.close();
				mm.SetType("true");
				mm.SetNum(0);
				System.out.println(id+" joind bid success");
				mo.appendmessage(id+" joind bid success"+"\n");
				return true;
			}
		}
		catch(SQLException e)
		{
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
	public boolean SoftDevelopOrder(MyMessage mm)
	{
		String cmd="select * from softdevelop_all_";
		cmd=cmd.concat(mm.GetMes(0));
		cmd=cmd.concat(" where softname=?");
		
		try{
			String id = new String(mm.GetMes(0));
			PreparedStatement pstat=conn.prepareStatement(cmd,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			pstat.setString(1,mm.GetMes(1));
			ResultSet rs=pstat.executeQuery();
			stat=conn.createStatement();
			if(!rs.next())
			{
				System.out.println(id+" no soft can be order");
				mo.appendmessage(id+" no soft can be order"+"\n");
				mm.SetType("false");
				mm.SetNum(0);
				rs.close();
				pstat.close();
				return true;
			}
			else{
				int num=0;
				num=Integer.parseInt(rs.getString("ordered"))+Integer.parseInt(mm.GetMes(3));
				rs.updateInt("ordered",num);
				rs.updateRow();
				String cmd2="select * from softsell_all_".concat(mm.GetMes(2));
				cmd2=cmd2.concat(" where softname=?");
				pstat=conn.prepareStatement(cmd2,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
				pstat.setString(1,mm.GetMes(1));
				ResultSet rss=pstat.executeQuery();// connect to softsell companies
				if(!rss.next())
				{
					rss.moveToInsertRow();
					rss.updateString("softname",mm.GetMes(1));
					rss.updateString("description", rs.getString("description"));
					rss.updateFloat("retail",Float.parseFloat(rs.getString("retail")));
					rss.updateInt("stored",Integer.parseInt(mm.GetMes(3)));
					rss.updateInt("sold",0);
					rss.updateString("develop_id",mm.GetMes(0));
					ResultSet temp=stat.executeQuery("select name from login where id='"+mm.GetMes(0)+"'");
					temp.next();
					rss.updateString("develop_name",temp.getString("name"));
					rss.insertRow();
					temp.close();
					rss.close();
					rs.close();
					pstat.close();
					mm.SetType("true");
					mm.SetNum(0);
					System.out.println(id+" new soft order success");
					mo.appendmessage(id+" new soft order success"+"\n");
					return true;
				}
				else
				{
					num=Integer.parseInt(rss.getString("stored"))+Integer.parseInt(mm.GetMes(3));
					rss.updateInt("stored",num);
					rss.updateRow();
					rs.close();
					rss.close();
					pstat.close();
					mm.SetType("true");
					mm.SetNum(0);
					System.out.println(id+" new soft order success");
					mo.appendmessage(id+" new soft order success"+"\n");
					return true;
				}
			}
		}
		catch(SQLException e)
		{
			System.out.println("SQLException!");
			e.printStackTrace();
		}
		return false;
	}
	public boolean SoftDevelopChooseSell(MyMessage mm)
	{
		
		try{