Showing posts with label simple java mysql program. Show all posts
Showing posts with label simple java mysql program. Show all posts

Friday, 13 March 2015

Java simple mysql program

import java.sql.*;
class MysqlConPro{
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver");
 
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
 
Statement stmt=con.createStatement();
 
ResultSet rs=stmt.executeQuery("select * from EMP");
 
while(rs.next())
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getDouble(3));
 
con.close();
  }
catch(Exception e){ System.out.println(e);}
 
}
}