search « Database « Java Database Q&A





1. Storing search criteria in a database    stackoverflow.com

I am working on an enhancement to a Flex dashboard that will allow the users to save searches. I'm using BlazeDS and Java/Spring/SpringJdbc on the server side. My question is this: how ...

2. I need to search for a "customer" in a db, what would be a good design here?    stackoverflow.com

We're a couple of students trying to implement a design to search for customer-information in a database. When the GUI-class is asking for any customer with the surname "Jensen", would a ...

3. Lucene Search Problem    stackoverflow.com

I have built an index on my database rows (Each row as a document) which are of unicode type in MySQL(i.e. Charset: utf8 and Collation: utf8-bin). But When I search any ...

4. Enabling the search engines to index data from web application    stackoverflow.com

I am building a social web application using Java and Cassandra DB. I want some of the data from my database to be visible to search engines. Since my application is ...

5. can Lucene be used to search inside db?    stackoverflow.com

Can we use Lucene to search text stored in DB? I saw this article that shows how to use it for normal articles stored as files http://javatechniques.com/blog/lucene-in-memory-text-search-example/ Can someone suggest?

6. Search mails in database     stackoverflow.com

I want to implement searching of mails in my mail system. I have used simple procedure to search the mails in the database. I want to know the error in the ...

7. Dynamic data storage with search and mapping for java project    stackoverflow.com

I'm looking for good dynamic data storage mainly based on JAVA, or to have ability to be really easy used by JAVA. Main problem in my project is in fast that ...

8. Searching through an access database    bytes.com

I've created a GUI for a hospital visitor system to allow visitors to find patients based on surname. I've also made a table in access with patient names, surnames, date of ...

9. Making the search in database case insensitive    coderanch.com

Thanks for reply but the way you suggested is very costly in terms of performance as I hav to retrive each row from database for converting it into an uniform case. can anyone suggest me another way?? is there any provision in SQL to do the same thing as I am using SELECT * FROM TABLE1 WHERE KEYWORDS LIKE '%keyword%'. thanks ...





10. Database searching    coderanch.com

I need to search a field in DB that contains the word user typped in. However, I was not successful. It returns less records than I expect. The following is my SQL to do the search: psSql = dbConn.prepareStatement( "SELECT id, email " + " FROM user " + "WHERE email like (?) " + " OR email like (?) " ...

11. DB search, order by, and i18n    coderanch.com

Hi Hope somone has done something similar before Let's say you have large table where one of the columns describe a type. Let's say the type is fruit. every fruit type is assigned an integer(apple =1, orange=2) and so on. Assume your application allows to filter and sort on the data in the table, where one of the columns you can ...

12. searching database    coderanch.com

13. search in database    coderanch.com

14. search engine to search both at database and web application level    coderanch.com

Hi , I have tried to use Nutch but it is only web search and does not include any search at database level. And following error appear while using it /**********************************/ Nutch search engine(nutch-0.7.2). After install Nutch and Tomcat, I tried to crawl three url one of them is my web application on jboss. using command as: nutch crawl urls -dir ...

15. How to search a db?    coderanch.com

Here is the JSP page: <%@ page contentType="text/html; charset=iso-8859-1" %> <%@ page import="java.net.*" %>

<% String ID =""; String Name =""; String Salary ="";%>
Search Staff ID: >
Search Staff Name: >
Search Salary:

16. web interface to search database    coderanch.com

Currently I need to implement a web interface for search & enquiry of databases. The senario is there is a page to provide search criterion, the criterion may comes from column A from Table 1, column B from table 2 (all thse tables can be joined). After speicified these criterion, the search result can display fields from various columns of various ...





17. web interface to search database    coderanch.com

Currently I need to implement a web interface for search & enquiry of databases. The senario is there is a page to provide search criterion, the criterion may comes from column A from Table 1, column B from table 2 (all thse tables can be joined). After speicified these criterion, the search result can display fields from various columns of various ...

18. how to search values in database    coderanch.com

Get the values in a particular row using the SELECT query. Check for the value in your code with the values retrieved from DB using the while loop.Simple. If you are aware of the column name which hosts the value of yours, then retrieve only the values stored in that column rather than entire data in the table to reduce the ...

19. Beginner Java Program Help/ txt database search    coderanch.com

Hi all, I am new to java and what I have learned so far I thoroughly enjoy! I am currently stuck on direction for this code I have to write. I am not looking for someone to do the work for me, but I am truly having a problem even getting started. Any help would be awesome! Here are the instructions: ...

23. searching in database    forums.oracle.com

I don't know a lot about working with databases, but I've been given an assignment based on databases and java, so i have a few questions. I hope somebody could just explain the answers to me, so I understand how it works. Basicly, the assignment is to create a sort of spelling checker. You enter a word, and when it turns ...

24. search algorithm for searching values in database    forums.oracle.com

Hi, I have written a database query(in java) for searching values from 10 tables and in some tables there are many columns. my computer is getting very slow when its executing this query and giving the result. Is there any searching algorithm which can reduce the execute time. Thanks and regards, Netai Edited by: netai on Feb 27, 2008 10:00 PM ...

25. Guidance on Binary Search Tree for a Database    forums.oracle.com

Hey everybody. Im trying to use a linked binary search tree to create a student database and just need some help figuring out how I should implement it. The student records (ID, first name, last name, year (sophomore etc.)) are to be stored in an array and will be sorted by student name and student ID. So there will be two ...

26. How to search from database......????????    forums.oracle.com

In those cases you should always use a PreparedStatement and the proper set...() method. Otherwise you are leaving yourself open for a world of pain in the form of an SQL injection attack (since I didn't notice you making any effort before building the SQL statement to ensure that none of the contents of the variables used contained anything that could ...

27. Searching from the database.    forums.oracle.com

28. java and search into the database    forums.oracle.com

Put Java aside, do you know how to do what you need using plain SQL statements? JDBC does only three things with any database: 1 - connects to the desired db engine. 2 - sends an sql statement (query) to it. 3 - recieves the query result(s). I think it is clear. Ahmad Elsafty

29. search db    forums.oracle.com

I have a table table1(column1, column2, column3, column4) I am writing a search program, that will fetch the value from table1. I have 4 textbox. column1tbx, column2tbx, column3tbx. column4tbx. If 1 of the textbox is empty, it will search based on remaining 3 textbox eg. if column2tbx is null. Then hsql is "from table1 where column1=?, column3=?, column4=?" If 2 of ...