chakan.jsp

jsp做的一个个人网站

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<table border="1" align="center">
<%String flag;
flag=request.getParameter("flag");
if(flag==null){}
else{
request.setCharacterEncoding("gb2312");
//String ID=request.getParameter("id");
//int id=java.lang.Integer.parseInt(ID);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
//String message="select * from gly where name='"+username+"'";
//String s="select * from gly where id="+id;
String s=" select * from gly ";
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery(s);
String id;
while(rs.next()){
id=rs.getString(1);%>
<tr>
<td bordercolor="#99CCCC" >用户名:<%=rs.getString(2)%></td>
<td bordercolor="#99CCCC">密码:<%=rs.getString(3)%></td>
<td bordercolor="#99CCCC">性别:<%=rs.getString(4)%></td>
<td bordercolor="#99CCCC">个人说明:<%=rs.getString(5)%></td>
<td bordercolor="#99CCCC"><a href="delete1.jsp?id=<%=id%>">删除该用户</a></td>
</tr><%
}
}
%>

</table>
<p><a href="guanli.jsp">返回</a></p>