在Java代码中展示mysql当前要执行的完整sql

xhuiting

于 2023-08-10 16:02:45 发布

阅读量109

点赞数

文章标签： java mysql sql

本文链接：https://blog.csdn.net/xhuiting/article/details/132212104

版权

代码如下：

PreparedStatement ps = conn.prepareStatement(sql);
String sqlText = ((JDBC4PreparedStatement)ps).asSql();

xhuiting

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

xhuiting CSDN认证博客专家 CSDN认证企业博客

码龄7年

暂无认证

64: 原创

7万+: 周排名

4万+: 总排名

7万+: 访问

: 等级

915: 积分

104: 粉丝

80: 获赞

38: 评论

121: 收藏

私信

关注

分类专栏

Springboot 6篇
数据库 15篇
大数据 4篇
调优 4篇
redis 1篇
mybatis 2篇
nginx 4篇
防火墙 2篇
linux 3篇
zookeeper 1篇
netty 2篇
虚拟机 2篇
分布式 4篇
springdata jpa 1篇
tomcat 1篇
springmvc 2篇
oracle 7篇
spring 7篇

最新评论

Postgresql在jdbc处理bit字段的解决方案
weixin_44231698: 可以了，谢谢大佬，您完美的解决了我的疑惑
Postgresql在jdbc处理bit字段的解决方案
xhuiting: PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, "ztt"); pstmt.setString(2, "123456"); PGobject pGobject = new PGobject(); pGobject.setType("BIT"); pGobject.setValue("1"); pstmt.setObject(3,pGobject);
Postgresql在jdbc处理bit字段的解决方案
xhuiting: PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, "ztt"); pstmt.setString(2, "123456"); // 设置bit(1)值，这里假设我们要插入的值是true PGobject pGobject = new PGobject(); pGobject.setType("BIT"); pGobject.setValue("1"); pstmt.setObject(3,pGobject); pstmt.setFloat(4, 170);
Postgresql在jdbc处理bit字段的解决方案
weixin_44231698: 这个设置报错啊，求指教，下面是建表语句：CREATE TABLE public.h_user ( id int4 DEFAULT nextval('user_id_seq'::regclass) NOT NULL, username varchar(50) NULL, "password" varchar(64) NULL, nickname varchar(60) NULL, email varchar(255) NULL, gender bit(1) NULL, height float4 NULL, CONSTRAINT user_pkey PRIMARY KEY (id) ); 下面是报错信息 D:\Java\jdk1.8\bin\java.exe "-javaagent:D:\idea\IntelliJ IDEA 2023.3.2\lib\idea_rt.jar=51441:D:\idea\IntelliJ IDEA 2023.3.2\bin" -Dfile.encoding=UTF-8 -classpath D:\java\jdk1.8\jre\lib\charsets.jar;D:\java\jdk1.8\jre\lib\deploy.jar;D:\java\jdk1.8\jre\lib\ext\access-bridge-64.jar;D:\java\jdk1.8\jre\lib\ext\cldrdata.jar;D:\java\jdk1.8\jre\lib\ext\dnsns.jar;D:\java\jdk1.8\jre\lib\ext\jaccess.jar;D:\java\jdk1.8\jre\lib\ext\jfxrt.jar;D:\java\jdk1.8\jre\lib\ext\localedata.jar;D:\java\jdk1.8\jre\lib\ext\nashorn.jar;D:\java\jdk1.8\jre\lib\ext\sunec.jar;D:\java\jdk1.8\jre\lib\ext\sunjce_provider.jar;D:\java\jdk1.8\jre\lib\ext\sunmscapi.jar;D:\java\jdk1.8\jre\lib\ext\sunpkcs11.jar;D:\java\jdk1.8\jre\lib\ext\zipfs.jar;D:\java\jdk1.8\jre\lib\javaws.jar;D:\java\jdk1.8\jre\lib\jce.jar;D:\java\jdk1.8\jre\lib\jfr.jar;D:\java\jdk1.8\jre\lib\jfxswt.jar;D:\java\jdk1.8\jre\lib\jsse.jar;D:\java\jdk1.8\jre\lib\management-agent.jar;D:\java\jdk1.8\jre\lib\plugin.jar;D:\java\jdk1.8\jre\lib\resources.jar;D:\java\jdk1.8\jre\lib\rt.jar;D:\tizhongCode\HealthManagement\target\classes;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.2.6.RELEASE\spring-boot-starter-web-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter\2.2.6.RELEASE\spring-boot-starter-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot\2.2.6.RELEASE\spring-boot-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.2.6.RELEASE\spring-boot-autoconfigure-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.2.6.RELEASE\spring-boot-starter-logging-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\Users\Admin\.m2\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\Users\Admin\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.12.1\log4j-to-slf4j-2.12.1.jar;C:\Users\Admin\.m2\repository\org\apache\logging\log4j\log4j-api\2.12.1\log4j-api-2.12.1.jar;C:\Users\Admin\.m2\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\Users\Admin\.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-core\5.2.5.RELEASE\spring-core-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-jcl\5.2.5.RELEASE\spring-jcl-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\yaml\snakeyaml\1.25\snakeyaml-1.25.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.2.6.RELEASE\spring-boot-starter-json-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.10.3\jackson-datatype-jdk8-2.10.3.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.10.3\jackson-datatype-jsr310-2.10.3.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.10.3\jackson-module-parameter-names-2.10.3.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.2.6.RELEASE\spring-boot-starter-tomcat-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.33\tomcat-embed-core-9.0.33.jar;C:\Users\Admin\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.33\tomcat-embed-el-9.0.33.jar;C:\Users\Admin\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.33\tomcat-embed-websocket-9.0.33.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-validation\2.2.6.RELEASE\spring-boot-starter-validation-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;C:\Users\Admin\.m2\repository\org\hibernate\validator\hibernate-validator\6.0.18.Final\hibernate-validator-6.0.18.Final.jar;C:\Users\Admin\.m2\repository\org\jboss\logging\jboss-logging\3.4.1.Final\jboss-logging-3.4.1.Final.jar;C:\Users\Admin\.m2\repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-web\5.2.5.RELEASE\spring-web-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-beans\5.2.5.RELEASE\spring-beans-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-webmvc\5.2.5.RELEASE\spring-webmvc-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-aop\5.2.5.RELEASE\spring-aop-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-context\5.2.5.RELEASE\spring-context-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-expression\5.2.5.RELEASE\spring-expression-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\postgresql\postgresql\42.2.11\postgresql-42.2.11.jar;C:\Users\Admin\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.2.6.RELEASE\spring-boot-starter-jdbc-2.2.6.RELEASE.jar;C:\Users\Admin\.m2\repository\com\zaxxer\HikariCP\3.4.2\HikariCP-3.4.2.jar;C:\Users\Admin\.m2\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-jdbc\5.2.5.RELEASE\spring-jdbc-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\org\springframework\spring-tx\5.2.5.RELEASE\spring-tx-5.2.5.RELEASE.jar;C:\Users\Admin\.m2\repository\com\auth0\java-jwt\3.10.3\java-jwt-3.10.3.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.10.3\jackson-databind-2.10.3.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.10.3\jackson-annotations-2.10.3.jar;C:\Users\Admin\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.10.3\jackson-core-2.10.3.jar;C:\Users\Admin\.m2\repository\commons-codec\commons-codec\1.13\commons-codec-1.13.jar;C:\Users\Admin\.m2\repository\com\alibaba\fastjson\1.2.9\fastjson-1.2.9.jar com.health.util.bitTest org.postgresql.util.PSQLException: ERROR: column "gender" is of type bit but expression is of type boolean 建议：You will need to rewrite or cast the expression. 位置：69 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) at com.health.util.bitTest.main(bitTest.java:34) Process finished with exit code 0 试验了好多都报错
Postgresql在jdbc处理bit字段的解决方案
weixin_44231698: package com.health.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.Types; public class bitTest { public static void main(String[] args) { // 数据库连接信息 String url = "jdbc:postgresql://localhost:5432/postgres"; String username = "postgres"; String password = "postgres"; // SQL语句 String sql = "insert into h_user (username, password, gender,height) values(?,?,?,?)"; try { // 加载并注册JDBC驱动 Class.forName("org.postgresql.Driver"); // 建立数据库连接 try (Connection conn = DriverManager.getConnection(url, username, password); // 创建PreparedStatement PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, "ztt"); pstmt.setString(2, "123456"); // 设置bit(1)值，这里假设我们要插入的值是true pstmt.setObject(3,true,Types.BIT); pstmt.setFloat(4, 170); // 执行SQL语句 pstmt.executeUpdate(); } } catch (Exception e) { e.printStackTrace(); } } }