sqlresult.java

这是和jspcourseware相对应的案例。希望大家通过这个案例的学习能够系统的掌握jsp编程的思想。

/*
 * SqlResult.java
 *
 * Created on 2007年3月26日, 上午9:38
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package util;
import java.sql.*;
/**
 *
 * @author hyl
 */
public class SqlResult {
    
    private Connection con;
    private String sql;
    /** Creates a new instance of SqlResult */
    
    public SqlResult(Connection con,String sql) {
        this.con = con;
        this.sql = sql;
    }
    
    public String toString(){
        
        StringBuffer sb = new StringBuffer();
        try{
            Statement statement = con.createStatement();
            if(statement.execute(sql)){
                ResultSet rs = statement.getResultSet();
                ResultSetMetaData md = rs.getMetaData();
                int colCont = md.getColumnCount();
                sb.append("<table cellspacing = 10><tr>");
                for(int i = 1;i <= colCont;i++){
                    sb.append("<th>"+md.getColumnLabel(i));
                }
                while (rs.next()){
                    sb.append("<tr>");
                    for(int j = 1; j<= colCont;j++){
                        sb.append("<td>");
                        Object obj = rs.getObject(j);
                        
                        if(obj != null)
                            sb.append(obj.toString());
                        else
                            sb.append("&nbsp");
                        sb.append("</td>");
                    }
                    sb.append("</tr>");
                }
                sb.append("</tr>");
                sb.append("<table>\n");
            }else{
                sb.append("<b>Update Count:</b>" + statement.getUpdateCount());
            }
        }catch(SQLException e){
            sb.append("</table><h1>SQL Exception Error:</h1>"+e.getMessage());
        }
        return sb.toString();
    }
    
}