📄 qx_update.jsp

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

<body background="picture/qx.jpg">
<font color="#0066FF">
<%!
  public String getStr(String str){
  try{
     String temp_p=str;
     String temp=new String(temp_p.getBytes("iso-8859-1"),"gb2312");
     return temp;
  }
  catch(Exception e){}
    return "NULL";
 }
%>  

<%
String username="";
username= request.getParameter("username");
//out.print(username);
String s = "";

String drivername="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=oa110;user=sa;password=;";
Connection conn=null;
Statement state=null;


Class.forName(drivername);


conn = DriverManager.getConnection(url);

state = conn.createStatement();
int rsint=0;


String checkbox3=request.getParameter("checkbox3");
if(checkbox3==null)
{
s="update user_login set use_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set use_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox4=request.getParameter("checkbox4");
if(checkbox4==null)
{
s="update user_login set use_delete=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set use_delete=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox5=request.getParameter("checkbox5");
if(checkbox5==null)
{
s="update user_login set use_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set use_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox6=request.getParameter("checkbox6");
if(checkbox6==null)
{
s="update user_login set use_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set use_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox7=request.getParameter("checkbox7");

if(checkbox7==null)
{
s="update user_login set org_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set org_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox8=request.getParameter("checkbox8");

if(checkbox8==null)
{

s="update user_login set org_delete=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set org_delete=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox9=request.getParameter("checkbox9");

if(checkbox9==null)
{
s="update user_login set org_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set org_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



String checkbox10=request.getParameter("checkbox10");

if(checkbox10==null)
{
s="update user_login set org_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set org_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



String checkbox11=request.getParameter("checkbox11");

if(checkbox11==null)
{

s="update user_login set rec_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set rec_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox12=request.getParameter("checkbox12");

if(checkbox12==null)
{

s="update user_login set arr_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set arr_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox13=request.getParameter("checkbox13");

if(checkbox13==null)
{

s="update user_login set rec_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set rec_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox14=request.getParameter("checkbox14");

if(checkbox14==null)
{

s="update user_login set arr_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set arr_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox15=request.getParameter("checkbox15");

if(checkbox15==null)
{

s="update user_login set sch_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sch_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



String checkbox16=request.getParameter("checkbox16");

if(checkbox16==null)
{

s="update user_login set sch_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sch_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



String checkbox17=request.getParameter("checkbox17");

if(checkbox17==null)
{

s="update user_login set sch_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sch_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);





String checkbox18=request.getParameter("checkbox18");

if(checkbox18==null)
{

s="update user_login set com_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set com_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);





String checkbox19=request.getParameter("checkbox19");

if(checkbox19==null)
{

s="update user_login set com_delete=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set com_delete=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox20=request.getParameter("checkbox20");

if(checkbox20==null)
{

s="update user_login set com_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set com_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox21=request.getParameter("checkbox21");

if(checkbox21==null)
{

s="update user_login set sup_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sup_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);





String checkbox22=request.getParameter("checkbox22");

if(checkbox22==null)
{

s="update user_login set sup_del=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sup_del=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox23=request.getParameter("checkbox23");
if(checkbox23==null)
{

s="update user_login set sup_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sup_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox24=request.getParameter("checkbox24");
if(checkbox24==null)
{

s="update user_login set sup_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set sup_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox25=request.getParameter("checkbox25");
if(checkbox25==null)
{

s="update user_login set mat_add=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set mat_add=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



String checkbox26=request.getParameter("checkbox26");
if(checkbox26==null)
{

s="update user_login set mat_del=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set mat_del=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox27=request.getParameter("checkbox27");
if(checkbox27==null)
{

s="update user_login set mat_update=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set mat_update=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox28=request.getParameter("checkbox28");
if(checkbox28==null)
{

s="update user_login set mat_query=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set mat_query=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);




String checkbox29=request.getParameter("checkbox29");
if(checkbox29==null)
{

s="update user_login set modify=0 where username"+"="+"'"+username+"'";
}
else
{
s="update user_login set modify=1 where username"+"="+"'"+username+"'";
}
rsint=state.executeUpdate(s);



//rsint.close();
state.close();
conn.close();



%>


</font>
<p>
  <font color="#0066FF"><a href="index.jsp"><font size="7" >修改完成!!!</font></a>
  </font>
<p>

</body>
</html>
⌨️ 快捷键说明

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