Friday, 17 October 2014

JDBC Connectivity With Mysql


package jdbcswing;
import java.sql.*;
public class Jdbcswing {

    public static void main(String[] args) {
        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())
          {
              System.out.print("Name is  "+rs.getString(1));
              System.out.println("  Pass is  "+rs.getString(2));
          }
       
        }
        catch(Exception e){}
        // TODO code application logic here
    }
   
}

No comments:

Post a Comment