import java.sql.*; public class Test { public static void main(String[] args) { try { // new Test().queryMySql(); new Test().querySqlite(); } catch (SQLException e) { throw new RuntimeException(e); } catch (ClassNotFoundException e) { throw new RuntimeException(e); } } private void querySqlite() throws ClassNotFoundException, SQLException { Connection c = null; Statement stmt = null; Class.forName("org.sqlite.JDBC"); c = DriverManager.getConnection("jdbc:sqlite:dictionary.db"); c.setAutoCommit(false); stmt = c.createStatement(); String en = "test"; String sql = "SELECT * FROM dictionary WHERE en = \""+en+"\";"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { System.out.println(rs.getString("en")); } stmt.close(); c.close(); } private void queryMySql() throws SQLException { String URL = "jdbc:mysql://localhost/dictionary?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8"; String USER = "username"; String PASS = "********"; Connection conn = DriverManager.getConnection(URL, USER, PASS); Statement stmt = conn.createStatement(); String sql = "SELECT * FROM dictionary LIMIT 50;"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { System.out.println(rs.getString("en")); } conn.close(); } }
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.example</groupId> <artifactId>QueryMissing</artifactId> <version>1.0-SNAPSHOT</version> <properties> <maven.compiler.source>8</maven.compiler.source> <maven.compiler.target>8</maven.compiler.target> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <dependencies> <dependency> <groupId>org.xerial</groupId> <artifactId>sqlite-jdbc</artifactId> <version>3.34.0</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.13</version> </dependency> </dependencies> </project>
分类:
backend / Java
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 地球OL攻略 —— 某应届生求职总结
· 周边上新:园子的第一款马克杯温暖上架
· 提示词工程——AI应用必不可少的技术
· Open-Sora 2.0 重磅开源!
2022-03-24 uniapp安装uview