?? linknews.java
字號:
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select newsId,headTitle,DATE_FORMAT(newsTime,'%Y-%m-%d') as time from news where state=1 and kindId=? order by newsTime desc limit 0,6;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,kindId);
rs=sdbo.executeQuery();
try{
while(rs.next()){
NEWSTable tableNews = new NEWSTable();
tableNews.setNewsId(rs.getInt("newsId"));
tableNews.setHeadTitle(rs.getString("headTitle"));
tableNews.setNewsTime(rs.getString("time"));
vector.add(tableNews);
}
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return vector.iterator();
}
/**
* 熱門文章
*/
public Iterator hotNewsClass(int classId){
Vector vector = new Vector();
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select newsId,headTitle from news where state=1 and classId=? order by hits desc limit 0,8;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,classId);
rs=sdbo.executeQuery();
try{
while(rs.next()){
NEWSTable tableNews = new NEWSTable();
tableNews.setNewsId(rs.getInt("newsId"));
tableNews.setHeadTitle(rs.getString("headTitle"));
vector.add(tableNews);
}
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return vector.iterator();
}
/**
****************************************
* newsII的操作
* newsII的具體列表
*/
/**
* 新聞總數(shù)
*/
public int sumNews(int kindId){
int sum=0;
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select count(newsId) as total from news where state=1 and kindId=?;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,kindId);
rs=sdbo.executeQuery();
try{
rs.next();
sum=rs.getInt("total");
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return sum;
}
/**
* 列出具體的新聞
*/
public Iterator listNews(int kindId){
Vector vector = new Vector();
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select newsId,headTitle,DATE_FORMAT(newsTime,'%Y-%m-%d') as time from news where state=1 and kindId=? order by newsTime desc;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,kindId);
rs=sdbo.executeQuery();
try{
while(rs.next()){
NEWSTable tableNews = new NEWSTable();
tableNews.setNewsId(rs.getInt("newsId"));
tableNews.setHeadTitle(rs.getString("headTitle"));
tableNews.setNewsTime(rs.getString("time"));
vector.add(tableNews);
}
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return vector.iterator();
}
/**
* 某個(gè)類別的熱門文章
*/
public Iterator hotNewsKind(int kindId){
Vector vector = new Vector();
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select newsId,headTitle from news where kindId=? order by hits desc limit 0,6;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,kindId);
rs=sdbo.executeQuery();
try{
while(rs.next()){
NEWSTable tableNews = new NEWSTable();
tableNews.setNewsId(rs.getInt("newsId"));
tableNews.setHeadTitle(rs.getString("headTitle"));
vector.add(tableNews);
}
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return vector.iterator();
}
/**
* 類別的名字
*/
public String strKind(int kindId){
String strKind=null;
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select content from newskind where kindId=?;";
try{
sdbo.prepareStatement(strSql);
sdbo.setInt(1,kindId);
rs=sdbo.executeQuery();
try{
rs.next();
strKind=rs.getString("content");
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return strKind;
}
/**
* 最近更新的時(shí)間
*/
public String nearTime(int kindId){
String strTime=null;
if (sdbo==null)
sdbo = SQLDBOperator.getInstance("Connection");
ResultSet rs=null;
String strSql = "select DATE_FORMAT(newsTime,'%Y年%c月%e日 %k時(shí)%i分%S秒') as time from news where kindId='"+kindId+"' order by newsTime limit 0,1;";
try{
//sdbo.prepareStatement(strSql);
// sdbo.setInt(1,kindId);
rs=sdbo.executeQuery(strSql);
try{
rs.next();
strTime=rs.getString("time");
rs.close();
}
catch(NullPointerException nullE){
System.out.print("NewsShow sumNews() " +nullE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
}
}
catch(SQLException sqlE){
System.out.print("NewsShow sumNews() " +sqlE.getMessage());
Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
}
finally{
sdbo.Close();
}
return strTime;
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -