Home
JAVA JDBC
Display all records from the Database
Here is a sample code to display all records from the Database
import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class joy extends HttpServlet { Connection com; ResultSet rs; Statement st; String str; PrintWriter pw; public void service(HttpServletRequest req,HttpServletResponse res)throws IOException, ServletException { pw=res.getWriter(); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundException e){} try{ com=DriverManager.getConnection("jdbc:odbc:persinfo"); str="select *from info"; st=com.createStatement(); rs=st.executeQuery(str); while(rs.next()) { pw.println(rs.getString("name")); pw.println(rs.getInt("age")); } pw.close(); rs.close(); st.close(); com.close(); }catch(SQLException se) {} } }
Previous
Next
