📄 bm_manage_db.jsp

📁 java开发的考勤管理系统 java开发的考勤管理系统
💻 JSP
字号:
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>部门管理</title>
</head>
<%@ page contentType="text/html;charset=ISO8859_1" %>
<%@ page import="java.sql.*"%> 
<%
	try
	{
		String name = (String) session.getValue("thename");
		if (name.equals(""))
		{
			response.sendRedirect("index.htm");
		}
	}
	catch(Exception e)
	{
		response.sendRedirect("index.htm");
	}
%>
<body>
<%
	ResultSet rs;
	int irs;
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
	String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=zwkq"; 
	String user="zwkq"; 
	String password="zwkq"; 
	Connection conn= DriverManager.getConnection(url,user,password); 
	Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	String s_but=request.getParameter("B_but");
	String sql,bmid,bmname,zgname,tele,addr,bz;
	if (s_but.equals("增加"))
	{
		bmid=request.getParameter("T_bmid");
		bmname=request.getParameter("T_bmname");	
		zgname=request.getParameter("T_zgname");
		tele=request.getParameter("T_tele");
		addr=request.getParameter("T_addr");
		bz=request.getParameter("S_bz");
		sql="insert into zwkq_bm_manage values('"+bmid+"','"+bmname+"','"+zgname+"','"+tele+"','"+addr+"','"+bz+"')";
		irs=stmt.executeUpdate(sql);
		if(irs==1)
			out.println("增加部门成功!!!");
		else
			out.println("增加部门失败!!!");			
	}
	if (s_but.equals("修改"))
	{
		bmid=request.getParameter("T_bmid");
		bmname=request.getParameter("T_bmname");	
		zgname=request.getParameter("T_zgname");
		tele=request.getParameter("T_tele");
		addr=request.getParameter("T_addr");
		bz=request.getParameter("S_bz");
		sql="update zwkq_bm_manage set bmname='"+bmname+"',bmmanage='"+zgname+"',bmtel='"+tele+"',bmhome='"+addr+"',bmbz='"+bz+"' where bmcode='"+bmid+"'";
		irs=stmt.executeUpdate(sql);
		if(irs==1)
			out.println("修改部门成功!!!");
		else
			out.println("修改部门失败!!!");	
		
	}
	if (s_but.equals("删除"))
	{
	 	bmid=request.getParameter("T_bmid");
		sql="delete from zwkq_bm_manage where bmcode='"+bmid+"'";
		irs=stmt.executeUpdate(sql);
		if(irs>=1)
			out.println("删除部门成功!!!");
		else
			out.println("删除部门失败!!!");		
	}
	if (s_but.equals("查询全部"))
	{
%>
		<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
			<tr>
    				<th width="15%">部门编号</th>
    				<th width="15%">部门名称</th>
    				<th width="15%">主管姓名</th>
    				<th width="15%">联系电话</th>
    				<th width="15%">家庭住址</th>
    				<th width="25%">部门备注</th>
  			</tr>
		</table>  
		<%
		sql="select * from zwkq_bm_manage"; 
		rs=stmt.executeQuery(sql); 
		while(rs.next()) {
		%> 
		<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  			<tr VALIGN=MIDDLE>
   				<td width="15%"><%=rs.getString(1)%></td>
   				<td width="15%"><%=rs.getString(2)%></td>
    				<td width="15%"><%=rs.getString(3)%></td>
    				<td width="15%"><%=rs.getString(4)%></td>
    				<td width="15%"><%=rs.getString(5)%></td>
   				<td width="25%"><%=rs.getString(6)%></td>
  			</tr>
		</table> 
		<%}
			rs.close();
	} 
	stmt.close(); 
	conn.close(); 
%> 
</body>

</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -