Scrollable RESULTSET

import java.sql.*;
public class Arin {
public Arin(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/Libary","root","password");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery("Select * from idnt");
int i=0;
while(rs.next())
i++;
System.out.println("Result Set Length:"+i);
rs.beforeFirst();
while(rs.next())
System.out.println(""+rs.getString(1));
}catch(Exception e){
System.out.println(e.toString());
}
}
public static void main(String ar[]){
new Arin();
}
}

Comments

Post a Comment

Popular posts from this blog

Few tips for Linux User related to MAN page

To read a man page general command is:- #/$man example :-$man ping The above command gives you a name synopsis and short description about that command , list of option with that command and the author name. it also display ping(8).Here 8 is a section. The manual page categorized into several section. 1 - user commands 2 - System calls 3 - Subroutines 4 - Devices 5 - File Formats 6 - Games 7 - Miscellaneous 8 - System Administrator n - New x - X Window For ubuntu man page configuration file is : /etc/manpath.config for other system (Red Hat) /etc/man.config 1.Search a string with in man page: $man -k command 2.Convert man page to other format(by default post script format) $man -t command suppose you want to convert it into pdf format then $man -t ping|ps2pdf -> ping.pdf 3. Find a command form a particular section:- $man command eg. $man 3 printf 4. Small description(One sentence) about any command. $man -f command eg. $man -f ifconfig
Read more

SEND Mail Using JAVA Mail API

You need mail.jar to add your project ----------------------------------------------------- ----------------------------------------------------- import javax.mail.*; import javax.mail.internet.*; import java.util.Properties; public class SimpleSSLMail { private static final String SMTP_HOST_NAME = "smtp.gmail.com"; private static final int SMTP_HOST_PORT = 465; private static final String SMTP_AUTH_USER = "arinengg@gmail.com"; private static final String SMTP_AUTH_PWD = "password"; public static void main(String[] args) throws Exception{ new SimpleSSLMail().test(); } public void test() throws Exception{ Properties props = new Properties(); props.put("mail.transport.protocol", "smtps"); props.put("mail.smtps.host", SMTP_HOST_NAME); props.put("mail.smtps.auth", "true"); Session mailSession = Session.getDefaultInstance(props); mailSession.setDebug(true); Transport transport = mailSession.getTransport(); MimeM
Read more