【JSP开源代码栏目提醒】:网学会员为需要JSP开源代码的朋友们搜集整理了update-j7_3-2.jsp相关资料,希望对各位网友有所帮助!
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<HTML>
<HEAD>
<TITLE>上机题三</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>员工管理系统</FONT>
</CENTER>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为数据库的名称
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
//建立Statement对象
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String id = (String)request.getParameter("id");
String name = request.getParameter("name");
String sex=request.getParameter("sex");
int time = Integer.valueOf(request.getParameter("age"));
int salary = Integer.valueOf(request.getParameter("salary"));
//String sql = "delete * from stu_info where id =" + id;//删除符合条件的记录
String sql="update employee set em_name='" + name + "',em_sex='" + sex + "',em_time=" + time + ",em_salary=" + salary + " where em_id ='" + id + "'";
stmt.executeUpdate(sql);//执行sql语句
stmt.close();
conn.close();
%>
<center><h2 class="style1">修改员工信息</h2>
<p><br>
<span class="style2">该员工记录已经被修改!
</span></p>
<form name="form1" method="post" action="j7-3List.jsp">
<input type="submit" id="back" name="back" value="返回">
</form>
<p>
</p>
</center>
</BODY>
</HTML>