📄 fabugonggao2.jsp

📁 教师管理系统

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -