Tuesday, 24 March 2015

JSP code to show value from mysql database using type 4 driver

<%@page  language="java" import="java.sql.*" contentType="text/html" pageEncoding="UTF-8"%>


   
       
        JSP Page
   
   
        <%
        Connection con;
        PreparedStatement ps;
        try
        {
          Class.forName("com.mysql.jdbc.Driver");
          con=DriverManager.getConnection("jdbc:mysql://localhost/school","root","admin");
          Statement st=con.createStatement();
          ResultSet rs=st.executeQuery("select * from login");
          while(rs.next())
          {
              out.print("Name is  "+rs.getString(1));
              out.println("  Pass is  "+rs.getString(2));
              out.println("
");
          }
       
        }
        catch(Exception e){}
        %>
   


No comments:

Post a Comment