手机数据上传mysql

随着移动互联网的发展,手机已经成为了人们不可或缺的工具。而在使用手机的过程中,手机数据的上传和存储也变得越来越重要。本文将介绍如何使用MySQL数据库来上传手机数据。

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class MySQLHelper { private static final String DRIVER = "com.mysql.jdbc.Driver"; private static final String URL = "jdbc:mysql://localhost:3306/DatabaseName"; private static final String USERNAME = "username"; private static final String PASSWORD = "password"; public static Connection getConnection() { Connection conn = null; try { Class.forName(DRIVER); conn = DriverManager.getConnection(URL, USERNAME, PASSWORD); } catch (SQLException | ClassNotFoundException e) { e.printStackTrace(); } return conn; } public static void insertData(String data1, String data2) { Connection conn = getConnection(); PreparedStatement stmt = null; String sql = "INSERT INTO TableName (column1, column2) VALUES (?, ?)"; try { stmt = conn.prepareStatement(sql); stmt.setString(1, data1); stmt.setString(2, data2); stmt.executeUpdate(); } catch(SQLException e) { e.printStackTrace(); } finally { try { if(stmt != null) { stmt.close(); } if(conn != null) { conn.close(); } } catch(SQLException e) { e.printStackTrace(); } } } }