?? stockupdate.java
字號:
/* * 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(); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -