groupname.java

来自「改代码是采用JSP实现的在线办公自动化管理系统」· Java 代码 · 共 49 行

package swing;

import java.sql.*;
import com.zh.conpool.Condata;

public class GroupName{

	private Connection conn=null;
	private ResultSet rs=null;
	private Condata con=new Condata();
	private int Stat_num=0;
	private int nums=0;
	private String names="";
	private String rsSql="";
	private String sql="SELECT Name, SUM(Numbers) Stat_Num, SUM(Money) AS Stat_Mon FROM tb_th_plan WHERE (Name = '";
	private String P_sql="') AND (Planing ='" ;
	private String E_sql="') GROUP BY Name";
	
	public  synchronized int rbNum(String name,int num){
		nums=num;
		names=name;
		rsSql=sql+names+P_sql+num+E_sql;
		try{
			con.getConnection();
			rs=con.executeQuery(rsSql);
			if(rs.next()){
				Stat_num=rs.getInt(2);
			}else{
				Stat_num=0;
			}
		}catch(Exception e){
			System.out.println(e.getStackTrace());
		}
		return Stat_num;
	}
	public void close(){
		try{
				rs.close();
			}catch(Exception e){
			}try{
				conn.close();
			}catch(Exception ee){
				
			}finally{
				con.close();
			}	
	}
}