dbssort.java~13~

一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.

package com.bwm.database;

import java.sql.*;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import com.bwm.model.Ssort;
import com.bwm.core.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */

public class Dbssort extends Ssort {
    private Ssort s=new Ssort();
    public Dbssort() {
    }
    public Dbssort(String sql) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            con = Database.getConnection();
            ps = con.prepareStatement(FinalConstants.SELECT_LINK + sql,
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_READ_ONLY);
            rs = ps.executeQuery();
            if (rs.next()) {
                l.setLid(rs.getInt("lid"));
                l.setName(ParamUtils.getSqlString(rs.getString("name")));
                l.setLtime(ParamUtils.getSqlString(rs.getString("ltime")));
                l.setUrl(ParamUtils.getSqlString(rs.getString("url")));
            }
        } catch (SQLException e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
        } finally {
            System.out.println(ps + " Dblink(String sql) " + l.getLid());
            try {
                if (ps != null) {
                    ps.close();
                    ps = null;
                }
            } catch (SQLException e) {
                ps = null;
            }
            try {
                if (con != null) {
                    con.close();
                    con = null;
                }
            } catch (SQLException e) {
                con = null;
            }
        }
    }
    public int getSid() {
        return s.getSid();
    }
    public void setSid(int sid) {
        s.setSid(sid);
    }
    public String getName() {
        return s.getName();
    }
    public void setName(String name) {
        s.setName(name);
    }
    public String getResume() {
        return s.getResume();
    }
    public void setResume(String resume) {
        s.setResume(resume);
    }
}