Retrieving fron Access
import java.sql.*;
Class DBAccess{
public static void main(String[] args){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:MSAccess");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("SELECT*FROM Student");
while(rs.next()){
System.out.println(rs.getInt(1)+"\t");
System.out.println(rs.getString(2)+"\t");
System.out.println(rs.getInt(3)+"\t");
System.out.println(rs.getInt(4)+"\t");
}
rs.close();
st.close()
con.close();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
Catch(SQLException ee();
ee.printStackTrace();
}}}
……..
Insert record
; import java.sql.*
import java.io*;
class InsertTest {
public static void main(String[] args){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:db1");
String query="INSERT INTO Student VALUES(?,?,?)";
PreparedStatement st;
st=con.prepareStatement(query);
DataInputStream dis=new DataInputStream(System.in);
System.out.println('Enter student Name");
String name=dis.readLine();
System.out.println("Enter Student Marks1");
Int mark1=Integer.parslent(dis.readLine());
System.out.println("Enter student Marks2");
Int mark2=Integer.parseInt(dis.readLine());
st.setString(1,name);
st.setInt(2,mark1);
st.setInt(3,mark2);
int res;
res=st.executeUpdate();
if(res==1)
System.out.println("success");
else
System.out.println("Failure");
st.close
con.close();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLExcption se){
se.printStackTrace();
} catch(IOException ie) {
ie.printStackTrace();
}}}
………
…….
Servlet life cycle
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class HelloWorld extends HttpServlet
{
public void init(){
System.out.println("init called");
}
public void doGet(HttpservletRequest req,HttpServletResponsr res)
-throws ServletException,IOException{
System.out.println("Welcome to servlet demo");
PrintWriter out=res.getWriter();
Out.println("Welcome to Servlet Demo");
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
-throws ServletException,IOException{
System.out.println("doPost called");
doGet(req,res);
}
public void destroy(){
System.out.println("destroy called");
}
}
……….
Applet
import java.awt.Graphics;
import javax.swing.JApplet;
import javax.swing.JOptionPane;
public class AdditionApplet extends JApplet
{
private double sum;
public void init()
{
String firstNumber=
JOptionPane.showInputDialog("Enter first value");
String secondNumber=
JOptionPane.showInputDialog("Enter second value");
double n1=Double.parseDouble(firstNumber);
double n2=Double.parseDouble(secondNumber);
Sum=n1+n2;
}
public void paint(Graphics g)
{
super.paint(g);
g.drawReet(15,10,270,20);
g.drawString("the sum is"+sum,12,25);
}
}
................
……………..
Import java.sql.Connection;
Import java.sql.Statement;
Import java.sql.ResultSet;
Import java.sql.DriverManager;
Public class ExcelReader
{
Public static void main( String[] args)
{
Connection c =null;
Statement stmnt= null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc:odbc:sohail1","","");
stmnt = c.createStatement();
String query="select name from [emp$]where id=30";
ResultSet rs= stmnt.executeQury( query );
System.out.println("Student Details:");
while(rs.next() )
{
System.out.println(rs.getString("name"));
}}
catch( Exception e)
{
System.err.println( e );
}
finally
{
try
{
Stmnt.class():
c.close();
}
catch( Exception e)
{
System.err.println( e );
} } } }