Tuesday, 26 February 2013
how to store database record into java object
//this BChequeDiscount is Bean which used for setting value and getting the value
import java.util.*;
import java.sql.*;
import java.io.*;
public class BChequeDiscount
{
public int Id;
public String FName;
public String LName;
public void setId(int Id)
{
this.Id=Id;
}
public void setFName(String FName)
{
this.FName=FName;
}
public void setLName(String LName)
{
this.LName=LName;
}
public int getId()
{
return Id;
}
public String getFName()
{
return FName;
}
public String getLName()
{
return LName;
}
}
/*This class is used the above bean for storing data into the object which is retrive from database and add into the arraylist */
import java.util.*;
import java.sql.*;
import java.io.*;
public class BChequeDiscountDemo
{
Connection connection;
String sql="";
Statement stmt;
ResultSet rs,rsn;
public List<BChequeDiscount> ReadFDB()throws Exception
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost/univercity","root","");
stmt=connection.createStatement();
}
catch(SQLException sa)
{
System.out.println("Error loading driver:" + sa.getMessage());
}
List<BChequeDiscount> al=new ArrayList<BChequeDiscount>();
sql="Select *From lecture";
rs=stmt.executeQuery(sql);
while(rs.next())
{
BChequeDiscount bcd=new BChequeDiscount();
bcd.setId(rs.getInt("id"));
bcd.setFName(rs.getString("FName"));
bcd.setLName(rs.getString("LName"));
al.add(bcd);
}
return al;
}
public void ReadList(List<BChequeDiscount> bcd)
{
BChequeDiscount rbcd=null;
Iterator<BChequeDiscount> ite=bcd.iterator();
while(ite.hasNext())
{
rbcd=ite.next();
System.out.println("the id is"+rbcd.getFName());
System.out.println("the id is"+rbcd.getId());
System.out.println("the id is"+rbcd.getLName());
}
}
public static void main(String args[])throws Exception
{
BChequeDiscountDemo bcdd=new BChequeDiscountDemo();
//This following method read data from database and return arraylist object.
List<BChequeDiscount> bcd=bcdd.ReadFDB();
//this following method is read from arraylist object
bcdd.ReadList(bcd);
}
}
How to send Mail from your gmail account using java.
import java.security.Security;
import java.util.Properties;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.Message.RecipientType;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import javax.mail.*;
public class SendMail
{
public static int status=0;
private String from;
private String to;
private String subject;
private String text;
private String host;
private String pass;
private String username;
public SendMail(){}
public SendMail(String from, String to, String subject, String text)
{
this.from = from;
this.to = to;
this.subject = subject;
this.text = text;
status=0;
}
public void send()
{
username="panjariixxxx"; //here u have to write your user name
pass="ishwaxxxx"; //here your gmail password
host = "smtp.gmail.com";
Properties props = new Properties();
props.put("mail.smtp.host",host);
props.put("mail.smtp.auth","true");
props.put("mail.smtp.port", "25");
props.put("mail.smtp.protocolo","smtps");
//this follwoing need to set for server authentication.
props.put("mail.smtp.starttls.enable", "true");
Session mailSession=Session.getDefaultInstance(props,new javax.mail.Authenticator(){
protected PasswordAuthentication getPasswordAuthentication()
{
return new PasswordAuthentication(username,pass);
}
});
Message simpleMessage = new MimeMessage(mailSession);
InternetAddress fromAddress = null;
InternetAddress toAddress = null;
try {
fromAddress = new InternetAddress(from);
toAddress = new InternetAddress(to);
} catch (AddressException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try
{
simpleMessage.setFrom(fromAddress);
simpleMessage.setRecipient(RecipientType.TO,toAddress);
simpleMessage.setSubject(subject);
//this following line for other formate message e.g this support html and simple formate too
simpleMessage.setContent(text,"text/html");
Transport.send(simpleMessage);
status=1;
}
catch (MessagingException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String args[])
{
String femailid="xxxxx@gmail.com"; //this is from email id
String temailid="xxxxx@gmail.com"; //this is too email id
String sub="Good Morining";
String message="<h1>This is mail from local server and sent using gmail account..by java program <h1>";
SendMail sendmail=new SendMail(femailid,temailid,sub,message);
sendmail.send();
}
}
for above program you need to download two jar file
1)jaf-1.1.1
2)javamail-1.4.5
You can download this example from the following link
https://sites.google.com/site/poolofjava/Sending%20Mail.zip?attredirects=0&d=1
Subscribe to:
Posts (Atom)