?? worddao.java
字號:
package com.yxq.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.yxq.toolsbean.DB;
import com.yxq.valuebean.PhotoBean;
import com.yxq.valuebean.WordBean;
public class WordDao {
private DB connection = null;
public WordDao() {
connection = new DB();
}
public boolean operationWord(String oper, WordBean single) {
/* 生成SQL語句 */
String sql = null;
if (oper.equals("add")) //發表留言
sql = "insert into tb_word values('"+single.getWordTitle()+"','"+single.getWordContent()+"','"+single.getWordTime()+"','"+single.getWordAuthor()+"')";
if (oper.equals("delete")) //刪除留言
sql = "delete from tb_word where id=" + single.getId();
/* 執行SQL語句 */
boolean flag =connection.executeUpdate(sql);
return flag;
}
public List queryWord(String type){
String sql="";
if(type==null||type.equals(""))
type="sub";
if(type.equals("all"))
sql="select * from tb_word order by word_sdTime DESC";
else
sql="select top 5 * from tb_word order by word_sdTime DESC";
List wordlist = null;
WordBean wordBean = null;
ResultSet rs = connection.executeQuery(sql);
if(rs!=null){
wordlist=new ArrayList();
try {
while (rs.next()) {
wordBean = new WordBean();
wordBean.setId(rs.getInt(1));
wordBean.setWordTitle(rs.getString(2));
wordBean.setWordContent(rs.getString(3));
wordBean.setWordTime(rs.getString(4));
wordBean.setWordAuthor(rs.getString(5));
wordlist.add(wordBean);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return wordlist;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -