📄 formelements.java

📁 企业进销存源码
💻 JAVA
字号:
package com.web.util;
/**
 * @author Lizn
 */
import java.sql.*;
import java.util.Random;
import java.util.StringTokenizer;
import java.math.*;

import com.dao.util.DbConnect;




public class FormElements{	
	
	public static String getDropList(String sqlStr,String ctlName){
		StringBuffer buffer=new StringBuffer("");
		
		Connection conn=null;
		Statement stm=null;
		ResultSet rs=null;
		
		
		try{
			buffer.append("<SELECT NAME=\"" + ctlName + "\">\n");
			
			DbConnect db = new DbConnect();
			conn=db.getConnection();
			stm=conn.createStatement();
			rs=stm.executeQuery(sqlStr);
			
			buffer.append("<OPTION VALUE=\"\" SELECTED>--请选择--</OPTION>\n");				
			
			while(rs.next())
			{
				buffer.append("<OPTION VALUE=\"" + rs.getObject(2) + "\">" + rs.getObject(1) + "</OPTION>\n");				
			}
			

			
			buffer.append("</SELECT>");
						
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			try{
				conn.close();
				rs.close();
				stm.close();
				rs=null;
				stm=null;
				
			}catch(Exception e){
			}	
		}
		
		return buffer.toString();			
	}
	
	public static String getDropList(String sqlStr,String ctlName,String defaultValue){
		StringBuffer buffer=new StringBuffer("");
		
		Connection conn=null;
		Statement stm=null;
		ResultSet rs=null;
	
		try{
			buffer.append("<SELECT NAME=\"" + ctlName + "\">\n");
			
			DbConnect db = new DbConnect();
			conn=db.getConnection();
			stm=conn.createStatement();
			rs=stm.executeQuery(sqlStr);
			
			buffer.append("<OPTION VALUE=\"\">--请选择--</OPTION>\n");				
			
			while(rs.next()){
				String dValue = WebTools.showEx(rs.getObject(2));
				if(dValue.equals(defaultValue)){
					buffer.append("<OPTION VALUE=\"" + dValue + "\" selected>" + rs.getObject(1) + "</OPTION>\n");	
				}else{
					buffer.append("<OPTION VALUE=\"" + dValue + "\">" + rs.getObject(1) + "</OPTION>\n");	
				}
			}

			
			buffer.append("</SELECT>");
						
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			try{
				conn.close();
				rs.close();
				stm.close();
				rs=null;
				stm=null;
				
			}catch(Exception e){
			}	
		}
		
		return buffer.toString();	
	}
	
/**
*Data control
*Usage:
*Please insert following code between <HEAD> and </HEAD>.
*Sample:
*	<HEAD>			
*		<SCRIPT language="javascript" src="../js/DateInput.js" type="text/javascript">
*		</SCRIPT>		
*	</HEAD>	
*@param formName Form name you have named.
*@param ctlName  The control name for submit data.
*@return Date list ctrol string.
*/	


	public static String getDateInput(String formName,String ctrlName){
		
		StringBuffer buffer=new StringBuffer();
		String timeID="time" + Long.toString(System.currentTimeMillis());
		String dateInputID="date" + Long.toString(System.currentTimeMillis());
		
		
		buffer.append("<div id=\"" + timeID + "\" vAlign=\"bottom\">\n");
		buffer.append("<INPUT id=\"" + dateInputID + "\" readOnly name=\"" + ctrlName + "\" size=\"10\" style=\"border: 1 solid #808080\">\n");


		buffer.append("<SCRIPT language=\"javascript\" type=\"text/javascript\">\n");
		buffer.append("new DateInput('" + timeID + "'," + timeID +"," + formName + "." + dateInputID + ",true,'');\n");
		buffer.append("</SCRIPT>\n");
		buffer.append("</div>\n");

	
		return buffer.toString();
	
	}


