JSP+JDBC案例代码（数据维护）

最新推荐文章于 2024-01-04 19:43:52 发布

LYH&

最新推荐文章于 2024-01-04 19:43:52 发布

阅读量535

点赞数 2

分类专栏：项目案例文章标签： sql javaee

本文链接：https://blog.csdn.net/qq_42759832/article/details/105464115

版权

项目案例专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文主要用于最近记录最近学习时所用到的代码，使用时需先与数据库建立连接，导入sqjdbc4.jar包并在数据库中建立相应的表。
在这里插入图片描述

ZgCx.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
	<head>
		<title>职工查询</title>
	</head>
	<body>
	<%
		try{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
			String user="sa";
			String password="abc123!";
			Connection conn=DriverManager.getConnection(url,user,password);
			String sql="select * from bmb order by bmbh";
			Statement stmt=conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
		%>
			<form method="post" action="ZgWh.jsp">
			部门：
			<select name="bmbh">
		<%
			while(rs.next()){
				String bmbh=rs.getString("bmbh");
				String bmmc=rs.getString("bmmc");
		%>
			<option value="<%=bmbh%>"><%=bmmc%></option>
		<%
			}
		%>
			</select>
			<input name="Submit" type="submit" value="确定"/>
			</form>
		<%
			rs.close();
			stmt.close();
			conn.close();
		}catch(Exception e){
			out.print(e.toString());
		}
	 %>
	</body>
</html>

ZgWh.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
	<head>
		<title>职工维护</title>
	</head>
	<body>
		<div align="center">
			<p>职工维护</p>
		<%
			String bmbh=request.getParameter("bmbh");
			String pageNo=request.getParameter("pageno");
			int pageSize=3;
			int pageCount;
			int rowCount;
			int pageCurrent;
			int rowCurrent;
			if(pageNo==null || pageNo.trim().length()==0){
				pageCurrent=1;
			}else{
				pageCurrent=Integer.parseInt(pageNo);
			}
			try{
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
				String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
				String user="sa";
				String password="abc123!";
				Connection conn=DriverManager.getConnection(url,user,password);
				String sql="select bh,xm,xb,bmmc,csrq,jbgz,gwjt from zgb,bmb";
				sql=sql+" where zgb.bm=bmb.bmbh and bm='"+bmbh+"'";
				sql=sql+" order by bh";
				Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
				ResultSet rs=stmt.executeQuery(sql);
				rs.last();
				rowCount = rs.getRow();
				pageCount = (rowCount + pageSize - 1)/pageSize;
				if(pageCurrent>pageCount)
					pageCurrent=pageCount;
				if(pageCurrent<1)
					pageCurrent=1;
					
		 %>
		 	<table border="1">
		 	<tr><td>编号</td><td>姓名</td><td>性别</td><td>部门</td><td>出生日期</td>
		 	<td>基本工资</td><td>岗位津贴</td><td>操作</td></tr>
		 <%
		 	rs.beforeFirst();
		 	rowCurrent=1;
		 	while(rs.next()){
		 		if(rowCurrent>(pageCurrent-1)*pageSize && rowCurrent<=pageCurrent*pageSize){
		 			String bh=rs.getString("bh");
		 			String xm=rs.getString("xm");
		 			String xb=rs.getString("xb");
		 			String bmmc=rs.getString("bmmc");
		 			String csrq=rs.getDate("csrq").toLocaleString();
		 			String jbgz=String.valueOf(rs.getFloat("jbgz"));
		 			String gwjt=String.valueOf(rs.getFloat("gwjt"));
		  %>
		  	<tr><td><%=bh%></td><td><%=xm%></td><td><%=xb%></td>
		  	<td><%=bmmc%></td><td><%=csrq%></td><td><%=jbgz%></td>
		  	<td><%=gwjt%></td><td><a href="ZgXq.jsp?bh=<%=bh%>" target="_black">详情</a>
		  	<a href="ZgXg.jsp?bh=<%=bh%>">修改</a>
		  	<a href="ZgSc.jsp?bh=<%=bh%>">删除</a></td></tr>
		  <%
		  		}
		  		rowCurrent++;
		  	}
		   %>
		   </table>
		   	<p align="center">
		   	<form method="post" action="ZgWh.jsp">
		   		第<%=pageCurrent %>页 共<%=pageCount %>页&nbsp;
		   		<%if(pageCurrent>1){ %>
		   		<a href="ZgWh.jsp?bmbh=<%=bmbh %>&pageno=1">首页</a>
		   		<a href="ZgWh.jsp?bmbh=<%=bmbh %>&pageno=<%=pageCurrent-1 %>">上一页</a>
		   		<%} %>
		   		&nbsp;
		   		<%if(pageCurrent<pageCount){ %>
		   		<a href="ZgWh.jsp?bmbh=<%=bmbh %>&pageno=<%=pageCurrent+1 %>">下一页</a>
		   		<a href="ZgWh.jsp?bmbh=<%=bmbh %>&pageno=<%=pageCount %>">尾页</a>
		   		<%} %>
		   		&nbsp;跳到第<input type="text" name="pageno" size="3" maxlength="5">页<input name="submit" type="submit" value="GO">
		   		<input name="bmbh" type="hidden" value="<%=bmbh %>">
		   	</form>
		 <%
		 	rs.close();
		 	stmt.close();
		 	conn.close();
		 	}catch(ClassNotFoundException e){
		 		out.println(e.getMessage());
		 	}catch(SQLException e){
		 		out.println(e.getMessage());
		 	}catch(Exception e){
		 		out.print(e.toString());
		 	}
		 %>
		</div>
	</body>
