import java.sql.Connection; import java.sql.DriverManager; public class JDBCExample { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/dbname"; String user = "username"; String password = "password"; try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection(url, user, password); conn.close(); } catch (Exception e) { e.printStackTrace(); } } } import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class JDBCExample { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/dbname"; String user = "username"; String password = "password"; try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection(url, user, password); String query = "SELECT * FROM students WHERE id = ?"; PreparedStatement ps = conn.prepareStatement(query); ResultSet rs = ps.executeQuery(); while (rs.next()) { } rs.close(); ps.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }


上一篇:
下一篇:
切换中文