id not unique
29/09/2009 00:00
CREATE TABLE dbo.ACADEMICO_ATIV_COMP
(
cd_acad INT NOT NULL,
cd_ativ_comp TINYINT NOT NULL,
evento VARCHAR (120) NOT NULL,
dt_inicio VARCHAR (10) NOT NULL,
tot_hor SMALLINT NOT NULL,
tot_min TINYINT NOT NULL,
PRIMARY KEY NONCLUSTERED (cd_acad,cd_ativ_comp)
)
cd_acad | cd_ativ_comp
1 | 1
1 | 2
1 | 3
2 | 1
3 | 1
3 | 2
class Ativcomp {
Short acad
String evento
String data
Short hora
Short minuto
static mapping = {
table 'marcelo..ACADEMICO_ATIV_COMP'
id column:'cd_ativ_comp', generator:'assigned', sqlType:'int'
acad column:'cd_acad'
data column:'dt_inicio'
hora column:'tot_hor'
minuto column:'tot_min'
version false
}
}
cd_acad | cd_ativ_comp
1 | 1
1 | 2
1 | 3
2 | 1
3 | 1
3 | 2
class Ativcomp implements Serializable {
String evento
Date data
Short hora
Short minuto
Integer cd_ativ_comp
Academicos acad
static mapping = {
id composite:['acad','cd_ativ_comp'], generator:'assigned'
id column:'cd_ativ_comp', sqlType:'int'
acad column:'cd_acad'
evento column:'evento'
data column:'dt_inicio'
hora column:'tot_hor'
minuto column:'tot_min'
version false
}
}
def ativcompInstance = Ativcomp.get( new Ativcomp(acad:params.acad,ativ:params.ativ) )
<g:link action="show" params="[acad:ativcompInstance.acad, ativ:ativcompInstance.ativ]">SHOW</g:link>
redirect(action:show,params:[acad:ativcompInstance.acad, ativ:ativcompInstance.ativ])
Para se registrar, clique aqui.