Java

5-Jul-12 19:10

There is no way to do this - you will have to use JDialog.
Maximize and minimize are 2 functions that are literally combined.

Another approach would be to make the JFrame undecorated(true) and to draw some buttons yourself (and a title bar if you need a real title bar).

regards Torsten
When I'm not working

java database

Member 82109845-Jul-12 5:17

Member 8210984

5-Jul-12 5:17

can i know how to the excel files can be imported into sql database by using java codes..

thank u

u.vinothh@gmail.com

Re: java database

jschell5-Jul-12 6:20

jschell

5-Jul-12 6:20

What does "imported" mean?

Do you want to store the excel file itself into the database?
Or do you want to read the data from the excel file and then store that into columns in the database?

For the first option read the file in binary (bytes, not String/char) and then stream it via JDBC.

For the second, easiest is don't use java. Store the excel file as CSV then use the import features of the database to load it.

Provider

JimAce5-Jul-12 0:53

JimAce

5-Jul-12 0:53

I have a project with Java Eclipse for android which stores data in SQLLite. My issue comes in when I include 100 lines of INSERT, it prompts me the EXCEEDED 65535 bytes.

Is it possible to place 2 "provider android:name=" in manifest then create 2 sets of the ContentProvider then make the second provider run like a continuation of the first set?

Hope you can help me. This is my first project with android. Thank you.

Re: Provider

TorstenH.5-Jul-12 1:19

5-Jul-12 1:19

false approach.
Why do you insert 100 rows into the database at once? what is that? can't you narrow that down?

you should limit the data - paging could also be a solution.

regards Torsten
When I'm not working

Re: Provider

JimAce5-Jul-12 4:12

JimAce

5-Jul-12 4:12

What my objective is to update the database if there is a new version. Normally 1 category contains between 50 to 100 records which I hardcode in ContentProvider. Since I was getting the exceeded 65535 error, I had to split the insert to 2 classes however I am not sure how. Should I place 2 Provider android:name in Manifest? I am lost.

However, if there are any better options I am open to it since I am very new to Java Eclipse.

Thank you.

Elegant validation?

Neo101014-Jul-12 4:33

Neo10101

4-Jul-12 4:33

Given the following code:

XML

private String name;
private List<String> years;
private List<String> studyChoices;

    private void doCheck() {
        if (!name.isEmpty() || name == null) {

        }
        for (String year : years) {
            if (!year.isEmpty() || year == null) {

            }
        }
        for (String studyChoice : studyChoices) {
            if (!studyChoice.isEmpty() || studyChoice == null){

            }
        }
    }

How do I condense this code into a more elegant and OO solution? Maybe put it all in one list and check for each item in that list?

I would like something like:

'If any of these parameters were not passed in or if they are empty, output an error message, else give the desired output'.

Basically I have to write a Servlet that gets form parameters from the request and checks if all parameters were provided. If they were, it is then supposed to write an output page.

Any ideas?

Thanks

Re: Elegant validation?

Richard MacCutchan4-Jul-12 5:06

4-Jul-12 5:06

First thing is that all your tests are the wrong way round (and logically wrong I suspect), you should check the variable is not null before using it as a reference to a method thus:

Java

