?? linkdaoimpl.java~2~
字號(hào):
package com.victor.dao;
import java.util.List;
import java.util.Arrays;
import com.victor.tool.JDBConnection;
import com.victor.domain.LinkActionForm;
import java.sql.ResultSet;
import java.sql.*;
import java.util.ArrayList;
public class LinkDaoImpl
implements LinkDao {
//對(duì)鏈接的全部查找
public List linkSelect() {
List list = new ArrayList();
JDBConnection connection = new JDBConnection();
LinkActionForm linkActionForm = null;
String sql = "select * from tb_Link";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
linkActionForm = new LinkActionForm();
linkActionForm.setLinkID(Integer.valueOf(rs.getString(1)));
linkActionForm.setLinkPicture(rs.getString(2));
linkActionForm.setLinkName(rs.getString(3));
linkActionForm.setLinkAddress(rs.getString(4));
linkActionForm.setLinkIssueDate(rs.getString(5));
list.add(linkActionForm);
}
}
catch (SQLException ex) {
}
connection.close();
return list;
}
//刪除鏈接
public void linkDelete(LinkActionForm linkActionForm) {
JDBConnection connection = new JDBConnection();
String sql="delete from tb_Link where ID='"+linkActionForm.getLinkID()+"'";
connection.executeUpdate(sql);
connection.close();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -