messfun.java

具有特定功能的登录界面 帐号 name 密码 password 站点 login

/*****************************************************************
                        *  Date:2007-04-27   *
                        *  File:messFun.java *
                        *  Author:jezz       *
*****************************************************************/

package beans;

import java.sql.*;
import java.util.LinkedList;
import java.util.List;


import beans.connDB;
import beans.insert;

public class messFun{
	
	public messFun(){
	}
	//多用户判断登陆验证
        public String checkLogin(String name,String pass,String per){
		
	
	String id=ex_chinese(name);
	String password=	ex_chinese(pass);
	String sql="";
	String fno="";
	fno="aerror";
	connDB db =new connDB();
	if(per.equals("radio1"))
	{
	sql="select * from salesman where name='"+id+"' and password='"+password+"'";
	try{
		ResultSet rs=db.executeQuery(sql);
		if(rs.next())
		fno="ywy";
		else
			fno="error";
		db.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	
	}	
	
		
	else if(per.equals("radio2"))
	 {
	sql="select * from supplier where supplierno='"+id+"' and password='"+password+"'";
	try{
		ResultSet rs=db.executeQuery(sql);
		if(rs.next())
		fno="gys";
		else
			fno="error";
		db.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	
	}	
	 else if(per.equals("radio3"))	
		{
	sql="select * from leader where name='"+id+"' and password='"+password+"'";
	try{
		ResultSet rs=db.executeQuery(sql);
		if(rs.next())
		fno="leader";
		else
			fno="error";
		db.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	
	}
	else if(per.equals("radio4"))	
		{
	sql="select * from master where name='"+id+"' and password='"+password+"'";
	try{
		ResultSet rs=db.executeQuery(sql);
		if(rs.next())
		fno="master";
		else
			fno="error";
		db.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	
	}		
	return fno;	
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	//插入留言
        public boolean addMess(String ip,String email,String sj,String content,String restore,String xm)
	{
		connDB db =new connDB();
		boolean flag=true;
		email=this.filter(email);//过滤
		content=this.filter(content);
		xm=this.filter(xm);
		email=this.ex_chinese(email);
		content=this.ex_chinese(content);
		xm=this.ex_chinese(xm);
		String sql="insert into liuyan_temp(ip,email,sj,content,restore,xm) values('"+ip+"','"+email+"','"+sj+"','"+content+"','"+restore+"','"+xm+"')";
		try{
		db.executeUpdate(sql);
		db.close();
		}
		catch(Exception ex)
		{
			flag=false;
			ex.printStackTrace();
		}
		return flag;
	}
	//添加回复
	public boolean postMess(String id,String restore)
	{
		connDB db=new connDB();
		boolean flag=true;
		restore=this.filter(restore);
		restore=this.ex_chinese(restore);
		String sql="update liuyan_temp set restore='"+restore+"',restore_time='"+this.gettime()+"' where id='"+id+"'";
		try{
			db.executeUpdate(sql);
			db.close();
		}
		catch(Exception ex)
		{
			flag=false;
			ex.printStackTrace();
		}
		return flag;
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	//过滤留言
       	public static String filter(String text){
		if(text != null){
			text = text.replaceAll("<", "&lt;");
			text = text.replaceAll(">", "&gt;");
			
			text = text.replaceAll("\r\n", "\n");
			text = text.replaceAll("\r", "\n");
			text = text.replaceAll("\n", "\r");
			text = text.replaceAll("\r{2,}","\n</p><p>\n");
			text = text.replaceAll("\r","<br />");
		}
		return text;
       }
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	   
	public boolean validLength(String item,int minLen,int maxLen)
	{//判断字符范围
	  if((item.length()>=minLen)&&(item.length()<=maxLen))
	  return true;
	else
		return false;
	  }
	  
	public boolean validNum(String str)
	{
	int i;
	boolean flag=false;
	if(str.length()>0)
	  for(i=0;i<str.length()-1;i++)
	   {
	     if (str.charAt(i)>='0'&&str.charAt(i)<='9')
	     //if(i==str.length()-1)
	       return flag=true;
	    else
	    	return flag=false;
	    	 //break; 
	   }
	   return flag;
	}











 public String gettime() {//生成详细的时间
    String datestr =  "" ;
    try {
    java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:ss") ;
    java.util.Date date = new java.util.Date() ;
    datestr = df.format(new java.util.Date()) ;
    }
    catch (Exception ex) {

    }
    return datestr ;
  }
  
 
 
 
 
 
  
  
   public String getdate() 
   {//生成日期
    String datestr =  "" ;
    try {
    java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd") ;
    java.util.Date date = new java.util.Date() ;
    datestr = df.format(new java.util.Date()) ;
    }
    catch (Exception ex) {

    }
    return datestr ;
  }
 
 
 
 
 
 
  
  
public String ex_chinese(String str)
{//转成中文
     if(str==null){
     str  ="" ;
     }
     else{
         try {
        str = new String(str.getBytes("iso-8859-1"),"utf-8") ;
         }
         catch (Exception ex) {
         }
     }
     return str ;
  }











public ResultSet asearch( String s1,String i1,String m1,String a1,String s2,String i2,String m2,String a2,String s3,String i3,String m3,String a3,String s4,String i4,String m4)
{//生成高级SQL查询语句
String sql1="select * from fitting";

if(i1!="")
         {   String ii1 = ex_chinese(i1);
		  if(m1.equals("like")) {	sql1=sql1+" where "+s1+" like '%"+ii1+"%'";}
		  else{  sql1=sql1+" where "+s1+"=  '"+ii1+"'";  }
	    }
	



if(i2!="")
         {   String ii2 = ex_chinese(i2);
            if(a1.equals("and"))
			                      {
								   if(m2.equals("like")){ sql1=sql1+" and "+s2+" like '%"+ii2+"%'"; }
								  else  { sql1=sql1+" and "+s2+"='"+ii2+"'";}
								  
								  }
			
			
			else if(a1.equals("or")) 
			                         {
									 if(m2.equals("like"))  { sql1=sql1+" or "+s2+" like '%"+ii2+"%'";}
								     else {sql1=sql1+" or "+s2+"='"+ii2+"'"; }
									 
			                         }
			else 
			   {
			   if(m2.equals("like"))  { sql1=sql1+" and "+s2+" not like '%"+ii2+"%'";}
			   else {sql1=sql1+" or "+s2+"!='"+ii2+"'"; }
			   }
									 
			}

if(i3!="")	
         {  String ii3 =  ex_chinese(i3);
            if(a2.equals("and"))
			                      {
								   if(m3.equals("like")){ sql1=sql1+" and "+s3+" like '%"+ii3+"%'"; }
								  else  { sql1=sql1+" and "+s3+"='"+ii3+"'";}
								  
								  }
			
			
			else if(a2.equals("or")) 
			                         {
									 if(m3.equals("like"))  { sql1=sql1+" or "+s3+" like '%"+ii3+"%'";}
								     else {sql1=sql1+" or "+s3+"='"+ii3+"'"; }
									 
			                         }
			else 
			   {
			   if(m3.equals("like"))  { sql1=sql1+" and "+s3+" not like '%"+ii3+"%'";}
			   else {sql1=sql1+" or "+s3+"!='"+ii3+"'"; }
			   }
			}		
if(i4!="")	
         {         String ii4 =  ex_chinese(i4);
								   if(m4.equals("like")){ sql1=sql1+" and "+s4+" like '%"+ii4+"%'"; }
								  else  { sql1=sql1+" and "+s4+"='"+ii4+"'";}
			}
	connDB db=new connDB();		
	ResultSet rs=db.executeQuery(sql1);
	return rs;
}









public String addfit(String fno,String title,String aparam,String marprice,String ipotime,String warranty,String itype,String ipin,String stype,String spin,String edit,String edtime)
{//增加配件信息
insert db =new insert();
String dtype="";
String dpin="";
if(itype!="")
                       {
					   dtype = ex_chinese(itype);//种类
					   
					   }
					   
					   else
					   
					      {
						  dtype = ex_chinese(stype);//种类 
					      }
if(ipin!="")
                       {
					   dpin = ex_chinese(ipin);//品牌
					   
					   }
					 	
						else
					   
					      {
						  dpin = ex_chinese(spin);//种类 
					      }	
						  
String ti = ex_chinese(title);	
String Con = ex_chinese(aparam);
String mar = ex_chinese(marprice);	
String ipo = ex_chinese(ipotime);
String warr = ex_chinese(warranty);	
String ed = ex_chinese(edit);
String edti = ex_chinese(edtime);	
String re="";
String sql="insert into fitting(fittingno,title,aparam,marprice,ipotime,warranty,type,pin,edit,edtime)  values('"+fno+"','"+ti+"','"+Con+"','"+mar+"','"+ipo+"','"+warr+"','"+dtype+"','"+dpin+"','"+ed+"','"+edti+"') ";	
	
try
{
 db.executeQuery(sql);
 re=fno;
}
catch(Exception e){e.printStackTrace();}
finally{db.close();}
return sql;			  
}











public String addk(String fittingno,String supplierno,String price,String ku)
{
insert db =new insert();
String re="Error";
String id = ex_chinese(fittingno);	
String no = ex_chinese(supplierno);
String pr = ex_chinese(price);
String kk = ex_chinese(ku);
String inn="insert into supplystatus(fittingno,supplierno,stochstatus,stockprice) values('"+id+"','"+no+"','"+kk+"','"+pr+"')";
try
{
 db.executeQuery(inn);
 re="OK";
}