/* * Stockupdate.java * * Created on 2005年5月20日, 上午10:48 *//** * * @author  administrator */package com.zh.util;import com.zh.conpool.*;import javax.servlet.*;import javax.servlet.http.*;import com.bwm.string.*;import java.sql.*;import java.io.*;public class Stockupdate {    private String sql;    public Condata con;    public ResultSet rs;    Connection conn;    /** Creates a new instance of Stockupdate */    public Stockupdate() {    }  public void Init(javax.servlet.http.HttpServletRequest req,javax.servlet.http.HttpServletResponse res)throws ServletException,SQLException,IOException{    	PrintWriter out=res.getWriter();    	try{    		conn=con.getConnection();	    	}catch(Exception e){    		e.getMessage();	    	}    	int num=0;    	con=new Condata();    	rs=con.executeQuery(getSql());    	while(rs.next()){    		out.println("<tr align='center'>");    		out.println("<td height='26'>"+rs.getString(2)+"</td>");    		out.println("<td height='26'>"+rs.getDate(3)+"</td>");    		out.println("<td height='26'>"+rs.getString(4)+"</td>");    		out.println("<td height='26'>"+rs.getInt(5)+"</td>");    		out.println("<td height='26'>"+rs.getString(6)+"</td>");    		out.println("</tr>");    	}    	/*    	while(rs.next()){  			num++;  				  		out.println("<tr align='center'>");	    	out.println(	"<td height='26'>"+num+"</td>");	    	out.println(	"<td height='26'>"+rs.getString(2)+"</td>");	    	out.println(	"<td height='26'>"+rs.getDate(3)+"</td>");	    	out.println(	"<td height='26'>"+rs.getString(4)+"</td>");	    	out.println(	"<td height='26'>"+rs.getInt(5)+"</td>");	  		out.println(	"<td height='26'>"+rs.getInt(6)+"</td>");	  		out.println("</tr>");	  		  		}*/  		try{  			conn.close();  			conn=null;    		}catch(Exception e){  			e.getMessage();  		}  		try{  			con.close();  			con=null;  		}catch(Exception e){  			e.getMessage();  		}  		try{  			rs.close();  			rs=null;  		}catch(Exception e){  			e.getMessage();  		}  		  		    }    public String getSql(){    	sql="select * from tb_Stcokadd";    	return sql;    }    public ResultSet getRs(){    	try{    		con.getConnection();    	}catch(Exception e){    		e.getMessage();    	}    	con=new Condata();	    	try{    		rs=con.executeQuery(getSql());	    	}catch(Exception e){    		e.getMessage();    	}    	return rs;    }    public void Close(){    	try{    		conn.close();    		conn=null;    	}catch(Exception e){    		e.getMessage();    	}    	try{    		con.close();    		con=null;    	}catch(Exception e){    		e.getMessage();    	}    }}