</html>

ZgXq.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*" %>
<%request.setCharacterEncoding("gb2312");%>
<html>
	<head><title>职工信息</title></head>
	<body>
	<div align="center">
	<p>职工信息</p>
	<%
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
				String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
				String user="sa";
				String password="abc123!";
				Connection conn=DriverManager.getConnection(url,user,password);
				String bh0=request.getParameter("bh");
				String sql0="select * from zgb where bh='"+bh0+"'";
				Statement stmt0=conn.createStatement();
				ResultSet rs0=stmt0.executeQuery(sql0);
				rs0.next();
				String xm0=rs0.getString("xm").trim();
				String xb0=rs0.getString("xb").trim();
				String bm0=rs0.getString("bm").trim();
				SimpleDateFormat sdf=new SimpleDateFormat();
				String csrq0=sdf.format(rs0.getDate("csrq"));
				String jbgz0=String.valueOf(rs0.getFloat("jbgz"));
				String gwjt0=String.valueOf(rs0.getFloat("gwjt"));
				rs0.close();
				stmt0.close();		
	 %>
	 <form id="form1" name="form1" method="post" action="">
	 	<table border="1">
	 	<tr><td>编号</td><td><input name="bh" type="text" id="bh" value="<%=bh0 %>" readonly="true"/></td></tr>
	 	<tr><td>姓名</td><td><input name="xm" type="text" id="xm" value="<%=xm0 %>"/></td></tr>
	 	<tr><td>性别</td><td>
	 	<input type="radio" name="xb" value="男"<%if(xb0.equals("男")){%> checked="checked" <%} %> disabled="disabled"/>男
		<input type="radio" name="xb" value="女"<%if(xb0.equals("女")){%> checked="checked" <%} %> disabled="disabled"/>女
	 	</td></tr>
	 <%
	 	String sql = "select * from bmb order by bmbh";
	 	Statement stmt=conn.createStatement();
	 	ResultSet rs=stmt.executeQuery(sql);
	  %>
	  	<tr><td>部门</td>
	  	<td><select name="bh" disabled="disabled">
	  <%
	  	while(rs.next()){
	  		String bmbh = rs.getString("bmbh").trim();
	  		String bmmc = rs.getString("bmmc").trim();
	  %>
	  	<option value="<%=bmbh %>"<%if(bm0.equals(bmbh)){ %>selected
	  	<%} %>><%=bmmc %></option>
	  <%
	  	}
	  	rs.close();
	  	stmt.close();
	  	conn.close();
	  %>
	  </select>
	  </td></tr>
	  <tr><td>出生日期</td><td><input name="csrq" type="text" id="csrq" value="<%=csrq0 %>"/></td></tr>
	  <tr><td>基本工资</td><td><input name="jbgz" type="text" id="jbgz" value="<%=jbgz0 %>"/></td></tr>
	  <tr><td>岗位津贴</td><td><input name="gwjt" type="text" id="gwjt" value="<%=gwjt0 %>"/></td></tr>
	  </table>
	  <br>
	  <a href="javascript:window.close()">[关闭]</a>
	  </form>
	  </div>
	</body>
</html>

