package goodSearch;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
/**
 * @author snoomy
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class GoodSimilar {

	public ArrayList Search(String goodname, String type) {
		ArrayList temp = new ArrayList();
		try {
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			String url = "jdbc:oracle:thin:@146.200.51.54:1521:userinfo";
			String search =
				"select * from goodinfo where NAME like ? and type like ?";
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection jbc = DriverManager.getConnection(url, "sa", "sa");
			PreparedStatement ps;
			ps = jbc.prepareStatement(search);
			ps.setString(1, "%"+goodname+"%");
			ps.setString(2, "%"+type+"%");
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				temp.add(
					new GoodInfo(
						rs.getString("GOODID"),
						rs.getString("TYPE"),
						rs.getString("NAME")));

			}
			ps.close();
			jbc.close();
		} catch (Exception e) {
		}

		return temp;
	}
}