<html>
<head>
<script language="javascript">
function XML_TO_SQL()
{
var submit_val = document.getElementById("from_txt").value;
var param_txt = document.getElementById("from_param").value;
//生成参数ARREY
var param_values = param_txt.split("],");
for(i = 0;i < param_values.length-1;i++)
{
var temp_val = "'" + param_values[i].substr(param_values[i].lastIndexOf(",")+1) + "'";
submit_val = submit_val.replace(":" + i,temp_val);
}
document.getElementById("to_txt").value = submit_val;
}
function Clear()
{
document.getElementById("from_param").value = "";
document.getElementById("from_txt").value = "";
document.getElementById("to_txt").value = "";
}
</script>
</head>
<body>
<table>
<tr>
<td >
<textarea cols="50" rows="10" id="from_txt" name="from_txt" οndblclick="this.value = clipboardData.getData('Text');"></textarea>
</td>
<td rowspan = "2">
<textarea cols="50" rows="20" id="to_txt" name="to_txt" readonly></textarea>
</td>
</tr>
<tr>
<td colspan = "2">
<textarea cols="50" rows="10" id="from_param" name="from_param" οndblclick="this.value = clipboardData.getData('Text');"></textarea>
</td>
</tr>
</table>
<input type="button" value="SUBMIT" οnclick="XML_TO_SQL()">
<input type="button" value="CLEAR" οnclick="Clear()">
</body>
</html>