creat table start create table parent ( par_id int not null, primary key (par_id) ) type = innodb; create table child ( par_id int not null, child_id int not null, primary key (par_id,child_id), foreign key (par_id) references parent (par_id) on delete cascade ) type = innodb;# creat table end# insert stratinsert into parent (par_id) values (1),(2),(3); insert into child (par_id,child_id) values (1,1),(1,2); insert into child (par_id,child_id) values (2,1),(2,2),(2,3); insert into child (par_id,child_id) values (3,1);# insert end
create table parent
(
par_id int not null,
primary key (par_id)
) type = innodb;
create table child
(
par_id int not null,
child_id int not null,
primary key (par_id,child_id),
foreign key (par_id) references parent (par_id) on delete cascade
) type = innodb;# creat table end# insert stratinsert into parent (par_id) values (1),(2),(3);
insert into child (par_id,child_id) values (1,1),(1,2);
insert into child (par_id,child_id) values (2,1),(2,2),(2,3);
insert into child (par_id,child_id) values (3,1);# insert end
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>锐博机构客户管理系统</title>
<style type="text/css">
<!--
body {
background-color: #E3F4FE;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<link href="css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.STYLE1 {font-weight: bold}
.STYLE2 { font-size: 18px;
font-weight: bold;
}
body,td,th {
font-size: 12px;
}
-->
</style>
</head>
<script language="javascript" src="script/select.js"></script><br />
<script language="javascript" type="text/javascript">
function window.onload()
{
today1=new Date();
var str = today1.getYear();
document.getElementById("y").value=str;
}
</script>
<body>
<table width="672" height="745" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#CBEBFF">
<form action="baksifor.do?method=save" method="post">
<tr>
<td height="36" colspan="6" align="center" bgcolor="#D7EAF6"><span class="STYLE2">社保数据参考源设定</span></td>
</tr>
<tr align="center">
<td height="28" bgcolor="#FFFFFF">员工姓名</td>
<td colspan="5" align="left" bgcolor="#FFFFFF"> </td>
</tr>
< <td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="miind" type="text" id="miind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="miindb" type="text" id="p3" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="156" rowspan="2" bgcolor="#FFFFFF">失业保险</td>
<td width="101" height="28" bgcolor="#FFFFFF">单位</td>
<td width="80" bgcolor="#FFFFFF">比例</td>
<td width="100" bgcolor="#FFFFFF"><input name="uicom" type="text" id="uicom" size="8" />
%</td>
<td width="67" align="center" bgcolor="#FFFFFF">基数</td>
<td width="149" align="left" bgcolor="#FFFFFF"><input name="uicomb" type="text" id="u4" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="uiind" type="text" id="uiind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="uiindb" type="text" id="p4" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="156" rowspan="2" bgcolor="#FFFFFF">生育保险</td>
<td width="101" height="28" bgcolor="#FFFFFF">单位</td>
<td width="80" bgcolor="#FFFFFF">比例</td>
<td width="100" bgcolor="#FFFFFF"><input name="ricom" type="text" id="ricom" size="8" />
%</td>
<td width="67" align="center" bgcolor="#FFFFFF">基数</td>
<td width="149" align="left" bgcolor="#FFFFFF"><input name="ricomb" type="text" id="u5" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="riind" type="text" id="riind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="riindb" type="text" id="p5" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="156" rowspan="2" bgcolor="#FFFFFF">补充医疗</td>
<td width="101" height="28" bgcolor="#FFFFFF">单位</td>
<td width="80" bgcolor="#FFFFFF">比例</td>
<td width="100" bgcolor="#FFFFFF"><input name="cmcom" type="text" id="cmcom" size="8" />
%</td>
<td width="67" align="center" bgcolor="#FFFFFF">基数</td>
<td width="149" align="left" bgcolor="#FFFFFF"><input name="cmcomb" type="text" id="u6" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="cmind" type="text" id="cmind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="cmindb" type="text" id="p6" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="156" rowspan="2" bgcolor="#FFFFFF">重大疾病</td>
<td width="101" height="28" bgcolor="#FFFFFF">单位</td>
<td width="80" bgcolor="#FFFFFF">比例</td>
<td width="100" bgcolor="#FFFFFF"><input name="dicom" type="text" id="dicom" size="8" />
%</td>
<td width="67" align="center" bgcolor="#FFFFFF">基数</td>
<td width="149" align="left" bgcolor="#FFFFFF"><input name="dicomb" type="text" id="u7" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="diind" type="text" id="diind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="diindb" type="text" id="p7" size="8" /></td>
</tr>
<tr align="center">
<td width="156" rowspan="2" bgcolor="#FFFFFF">其他保险</td>
<td width="101" height="28" bgcolor="#FFFFFF">单位</td>
<td width="80" bgcolor="#FFFFFF">比例</td>
<td width="100" bgcolor="#FFFFFF"><input name="oicom" type="text" id="oicom" size="8" />
%</td>
<td width="67" align="center" bgcolor="#FFFFFF">基数</td>
<td width="149" align="left" bgcolor="#FFFFFF"><input name="oicomb" type="text" id="u8" value="0" size="8" /></td>
</tr>
<tr align="center">
<td width="101" height="33" bgcolor="#FFFFFF">个人</td>
<td bgcolor="#FFFFFF">比例</td>
<td bgcolor="#FFFFFF"><input name="oiind" type="text" id="oiind" size="8" />
%</td>
<td align="center" bgcolor="#FFFFFF">基数</td>
<td align="left" bgcolor="#FFFFFF"><input name="oiindb" type="text" id="p8" size="8" /></td>
</tr>
<tr align="center">
<td height="28" colspan="6" bgcolor="#FFFFFF"><input type="submit" name="Submit" value="增加" />
<input type="reset" name="Submit2" value="重置" /></td>
</tr>
</form>
</table>
</body>
</html>