ZgXg.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*" %>
<%request.setCharacterEncoding("gb2312");%>
<script language="JavaScript">
function check(theForm){
	if(theForm.bh.value.length!=7){
		alert("职工编号必须为7位！");
		theForm.bh.focus();
		return(false);
	}
	if(theForm.xm.value==""){
		alert("请输入姓名！");
		theForm.xm.focus();
		return(false);
	}
	if(theForm.csrq.value==""){
		alert("请输入出生日期！");
		theForm.csrq.focus();
		return(false);
	}
	if(theForm.jbgz.value==""){
		alert("请输入基本工资！");
		theForm.jbgz.focus();
		return(false);
	}
	if(theForm.gwjt.value==""){
		alert("请输入岗位津贴！");
		theForm.gwjt.focus();
		return(false);
	}
	return (true);
}
</script>
<html>
	<head><title>职工修改</title></head>
	<body>
	<div align="center">
	<p>职工修改</p>
	<%
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
		String user="sa";
		String password="abc123!";
		Connection conn=DriverManager.getConnection(url,user,password);
		String bh0=request.getParameter("bh").trim();
		String sql0="select * from zgb where bh='"+bh0+"'";
		Statement stmt0=conn.createStatement();
		ResultSet rs0=stmt0.executeQuery(sql0);
		rs0.next();
		String xm0=rs0.getString("xm").trim();
		String xb0=rs0.getString("xb").trim();
		String bm0=rs0.getString("bm").trim();
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		String csrq0=sdf.format(rs0.getDate("csrq"));
		String jbgz0=String.valueOf(rs0.getFloat("jbgz"));
		String gwjt0=String.valueOf(rs0.getFloat("gwjt"));
		rs0.close();
		stmt0.close();
	 %>
	 <form id="form1" name="form1" method="post" action="ZgXg0.jsp" onSubmit="return check(this)">
	 <table border="1">
	 <tr><td>编号</td><td><input name="bh" type="text" id="bh" value="<%=bh0 %>" readonly="true"/></td></tr>
	 <tr><td>姓名</td><td><input name="xm" type="text" id="xm" value="<%=xm0 %>"/></td></tr>
	 <tr><td>性别</td><td>
	 	<input type="radio" name="xb" value="男"<%if(xb0.equals("男")){%> checked="checked" <%} %>/>男
		<input type="radio" name="xb" value="女"<%if(xb0.equals("女")){%> checked="checked" <%} %>/>女
	</td></tr>
	<%
		String sql="select * from bmb order by bmbh";
		Statement stmt=conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql);
	 %>
	 <tr><td>部门</td>
	 <td><select name="bm">
	 <%
	 	while(rs.next()){
	 		String bmbh=rs.getString("bmbh").trim();
	 		String bmmc=rs.getString("bmmc").trim();
	  %>
	  <option value="<%=bmbh %>"<% if(bm0.equals(bmbh)){ %>selected
	  <%} %>><%=bmmc %></option>
	  <%
	  }
	  rs.close();
	  stmt.close();
	  conn.close();
	   %>
	 </select>
	 </td></tr>
	 <tr><td>出生日期</td><td><input name="csrq" type="text" id="csrq" value="<%=csrq0 %>"/></td></tr>
	  <tr><td>基本工资</td><td><input name="jbgz" type="text" id="jbgz" value="<%=jbgz0 %>"/></td></tr>
	  <tr><td>岗位津贴</td><td><input name="gwjt" type="text" id="gwjt" value="<%=gwjt0 %>"/></td></tr>
	 </table>
	 <br>
	 <input name="submit" type="submit" value="确定"/>
	 <input name="reset" type="reset" value="重置"/>
	 </form>
	 </div>
	</body>
</html>

ZgSc.jsp

