Java

Sunday, 12 April 2015

Java program to access MS Access database

Program:


Read: Convert infix to postfix expression.

import java.sql.*;
public class msaccess
{
    public static void main(String args[])

{
    try
}
    Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
   
};

Connection con=DriverManager.getConnection("jdbc:odbc:ganesh"," "," ");
System.out.println("connection Successful");
Statement stmt=con.createStatement();
stmt.execute("select * from student");
ResultSet rs=stmt.getResultSet();
if(rs!=null)
while(rs.next())
{
    System.out.println("rno"+rs.getInt("rno")+"name"+rs.getString("name");
}
stmt.close();
con.close();
}
catch(Exception error)
{
    System.out.println("error:"+error);
}
}
}

No comments:

Post a Comment