Fetch values from database and store it in array

13,262

8TB

Hi,

I am doing send some values(signup form::firstname,lastname,title,organization)
to mail id using javamail at the same time it should store in database, my problem is how to fetch values from database and store it in array.

I need urgently ,Please help me.

thanks in advance.

You can connect to a database using JDBC. Do you know anything about it?

Aug 22 '07 #2

dmjpro

2,476

2GB

You can connect to a database using JDBC. Do you know anything about it?

Post the Code so far you did.
Then experts are here to solve your problem.
And remember, while you posting the code then don't forget to use Code Tag.
Please read the guidelines before Posting.
OK.

Best of luck with your try.

Kind regards,
Dmjpro.

Aug 22 '07 #3

Hi,
I post the code here,

Expand|Select|Wrap|Line Numbers

 
import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import java.sql.*;

import javax.mail.*;

import javax.mail.internet.*;

import javax.mail.event.*;

import java.net.*;

import java.util.*;
 
public class mail3 extends HttpServlet
 
{

    public  void doGet(HttpServletRequest request,HttpServletResponse response)  throws ServletException, IOException

    {
 
        PrintWriter out=response.getWriter();

        response.setContentType("text/html");

try

{

           Properties props=new Properties();

           props.put("mail.smtp.host","mail.cygnussoftwares.com");

           Session session =  Session.getDefaultInstance(props,null);

           String fname = request.getParameter("firstname");

           String lname = request.getParameter("lastname");

           String tit = request.getParameter("Title");

           String org = request.getParameter("organization");

           String add1 = request.getParameter("Address1");

           String add2 = request.getParameter("address2");

           String city = request.getParameter("city");

           String state = request.getParameter("state");

           String country = request.getParameter("country");

           String organizationSize= request.getParameter("turnover");

           String phone= request.getParameter("phone");

           String email= request.getParameter("emailid");

           String product= request.getParameter("product");
 
           //String recipients= "devteam@yahoo.com" 
 
           //={"devteam@yahoo.com","sathya@gmail.com","pnithya@yahoo.co.in"}; 
 
           String k=fname+lname+tit+org+add1+add2+city+state+country+organizationSize+product+phone+email;

           String subject="Product Inquiry Form";
 
            String FirstName="FirstName:";

            String LastName="LastName:";

            String Title="Title:";

            String Organization="Organization:";

            String Address1="Address1:";

            String Address2="Address2:";

            String City="City:";

            String State="State:";

            String Country="Country:";

            String OrganizationSize="OrganizationSize:";

            String Phone="Phone:";

            String Email="E-Mail:";

            String Product="Product";
 
            //String recipients;
 
           try

        {

    //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

    //Connection cn = DriverManager.getConnection("jdbc:microsoft:sqlserver://CSISERVER2:1433;DatabaseName=web Hosting","sa","sa") ;

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    Connection cn = DriverManager.getConnection("jdbc:odbc:send", " ", " ");

    Statement st = cn.createStatement();

    ResultSet rs = st.executeQuery("select * from send ");
 
    //st.executeUpdate("insert into sendmail values('"+fname+"','"+lname+"','"+tit+"','"+org+"',

'"+add1+"','"+add2+"','"+city+"','"+state+"',

'"+country+"','"+organizationSize+"','"+product+"','"+phone+"','"+email+"')");

    //out.println("Record inserted successfully ........");
 
    String to=""; 
 
   while(rs.next())

   {

   to = rs.getString(1);
 
   }  

   System.out.println("the name is :"+to);
 
   }

   catch(Exception e)

   {

      e.printStackTrace();

   }
 
           MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(to));
 
           /*InternetAddress[] addressTo = new InternetAddress[recipients.length]; 

           for (int i = 0; i < recipients.length; i++)

           {

           addressTo[i] = new InternetAddress(recipients[i]);

           }

           message.setRecipients(Message.RecipientType.TO, addressTo);*/
 
