思享工具箱

在servlet连接mysql下的最简单增删查改

摘要：
)“；stmt=conn.prepareStatement；stmt.setString；stmt.set String；stmt.executeUpdate（）；System.out.println；//out.flush（）；//out.close（）；}catch｛e.printStackTrace（）；｝catch｛e.printStack Trace（！

添加

package com.jquery.register;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class add extends HttpServlet {

    public void destroy() {
        super.destroy(); 
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        request.setCharacterEncoding("utf-8"); 
         response.setCharacterEncoding("utf-8");
         Connection conn = null;
         PreparedStatement stmt = null;
         ResultSet rs = null;
         String name="li";
         String password="12345";
         String drive = "com.mysql.jdbc.Driver";
         System.out.println("ajax后台交互成功");  
         try{
             Class.forName(drive);
             conn = DriverManager
                     .getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123");
             System.out.println("数据库连接成功");
             String sql="insert  into user_table(name,password)";
             sql+=" values(?,?)";
             stmt = conn.prepareStatement(sql);
             stmt.setString(1,name);
             stmt.setString(2,password);
             stmt.executeUpdate();
             System.out.println("success");
//        out.flush();
//        out.close();
    }catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                //注意关闭原则：从里到外
                    if (rs != null) {
                        rs.close();
                    }
                    if (stmt != null) {
                        stmt.close();
                    }
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
    }
    public void init() throws ServletException {
        // Put your code here
    }

}

删除

package com.jquery.register;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class delete extends HttpServlet {

    public void destroy() {
        super.destroy();
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        request.setCharacterEncoding("utf-8");
         response.setCharacterEncoding("utf-8");
         Connection conn = null;
         PreparedStatement stmt = null;
         ResultSet rs = null;
         String drive = "com.mysql.jdbc.Driver";
         System.out.println("ajax后台交互成功");  
         try{
             Class.forName(drive);
             conn = DriverManager
                     .getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123");
             System.out.println("数据库连接成功");
             String sql="delete  from user_table where name='zhang'";
             stmt = conn.prepareStatement(sql);
             stmt.executeUpdate();
             System.out.println("success");
//        out.flush();
//        out.close();
    }catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                //注意关闭原则：从里到外
                    if (rs != null) {
                        rs.close();
                    }
                    if (stmt != null) {
                        stmt.close();
                    }
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
    }
    public void init() throws ServletException {
        // Put your code here
    }

}

查找

package com.jquery.register;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class search extends HttpServlet {

    public void destroy() {
        super.destroy(); 
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        request.setCharacterEncoding("utf-8"); 
         response.setCharacterEncoding("utf-8");
         Connection conn = null;
         PreparedStatement stmt = null;
         ResultSet rs = null;
         
         String drive = "com.mysql.jdbc.Driver";
         System.out.println("ajax后台交互成功");  
         try{
             Class.forName(drive);
             conn = DriverManager
                     .getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123");
             System.out.println("数据库连接成功");
             String sql="select  *  from user_table ";
             
             stmt = conn.prepareStatement(sql);
             
             rs=stmt.executeQuery();
             
             System.out.println("success");
             while(rs.next()){
                 String name = rs.getString(1);
                String password = rs.getString(2);
                System.out.println(name + ", " + password);
             }
//        out.flush();
//        out.close();
    }catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                //注意关闭原则：从里到外
                    if (rs != null) {
                        rs.close();
                    }
                    if (stmt != null) {
                        stmt.close();
                    }
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
    }
    public void init() throws ServletException {
        // Put your code here
    }

}

在servlet连接mysql下的最简单增删查改第1张

修改

package com.jquery.register;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class update extends HttpServlet {

    public void destroy() {
        super.destroy(); 
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        request.setCharacterEncoding("utf-8"); 
         response.setCharacterEncoding("utf-8");
         Connection conn = null;
         PreparedStatement stmt = null;
         ResultSet rs = null;
         String password="654321";
         String drive = "com.mysql.jdbc.Driver";
         System.out.println("ajax后台交互成功");  
         try{
             Class.forName(drive);
             conn = DriverManager
                     .getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123");
             System.out.println("数据库连接成功");
             String sql="update user_table set password='"+password+"' where name='li'";
             
             stmt = conn.prepareStatement(sql);
             
             stmt.executeUpdate();
             
             System.out.println("success");
             
//        out.flush();
//        out.close();
    }catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                //注意关闭原则：从里到外
                    if (rs != null) {
                        rs.close();
                    }
                    if (stmt != null) {
                        stmt.close();
                    }
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
    }
    public void init() throws ServletException {
        // Put your code here
    }

}

在servlet连接mysql下的最简单增删查改第2张

标签：#mysql#response#mysql数据库 | 浏览：118 | 发布日期：

免责声明：文章转载自《在servlet连接mysql下的最简单增删查改》仅用于学习参考。如对内容有疑问，请及时联系本站处理。

上篇深度分析：高并发系统架构设计原理,史上最全系列！078_<laber>标签有什么作用？下篇

宿迁高防，2C2G15M，22元/月；香港BGP，2C5G5M，25元/月 雨云优惠码：MjYwNzM=

相关文章

MySQL数据库高并发优化配置

在Apache, PHP, mysql的体系架构中，MySQL对于性能的影响最大，也是关键的核心部分。对于Discuz!论坛程序也是如此，MySQL的设置是否合理优化，直接 影响到论坛的速度和承载量！同时，MySQL也是优化难度最大的一个部分，不但需要理解一些MySQL专业知识，同时还需要长时间的观察统计并且根据经验 进行判断，然后设置合理的参数。...

Mysql批量更新的一个坑-&allowMultiQueries=true允许批量更新

前言        实际上，我们经常会遇到这样的需求，那就是利用Mybatis批量更新或者批量插入，但是，实际上即使Mybatis完美支持你的sql，你也得看看你说操作的数据库是否支持，而阿福，最近就遇到这样的一个坑。 问题        先带大家来看一段sql的配置， <update id="updateAllAvailable"> <...

基于Boost库的HTTP Post函数

两个函数的区别： 提交表单数据和提交文本数据 表单数据： request_stream << "Content-Type: application/x-www-form-urlencoded "; 文本数据： request_stream << "Content-Type: text/html "; #include <i...

Jsp基础知识

Jsp:Java Server Pages http://127.0.0.1:8080/weba/hello.html Tomcat执行过程： 浏览器通过http协议发送请求，以TCP协议作为底层，去tomcat的安装目录下找到webapps下的weba文件夹，再继续找到hello.html. http协议有协议头和协议头，底层是TCP，是无状态的，两次连...

Mariadb 修改 Root 密码

默认情况下，新安装的 mariadb 的密码为空，在shell终端直接输入 mysql 就能登陆数据库。 如果是刚安装第一次使用，请使用 mysql_secure_installation 命令初始化。 # mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMM...

【MySQL笔记】mysql来源安装/配置步骤和支持中国gbk/gb2312编码配置

不久的学习笔记。分享。我想有很大的帮助谁刚开始学习其他人的 备注：该票据于mysql-5.1.73版本号例如 1. mysql源代码编译/安装步骤 1) 官网下载mysql源代码并解压 2) cd至源代码文件夹。运行 ./configure --prefix=/home/slvher/tools/mysql-5.1.73 --with-charset=...

最新文章

随机推荐

思享工具箱导航