⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 emp_mod_mod.jsp

📁 很不错的！！大家可以试试！！！D:学习专业课程设计成果OA.rar
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 


<html><style type="text/css">
<!--
body {
	background-color: #6699CC;
}
-->
</style>
<body>
<%
String emp_id=request.getParameter("emp_id");

String newEmp_name=request.getParameter("emp_name");
if (newEmp_name==null)
{newEmp_name="";}

String newDepartment_name=request.getParameter("department_name");
if (newDepartment_name==null)
{newDepartment_name="";}

String newDuty=request.getParameter("duty");
if (newDuty==null)
{newDuty="";}

String newEmp_sex=request.getParameter("emp_sex");
if (newEmp_sex==null)
{newEmp_sex="";}

String newNation=request.getParameter("nation");
if (newNation==null)
{newNation="";}

String newBirthday=request.getParameter("birthday");
if (newBirthday==null)
{newBirthday="";}

String newId_number=request.getParameter("id_number");
if (newId_number==null)
{newId_number="";}

String newTelephone=request.getParameter("telephone");
if (newTelephone==null)
{newTelephone="";}

String newAddress=request.getParameter("address");
if (newAddress==null)
{newAddress="";}
String newCollege_degree=request.getParameter("college_degree");
if (newCollege_degree==null)
{newCollege_degree="";}

String newEnter_time=request.getParameter("enter_time");
if (newEnter_time==null)
{newEnter_time="";}

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=oa110";
String user="sa"; 
String password=""; 
String sql = "";
Connection conn=DriverManager.getConnection(url,user,password); 

Statement stmt=conn.createStatement();
sql="update emp_info set emp_name='"+newEmp_name+"',department_name='"+newDepartment_name+"',duty='"+newDuty+"',emp_sex='"+newEmp_sex+"',nation='"+newNation+"',birthday='"+newBirthday+"',id_number='"+newId_number+"',telephone='"+newTelephone+"',address='"+newAddress+"',college_degree='"+newCollege_degree+"',enter_time='"+newEnter_time+"' where  emp_id="+emp_id;
stmt.executeUpdate(sql);

%>
<p>??????????:
<% 
ResultSet rs=stmt.executeQuery("select * from emp_info order by emp_id");
out.print("<table border>");
out.print("<tr>");
    
	  out.print("<th width=100>"+"ID(??) ");
    out.print("<th width=100>"+"??");
    out.print("<th width=100>"+"????");
    out.print("<th width=100>"+"??");
    out.print("<th width=100>"+"??");
    out.print("<th width=100>"+"??");
	  out.print("<th width=100>"+"????");
	  out.print("<th width=100>"+"??");
	  out.print("<th width=100>"+"????");
	  out.print("<th width=100>"+"??");
	  out.print("<th width=100>"+"??");
	  out.print("<th width=100>"+"??????");
	  
	  
	  out.print("</tr>");
    while ( rs.next() ) 
    { out.print("<tr>");
        out.print("<td>"+rs.getInt(1)+"</td>");
		out.print("<td>"+rs.getString(2)+"</td>");
		out.print("<td>"+rs.getString(3)+"</td>");
		out.print("<td>"+rs.getString(4)+"</td>");
		out.print("<td>"+rs.getString(5)+"</td>");
		out.print("<td>"+rs.getString(6)+"</td>");
	   out.print("<td>"+rs.getString(7)+"</td>");
	   out.print("<td>"+rs.getString(8)+"</td>");
	   out.print("<td>"+rs.getString(9)+"</td>");
	   out.print("<td>"+rs.getString(10)+"</td>");
	   out.print("<td>"+rs.getString(11)+"</td>");
	   out.print("<td>"+rs.getString(12)+"</td>");
out.print("</tr>");
}
out.print("</table>");
rs.close();
stmt.close();
conn.close();

%>
<p><a href="emp_mod.jsp">返回</p>
</body>

</html>

⌨️ 快捷键说明

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