


How to implement a simple electronic signature function using MySQL and Java
Sep 20, 2023 pm 01:12 PMHow to use MySQL and Java to implement a simple electronic signature function
Introduction:
In our daily lives, electronic signatures are becoming more and more common. It can be used in various situations, such as electronic contracts, electronic receipts and authorization documents, etc. This article will introduce how to use MySQL and Java to implement a simple electronic signature function, and provide specific code examples.
1. Create a database table
First, we need to create a table in MySQL to store electronic signature data. We create a table named "signature", which contains the following fields:
- id: The unique identifier of the signature record, which is an auto-incrementing primary key.
- name: The name of the signer.
- signature: Stores the binary data of the signature.
- date: Date and time of signature.
CREATE TABLE signature (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
signature LONGBLOB,
date DATETIME
);
2. Implement Java code
Next, we will use Java to implement the electronic signature function. We use Java's Swing library to create the user interface. Here is a simple sample code:
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql .*;
import javax.swing.*;
public class ElectronicSignature extends JFrame {
private JTextArea signatureTextArea;
private JButton saveButton;
public ElectronicSignature() {
// 設(shè)置窗口標(biāo)題 super("電子簽名"); // 創(chuàng)建界面元素 signatureTextArea = new JTextArea(10, 20); saveButton = new JButton("保存簽名"); // 添加按鈕點(diǎn)擊事件監(jiān)聽器 saveButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { saveSignature(); } }); // 添加界面元素到窗口布局 setLayout(new FlowLayout()); add(signatureTextArea); add(saveButton); // 設(shè)置窗口大小、可見性和關(guān)閉操作 setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setSize(300, 200); setVisible(true);
}
private void saveSignature() {
try { // 獲取連接數(shù)據(jù)庫的URL、用戶名和密碼 String url = "jdbc:mysql://localhost:3306/database_name"; String user = "username"; String password = "password"; // 建立數(shù)據(jù)庫連接 Connection conn = DriverManager.getConnection(url, user, password); // 創(chuàng)建SQL語句 String sql = "INSERT INTO signature (name, signature, date) VALUES (?, ?, ?)"; // 創(chuàng)建預(yù)編譯的語句 PreparedStatement pstmt = conn.prepareStatement(sql); // 設(shè)置參數(shù)值 pstmt.setString(1, ""); pstmt.setBytes(2, signatureTextArea.getText().getBytes()); pstmt.setTimestamp(3, new Timestamp(System.currentTimeMillis())); // 執(zhí)行SQL語句 pstmt.executeUpdate(); // 關(guān)閉預(yù)編譯的語句和數(shù)據(jù)庫連接 pstmt.close(); conn.close(); // 提示保存成功信息 JOptionPane.showMessageDialog(this, "簽名保存成功。"); } catch (Exception ex) { // 處理異常 ex.printStackTrace(); JOptionPane.showMessageDialog(this, "簽名保存失敗。"); }
}
public static void main(String[] args) {
new ElectronicSignature();
}
}
Code analysis:
- In the saveSignature method, we first get the connection to the MySQL database, then create an INSERT statement, and add the signature text and The current time is set as the parameter value. Finally, we execute the SQL statement and close the connection.
- If the save is successful, a prompt box will pop up to display the successful save information. Otherwise, a prompt box will pop up to display a message indicating that the save failed.
3. Run the code
Now, we can run the Java code and enter the signature content in the generated window. When we click on the "Save Signature" button, the signature will be saved to the MySQL database. If the save is successful, a prompt box will pop up to display the message that the save was successful; otherwise, a prompt box will pop up to display the message that the save failed.
Summary:
This article introduces how to use MySQL and Java to implement a simple electronic signature function. We created a data table named "signature" and created a window interface using Java's Swing library. By entering the signature content and clicking the "Save Signature" button, the signature will be saved to the MySQL database. With this example, you can further extend this functionality, integrate it with other applications, and refine the electronic signature functionality based on your actual needs.
The above is the detailed content of How to implement a simple electronic signature function using MySQL and Java. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

There are three common methods to traverse Map in Java: 1. Use entrySet to obtain keys and values at the same time, which is suitable for most scenarios; 2. Use keySet or values to traverse keys or values respectively; 3. Use Java8's forEach to simplify the code structure. entrySet returns a Set set containing all key-value pairs, and each loop gets the Map.Entry object, suitable for frequent access to keys and values; if only keys or values are required, you can call keySet() or values() respectively, or you can get the value through map.get(key) when traversing the keys; Java 8 can use forEach((key,value)->

In Java, Comparable is used to define default sorting rules internally, and Comparator is used to define multiple sorting logic externally. 1.Comparable is an interface implemented by the class itself. It defines the natural order by rewriting the compareTo() method. It is suitable for classes with fixed and most commonly used sorting methods, such as String or Integer. 2. Comparator is an externally defined functional interface, implemented through the compare() method, suitable for situations where multiple sorting methods are required for the same class, the class source code cannot be modified, or the sorting logic is often changed. The difference between the two is that Comparable can only define a sorting logic and needs to modify the class itself, while Compar

MySQL query performance optimization needs to start from the core points, including rational use of indexes, optimization of SQL statements, table structure design and partitioning strategies, and utilization of cache and monitoring tools. 1. Use indexes reasonably: Create indexes on commonly used query fields, avoid full table scanning, pay attention to the combined index order, do not add indexes in low selective fields, and avoid redundant indexes. 2. Optimize SQL queries: Avoid SELECT*, do not use functions in WHERE, reduce subquery nesting, and optimize paging query methods. 3. Table structure design and partitioning: select paradigm or anti-paradigm according to read and write scenarios, select appropriate field types, clean data regularly, and consider horizontal tables to divide tables or partition by time. 4. Utilize cache and monitoring: Use Redis cache to reduce database pressure and enable slow query

To deal with character encoding problems in Java, the key is to clearly specify the encoding used at each step. 1. Always specify encoding when reading and writing text, use InputStreamReader and OutputStreamWriter and pass in an explicit character set to avoid relying on system default encoding. 2. Make sure both ends are consistent when processing strings on the network boundary, set the correct Content-Type header and explicitly specify the encoding with the library. 3. Use String.getBytes() and newString(byte[]) with caution, and always manually specify StandardCharsets.UTF_8 to avoid data corruption caused by platform differences. In short, by

JavaScript data types are divided into primitive types and reference types. Primitive types include string, number, boolean, null, undefined, and symbol. The values are immutable and copies are copied when assigning values, so they do not affect each other; reference types such as objects, arrays and functions store memory addresses, and variables pointing to the same object will affect each other. Typeof and instanceof can be used to determine types, but pay attention to the historical issues of typeofnull. Understanding these two types of differences can help write more stable and reliable code.

InJava,thestatickeywordmeansamemberbelongstotheclassitself,nottoinstances.Staticvariablesaresharedacrossallinstancesandaccessedwithoutobjectcreation,usefulforglobaltrackingorconstants.Staticmethodsoperateattheclasslevel,cannotaccessnon-staticmembers,

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

StructuredconcurrencyinJavasolvesthecomplexityofmanagingmultipleconcurrenttasksbygroupingthemintoasingleunitforcleanerhandling.1)Itsimplifieserrorpropagation,cancellation,andcoordination,especiallywhendealingwithexceptionsorwaitingforresults.2)Itwork