            //message.setFrom(new InternetAddress(from));
 
            if(subject!=null)

            {

            message.setSubject(subject);

            }

            else

            {

            message.setSubject("");

            }
 
            if (k!=null)

            {

            message.setContent("<html><body ><table border=1><tr><td>"+FirstName+"</td><td>"+fname+"</td></tr>

<tr><td>"+LastName+"</td><td>"+lname+"</td></tr><tr><td>"+Title+"</td><td>

"+tit+"</td></tr><tr><td>"+Organization+"</td>

<td>"+org+"</td></tr><tr><td>"+Address1+"</td>

<td>"+add1+"</td></tr><tr><td>"+Address2+"</td>

<td>"+add2+

            "</td></tr><tr><td>"+City+"</td>

<td>"+city+"</td></tr><tr><td>"+State+"</td>

<td>"+state+"</td></tr><tr><td>"+Country+"</td>

<td>"+country+"</td></tr><tr><td>"+OrganizationSize+"</td>

<td>"+organizationSize+ "</td></tr><tr><td>"+Product+"</td><td>"+product+"</td></tr>

<tr><td>"+Phone+"</td><td>"+phone+"</td></tr><tr>

<td>"+Email+"</td><td>"+email+"</td></tr></table>

</body></html>","text/HTML");

            }

            else

            {

            message.setContent("","text/HTML");

            }
 
            Transport.send(message);

            //out.println("The Mail has been sent");

            response.sendRedirect("../signUp/success.html");

        }

        catch (Exception e)

        {

            out.println("ERROR....."+e);

             System.out.println("ERROR....."+e);

        }
 
}

}

Aug 22 '07 #4

13,262

8TB

Which values do you want to store in an array?
You do know how to declare arrays, right?

Aug 22 '07 #5

Hi,
Get multiple mail ids from database and store that in array, and then send that as to like new InternetAddress(to),

first I got send to multiple mail ids without database using array like

Expand|Select|Wrap|Line Numbers

 
String recipients=={"devteam@yahoo.com","sathya@gmail.com","pnithya@yahoo.co.in"};
 
InternetAddress[] addressTo = new InternetAddress[recipients.length]; 

           for (int i = 0; i < recipients.length; i++)

           {

           addressTo[i] = new InternetAddress(recipients[i]);

           }

           message.setRecipients(Message.RecipientType.TO, addressTo);

now I want, how to store the resultSet values in array

Aug 22 '07 #6

13,262

8TB

Hi,
Get multiple mail ids from database and store that in array, and then send that as to like new InternetAddress(to),

first I got send to multiple mail ids without database using array like

Expand|Select|Wrap|Line Numbers

String recipients=={"devteam@yahoo.com","sathya@gmail.com","pnithya@yahoo.co.in"};

InternetAddress[] addressTo = new InternetAddress[recipients.length];

           for (int i = 0; i < recipients.length; i++)

           {

           addressTo[i] = new InternetAddress(recipients[i]);

           }

           message.setRecipients(Message.RecipientType.TO, addressTo);

now I want, how to store the resultSet values in array

Use an Arraylist instead since you may not know how many times rs.next is going to be called. Then you just do

Expand|Select|Wrap|Line Numbers

list.add(rs.getString(1));

Aug 22 '07 #7

Hi,

Thanks for your solution, if i put this code like list.add(rs.getstring(1)) other simple coding means i got all the values from database, but in javamail
I got one error like
cannot resolve symbol,
symbol:variable list

Expand|Select|Wrap|Line Numbers

 
ArrayList list = new ArrayList();  
 
 while(rs.next())

   {

  list.add(rs.getString(1));

    }  
 
MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(list));

Aug 22 '07 #8

13,262

8TB

Hi,

Thanks for your solution, if i put this code like list.add(rs.getstring(1)) other simple coding means i got all the values from database, but in javamail
I got one error like
cannot resolve symbol,
symbol:variable list