if (name == null || name.isEmpty()) {
// or maybe you really mean
if (name != null && !name.isEmpty()) {

I am not sure how you would condense the two loops any more as they appear to be independent of each other.

Re: Elegant validation?

TorstenH.4-Jul-12 22:46

location-awareness simulation project

4-Jul-12 22:46

Is this entered from a GUI or is this object coming from some API?

For a GUI you can also use a GUI sided validation. You can e.g. use a KeyListener and validate the entered value right away.

For an API side validation I would suggest a Validation Layer which has to be passed before the data is used.

Your code - as Richard already stated - is a bit mixed up. Here is a valid suggestion:

private void doCheck() {
   if (name != null && name != "") { // always check first for null
      for (String year : years) { // years only need to be checked when name was ok
         if (year != null && year != "" ) {
            try{
                int i = Integer.parseInt(year);
                // you can check if the number has a valid value here 
                // (e.g. between 1900 and 2012 (now-18 for adult check)
            }
            catch(Exception oException){
                /* not a valid number */   
            }
          }
      }
      for (String studyChoice : studyChoices) {
         if (studyChoice!=null && studyChoice != ""){
            /*Check for valid study course here - I suggest an Enum for the fixed range of valid values*/
         }
      }
   }
   else{ /*not even a valid name is given*/ }
}

regards Torsten
When I'm not working

simbarashe gumbo28-Jun-12 3:41

simbarashe gumbo

28-Jun-12 3:41

i am trying to design a simulation with java for my project title location-aware communication to achieve social inclusion and social responsibility which is a telecommunication project which conveys messages to subscribers that are mostly affected or benefited by the piece of information and shows boosters that are necessary to make this possible.

Peter_in_278028-Jun-12 3:48

Peter_in_2780

28-Jun-12 3:48

We believe you. What is the question?

Peter

Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012

TorstenH.28-Jun-12 19:03

28-Jun-12 19:03

Structure - it's all about structure.
No matter if face to face, while working or anywhere else.

Especially when writing some.

regards Torsten
When I'm not working

CodingLover2-Jul-12 15:54

CodingLover

2-Jul-12 15:54

Simulation with Java OMG | :OMG:

If you've never failed... You've never lived...

to open an excel file and write

Paul Conrad2-Jul-12 17:50

Paul Conrad

2-Jul-12 17:50

Is there a question in all that babble somewhere?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

prithaa27-Jun-12 21:50

27-Jun-12 21:50

Hello

Is there an article to open an excel file and write through jxl files.
Every time I try to write into excel file a new file is created instead of opening the old file.

Pritha

Richard MacCutchan27-Jun-12 22:31

27-Jun-12 22:31

prithaa wrote:
Is there an article to open an excel file

Quite possibly, have you tried a Google search?

prithaa wrote:
a new file is created instead of opening the old file.

Without seeing your code I don't think we can guess what you may be doing wrong.

[edit]
This method[^] is probably what you are looking for.
[/edit]

prithaa27-Jun-12 23:05

27-Jun-12 23:05

thanks

but the above link is not opening
my problem was the following

InputStream inp = new FileInputStream("d:/Writefile.xls");    
		WorkbookSettings ws = new WorkbookSettings();
		Workbook wb = Workbook.getWorkbook(inp, ws);
		Sheet sheet = wb.getSheet(0);  
		//Cell cells[] = sheet.getRow(0);     
		//Cell cell = cells[0];
		//String cellContents = cell.getContents(); 
		//Modify the cellContents here     
		//Write the output to a file 		
		Number number;
		number = new Number(0, 0, 453.25, times);
		((WritableSheet) sheet).addCell(number);
		wb.close();

The above code doesnt add the cell to the given file just opens the file.I get DispatchUnCaughtException for the line

((WritableSheet) sheet).addCell(number);

Thanks for the reply

Pritha

Richard MacCutchan27-Jun-12 23:22

27-Jun-12 23:22

Looking at the documentation (this link works for me[^]) it would suggest that you need to create a WritableWorkbook[^] and within that create a WritableSheet[^]. Casting a Sheet to a WritableSheet will not change the underlying object; it is still a (read-only) Sheet.

prithaa27-Jun-12 23:33

27-Jun-12 23:33

thanks Richard

but a

WritableWorkbook creates a new workbook and has no method which opens a workbook

Pritha

Richard MacCutchan28-Jun-12 0:09

28-Jun-12 0:09

This method[^] creates one. May I suggest you go through all the documentation to check which methods are required to create the objects you are trying to work with.

prithaa28-Jun-12 20:21

28-Jun-12 20:21

thanks for the article

but i cant still open a writableworkbook .i can write on a new

workbook

but cant write on an existing workbook
I didnt find any method doing that either in writableworkbook

regards
Pritha

Anil Kumar 2328-Jun-12 22:12

Anil Kumar 23

28-Jun-12 22:12

Check this article ... may be of some help for your purpose
Read and write to excel files in java

Richard MacCutchan28-Jun-12 22:19

28-Jun-12 22:19

prithaa wrote:
thanks for the article

I did not provide one, I wonder what you have been looking at.

prithaa wrote:
but i cant still open a writableworkbook

Did you follow my advice and read all the documentation in the link I gave you? It clearly shows how to create a writeable workbook from an existing file.

prithaa29-Jun-12 0:04