Java web项目爱分享社区用户管理部分代码

最新推荐文章于 2024-04-17 13:40:17 发布

Allureyou

最新推荐文章于 2024-04-17 13:40:17 发布

阅读量668

点赞数

分类专栏：程序程序数据结构 java 文章标签： java web java jsp 社区

本文链接：https://blog.csdn.net/Allureyou/article/details/55271738

版权

程序同时被 3 个专栏收录

77 篇文章 0 订阅

订阅专栏

程序数据结构

31 篇文章 0 订阅

订阅专栏

java

23 篇文章 0 订阅

订阅专栏

<%@ page import ="java.sql.*"   %>
<%@ page import ="DAO.*"   %>
<%@ page import ="java.util.*"   %>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>用户管理</title>
</head>
<body>
<STYLE type=text/css> BODY {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; BACKGROUND-COLOR: #2a8dc8
}
BODY {
	FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
TD {
	FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
DIV {
	FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
P {
	FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
</STYLE>

<META content="MSHTML 6.00.2900.3492" name=GENERATOR></HEAD>
<BODY>

<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD width=10><IMG src="images/new_001.jpg" border=0></TD>
    <TD background=images/new_002.jpg><FONT size=4><B>用户管理中心
      </B></FONT> </TD>
    <TD background=images/new_002.jpg>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD align=right height=25></TD></TR>
        <TR>
          <TD height=35>
           <A href="typo.jsp"  target=_top><FONT color=red><B>增加用户</B></FONT></A> 
           <form  action="updateuser.jsp"    >
请输入要修改的用户名：<input   type="text"    name="unname"        >
<input  type="submit"     name="submit"      value="提交" /    >
</form>
 <form  action="deleteuser.jsp"    >
请输入要删除的用户名：<input   type="text"    name="uname"        >
<input  type="submit"     name="submit"      value="提交" /    >
</form>
          <A href="exit.jsp"   target=_top><FONT color=red><B>安全退出</B></FONT></A>       
      </TD></TR>
      

  
      </TBODY></TABLE></TD>
    <TD width=10><IMG src="images/new_003.jpg" 
border=0></TD></TR></TBODY></TABLE></BODY>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection  conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","system","Oracle11g");
  request.setCharacterEncoding("utf-8"); 
Statement stmt =conn.createStatement();

 
 ArrayList<UserInfo> users=new ArrayList<UserInfo>();
String sql1 = "select  *  from USERS ";      
ResultSet rs=stmt.executeQuery(sql1);
while(rs.next()){
	UserInfo user=new UserInfo();
	user.username=rs.getString("username");
	user.pass=rs.getString("pass");
	user.sex=rs.getString("sex");
	users.add(user);
}
	 stmt.close();
		conn.close();
%>


<table width="990" border="2" style="background:#ccccff">
<tr height="35">
	<td align="left" width="660" colspan="9">此时所有的用户如下：</td>
</tr>
<tr height="30">
	<th>用户名</th>
	<th>密码</th>
	<th>性别</th>

</tr>
<% 
	for(int i=0;i<users.size();i++){
%>
<tr height="25">
	<td><%=users.get(i).getUsername() %></td>
	<td><%=users.get(i).getPass() %></td>
	<td><%=users.get(i).getSex() %></td>
</tr>
<% } %>
</table>


</body>
</html>