Expand|Select|Wrap|Line Numbers

ArrayList list = new ArrayList();

while(rs.next())

   {

  list.add(rs.getString(1));

    }

MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(list));

It's your try/catch blocks that are putting list out of scope as soon as you exit the try/catch block. Either declare the ArrayList before the try/catch block or move your catch blocks to the end of the code.

Aug 22 '07 #9

Hi,

I put the code like

Expand|Select|Wrap|Line Numbers

 
while(rs.next())

{

list.add(rs.getString(1));

}  

}

catch(Exception e)

{

out.println(e);

}
 
           MimeMessage message = new MimeMessage(session);

          message.setRecipient(Message.RecipientType.TO,new InternetAddress(list));

means I got the following error,

cannot resolve symbol
symbol:constractor InternetAddress (java.util.ArrayList)

If I put the code like

Expand|Select|Wrap|Line Numbers

 
while(rs.next())

{

list.add(rs.getString(1));

}  

}

catch(Exception e)

{

out.println(e);

}
 
           MimeMessage message = new MimeMessage(session);

          message.setRecipient(Message.RecipientType.TO,new InternetAddress("list"));

this means I didnot get compile time error,
but I got run time error like

ERROR.....javax.mail.SendFailedException: Invalid Addresses; nested exception is: class com.sun.mail.smtp.SMTPAddressFailedException: 550 5.7.1 Hello [125.22.243.43], Policy rejection on the target address:

Please help me

Thanks in advance

Aug 23 '07 #10

13,262

8TB

Read the docs for ArrayList class to see how to use the get method to get values out of an arraylist.
Also, you'll have to make sure you're passing the correct address format because the InternetAddress constructor does strict parsing on it.

Aug 23 '07 #11

Hi,
I tried many ways, but I didnot get the answer,Please help me.

I think it is typecast error, after fetching the values from database I print that values using out.println(list) , I got the output [dev@yahoo.com].
and then I tried to convert from arraylist to string, I had no compile time error,
but I got runtime error, that time also I print that values using out.println(list).

If I pass the values like this

Expand|Select|Wrap|Line Numbers

 ]

Strint to={"dev@yahoo.com","a@yahoo.com"}

 message.setRecipient(Message.RecipientType.TO,new InternetAddress(to));

means I got the correct answer.

but I didnot have any solution how to convert [a@yahoo.com] to "a@yahoo.com", Please the solution.

Aug 24 '07 #12

madhoriya22

252

100+

Hi,
I tried many ways, but I didnot get the answer,Please help me.

I think it is typecast error, after fetching the values from database I print that values using out.println(list) , I got the output [dev@yahoo.com].
and then I tried to convert from arraylist to string, I had no compile time error,
but I got runtime error, that time also I print that values using out.println(list).

If I pass the values like this

Expand|Select|Wrap|Line Numbers

]

Strint to={"dev@yahoo.com","a@yahoo.com"}

message.setRecipient(Message.RecipientType.TO,new InternetAddress(to));

means I got the correct answer.

but I didnot have any solution how to convert [a@yahoo.com] to "a@yahoo.com", Please the solution.

Hi,
It is very simple..... Use get method of list as

Expand|Select|Wrap|Line Numbers

list.get(i);//where i is the position of element in the list

If list contain class object or String then typeCast it..

Expand|Select|Wrap|Line Numbers

  
(object)list.get(i); // ..or

(String)list.get(i);

Aug 24 '07 #13

Hi,
I tried that way even then I didnot get the answer, I put the code like this

Expand|Select|Wrap|Line Numbers

  
ArrayList list = new ArrayList();  

while(rs.next())

{

  String to=rs.getString(1);

  list.add(to);

 }

 String m="";

 for(int i=0;i<list.size();i++)

 {

  m += list.get(i).toString();

 }

String to=m;

out.println(to);

}

catch(Exception e)

{

out.println(e);

}
 
           MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress("to"));

I got the following error,

