JSP实现列表增删

list.jsp

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>list.jsp</title>
</head>

<body>
<SCRIPT language="JavaScript">
function gotoEdit(id,name1,date1,salary){
 var id,name1,date1,salary; 
 form1.action = "edit.jsp?userID="+id+"&name1="+name1+"&date1="+date1+"&salary="+salary+"";
 form1.submit();
}
function gotoDel(id,name1,date1,salary){
 var id,name1,date1,salary; 
 form1.action = "del.jsp?userID="+id+"&name1="+name1+"&date1="+date1+"&salary="+salary+"";
 form1.submit();
}
</SCRIPT>
<%
//声明
Connection conn;
java.sql.Statement stmt;
ResultSet rslt;
//注册jdbc驱动程序
try{
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
 //连接数据库
 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspTest","sa","sa");
 //建立对驱动程序的引用
 stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
 //执行查询语句
 rslt = stmt.executeQuery("Select * from Tbl_user");  
%>
<form name="form1" method="post" action="">
  <table width="70%" border="2">
    <tr>
      <td width="12%" height="33">
        <div align="center">用户ID</div></td>
      <td width="17%"><div align="center">姓名</div></td>
      <td width="18%"><div align="center">出生日期</div></td>
      <td width="28%"><div align="center">工资</div></td>
      <td width="25%"><div align="center">操作</div></td>
    </tr>
    <%while(rslt.next()){
     String userId=rslt.getString(1);
     String name1=rslt.getString(2);
     String date1=(String)(rslt.getString(3)).substring(0,10);
     String salary=rslt.getString(4);
    %>  
    <tr>
      <td height="25">
        <div align="center"><%=userId%></div></td>
      <td><div align="center"><%=name1%></div></td>
      <td><div align="center"><%=date1%></div></td>
      <td><div align="center"><%=salary%></div></td>
      <td><div align="center">      
          <input type="button" name="Edit" value="编辑" οnclick=gotoEdit("<%=userId%>","<%=name1%>","<%=date1%>","<%=salary%>")>
          <input type="button" name="Delete" value="删除" οnclick=gotoDel("<%=userId%>","<%=name1%>","<%=date1%>","<%=salary%>")>
        </div></td>
    </tr>
    <%}%>   
  </table>
  <%
    if(conn!=null&&!conn.isClosed()){
     conn.close();
     conn=null;
    }    
   }catch(Exception e){
    e.printStackTrace();
   }
  %>
 </form>
<form name="form2" method="post" action="add.jsp">
   <input type="submit" name="Add" value="添加记录"> 
</form>
<p>&nbsp;</p>
</body>
</html>

add.jsp

<%@ page language="java" pageEncoding="GB2312" %>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>Lomboz JSP</title>
</head>
<body bgcolor="#FFFFFF">
<SCRIPT  language="JavaScript"> 
function  isValid(form1){ 
   if(form1.name1.value==""){
         alert("姓名不能为空!"); 
    form1.name1.focus();
             return  false;     
             }  else if(form1.name1.value.length>10){
      alert("姓名太长!");
     return false;
     }
    
  if(form1.salary.value<0||isNumberString(form1.salary.value,".1234567890")!=1 ){
   alert("工资栏为空或输入了负值或非法字符!");
   form1.salary.focus();
   return false;
  }
  
  //把表单里的值赋给相应变量
  name1=form1.name1.value;  
  
  if(form1.month1.value<10) month1="0"+form1.month1.value
  else month1=form1.month1.value;
  if(form1.day1.value<10) day1="0"+form1.day1.value
  else day1="0"+form1.day1.value;  
  date1=form1.year1.value+"-"+month1+"-"+day1;
    
  salary=form1.salary.value;
  
  //设置表单action
  form1.action="add_end.jsp?name1="+name1+"&date1="+date1+"&salary="+salary+"";
  form1.submit();
}
  
function isNumberString (InString,RefString)
{
if(InString.length==0) return (false);
for (Count=0; Count < InString.length; Count++)  {
 TempChar= InString.substring (Count, Count+1);
 if (RefString.indexOf (TempChar, 0)==-1) 
 return (false);
}
return (true);
}


//  if(form.replycontent.value==""){ 
    //     alert("内容不能为空!"); 
        //     return  false; 
            // }             
</SCRIPT>
<form name="form1" method="post" action="" >
  <table width="75%" border="0">
    <tr>
      <td>姓名</td>
      <td><input type="text" name="name1">
        * </td>
    </tr>
    <tr>
      <td>工资</td>
      <td><input type="text" name="salary">
        *</td>
    </tr>
    <tr>
      <td>出生日期</td>
      <td> <script language="JavaScript">
  function mydate(dateid,datename){ //Powered by yayap
  var dateid,datename,i;
  var j=1;
  document.write('<select name="'+datename+'" size="1">'+'onChange="'+'alert("ddd");'+'"');
  // <select name="select" size="1" onChange="alert(document.all.form1.select[selectedIndex].value)">
  if (dateid>1899) j=1900
  else i=j
  for (i=j;i<=dateid ;i++)
  {
  document.write('<option value="'+i+'">'+i+'</option>')
  };
  document.write('</select>');
  }
  mydate(2020,'year1');
  mydate(12,'month1');
  mydate(31,'day1');
  //document.write(document.all.form1.year1.options[selectedIndex].value);
  </script> </td>
    </tr>
    <tr>
      <td height="53"> <p align="right">&nbsp; </p>
        <p>&nbsp; </p>
        <p>&nbsp;</p></td>
      <td> <p align="left">
          <input type="button" name="Submit" value="提交" οnclick=isValid(form1)>
          <input type="button" name="Cancel" value="取消" οnclick="Javascript:form1.action='list.jsp';form1.submit();">
        </p>
        <p>&nbsp; </p>
        <p>&nbsp; </p></td>
    </tr>
  </table>
</form>
<p>&nbsp;</p>

</body>
</html>

 

add_end.jsp

 

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>list.jsp</title>
</head>

<body>
<%!long userId;String name1,date1;float salary;%>
<SCRIPT language="JavaScript">
function gotoAdd(name1,date1,salary){
  var name1,date1,salary; 
  form1.action = "add.jsp?name1="+name1+"&date1="+date1+"&salary="+salary+"";
  form1.submit();
 }
</SCRIPT>
<%
//声明
Connection conn;
java.sql.Statement stmt;
int rowCount;
//注册jdbc驱动程序
try{
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
 //连接数据库
 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspTest","sa","sa");
 //建立对驱动程序的引用
 stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
 //执行添加语句
 name1 = new String(request.getParameter("name1").getBytes("8859_1"),"GB2312");
 date1 = request.getParameter("date1");
 salary = Float.valueOf(request.getParameter("salary")).floatValue();
 String addReq = "INSERT INTO Tbl_user(Name,birthday,salary) VALUES (" + "'" + name1 + "'" + "," + "'" + date1 + "'" + "," + "'" + salary + "'"+")"; 
 rowCount = stmt.executeUpdate(addReq);
 if(rowCount>0){
 %>
 数据添加成功!
 <%}
 else{
 %>
 数据添加失败!
 <%}
 if(conn!=null&&!conn.isClosed()){
  conn.close();
  conn=null;
  }    
  }catch(Exception e){
  %>
 数据添加失败!
  <% 
    e.printStackTrace();
   }
%>

 </form>
<form name="form1" method="post" action="">
<input type="button" name="Add" value="返回插入" οnclick=gotoAdd("<%=name1%>","<%=date1%>","<%=salary%>")>
<input type="button" name="List" value="返回列表" οnclick="Javascript:form1.action='list.jsp';form1.submit();">  
 </form>
<p>&nbsp;</p>
</body>
</html>

 

del.jsp
<%@ page language="java" pageEncoding="GB2312" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>Lomboz JSP</title>
</head>
<body bgcolor="#FFFFFF">
<SCRIPT language="JavaScript">
function gotoDelEnd(form1){
 var id = form1.ID.value;
 form1.action = "del_end.jsp?userId="+id+"";
 form1.submit();
}
</SCRIPT>
<form name="form1" method="post" action=""  >
  <table width="75%" border="0">
    <tr>
      <td>用户</td>
      <td> <input type="text" name="ID" value="<%=request.getParameter
("userID")%>" readonly> </td>
    </tr>
    <tr>
      <td>姓名</td>
   <!--转换字符编码-->
      <td><input type="text" name="name1" value="<%=new String(request.
