<!-- 这是一个有问题的代码,求教高手 -->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head><title>radio.jsp</title>
</head>
<body>
<script type="text/javascript">
<!--
function check()
{
var radios=document.getElementsByTagName("ra");
for(var i=0;i<radios.length;i++)
{
if(radios[i].checked){
if(radios[i].value.equals("insert"))
{
document.write("
<form method="post" action="test.jsp">
<table>
<tr><td>id:</td><td><input type="text" name="id"></td></tr>
<tr><td>name:</td><td><input type="text" name="name"></td></tr>
<tr><td>password:</td><td><input type="text" name="password"></td></tr>
<tr><td><input type="submit" value="insert"></td></tr>
</table>
</form>
");
}else if(radios[i].test.equals("update"))
{
document.write("
<form method="post" action="test.jsp">
<table>
<tr><td>id:</td><td><input type="text" name="id"></td></tr>
<tr><td>name:</td><td><input type="text" name="name"></td></tr>
<tr><td>password:</td><td><input type="text" name="password"></td></tr>
<tr><td><input type="submit" value="update"></td></tr>
</table>
</form>
");
}
else if(radios[i].test.equals("delete"))
{
document.write("
<form method="post" action="test.jsp">
<table>
<tr><td>id:</td><td><input type="text" name="id"></td></tr>
<tr><td><input type="submit" value="delete"></td></tr>
</table>
</form>
");
}
}
}
}
//-->
</script>
<%
Connection conn;
Statement sql;
ResultSet rs;
try{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
}
catch(ClassNotFoundException e){
out.print("error1");
out.print(e);
}%>
<input type="radio" name="ra" value="insert" οnclick="check()">insert
<input type="radio" name="ra" value="update" οnclick="check()">update
<input type="radio" name="ra" value="delete" οnclick="check()">delete
<%
String s=request.getParameter("ra");
s=request.getParameter("ra");
String s1=request.getParameter("id");
String s2=request.getParameter("name");
String s3=request.getParameter("password");
if(s1!=null)
{
if(s.equals("delete"))
{
s="delete login where id='"+s1+"'";
}
else if(s.equals("update"))
{
s="update login set name='"+s2+"'and password='"+s3+"'"+" where id='"+s1+"'";
}
else if(s.equals("insert"))
{
s="insert into login values('"+s1+"','"+s2+"','"+s3+"')";
}
try{
conn=DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/student","sa","sa");
sql=conn.createStatement();
sql.executeUpdate(s);
conn.close();
}catch(SQLException e2)
{
out.print("error3");
out.print(e2);
}
}
try{
conn=DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/student","sa","sa");
sql=conn.createStatement();
rs=sql.executeQuery("select * from login");
out.println("<table border=2>");
out.println("<tr>");
out.println("<td>id</td>");
out.println("<td>name</td>");
out.println("<td>password</td></tr>");
while(rs.next())
{
out.println("<tr><td>"+rs.getString("id")+"</td>");
out.println("<td>"+rs.getString("name")+"</td>");
out.println("<td>"+rs.getString("password")+"</td></tr>");
}
out.println("</table>");
conn.close();
}
catch(SQLException e1){
out.print("error2");
out.print(e1);
}
%>
</body>
</html>