jsp页面以表格的形式显示数据库的数据,小弟我想在每一行后面增加一个删除,大侠能把这个代码发给小弟我吗
jsp页面以表格的形式显示数据库的数据,我想在每一行后面增加一个删除,大侠能把这个代码发给我吗?
con=DriverManager.getConnection("jdbc:odbc:student","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM people");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"社团名");
out.print("<TH width=100>"+"创始人");
out.print("<TH width=100>"+"社团管理员");
out.print("<TH width=100>"+"社团类型");
out.print("<TH width=100>"+"删除");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+删除+"</TD>");
out.print("</TR>");
}
out.print("</TABLE>");
con.close();
}
------解决方案--------------------
out.print("<TD><input type='button' value='删除' /></TD>");
------解决方案--------------------
[code=java
con=DriverManager.getConnection("jdbc:odbc:student","sa","sa");
sql=con.createStatement();
String delete="<TD><input type='button' value='删除' onclick='delete(this)' /></TD>";
rs=sql.executeQuery("SELECT * FROM people");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"社团名");
out.print("<TH width=100>"+"创始人");
out.print("<TH width=100>"+"社团管理员");
out.print("<TH width=100>"+"社团类型");
out.print("<TH width=100>"+"删除");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print(delete);
out.print("</TR>");
}
out.print("</TABLE>");
con.close();
}
更多 0][/code]
------解决方案--------------------
con=DriverManager.getConnection("jdbc:odbc:student","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM people");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"社团名");
out.print("<TH width=100>"+"创始人");
out.print("<TH width=100>"+"社团管理员");
out.print("<TH width=100>"+"社团类型");
out.print("<TH width=100>"+"删除");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+删除+"</TD>");
out.print("</TR>");
}
out.print("</TABLE>");
con.close();
}
------解决方案--------------------
out.print("<TD><input type='button' value='删除' /></TD>");
------解决方案--------------------
[code=java
con=DriverManager.getConnection("jdbc:odbc:student","sa","sa");
sql=con.createStatement();
String delete="<TD><input type='button' value='删除' onclick='delete(this)' /></TD>";
rs=sql.executeQuery("SELECT * FROM people");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"社团名");
out.print("<TH width=100>"+"创始人");
out.print("<TH width=100>"+"社团管理员");
out.print("<TH width=100>"+"社团类型");
out.print("<TH width=100>"+"删除");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print(delete);
out.print("</TR>");
}
out.print("</TABLE>");
con.close();
}
更多 0][/code]
------解决方案--------------------
con=DriverManager.getConnection("jdbc:odbc:student","sa","sa");
sql=con.createStatement();
String delete="<TD><input type='button' value='删除' onclick='delete(this)' /></TD>";
rs=sql.executeQuery("SELECT * FROM people");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"社团名");
out.print("<TH width=100>"+"创始人");
out.print("<TH width=100>"+"社团管理员");
out.print("<TH width=100>"+"社团类型");
out.print("<TH width=100>"+"删除");
out.print("</TR>");