乐码库:一个极速、放心、纯净的下载站! 更新: 资源发布
  • 您的位置:首页 > 技术文档 > JSP编程 > jsp+mysql数据库操作常用方法实例总结
  • 收藏本页
      jsp+mysql数据库操作常用方法实例总结
      发布时间:2016-12-21 07:55:27 关键词: jsp,mysql,数据库操作
      内容简介:这篇文章主要介绍了jsp+mysql数据库操作常用方法,以实例形式较为详细的总结了JSP操作mysql数据库实现基本的增、删、改、查相关技巧,具有一定参考借鉴价值,需要的朋友可以参考下

    本文实例讲述了jsp+mysql数据库操作常用方法。分享给大家供大家参考。具体如下:

    1. 查看:    

    <%@ page contentType="text/html;charset=GB2312" %> 
    <%@ page import="java.sql.*" %> 
    <HTML><style type="text/css">
    <!--
    body {
      background-color: #99CCFF;
    }
    -->
    </style> 
    <BODY>
    <font color="#FFFFFF"> 
    <center>
    <% Connection con; 
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
    Statement sql; 
    ResultSet rs; 
    try
    { 
    sql=con.createStatement(); 
    rs=sql.executeQuery("SELECT * FROM student");
    out.print("<Table Border style='font-size: 10pt'>"); 
    out.print("<TR><td colspan=5 align=center>考生数据</td></tr>"); 
    out.print("<TR><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>"); 
    out.print("<TR>"); 
    out.print("<Td width=50 >"+"姓名"); 
    out.print("<Td width=100 >"+"年龄"); 
    out.print("<Td width=100>"+"出生日期"); 
    out.print("<Td width=100 colspan=2>"+"操作"); 
    out.print("</TR>"); 
    while(rs.next()) 
    { out.print("<TR>"); 
    out.print("<TD >"+rs.getString(2)+"</TD>"); 
    out.print("<TD >"+rs.getString(3)+"</TD>"); 
    out.print("<TD >"+rs.getString(4)+"</TD>"); 
    String idstr=rs.getString(1);
    out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>"); 
    out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>"); 
    out.print("</TR>") ; 
    }
    out.print("</Table>"); 
    con.close(); 
    } 
    catch(SQLException e1) 
    { 
    out.print("SQL异常!!!!"); 
    } 
    %> 
    </center>
    </BODY> 
    </HTML>
    
    

    2. add 添加:

    <%@ page contentType="text/html;charset=gb2312" %>
    <HTML><HEAD>
    <style type="text/css">
    <!--
    body {
      background-image: url();
      background-color: #CCCCFF;
    }
    .STYLE5 {font-family: "Courier New", Courier, monospace; font-size: 14px; }
    .STYLE6 {
      font-family: "Courier New", Courier, monospace;
      font-size: 24px;
    }
    -->
    </style>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312"></HEAD>
    <BODY>
    <Font size=2>
    <p align="center" class="STYLE6">添加考生信息</p>
    <CENTER>
    <FORM action="insert.jsp" name=form>
    <table>
      <tr><td height="36"><span class="STYLE5">姓名:</span></td>
      <td><Input name="name" type=text size="15" ></td></tr>
      <tr>
       <td height="36"><span class="STYLE5">年龄:</span></td>
      <td><Input name="age" type=text size="15"></td></tr>
      <tr>
       <td height="36"><span class="STYLE5">出生年月:</span></td>
      <td><Input name="birth" type=text size="15"></td></tr>
     </table>
     <table width="165">
      <tr><td width="42" wnameth="42"><Input type=submit name="g" value="添加"></td>
       <td width="28" wnameth="50"> </td>
       <td width="42" wnameth="50"><Input type="reset" name="h" value="重置"></td>
       <td width="33" wnameth="42"> </td>
      </tr>
    </table>
    </Form></CENTER>
    </Body></HTML>
    
    

    3. delete 删除:

    <%@ page contentType="text/html;charset=gb2312" %> 
    <%@ page import="java.sql.*" %> 
    <html> 
    <head> 
    <title>删除操作</title> 
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
    <!--
    body {
      background-color: #FFCCFF;
    }
    -->
    </style></head> 
    <body> 
    <center>
    <% Connection con; 
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
    Statement stmt; 
    Statement s; 
    ResultSet rs; 
    String id=request.getParameter("id");
    try
    { 
    stmt=con.createStatement();
    String sql="delete from student where id="+id; 
    stmt.executeUpdate(sql); 
    s=con.createStatement(); 
    rs=s.executeQuery("SELECT * FROM student"); 
    out.print("<Table Border style='font-size: 10pt'>"); 
    out.print("<TR><td colspan=5 align=center>考生数据</td></tr>");
    out.print("<TR><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>"); 
    out.print("<TR>"); 
    out.print("<Td width=50 >"+"姓名"); 
    out.print("<Td width=100 >"+"年龄"); 
    out.print("<Td width=100>"+"出生日期"); 
    out.print("<Td width=100 colspan=2>"+"操作"); 
    out.print("</TR>"); 
    while(rs.next()) 
    { out.print("<TR>"); 
    out.print("<TD >"+rs.getString(2)+"</TD>"); 
    out.print("<TD >"+rs.getString(3)+"</TD>"); 
    out.print("<TD >"+rs.getString(4)+"</TD>"); 
    String idstr=rs.getString(1);
    out.print("<TD >"+idstr+"</TD>"); 
    out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>"); 
    out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>"); 
    out.print("</TR>") ; 
    } 
    out.print("</Table>"); 
    con.close(); 
    } 
    catch(SQLException e1) 
    { 
    out.print("SQL异常!!!!"); 
    } 
    %>
    </center>
    </body> 
    </html>
    
    

    4. update 示例1:

    <%@ 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>
    <style type="text/css">
    <!--
    body {
      background-color: #FFCCFF;
    }
    -->
    </style></head>
    <body>
    <%String id=request.getParameter("id");
     Connection con; 
     String name=null;
     String age=null;
     String birth=null;
     String id1=null;
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
    Statement sql; 
    ResultSet rs; 
    try
    { 
    sql=con.createStatement(); 
    rs=sql.executeQuery("SELECT * FROM student");
    while(rs.next()) 
    { 
     name=rs.getString(2);
     age=rs.getString(3);
     birth=rs.getString(4);
     id1=rs.getString(1);
    }
    con.close(); 
    } 
    catch(SQLException e1) 
    { 
    out.print("SQL异常!!!!"); 
    } 
    %>
    <center>
    <form action="update2.jsp">
    <center>
     <p>  </p>
     <p>姓名:
      <input name="name" type="text" size="15" value="<%=name%>">
     </p>
     <p>
     年龄:
      <input name="age" type="text" size="15" value="<%=age%>">
     </p>
     <p>出生日期:
      <input name="birth" type="text" size="15" value="<%=birth%>">
      <input name="id1" type="hidden" value="<%=id1%>" />
    </p>
     <p><input name="g" type="submit" value="修改">     <input name="h" type="reset" value="重置"></p>
    </form>
    </center>
    </body>
    </html>
    
    

    5. update 示例2:    

    <%@ page contentType="text/html;charset=gb2312" %>
    <%@ page import="java.sql.*" %> 
    <%
    String name=request.getParameter("name");
    String age=request.getParameter("age");
    String birth=request.getParameter("birth");
    String id1=request.getParameter("id1");
    System.out.println(id1);
    Connection con=null;
    try
    { 
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
    Statement sql; 
    sql=con.createStatement(); 
    String sql2="update student set name='"+name+"',age='"+age+"',birth='"+birth+"' where id="+id1;
    System.out.print(sql2);
    int s=sql.executeUpdate(sql2);
    }
    catch(Exception e){
    System.out.println(e);
    }
    %>
    恭喜你,修改成功!<br />
    <a href="chakan.jsp">查看</a>
    
    

    6. insert 插入

    <%@ page contentType="text/html;charset=gb2312" %>
    <%@ page import="java.sql.*" %> 
    <%
    String name=request.getParameter("name");
    String age=request.getParameter("age");
    String birth=request.getParameter("birth");
    Connection con=null;
    try
    { 
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
    Statement sql; 
    sql=con.createStatement(); 
    String sql2="insert into student(name,age,birth) values('"+name+"','"+age+"','"+birth+"')";
    System.out.print(sql2);
    int s=sql.executeUpdate(sql2);
    }
    catch(Exception e){
    System.out.println(e);
    }
    %>
    恭喜你,添加成功!<br />
    <a href="chakan.jsp">查看</a>
    
    

    7. 创建数据库

    /*
    MySQL Data Transfer
    Source Host: localhost
    Source Database: student
    Target Host: localhost
    Target Database: student
    Date: 2009-3-27 13:24:01
    */
    SET FOREIGN_KEY_CHECKS=0;
    create database student;
    use student;
    -- ----------------------------
    -- Table structure for student
    -- ----------------------------
    CREATE TABLE `student` (
     `id` int(11) NOT NULL auto_increment,
     `name` varchar(255) default NULL,
     `age` varchar(255) default NULL,
     `birth` varchar(255) default NULL,
     PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
    
    

    希望本文所述对大家的JSP程序设计有所帮助。

      最新更新
      热门排行榜