Как реализовать поиск по БД?

есть на странице поле для ввода текста и кнопка submit,в поле вводим(например) имя товара ну и должен происходить поиск по имени,и выводить данные о товаре.Как бы реализовать этот поиск,можно какие нибудь примеры приветси?Заранее спасибо

0

да ещё есть 2 класса ,NameAction.java и NameForm.java,где NameForm.java выглядит примерно так:

package com.epam.hwutil.web.request.assign;

import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionMapping;
import com.epam.hwutil.web.BaseForm;

public class FilterNameForm extends BaseForm {

private String Name;

public String getName(){
return Name;
}

public void setName(String Name){
this.Name = Name;
}

public void reset(ActionMapping mapping, HttpServletRequest request){
Name = null;
}

}

ну и в NameAction.java надо реализовать этот поиск...

0

Privet .
Posmotri primer s Listenerom knopki ,tam dlja poiska dannix est pochti vse ..
------------------------------start
ActionListener poisk = new ActionListener() {
public void actionPerformed(ActionEvent e) {
ResultSet rs = null, rs1 = null;
PreparedStatement pstmt = null, pstmt1 = null;
String strSQL, strSQL1, dateString1, dateString2, queryPart = "",
queryPart1 = "";

int DistNum = 0, rCount = 0, qa2500 = 0, qa5000 = 0, qa10000 = 0, m2500 = 0, m5000 = 0, m10000 = 0, AllCount = 0;

java.sql.Date dateFrom, dateTo;
java.util.Date uDateFrom, uDateTo;
Vector listData = null;

dateString1 = formatDate( (Date) date1_text.getValue());
dateString2 = formatDate( (Date) date2_text.getValue());
SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
try {
uDateFrom = dateFormat.parse(dateString1);
uDateTo = dateFormat.parse(dateString2);
dateFormat.applyPattern("yyyy-MM-dd");
dateString1 = dateFormat.format(uDateFrom);
dateString2 = dateFormat.format(uDateTo);
}
catch (Exception eX) {
eX.printStackTrace();
}
dateFrom = java.sql.Date.valueOf(dateString1);
dateTo = java.sql.Date.valueOf(dateString2);

if (!yndhanur1.isSelected()) {
DistNum = firmList3.getSelectedIndex() + 1;
}

a1text.setText(Integer.toString(getCardC ount("A1-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));
a2text.setText(Integer.toString(getCardC ount("A2-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));
b1text.setText(Integer.toString(getCardC ount("B1-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));
b2text.setText(Integer.toString(getCardC ount("B2-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));
c1text.setText(Integer.toString(getCardC ount("C1-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));
c2text.setText(Integer.toString(getCardC ount("C2-", dateFrom, dateTo, DistNum, yndhanur1.isSelected())));

firmList4.setListData(loadBernagirList(d ateFrom, dateTo, DistNum, yndhanur1.isSelected()));
verahskum_panel.xMyTableModel.getDataFro mDB(dateFrom, dateTo, DistNum, yndhanur1.isSelected());
verahskum_panel.validate();
verahskum_panel.repaint();
}
public int getCardCount(String CodePart, java.sql.Date StartDate, java.sql.Date EndDate, int FirmID, boolean Yndhanur) {
int rCount = 0;
ResultSet rs = null;
PreparedStatement pstmt = null;
String DistNum, strSQL, queryPart = "";
if (!Yndhanur) {
queryPart = " AND anvanum = ?";
}
try {
strSQL = "SELECT COUNT(ser_ham) CARDCOUNT FROM voice1 WHERE ser_ham like ? AND amis1 BETWEEN ? AND ?" + queryPart;
pstmt = con.prepareStatement(strSQL);
pstmt.setString(1, CodePart + ''%'');
pstmt.setDate(2, StartDate);
pstmt.setDate(3, EndDate);
if (!Yndhanur) {
pstmt.setInt(4, FirmID);
}
rs = pstmt.executeQuery();
while (rs.next()) {
rCount = rs.getInt("CARDCOUNT");
}
} catch (SQLException ex) {
rCount = 0;
System.out.println(ex.getMessage());
}
return rCount;
}
public Vector loadBernagirList(java.sql.Date StartDate, java.sql.Date EndDate, int FirmID, boolean Yndhanur) {
String strSQL = "", queryPart = "";
ResultSet rs = null;
PreparedStatement pstmt = null;
Vector listData = null;

if (!Yndhanur) {
queryPart = " AND anvanum = ?";
}
try {
strSQL = "SELECT bernagir_id FROM voice1 WHERE amis1 BETWEEN ? AND ?" + queryPart + " GROUP BY bernagir_id";
pstmt = con.prepareStatemen

0

Est 2 vihoda imet
DAO(DataBasaAccess) class v kotorom vi proizvodite deystviya s BD i peredaete dannie v Action gde potom ih sazhaete v request(session,application) i ispolzuya struts-beans.tld otobrazhaete na stranitse.
U nas v cachestve DAO ispolzuetsa stateless session bean.Eto vtoroy variant