"sruthi@yahoo.com" ERROR.....javax.mail.SendFailedException: Invalid Addresses; nested exception is: class com.sun.mail.smtp.SMTPAddressFailedException: 550 5.7.1 Hello [125.22.243.43], Policy rejection on the target address:

Aug 24 '07 #14

13,262

8TB

Hi,
I tried that way even then I didnot get the answer, I put the code like this

Expand|Select|Wrap|Line Numbers

ArrayList list = new ArrayList();

while(rs.next())

{

  String to=rs.getString(1);

  list.add(to);

}

String m="";

for(int i=0;i<list.size();i++)

{

  m += list.get(i).toString();

}

String to=m;

out.println(to);

}

catch(Exception e)

{

out.println(e);

}

           MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress("to"));

I got the following error,

"sruthi@yahoo.com" ERROR.....javax.mail.SendFailedException: Invalid Addresses; nested exception is: class com.sun.mail.smtp.SMTPAddressFailedException: 550 5.7.1 Hello [125.22.243.43], Policy rejection on the target address:

Remove the quotes in

Expand|Select|Wrap|Line Numbers

message.setRecipient(Message.RecipientType.TO,new InternetAddress("to"));

So you have

Expand|Select|Wrap|Line Numbers

message.setRecipient(Message.RecipientType.TO,new InternetAddress(to));

Aug 24 '07 #15

Hi,
If I remove the quotes , I got the compile time error,

cannot resolve symbol
symbol:variable m
location:message.setRecipient(Message.RecipientTyp e.TO,new InternetAddress(m));

Expand|Select|Wrap|Line Numbers

 
ArrayList list = new ArrayList();  

while(rs.next())

{

  String to=rs.getString(1);

  list.add(to);

 }

 String m="";

 for(int i=0;i<list.size();i++)

 {

  m += list.get(i).toString();

 }

MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(m));

Please help me,

Aug 27 '07 #16

Nepomuk

3,112

Expert 2GB

cannot resolve symbol
symbol:variable m
location:message.setRecipient(Message.RecipientTyp e.TO,new InternetAddress(m));
...

Expand|Select|Wrap|Line Numbers

message.setRecipient(Message.RecipientType.TO,new InternetAddress(m));

Why is it new InternetAddress(m) instead of new InternetAddress(to)? It doesn't recognize m! It used to be "to", didn't it?

Aug 27 '07 #17

13,262

8TB

Hi,
If I remove the quotes , I got the compile time error,

cannot resolve symbol
symbol:variable m
location:message.setRecipient(Message.RecipientTyp e.TO,new InternetAddress(m));

Expand|Select|Wrap|Line Numbers

ArrayList list = new ArrayList();

while(rs.next())

{

  String to=rs.getString(1);

  list.add(to);

}

String m="";

for(int i=0;i<list.size();i++)

{

  m += list.get(i).toString();

}

MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(m));

Please help me,

But what you posted is not what your code looks like. Can you post the code that's giving you this error as it is?

P.S It's not a bad time to read something about Java scoping rules.

Aug 27 '07 #18

Hi,

I used the following code,

Expand|Select|Wrap|Line Numbers

 
ArrayList list = new ArrayList();  

while(rs.next())

{

  //String to=rs.getString(1);

  list.add(rs.getString(1));

 }

 String m="";

 for(int i=0;i<list.size();i++)

 {

 m += list.get(i).toString()+"," ;

 }

//String to=m;
 
           MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(m));

If I pass one mail id to database I got the correct answer, If I pass more than one mail ids , I got the following error,

ERROR.....javax.mail.internet.AddressException: Illegal address in string ``dev@gmail.com,anu@gmail.com,a@yaoo.com,b@yahoo.c om,''

If I pass like

message.setRecipient(Message.RecipientType.TO,new InternetAddress("a@yaoo.com","b@yahoo.com"));

I got the correct answer, How to split the mail ids like above, If I use split(",") or "," means , It does not support more than one mail id's.

