title

import java.sql.*; 
import groovy.sql.Sql 

class Example { 
   static void main(String[] args) {
      // Creating a connection to the database
      def sql = Sql.newInstance('jdbc:mysql://MYSQL7003.site4now.net/db_a439c5_meusing', 'a439c5_meusing',  
         'Manoj#1532', 'com.mysql.jdbc.Driver')
         
		def insertval = """INSERT INTO EMPLOYEE(FIRST_NAME,
         LAST_NAME, AGE, SEX, INCOME) VALUES ('Man', 'Mohan singh', 80, 'M', 20)""" 
		
		sql.execute(insertval)	
      def sqlstr = """CREATE TABLE EMPLOYEE ( 
         FIRST_NAME CHAR(20) NOT NULL,
         LAST_NAME CHAR(20),
         AGE INT,
         SEX CHAR(1),
         INCOME FLOAT )""" 
         
         
sql.eachRow('select * from employee') {
         tp -> 
         println([tp.FIRST_NAME,tp.LAST_NAME,tp.age,tp.sex,tp.INCOME])
 }
    //  sql.execute(sqlstr);
 
      sql.close() 
   } 
}