jsp中插入修改删除语句的写法------供大家参考一下

1.查询语句

 <%
 String url="jdbc:odbc:happy";
 String user="sa";
 String pw="root";
 Connection con=DriverManager.getConnection(url, user,pw);
 Statement st=con.createStatement(
 ResultSet.TYPE_SCROLL_SENSITIVE,
 ResultSet.CONCUR_READ_ONLY);
 String sql="select * from info";
 ResultSet rs=st.executeQuery(sql);
 rs.last();
   %>
   <br>   <br>   <br>   <br>   <br>
   你要查询的学生数据表共有：
   <font size="5" color="red"><%=rs.getRow() %> </font>人
   <table border="2" bgcolor="ccceee" width="600">
   <tr>
     <th>记录条数</th>
     <th>学号</th>
     <th>姓名</th>
     <th>性别</th>
     <th>年龄</th>
     <th>体重</th>
   </tr>
   <%rs.beforeFirst();
   while(rs.next()){
    %>
    <tr align="center">
    <td><%=rs.getRow()%></td>
    <td><%=rs.getString(1)%></td>
     <td><%=rs.getString(2)%></td>
      <td><%=rs.getString(3)%></td>
       <td><%=rs.getString(4)%></td>
        <td><%=rs.getString(5)%></td>
          
    </tr>
   <%
   }
   rs.close();
   st.close();
   con.close();
  
    %>
    
   2删除语句

<%
 String url="jdbc:odbc:happy";
 String user="sa";
 String pw="root";
 Connection con=DriverManager.getConnection(url, user,pw);
 Statement stmt =con.createStatement();
 String id=request.getParameter("id");
 byte b[]=id.getBytes("ISO-8859-1");
 id=new String(b,"utf-8");
 String sql="delete from info where id="+id;
 stmt.executeUpdate(sql); %>
 <center>
 <h2>删除学生信息</h2>
 <p>该学生记录已经被删除！</p>

 

3插入语句

  <%
    String id=request.getParameter("id");
    byte b[]=id.getBytes("ISO-8859-1");//把上页获得的数据（默认是ISO-8859-1）转换成utf_8形势
    id=new String(b,"utf-8");
    String name=request.getParameter("name");
    byte b1[]=name.getBytes("ISO-8859-1");
    name=new String(b1,"utf-8");
    String sex=request.getParameter("sex");
    byte b2[]=sex.getBytes("ISO-8859-1");
    sex=new String(b2,"utf-8");
    String age=request.getParameter("age");
    byte b3[]=age.getBytes("ISO-8859-1");
    age=new String(b3,"utf-8");
    String tizhong=request.getParameter("tizhong");
    byte b4[]=tizhong.getBytes("ISO-8859-1");//防止乱码
    tizhong=new String(b4,"utf-8");
    String url="jdbc:odbc:happy";
 String user="sa";
 String pw="root";
 Connection con=DriverManager.getConnection(url, user,pw);
 Statement st=con.createStatement();
 String sql="insert into info values('"+id+"','"+name+"','"+sex+"','"+age+"','"+tizhong+"')";
 st.executeUpdate(sql);
 st.close();
 con.close();
     %>

4修改语句

 <%
    String id=request.getParameter("id");
    byte b[]=id.getBytes("ISO-8859-1");
    id=new String(b,"utf-8");
    String name=request.getParameter("name");
    byte b1[]=name.getBytes("ISO-8859-1");
    name=new String(b1,"utf-8");
    String sex=request.getParameter("sex");
    byte b2[]=sex.getBytes("ISO-8859-1");
    sex=new String(b2,"utf-8");
    String age=request.getParameter("age");
    byte b3[]=age.getBytes("ISO-8859-1");
    age=new String(b3,"utf-8");
    String tizhong=request.getParameter("tizhong");
    byte b4[]=tizhong.getBytes("ISO-8859-1");
    tizhong=new String(b4,"utf-8");
    String url="jdbc:odbc:happy";
 String user="sa";
 String pw="root";
 Connection con=DriverManager.getConnection(url, user,pw);
 Statement st=con.createStatement();
 String sql1="UPDATE info SET name = "+"'"+name+"'"+" WHERE id="+"'"+id+"'";
  String sql2="UPDATE info SET sex = "+"'"+sex+"'"+" WHERE id="+"'"+id+"'";
  String sql3="UPDATE info SET age = "+"'"+age+"'"+" WHERE id="+"'"+id+"'";
 String sql4="UPDATE info SET tizhong = "+"'"+tizhong+"'"+" WHERE id="+"'"+id+"'";
 st.executeUpdate(sql1);
 st.executeUpdate(sql2);
 st.executeUpdate(sql3);
 st.executeUpdate(sql4);
 st.close();
 con.close();
     %>