Please give the solution.

Aug 27 '07 #19

13,262

8TB

Hi,

I used the following code,

Expand|Select|Wrap|Line Numbers

ArrayList list = new ArrayList();

while(rs.next())

{

  //String to=rs.getString(1);

  list.add(rs.getString(1));

}

String m="";

for(int i=0;i<list.size();i++)

{

m += list.get(i).toString()+"," ;

}

//String to=m;

           MimeMessage message = new MimeMessage(session);

           message.setRecipient(Message.RecipientType.TO,new InternetAddress(m));

If I pass one mail id to database I got the correct answer, If I pass more than one mail ids , I got the following error,

ERROR.....javax.mail.internet.AddressException: Illegal address in string ``dev@gmail.com,anu@gmail.com,a@yaoo.com,b@yahoo.c om,''

If I pass like

message.setRecipient(Message.RecipientType.TO,new InternetAddress("a@yaoo.com","b@yahoo.com"));

I got the correct answer, How to split the mail ids like above, If I use split(",") or "," means , It does not support more than one mail id's.

Please give the solution.

You can get an array of InternetAddress objects from using the parse method.

Aug 27 '07 #20

ASP / Active Server Pages

Hi,

Thank you very much for your help, Now Its work perfectly with multiple mailid's.
but In some other system its not working. my smtp settings like
props.put("mail.smtp.host","mail.companyname.com") ;

If I give the mailids like a@company.com,b@company.com means
its working proper, otherwise I give a@gmail.com,b@yahoo.com means I got the following error,

ERROR.....javax.mail.SendFailedException: Invalid Addresses;
nested exception is:
class com.sun.mail.smtp.SMTPAddressFailedException: 500 Unauthorized relay msg rejected

Please help me,

thanks in advance.

Sep 3 '07 #21

Similar topics

Sorting values in an array

by: David C. Holley | last post by:

Anybody have some ready-made code that will loop through the values in an array and sort them in ascending or descending order? I'm about to start building some new functionality that will need to...

How to retrieve values from an array assigned to object type

by: HairlipDog58 | last post by:

I have a component that implements a property called obj of type object. The intent is that a user can pass in any value or array of values and I will be able to retrieve the values. If the...

.NET Framework

Copy unique values to new array

by: Joep | last post by:

Hi, In VB.net I have an array which contains different values. For example: array(0) = 2 array(1) = 2 array(2) = 2 array(3) = 3 array(4) = 3 array(5) = 6 array(6) = 6

Visual Basic .NET

beginner: unique values in an array

by: nescio | last post by:

hello, i have an array and i don't know the content of it, but i want only unique values. in php there is a function to do this, but how must i do this in javascript? i have tried a lot and...

Javascript

HELP! storing values into an array

by: ag203 | last post by:

I need to store 25 different values (1, 5, 10, 25 etc. theres no pattern) in an array and then when the user picks a number q through 25 one of those values (randomly not the same one every time)...

Storing more than 32,765 signed integer values in an array

by: mvenkatesh | last post by:

if i give int a; it shows "array size too large" and gives an error; How do i store more than 32,765(2^15) signed integer values in an array in C? I am using TuboC compiler.Please help me.

XML node values into actionscript array

by: srinivasreddypn | last post by:

Hi everybody, Here I am doing a project to generate flash line graphs using xml data. I prepared every thing ready for this, But only problem I am facing since so many days is from the node values...

Flash / Actionscript

fetch values from database

by: sruthini | last post by:

Hi, I am doing send some values(signup form::firstname,lastname,title,organization) to mail id using javamail at the same time it should store in database, my problem is how to fetch values from...

MySQL Database

delete replicating values from an array[]....

by: aswath | last post by:

hi dere, i have a question. i have an array with replicating values.... al i want to do is delete all replicating values and store the result in another array. eg., String a={1,2,3,3}; String...

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

Changing the language in Windows 10

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...