getParameter("name1").getBytes("8859_1"),"GB2312")%>" readonly>
        </td>
    </tr>
    <tr>
      <td>工资</td>
      <td><input type="text" name="salary" value="<%=request.getParameter
("salary")%>" readonly>
        </td>
    </tr>
    <tr>
      <td>出生日期</td>
      <td><input type="text" name="salary" value="<%=request.getParameter
("date1")%>" readonly>
        </td>
    </tr>
    <tr>
      <td height="53"> <p align="right">&nbsp; </p>
        <p>&nbsp; </p>
        <p>&nbsp;</p></td>
      <td> <p align="left">
          <input type="button" name="Submit" value="确认删除" οnclick=
gotoDelEnd(form1)>
          <input type="button" name="Cancel" value="取消删除"
οnclick="Javascript:form1.action='list.jsp';form1.submit();">
        </p>
        <p>&nbsp; </p>
        <p>&nbsp; </p></td>
    </tr>
  </table>
</form>
<p>&nbsp;</p>
</body>
</html>
----------------------------------------
del_end.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" 
import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>list.jsp</title>
</head>
<body>
<%
//声明
Connection conn;
java.sql.Statement stmt;
int rowCount;
//注册jdbc驱动程序
try{
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
 //连接数据库
 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;
DatabaseName=JspTest","sa","sa");
 //建立对驱动程序的引用
 stmt = conn.createStatement();
 //执行删除语句
 long userId = Long.valueOf(request.getParameter("userId")).longValue();
 
 String delReq = "DELETE FROM Tbl_user  WHERE Id=" +"'" + userId + "'"; 
 rowCount = stmt.executeUpdate(delReq);
 if(rowCount>0){
 %>
 数据删除成功!
 <%}
 else{
 %>
 数据删除失败!
 <%}
 if(conn!=null&&!conn.isClosed()){
  conn.close();
  conn=null;
  }    
  }catch(Exception e){
  %>
   数据删除失败!
  <%
     e.printStackTrace();
   }
%>
 </form>
<form name="form1" method="post" action="">
<input type="button" name="List" value="返回列表"
οnclick="Javascript:form1.action='list.jsp';form1.submit();">   
 </form>
<p>&nbsp;</p>
</body>
</html>

 

edit.jsp
<%@ page language="java" pageEncoding="GB2312" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>Lomboz JSP</title>
</head>
<body bgcolor="#FFFFFF">
<SCRIPT  language="JavaScript"> 
function  isValid(form1){
var id1,name1,month1,day1,date1,salary;
   if(form1.name1.value==""){
         alert("姓名不能为空!"); 
    form1.name1.focus();
             return  false;     
             }  else if(form1.name1.value.length>10){
      alert("姓名太长!");
     return false;
     }
    
  if(form1.salary.value<0||isNumberString(form1.salary.value,".1234567890")!=1 ){
   alert("工资栏为空或输入了负值或非法字符!");
   form1.salary.focus();
   return false;
  }
  //把表单里的值赋给相应变量
  id1=form1.ID.value;
  name1=form1.name1.value;
  
  if(form1.month1.value<10) month1="0"+form1.month1.value
  else month1=form1.month1.value;
  if(form1.day1.value<10) day1="0"+form1.day1.value
  else day1="0"+form1.day1.value;  
  date1=form1.year1.value+"-"+month1+"-"+day1;
    
  salary=form1.salary.value;
  
  //设置表单action
  form1.action="edit_end.jsp?userId="+id1+"&name1="+name1+"&date1=
"+date1+"&salary="+salary+"";
  form1.submit();
}
  
  function isNumberString (InString,RefString)
{
if(InString.length==0) return (false);
for (Count=0; Count < InString.length; Count++)  {
 TempChar= InString.substring (Count, Count+1);
 if (RefString.indexOf (TempChar, 0)==-1) 
 return (false);
}
return (true);
}

//  if(form.replycontent.value==""){ 
    //     alert("内容不能为空!"); 
        //     return  false; 
            // } 
             
</SCRIPT>
<form name="form1" method="post" action=""  >
  <table width="75%" border="0">
    <tr>
      <td>用户</td>
      <td> <input type="text" name="ID" value="<%=request.getParameter
("userID")%>" readonly> </td>
    </tr>
    <tr>
      <td>姓名</td>
   <!--转换字符编码-->
      <td><input type="text" name="name1" value="<%=new String(request.
getParameter("name1").getBytes("8859_1"),"GB2312")%>">
        * </td>
    </tr>
    <tr>
      <td>工资</td>
      <td><input type="text" name="salary" value="<%=request.getParameter
("salary")%>">
        *</td>
    </tr>
    <tr>
      <td>出生日期</td>
      <td> <script language="JavaScript">
  function mydate(dateid,datename,oldValue){ //Powered by yayap
  var dateid,datename,i,oldValue;
  var j=1;
  document.write('<select name="'+datename+'" size="1">'+'onChange="'+
'alert("ddd");'+'"');
  // <select name="select" size="1" onChange="alert(document.all.form1.
select[selectedIndex].value)">
  if (dateid>1899) j=1900
  else i=j
  for (i=j;i<=dateid ;i++)
  {if(i!=oldValue) document.write('<option value="'+i+'">'+i+'</option>')
     else  document.write('<option value="'+i+'" selected>'+i+'</option>')
  };
  document.write('</select>');
  }
  mydate(2020,'year1',<%=(String)(request.getParameter("date1")).
substring(0,4)%>);
  mydate(12,'month1',<%=(String)(request.getParameter("date1")).
substring(5,7)%>);
  mydate(31,'day1',<%=(String)(request.getParameter("date1")).
substring(8,10)%>);
  //document.write(document.all.form1.year1.options[selectedIndex].value);
  </script> </td>
    </tr>
    <tr>
      <td height="53"> <p align="right">&nbsp; </p>
        <p>&nbsp; </p>
        <p>&nbsp;</p></td>
      <td> <p align="left">
          <input type="button" name="Submit" value="提交"
οnclick=isValid(form1)>
          <input type="button" name="Cancel" value="取消"
οnclick="Javascript:form1.action='list.jsp';form1.submit();">
        </p>
        <p>&nbsp; </p>
        <p>&nbsp; </p></td>
    </tr>
  </table>
</form>
<p>&nbsp;</p>
</body>
</html>
-------------------------------
edit_end.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" 
import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>list.jsp</title>
</head>
<body>
<%!long userId;String name1,date1;float salary;%>
<SCRIPT language="JavaScript">
function gotoEdit(id,name1,date1,salary){
  var id,name1,date1,salary; 
  form1.action = "edit.jsp?userID="+id+"&name1="+name1+"&date1=
"+date1+"&salary="+salary+"";
  form1.submit();
 }
</SCRIPT>
<%
//声明
Connection conn;
java.sql.Statement stmt;
int rowCount;
//注册jdbc驱动程序
try{
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
 //连接数据库
 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;
DatabaseName=JspTest","sa","sa");
 //建立对驱动程序的引用
 stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.
CONCUR_READ_ONLY);
 //执行更新语句
 userId = Long.valueOf(request.getParameter("userId")).longValue();
 name1 = new String(request.getParameter("name1").getBytes("8859_1"),"GB2312");
 date1 = request.getParameter("date1");
 salary = Float.valueOf(request.getParameter("salary")).floatValue();
 String updateReq = "UPDATE Tbl_user SET " + " Name=" + "'" + name1 + "'"
+ "," + " birthday=" +"'" + date1 + "'" + "," + " salary=" +"'" + salary 
+ "'" + " WHERE Id=" +"'" + userId + "'"; 
 rowCount = stmt.executeUpdate(updateReq);
 if(rowCount>0){
 %>
 数据更新成功!
 <%}
 else{
 %>
 数据更新失败!
 <%}
 if(conn!=null&&!conn.isClosed()){
  conn.close();
  conn=null;
  }    
  }catch(Exception e){
 %>
 数据更新失败!
 <%
    e.printStackTrace();
   }
%>
 </form>
<form name="form1" method="post" action="">
<input type="button" name="Edit" value="返回编辑"
οnclick=gotoEdit("<%=userId%>","<%=name1%>","<%=date1%>","<%=salary%>")> 
<input type="button" name="List" value="返回列表"
οnclick="Javascript:form1.action='list.jsp';form1.submit();">   
 </form>
<p>&nbsp;</p>
</body>
</html>

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值