	public static String getDateInput(String formName,String ctrlName,String image){
		
		IDGenerator idg=null;
		
		try
		{
		
			String format[]=new String[]{"UA5","UA4","N4","AN4"};
			
			idg=new IDGenerator(format,"_");			
			
			
		}catch(Exception ex){
			ex.printStackTrace();

		}		
		
		
		StringBuffer buffer=new StringBuffer();
		String timeID="time" + idg.getID();
		String dateInputID="date" + idg.getID();
		
		/**
		buffer.append("<script language=\"javascript\">\n");	
		buffer.append("init(\"\",\"\"," + formName + ");\n");
		buffer.append("</script>\n");
		buffer.append("<input type=\"text\" name=\"" + ctrlName + "\" size=\"10\" readonly>\n");
		buffer.append("<input type=\"button\" name=\"" + timeID + "\" value=\"展开\"  onclick=\"show_cele_date(" + formName + "," + timeID + "," + ctrlName+ ")\">\n");
        */ 
	
		
		
		buffer.append("<div id=\"" + timeID + "\" vAlign=\"bottom\">\n");
		buffer.append("<INPUT id=\"" + dateInputID + "\" readOnly name=\"" + ctrlName + "\" size=\"10\" style=\"border: 1 solid #808080\">\n");


		buffer.append("<SCRIPT language=\"javascript\" type=\"text/javascript\">\n");
		buffer.append("new DateInput('" + timeID + "'," + timeID +"," + formName + "." + dateInputID + ",true,'" + image + "');\n");
		buffer.append("</SCRIPT>\n");
		buffer.append("</div>\n");

		
			
		return buffer.toString();
	
	}
	


	public static String getDateInput(String formName,String ctrlName,String image,String defaultDate){
		
		IDGenerator idg=null;
		
		try
		{
		
			String format[]=new String[]{"UA5","UA4","N4","AN4"};
			
			idg=new IDGenerator(format,"_");			
			
			
		}catch(Exception ex){
			ex.printStackTrace();

		}		
		
		
		StringBuffer buffer=new StringBuffer();
		String timeID="time" + idg.getID();
		String dateInputID="date" + idg.getID();
		
		
		buffer.append("<div id=\"" + timeID + "\" vAlign=\"bottom\">\n");
		buffer.append("<INPUT id=\"" + dateInputID + "\" readOnly name=\"" + ctrlName + "\" value=\"" + defaultDate  + "\" size=\"10\" style=\"border: 1 solid #808080\">\n");


		buffer.append("<SCRIPT language=\"javascript\" type=\"text/javascript\">\n");
		buffer.append("new DateInput('" + timeID + "'," + timeID +"," + formName + "." + dateInputID + ",true,'" + image + "');\n");
		buffer.append("</SCRIPT>\n");
		buffer.append("</div>\n");

	
		return buffer.toString();
	
	}	
	
	public static String getDropListExt(String sqlStr,String ctlName,String scriptFunctionStr){
		
		Connection conn=null;
		Statement stm=null;
		ResultSet rs=null;
		
		StringBuffer buffer=new StringBuffer("");
		try{
			buffer.append("<SELECT NAME=\"" + ctlName + "\"  " + scriptFunctionStr +  ">\n");
			
			DbConnect db = new DbConnect();
			conn=db.getConnection();
			stm=conn.createStatement();
			rs=stm.executeQuery(sqlStr);
			
			
			buffer.append("<OPTION VALUE=\"\" SELECTED>--请选择--</OPTION>\n");				
			
			while(rs.next())
			{
				buffer.append("<OPTION VALUE=\"" + rs.getObject(2) + "\">" + rs.getObject(1) + "</OPTION>\n");				
			}
			
		
			buffer.append("</SELECT>");
						
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			try{
				conn.close();
				rs.close();
				stm.close();
				rs=null;
				stm=null;
				
			}catch(Exception e){
			}	
		}
		
		return buffer.toString();			
	}
	
	public static String getDropListExt(String sqlStr,String ctlName,String scriptFunctionStr,String defaultValue){
		
		Connection conn=null;
		Statement stm=null;
		ResultSet rs=null;
		
		StringBuffer buffer=new StringBuffer("");
		try{
			buffer.append("<SELECT NAME=\"" + ctlName + "\"  " + scriptFunctionStr +  ">\n");
			
			DbConnect db = new DbConnect();
			conn=db.getConnection();
			stm=conn.createStatement();
			rs=stm.executeQuery(sqlStr);
			
			
			buffer.append("<OPTION VALUE=\"\" SELECTED>--请选择--</OPTION>\n");				
			
			while(rs.next()){
				String dValue = WebTools.showEx(rs.getObject(2));
				System.out.println(dValue +"AAA"+defaultValue);
				if(dValue.equals(defaultValue)){
					buffer.append("<OPTION VALUE=\"" + dValue + "\" selected>" + rs.getObject(1) + "</OPTION>\n");	
				}else{
					buffer.append("<OPTION VALUE=\"" + dValue + "\">" + rs.getObject(1) + "</OPTION>\n");	
				}
			}
			
		
			buffer.append("</SELECT>");
						
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			try{
				conn.close();
				rs.close();
				stm.close();
				rs=null;
				stm=null;
				
			}catch(Exception e){
			}	
		}
		
		return buffer.toString();			
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -