Basics In Java

a simple example for PreparedStatement package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); String sql="select * fr

The following code shows the use of some sqlexception method package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery("select stateId,

The following code illustrate how to limit the number of result in a result set and methods in scrollable result set go through it and may helpful in some way package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); stmt=conn.createStatement(ResultSet.TYPE_SCRO

package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery("select * from tours"); display(rs);

The following code illustrate how to connect mysql database using jdbc . It is very simple go through it and nothing fancy in it!!! package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); } catch (SQLException e) { System.err.println("something went wrong in database connection"); e.printStackTrace(); } finally{ if(conn!=null){ conn.close(

import java.util.*; class wordFrequency{ public static void main(String args[]){ String paragraph= "ab bc ab bc abbbb bc ab cd ef bc bc "; String eachWord[]=paragraph.split(" "); ArrayList listEachWord = new ArrayList (Arrays.asList(eachWord)); LinkedHashMap numeach=new LinkedHashMap (); for(int i=0;i&lteachWord.length;i++){ numeach.put(eachWord[i],Collections.frequency(listEachWord,eachWord[i])); } System.out.println(numeach); }}

1.Write a program to arrange a given set of names in alphabetical order import java.util.Arrays; class namesInAlphabeticalOrder{ public static void main(String args[]){ String names[]={"Sudeep","Rethin","george","Anu"}; System.out.println("before Sorting"); for(int i=0;i<names.length;i++) System.out.println(i+":"+names[i]); System.out.println("After Sorting"); Arrays.sort(names); for(int i=0;i&ltnames.length;i++) System.out.println(i+":"+names[i]); } }  2.Write a program to display the number of words in a given sentence 3.Accept a line of text.find the reverse of each word and display the string class countWord{ public static void main(String args[]){ String s="sudeep cv always find a way to success"; String[] s1=new String[s.length()]; s1=s.split(" "); System.out.println("Number of words in s is:"+s1.length); for(int i=0;i<s1.length;i++){ Strin