search
HomeJavajavaTutorial[JDBC] Android creates a mysql connection to perform regular operations of adding, deleting and modifying the database

This article introduces how Android connects to the mysql database to implement add, delete, modify and query operations.

Recommended related mysql video tutorials: "mysql tutorial"

The code is available for debugging by myself, you can refer to it.

The code is as follows:

package com.web.redrain;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import android.app.Activity;
import android.os.Bundle;
public class JDBC_Test extends Activity {
    // 创建静态全局变量
    static Connection conn;
    static Statement st;
    public void onCreate(Bundle savedInstanceState){
     super.onCreate(savedInstanceState);
     setContentView(R.layout.sound);
     insert();    //插入添加记录
      update();    //更新记录数据
      //   delete();    //删除记录
       //  query();
    }
    /* 插入数据记录,并输出插入的数据记录数*/
    public static void insert() {
        conn = getConnection();    // 首先要获取连接,即连接到数据库
       try {
            String sql = "INSERT INTO tb_user(username)"+ " VALUES ('Tom1')";    // 插入数据的sql语
            st = (Statement) conn.createStatement();    // 创建用于执行静态sql语句的Statement对象
            int count = st.executeUpdate(sql);    // 执行插入操作的sql语句,并返回插入数据的个
           System.out.println("向tb_user表中插入 " + count + " 条数据");    //输出插入操作的处理结果
             conn.close();    //关闭数据库连接
        } catch (SQLException e) {
            System.out.println("插入数据失败" + e.getMessage());
        }
    }
    /* 更新符合要求的记录,并返回更新的记录数目*/
    public static void update() {
        conn = getConnection();    //同样先要获取连接,即连接到数据库
       try {
               String sql = "update tb_user set username='见人' where username = 'Tom1'";// 更新数据的sql语句
               st = (Statement) conn.createStatement();    //创建用于执行静态sql语句的Statement对象,st属局部变量
               int count = st.executeUpdate(sql);// 执行更新操作的sql语句,返回更新数据的个数
               System.out.println("tb_user表中更新 " + count + " 条数据");        //输出更新操作的处理结果
               conn.close();    //关闭数据库连接
        } catch (SQLException e) {
                System.out.println("更新数据失败");
        }
     }
    /* 查询数据库,输出符合要求的记录的情况*/
     public static void query() {
        conn = getConnection();    //同样先要获取连接,即连接到数据库
        try {
                String sql = "select * from tb_user";        // 查询数据的sql语句
              st = (Statement) conn.createStatement();    //创建用于执行静态sql语句的Statement对象,st属局部变量
                 ResultSet rs = st.executeQuery(sql);    //执行sql查询语句,返回查询数据的结果集
              System.out.println("最后的查询结果为:");
                while (rs.next()) // 判断是否还有下一个数据
                  {
                   // 根据字段名获取相应的值
                 String name = rs.getString("username");
                    String sex = rs.getString("sex");
                    String question = rs.getString("question");
                    String answer = rs.getString("answer");
                    String email = rs.getString("email");
                    //输出查到的记录的各个字段的值
                  System.out.println(name + " " + sex + " " + question+ " " + answer + " " + email );
                }
               conn.close();    //关闭数据库连接
         } catch (SQLException e) {
                System.out.println("查询数据失败");
        }
    }
    /* 删除符合要求的记录,输出情况*/
    public static void delete() {
        conn = getConnection();    //同样先要获取连接,即连接到数据库
      try {
               String sql = "delete from tb_user where username = 'dd'";// 删除数据的sql语句
               st = (Statement) conn.createStatement();    //创建用于执行静态sql语句的Statement对象,st属局部变量
               int count = st.executeUpdate(sql);// 执行sql删除语句,返回删除数据的数量
                System.out.println("tb_user表中删除 " + count + " 条数据\n");    //输出删除操作的处理结果    
                conn.close();    //关闭数据库连接
        } catch (SQLException e) {
               System.out.println("删除数据失败");
         }
    }
    /* 获取数据库连接的函数*/
    public static Connection getConnection() {
         Connection con = null;    //创建用于连接数据库的Connection对象
      try {
                Class.forName("com.mysql.jdbc.Driver");// 加载Mysql数据驱动
                con = DriverManager.getConnection("jdbc:mysql://数据库ip:3306/数据库名称", "数据库用户名", "数据库密码");// 创建数据连接
         } catch (Exception e) {
                 System.out.println("数据库连接失败" + e.getMessage());
        }
        return con;    //返回所建立的数据库连接
   }
}

