fabugonggao2.jsp

来自「教师管理系统」· JSP 代码 · 共 44 行

JSP
44
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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=gb2312">
<title>无标题文档</title>
</head>

<body>
<%! public String getString(String s)
{if(s==null) s="";
try {byte a[]=s.getBytes("ISO-8859-1");
          s=new String(a);
		  }
		  catch(Exception e)
		  {}
		  return s;
		  } 
		   String gonggao=request.getParameter("gonggao");
     gonggao=getString(gonggao);
	   if(gonggao==null)
            {gonggao="";}
 Connection con=null;
  Statement sql=null;
  ResultSet rs=null;
      try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
      catch(ClassNotFoundException event) { }
  try {  
        con=DriverManager.getConnection("jdbc:odbc:sun","sa","hehong");
        sql=con.createStatement();
        String condition=
        "INSERT INTO teacher VALUES"+"("+"'"+tcode+"','"+tname+"','"+password1+"','"+tsex+"','"+tzhiwei+"','"+tzhicheng+"','"+tjiguang+"','"+tage+"','"+txueli+"','"+tyuanxiao+"','"+tminzhu+"','"+tdizhi+"','"+tdianhua+"','"+tdepartment+"','"+tgeyan+"','"+tqingkuang+"','1')";
		
		
         rs=sql.executeQuery("select * from teacher where tcode="+"'"+tcode+"'");
%>
<%     
    con.close();
    }
    catch(SQLException e) { }
%>
</body>
</html>

⌨️ 快捷键说明

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