%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%@page import="java.text.*" %>
<%request.setCharacterEncoding("gb2312");%>
<html>
	<head><title>职工删除</title></head>
	<body>
	<div align="center">
	<p>职工删除</p>
	<%
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
		String user="sa";
		String password="abc123!";
		Connection conn=DriverManager.getConnection(url,user,password);
		String bh0=request.getParameter("bh").trim();
		String sql0="select * from zb where bh='"+bh0+"'";
		Statement stmt0=conn.createStatement();
		ResultSet rs0=stmt0.executeQuery(sql0);
		rs0.next();
		String xm0=rs0.getString("xm").trim();
		String xb0=rs0.getString("xb").trim();
		String bm0=rs0.getString("bm").trim();
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		String csrq0=sdf.format(rs0.getDate("csrq"));
		String jbgz0=String.valueOf(rs0.getFloat("jbgz"));
		String gwjt0=String.valueOf(rs0.getFloat("gwjt"));
		rs0.close();
		stmt0.close();
	 %>
	 <form id="form1" name="form1" method="post" action="ZgSc0.jsp" onSubmit="return check(this)">
	 <table border="1">
	 <tr><td>编号</td><td><input name="bh" type="text" id="bh" value="<%=bh0 %>" readonly="true"/></td></tr>
	 <tr><td>姓名</td><td><input name="xm" type="text" id="xm" value="<%=xm0 %>"/></td></tr>
	 <tr><td>性别</td><td>
	 	<input type="radio" name="xb" value="男"<%if(xb0.equals("男")){%> checked="checked" <%} %>/>男
		<input type="radio" name="xb" value="女"<%if(xb0.equals("女")){%> checked="checked" <%} %>/>女
	</td></tr>
	<%
		String sql="select * from bmb order by bmbh";
		Statement stmt=conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql);
	 %>
	 <%
	 	while(rs.next()){
	 		String bmbh=rs.getString("bmbh").trim();
	 		String bmmc=rs.getString("bmmc").trim();
	  %>
	  <option value="<%=bmbh %>"<% if(bm0.equals(bmbh)){ %>selected
	  <%} %>><%=bmmc %></option>
	  <%
	  }
	  rs.close();
	  stmt.close();
	  conn.close();
	   %>
	   </select>
	 </td></tr>
	 <tr><td>出生日期</td><td><input name="csrq" type="text" id="csrq" value="<%=csrq0 %>"/></td></tr>
	  <tr><td>基本工资</td><td><input name="jbgz" type="text" id="jbgz" value="<%=jbgz0 %>"/></td></tr>
	  <tr><td>岗位津贴</td><td><input name="gwjt" type="text" id="gwjt" value="<%=gwjt0 %>"/></td></tr>
	 </table>
	 <br>
	 <input name="submit" type="submit" value="确定"/>
	 <input name="reset" type="reset" value="重置"/>
	 </form>
	 </div>
	</body>
</html>

ZgSc0.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head><title></title></head>
<body>
<%
	String bh=request.getParameter("bh");
	try{
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
		String user="sa";
		String password="abc123!";
		Connection conn=DriverManager.getConnection(url,user,password);
		String sql="delete from zgb";
		sql=sql+" where bh='"+bh+"'";
		Statement stmt=conn.createStatement();
		int n=stmt.executeUpdate(sql);
			if(n>0){
			 out.print("<script Language='JavaScript'>window.alert('职工记录删除成功')</script>");
			 out.print("<script Language='JavaScript'>window.location='ZgCx.jsp'</script>");
			}else{
				out.print("<script Language='JavaScript'>window.alert('职工记录删除失败')</script>");
				out.print("<script Language='JavaScript'>window.location='ZgCx.jsp'</script>");
			}
			stmt.close();
			conn.close();
		}catch(Exception e){
			out.print(e.toString());
		}
 %>
</body>
</html>

ZgXg0.jsp

<%@page contentType="text/html;charset=GB2312" language="java"%>
<%@page import="java.sql.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head><title></title></head>
<body>
<%
	String bh=request.getParameter("bh");
	String xm=request.getParameter("xm");
	String xb=request.getParameter("xb");
	String bm=request.getParameter("bm");
	String csrq=request.getParameter("csrq");
	String jbgz=request.getParameter("jbgz");
	String gwjt=request.getParameter("gwjt");
	try{
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String url="jdbc:sqlserver://localhost:1433;DatabaseName=rsgl";
			String user="sa";
			String password="abc123!";
			Connection conn=DriverManager.getConnection(url,user,password);
			String sql="update zgb set xm='"+xm+"',xb='"+xb+"',bm='"+bm+"'";
			sql=sql+",csrq='"+csrq+"',jbgz="+jbgz+",gwjt="+gwjt;
			sql=sql+"where bh='"+bh+"'";
			Statement stmt=conn.createStatement();
			int n=stmt.executeUpdate(sql);
			if(n>0){
			 out.print("<script Language='JavaScript'>window.alert('职工记录修改成功')</script>");
			 out.print("<script Language='JavaScript'>window.location='ZgCx.jsp'</script>");
			 
			}else{
				out.print("<script Language='JavaScript'>window.alert('职工记录修改失败')</script>");
				out.print("<script Language='JavaScript'>window.location='ZgCx.jsp'</script>");
			}
			stmt.close();
			conn.close();
		}catch(Exception e){
			out.print(e.toString());
		}
 %>
</body>
</html>

以下附上运行结果：
在这里插入图片描述

LYH&

关注

2
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
JSP+JDBC案例代码（数据维护）

本文主要用于最近记录最近学习时所用到的代码，使用时需先与数据库建立连接，导入sqjdbc4.jar包并在数据库中建立相应的表。ZgCx.jsp<%@page contentType="text/html;charset=GB2312" language="java"%><%@page import="java.sql.*"%><%request.set...
复制链接

扫一扫

专栏目录