Revision 24742 trunk/extensions/extMetadata/src/org/gvsig/metadata/extended/ExtendedMDLibrary.java

View differences:

ExtendedMDLibrary.java
30 30 

  		




  31
  31
  
    
package org.gvsig.metadata.extended;


  		




  32
  32
  
    

  		




  
  33
  
    
import java.sql.Connection;


  		




  
  34
  
    
import java.sql.PreparedStatement;


  		




  
  35
  
    
import java.sql.ResultSet;


  		




  
  36
  
    
import java.sql.SQLException;


  		




  
  37
  
    
import java.sql.Statement;


  		




  
  38
  
    

  		




  33
  39
  
    
import org.gvsig.metadata.MDLocator;


  		




  34
  40
  
    
import org.gvsig.metadata.MDManager;


  		




  35
  41
  
    
import org.gvsig.metadata.extended.manager.ExtendedMDManagerImpl;


  		




  
  42
  
    
import org.gvsig.personaldb.PersonalDBLocator;


  		




  36
  43
  
    
import org.gvsig.tools.locator.BaseLibrary;


  		




  37
  44
  
    
import org.gvsig.tools.locator.ReferenceNotRegisteredException;


  		




  38
  45
  
    

  		




  ......




  53
  60
  
    
        }


  		




  54
  61
  
    
        


  		




  55
  62
  
    
        // INICIALIZAR Base de Datos


  		




  
  63
  
    
        dataBaseInit();


  		




  56
  64
  
    
	}


  		




  57
  65
  
    
	


  		




  
  66
  
    
	public void dataBaseInit() {


  		




  
  67
  
    
		Connection conn = PersonalDBLocator.getInstance().getPersonalDBManager().getConnection();


  		




  
  68
  
    
		String sql = "CREATE TABLE IF NOT EXISTS MDDEFINITIONS(ID INT AUTO_INCREMENT(1) PRIMARY KEY, NAME VARCHAR2, DESCRIPTION LONGVARCHAR, FATHER INT DEFAULT 0, EXPORT_NAME VARCHAR2 DEFAULT '');";


  		




  
  69
  
    
		String sql2 = "CREATE TABLE IF NOT EXISTS MDELEMENTDEFINITIONS(ID INT AUTO_INCREMENT(1) PRIMARY KEY, NAME VARCHAR2, DESCRIPTION LONGVARCHAR, REQUIRED BOOLEAN DEFAULT true, FATHER INT DEFAULT 0, EXPORT_NAME VARCHAR2 DEFAULT '', TIPO VARCHAR2 DEFAULT 'String', DEF_VALUE VARCHAR2 DEFAULT '');";


  		




  
  70
  
    
		PreparedStatement prep;


  		




  
  71
  
    
		try {


  		




  
  72
  
    
			prep = conn.prepareStatement(sql);


  		




  
  73
  
    
			prep.execute();


  		




  
  74
  
    
			prep = conn.prepareStatement(sql2);


  		




  
  75
  
    
			prep.execute();


  		




  
  76
  
    
			conn.close();


  		




  
  77
  
    
		} catch (SQLException e) {


  		




  
  78
  
    
			// TODO Auto-generated catch block


  		




  
  79
  
    
			e.printStackTrace();


  		




  
  80
  
    
		}


  		




  
  81
  
    
	}


  		




  
  82
  
    
	


  		




  58
  83
  
    
}


  		












Also available in:  Unified diff