%@ page import="its.webcommon.*" %>
<%@ page import="its.webcommon.db.*" %>
<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.util.StringTokenizer" %>
<%@ page contentType="text/html; charset=EUC_KR" %>
<%
// get parameter ..........
String _string = Util.eng2ksc(request.getParameter("_string"));
String r_search = Util.eng2ksc(request.getParameter("_search"));
String r_string;
if(r_search == null) {
r_search = " ";
}
if(_string == null){
r_string = " ";
}
r_string = _string;
DBObject DB = new DBObject("jdbc.properties.oracle9");
RecordSet rsPage = null;
RecordSet rsList = null;
String queryPage = new StringBuffer()
.append("select count(*) from freenews").toString();
String queryList = new StringBuffer()
.append("select no,title,writer,ymd,cnt")
.append(" from freenews")
.append(" order by no desc").toString();
try {
rsPage = DB.select(queryPage);
rsList = DB.select(queryList);
}
catch (ServiceException e) {
Log.error("/freenews/list--" + e.toString());
}
rsPage.next();
int total = Util.str2int(rsPage.get(1));
int startNum = obj.getStartNumForward();
int endNum = obj.getEndNumForward();
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd");
Date currentTime_1 = new Date();
String dateString = formatter.format(currentTime_1);
%>