This article is provided by PHP Chinese website,

Article address: http://www.php.cn/java- article-377114.html

To learn programming, come to the PHP Chinese website www.php.cn

The above is the detailed content of [JDBC] Android creates a mysql connection to perform regular operations of adding, deleting and modifying the database. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
What aspects of Java development are platform-dependent?What aspects of Java development are platform-dependent?Apr 26, 2025 am 12:19 AM

Javadevelopmentisnotentirelyplatform-independentduetoseveralfactors.1)JVMvariationsaffectperformanceandbehavioracrossdifferentOS.2)NativelibrariesviaJNIintroduceplatform-specificissues.3)Filepathsandsystempropertiesdifferbetweenplatforms.4)GUIapplica

Are there performance differences when running Java code on different platforms? Why?Are there performance differences when running Java code on different platforms? Why?Apr 26, 2025 am 12:15 AM

Java code will have performance differences when running on different platforms. 1) The implementation and optimization strategies of JVM are different, such as OracleJDK and OpenJDK. 2) The characteristics of the operating system, such as memory management and thread scheduling, will also affect performance. 3) Performance can be improved by selecting the appropriate JVM, adjusting JVM parameters and code optimization.

What are some limitations of Java's platform independence?What are some limitations of Java's platform independence?Apr 26, 2025 am 12:10 AM

Java'splatformindependencehaslimitationsincludingperformanceoverhead,versioncompatibilityissues,challengeswithnativelibraryintegration,platform-specificfeatures,andJVMinstallation/maintenance.Thesefactorscomplicatethe"writeonce,runanywhere"

Explain the difference between platform independence and cross-platform development.Explain the difference between platform independence and cross-platform development.Apr 26, 2025 am 12:08 AM

Platformindependenceallowsprogramstorunonanyplatformwithoutmodification,whilecross-platformdevelopmentrequiressomeplatform-specificadjustments.Platformindependence,exemplifiedbyJava,enablesuniversalexecutionbutmaycompromiseperformance.Cross-platformd

How does Just-In-Time (JIT) compilation affect Java's performance and platform independence?How does Just-In-Time (JIT) compilation affect Java's performance and platform independence?Apr 26, 2025 am 12:02 AM

JITcompilationinJavaenhancesperformancewhilemaintainingplatformindependence.1)Itdynamicallytranslatesbytecodeintonativemachinecodeatruntime,optimizingfrequentlyusedcode.2)TheJVMremainsplatform-independent,allowingthesameJavaapplicationtorunondifferen

Why is Java a popular choice for developing cross-platform desktop applications?Why is Java a popular choice for developing cross-platform desktop applications?Apr 25, 2025 am 12:23 AM

Javaispopularforcross-platformdesktopapplicationsduetoits"WriteOnce,RunAnywhere"philosophy.1)ItusesbytecodethatrunsonanyJVM-equippedplatform.2)LibrarieslikeSwingandJavaFXhelpcreatenative-lookingUIs.3)Itsextensivestandardlibrarysupportscompr

Discuss situations where writing platform-specific code in Java might be necessary.Discuss situations where writing platform-specific code in Java might be necessary.Apr 25, 2025 am 12:22 AM

Reasons for writing platform-specific code in Java include access to specific operating system features, interacting with specific hardware, and optimizing performance. 1) Use JNA or JNI to access the Windows registry; 2) Interact with Linux-specific hardware drivers through JNI; 3) Use Metal to optimize gaming performance on macOS through JNI. Nevertheless, writing platform-specific code can affect the portability of the code, increase complexity, and potentially pose performance overhead and security risks.

What are the future trends in Java development that relate to platform independence?What are the future trends in Java development that relate to platform independence?Apr 25, 2025 am 12:12 AM

Java will further enhance platform independence through cloud-native applications, multi-platform deployment and cross-language interoperability. 1) Cloud native applications will use GraalVM and Quarkus to increase startup speed. 2) Java will be extended to embedded devices, mobile devices and quantum computers. 3) Through GraalVM, Java will seamlessly integrate with languages ​​such as Python and JavaScript to enhance cross-language interoperability.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)