MySQL? Java? ???? ??? ?? ?? ??? ???? ??

??:
?? ?? ???? ?? ??? ?? ? ????? ????. ????, ?????, ??? ? ??? ???? ??? ?????. ? ????? MySQL? Java? ???? ??? ?? ?? ??? ???? ??? ???? ???? ?? ??? ?????.

1. ?????? ??? ??
??, ?? ?? ???? ??? ???? MySQL? ???? ???. ?? ??? ???? "signature"?? ???? ????.

• id: ?? ?? ?? ?? ?? ???? ?? ??????.
• name: ???? ?????.
• ??: ??? ???? ???? ?????.
• date: ?? ?? ? ??.

CREATE TABLE ?? (
id INT AUTO_INCREMENT PRIMARY KEY,
?? VARCHAR(100),
?? LONGBLOB,
?? DATETIME
)

2 Java ?? ??
???? Java? ???? ?? ?? ??? ???????. . ??? Java? Swing ?????? ???? ??? ?????? ????. ??? ??? ?? ?????.

import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
import javax.swing.* ;

public ??? ElectronicSignature? JFrame? ?????. {
private JTextArea signedTextArea;
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();

}
}

?? ??:

• saveSignature ????? ?? MySQL ??????? ?? ??? ?? ?? INSERT ?? ???? ?? ???? ?? ??? ?? ?? ??? ?????. . ????? SQL ?? ???? ??? ????.
• ??? ???? ?? ?? ???? ???? ???? ??? ?????. ??? ??? ???? ??? ??? ??? ????? ???? ?????.

3. ?? ??
?? Java ??? ???? ??? ?? ?? ??? ??? ? ????. "?? ??" ??? ???? ??? MySQL ??????? ?????. ??? ???? ???? ??? ??? ??? ????? ???? ????, ??? ??? ???? ??? ??? ??? ????? ???? ?????.

??:
? ????? MySQL? Java? ???? ??? ?? ?? ??? ???? ??? ?????. "signature"?? ??? ???? ???? Java? Swing ?????? ???? ? ?????? ??????. ?? ??? ???? "?? ??" ??? ???? ??? MySQL ??????? ?????. ? ?? ???? ? ??? ?? ????, ?? ??????? ????, ?? ?? ??? ?? ?? ?? ??? ??? ? ????.

? ??? MySQL? Java? ???? ??? ???? ??? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!