📄 test1.jsp

📁 一个自已编写的用JSP编写的简单的人事管理系统

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<% 
String username="ab";
String pass="bb";
String id="1";
String name="d";

String bm="d";
String sex="v";
String sr="v";
String mz="v";
String jg="v";
String jtcs="d";
String jbgz="rd";
String zw="fe";
String zc="zc";
String xl="xl";
String jfqk="jfqk";
String zyjl="zyjl";
String shjz="reque";
String sf="员工";
String str1=(String)session.getAttribute("flag");
//String str1=request.getParameter("flag");
out.println(str1);
if(str1.equals("1"))
{
	out.println("修改成功！");
}
username=request.getParameter("username");
/*if(session.getAttribute("username1")!=null)
{
username=(String)session.getAttribute("username1");

}
pass=(String)session.getAttribute("pass1");*/
//values('"+id+"','"+niname+"','"+name+"','"+shengfengzheng+"','"+sex+"','"+email+"')"
 String sql1="select * from people where id='"+username+"'and pass='"+pass+"'";
 out.println(sql1);
 out.println("<br>");
 String sql2="insert into people values('"+id+"','"+name+"','"+pass+"','"+sf+"','"+bm+"','"+sex+"','"+sr+"','"+mz+"','"+jg+"','"+jtcs+"','"+jbgz+"','"+zw+"','"+zc+"','"+xl+"','"+jfqk+"','"+zyjl+"','"+shjz+"')";
// String sql2="insert into people values('"+id+"','"+name+"')";
out.println(sql2);
 out.println("<br>");
//String sql="select * from people where username='"+username+"'";
String sql="select * from people where id='"+username+"'";
out.println(sql);
   %>
<body>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -