jdbc预编译插入数据操作

时间:2022-09-14 14:14:11
package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException; /**
* jdbc使用预编译进行插入操作
*
* @Author: 张昊亮
* @Date: 2016年6月16日 上午10:56:43
*/
public class JdbcTest3 { public static void main(String[] args) throws SQLException, ClassNotFoundException { // 注册驱动
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Class.forName("com.mysql.jdbc.Driver"); // 获得链接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zhl", "root", "root"); // 得到操作数据库sql语句的预编译对象PraparementStatement
PreparedStatement ps = conn.prepareStatement("insert into user(id,usename,password) values(?,?,?)");
ps.setString(1, "5");
ps.setString(2, "xiaoming");
ps.setString(3, "xiaoming"); // 执行
int rs = ps.executeUpdate();
System.out.println(rs); // 释放资源
ps.close();
conn.close();
}
} 结果:
    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATUAAACRCAIAAAAth7gfAAAQ3UlEQVR4nO2d0W8Uxx3H569pHwqnNYhVeqoiVaoqRW0tYnyOUqKCTpUVWjWJABtHCRW8xLlERrZlwCLQhvISCLqQYK4JIkjENSfM+Xy33OVcu60qIqSqSMYmfsD0wX3Y3dnZ3+7e3nnnbmd2fh/9JJbd2b397m++t3N759+Qra2tNYZDhw6tCczT9afPn21uPnv2/PHjzeszmydPbr7++uahQ5ujo5ul+5vfP33+bPP58+fr6+stHvDJkyf1ev3GjRsXL1w4k3t/4vi7E8ffPftB7uPz52/cuPHtt99u4yTv3r07NjZ28uTJjz76qFarra6ubuMgCLK2tkbk8ieCJAzC4LMV/Ykg8UKd6bUo+hNBYgb9iSDi4ju+tVahPxEkXkxnsv507qjoTwSJF+/4Fv2JIKKA/kQQQWE/fLKfQvHzJ4KIDvoTQcQF/Ykg4hLoz98iCBI3zfz5MYKowZaohPiTyz3avARcDhUviRHSBBU0AuT25727X0aJNSbl9+5+uXH/HUkDCElkqKDRV3LcNgwk3J/zxZtRgk35fPHm9wsnJQ0gJJGhgkZfyXHbMJBwf96/dytKsCm/f+/W94vvSxpASCJDBY2+kuO2YSDh/lyYvx0l2JQvzN9+apx6apx6OrNXJz++ai6742o/IQGb4g0gJJEhl8bJlwkhv5zkITluGwYS7s9y6U6UYFNeLt15WjsdGu9rP7naQrMuBxCSyJBO49HUryZ5SI7bhoGE+7OyMBsl2JRXFmbXG+evDpi/LHzxauP8Oo1zL1o/OBx4c7THvUmMAEKm+gghvVMLs5XJXkIISb1hSb72RspS0ptK9U4tzFYWZq8f2WH/ynLH0DW6Zkcq5Vrpamkd8MN++gPNvg+HUuAIcHe+yRpKEZJ6Y6rPepn+yaCTDBTuWWnKsU/Y2to75WpJ5diNJ5lm9IJbF8ReGU1y3DYMJNyf1cW5KMGmvLo4t/73v5gx2vPTq/by+s39OrH+e/UVQgizSZgAQqqLc8Op3tOWzLH+1JvmytP7dgx/MVddnKtO9RLSe3pxrvrFm5q9lV0+vY+QfWNWS3Nhca46NWYe8/rQDm3osrUL6T29ODecItrQ5epUrzZ0OeiYfJNVXRzrJ/ZJLo71EyrNc5K+wn1XmudPX9T6L3NwW69zlcxNVLhzcEKYllEkx23DQML9aVSKUYJNuVEprq1cNmO052ef2svld35w8Pxle9PbB4mzSaBwCzEqxeHU3jOWzFP9qbcsyVN76Q2vf6poVIozQzuJi53D14tGpXim31pgd2cba0NXjErRuP6W1n/KebmpvdrQlaBj8k2WUTnVT6hG66X9T9JPuP9KU87UXnONdRHsI9OLQI/AXCW4CZ5eBMlx2zCQcH/WjPkowaa8Zsyv/euaGaO7fv6pvVw+/sODf7pmb/rjQeJsEijcQmrG/DHt5bOWzImMdhhqnzmsmSvPvKwN571X5mz/zmMz7t1nDmvEPibda+aw1j/hvJy5PuCYfJMFdZkv6nuSvsL9V05ktMOF4Z2Z4cNa/4RLlN24MLwzc8Z7leCmmjGRoWcSTXLcNgwk3J/1WilKsCmv10pr/y6YMbrrpU/t5bU7g/qvT1rLf36JEGaTOOEWUq+VRrTUSMFcIEQ7Uq+V6rWJDOmbNrUXjmjelUxMZ6zd67WJjNmycETLTNgHJ9qxz9iVI1rfdK1UP9unHfss6Jh8k1WvTWSIfRr0hH1PMlS4s7I0nenTtNRIoTSSSdmHsq+AdVhHGnOV7OPYr14/20ciXwTp/dmol6MEm/JGvfzku9GDroHZj96b/frJd19f2U/X/GLPbkJ2/+7Jd18LFUBIo15uTO8zz7hn5OgAISQz2ahPDjDaBqbLoCUhhJB95+rlr0ZS9rK9S2ayUS+fy1iNerQUIWRg2traM/L52xoh2lHzUAPTPseMmClvshr1yQHt6Nua/SKZSbOZ5yTLAcL9r8ZXIymiHTUXekY+d1baWCv/erSH2Z22pK9OyL4e85pElhy3DQMJ9+dSoxol2JQvNapPHv1N0gBCEhkejadf6RmO/ay6IDluGwYS7s/lpQdRgk358tKD1f/MSxpASCIDaHzHvn+9ci7+c+uo5LhtGEi4P1eW61GCTfnKcn31v1VJAwhJZKig0Vdy3DYMBP++rA0SI6QJKmgESOxPLpAEweuaIEIRtw0DQX+2R9z56jgzMzNxn0K3EVlyN8a3Zs/+5z8eSx3Unw8frSY4zM4a+2l0X7KYhPiTS+UB9KdEgf4UihB/ghoCrVQc81YeQH9KFOhPoQjzp7uGQEv+9FQeYPz5yauEEPKbC3Gbjbs/L75GCDlw0X+9/yYxo4k/E6PRV7KYhPgT1BAwHRh0LHOrt/IA9efxXeTVC4+P70qgPx8+Wj2xO7CDNtkkWjS/fyZDo69kMQnzp7uGQEv+9FQeAOPbBPjTvmMQQgjZ/R7toPut9XtOzMnad6k/E6zRV7KYhPgT1BBoxZ/eygNJ9KfVO785sWf/JdpBCXntysNHqw8vHbAWJOy7jD8Tq9FXspiE+dNdQ6Alf3oqDyTPn2Z8c2IPvbG4O+iV/cx6ufouGN8mUqOvZDEJ+/7TXUOgFX96Kw8k05+XDpDADipx33X5M6EafSWLSZg/3TUEWvKnp/JAAv156QB9XEn7ZTL6ruPP5Gr0lSwmYf501xBoyZ+eygPs81sGyVzK+vPEblbIgYv0acru9x4+sv/U/LUrzjLxf6YiYFB/JlhjcvwJagi04k9v5QFw/5Q0vJ8/Exn4+wShCPOnu4ZAK79P8FYeQH9KFOhPoQjxJ6gh0Io/vZUH0J8SBfpTKML8yaPyAPpTokB/CkX3/r4sGWwlve+iP4UC/z67PWaQJBK3DQPphj8/Frh+RFuInEheqKARILLkLtUH29ra2pAfM5Fxn0VnUUEjQG5/3rv7ZZRAf8qFChoBcvtzvniTRivfr7Dt54s30Z9yoYJGgNz+vH/vFo1W/Mm2v3/vltuf+az1nEXPGTFnZRs06bv5LCEkm+/Eqxo5vUNH9kMFjQC5/bkwf5uG6cCgY5lb2fYL87dZfzpJyGeJnospHdun+b0lp8fWwziigkaA3P4sl+7QaMWfbPty6U7A+DafldufzkAgm82aY4Gcns1m4ejAyOnEPWQwcjohuq57xhFO06yuO+9j5po47p+J1QiQ25+VhVkarfiTbV9ZmPX1pyHn+zDtu85AwMjpdv/L6XYfy2etBSOn07chZjmf9bQ037EMsNmim1dLBY0Auf1ZXZyj0Yo/2fbVxTmvP810x5SLSFh9N+DdhVlrjQ6YG4vrTuJ0U3YcQW9XnltJDP5MtEaA3P40KkUarfiTbW9UisCf+SyR1Jwb7fddtpOy+PddCntHgkfuOCpoBMjtz5oxT6MVf7Lta8Y8eD4U36cMDjBjP6dP5rPWLcOn77JjOwa/vsu0FMGfidYIkNuf9VqJRiv+ZNvXayXHn3AkJJ9TnWcnrJZsfoMO3PQcfN7BjOjMVfau2byrpaedZ+fufCmlgkZfyWIS7s9GvUyjFX+y7Rv1csDzWylR4bt7FTQC5PbnUqNKo5XfJ7DtlxpV9KdcqKARILc/l5ce0GjFn2z75aUH6E+5UEEjQG5/rizXowT6Uy5U0AiQ25/RQX9KhAoaARL7kxchf76OILEStw0DwfoJbSByInmhgkaAyJK7N75NACInkhcqaASILLl79RMSgMiJ5IUKGgEiS+5e/YQEIHIieaGCRoDIkrtXP8GkMGj+jCs9vhKf6O3iTWRhkBAyWNjuASPu3glU0AiQ25+86idsmakyM1UYFDtl/vgmcjwdSUnE3bmjgkaA3P7kVT/Bhez+tIcBZLDgdL6V8TRxjQ6cW4fZPj3OZ3fUyBW5/cmrfoKFlSEJ3UkTuTKets+fGbwVBumgnWnA3DoKg2bni7h7h1FBI0Buf/Kqn+BC5vvnimu4ZispDLIfqWkbb+eLuHunUUEjQG5/8qqfABD8M4kvKvRdFTQC5PYnr/oJruFNYTCWTxoRccZ+TI9yBm+MItpiPG1JHk/bH64i7t5hVNAIkNufvOonbG35PB6QC5pI+uyDkMG03asccaw85wulcfAoZNu7o8YOSRaQ7tVPSAAiJ5IXKmgEiCy5e/UTEoDIieSFChoBIkvuXv2EBCByInmhgkaAyJK7Vz8hAYicSF6ooBEgsmT8+7I2EDmRvFBBI0BkyVg/AUGU92fcMvkgciJ5oYJGgMiSsT5YG8woUDtLBY0Auf3Jq35C3FnggAp9VwWNALn9yat+QtxZ4IAKfVcFjQC5/cmrfsKGe8adGObBiUx43zWcWW250YljBqOCRoDc/uRVP2HDmlROPltSVLi3qKARILc/edVP2EiMP60Z8ZzJ89yz7LnuA86QgZ3ukl1rbLjm2MvmczphZqGGxzRyOiG6rntGIXZTPZfLwrNAjeGSxaR79RM2fGaUlAx6bzFyutkXvXPTwnlm83nzv8x7E53tlhnX2Qs5neg5A0xKDY6ZzzJ2MReY8WFOjzRDuQoafSWLSffqJ7ivif+ky4LDjv2s9xqPCNDPfD5yu/ulNZG8PZ+89U9I34VTU7tmo/dMTY0amyO3P3nVTwAXJcb5zLcN23fzWaLrPg81XLrYxx60x4ndd1XQCJDbn7zqJ8AxD7/r2zVo36WjL2cYZgP7rv0/a1C3sUE7nKt9tL7LXs98ls/4NsEaAXL7k1f9BOsSS/z1ipVIW4Tz7ETPGa7nH66Bnv1/XadDRc+A0DmO9ckqbz7+8Dmm99WdD3fWf7PZyP5MtkZfyWLSvfoJvK5mjMjx3YMR6aODChoB8vnzfy+8gIGBEbc90Z8YGMERtz3RnxgYwRG3PdGfGBjBEbc90Z8YGMERtz2xfkI7iPygjxcqaASILBnrg7WByInkhQoaASJL7l79hAQgciJ5oYJGgMiS26ufsI1Af8qFChoBIktur37CNsLXnyv2nFXjaWLNlEOnzkmPO0sFZ5GdWofOoOO7cmsLTmXHC28iJRXSBBU0AuT2J6iH4I7Rvp2/b9rgtp8/2dl5C4PpNJ2Lzp5zzn8iuoD5IQNWdmAeLE8iZRXSBBU0AuT2J6iHQGNy4oNy6YN9qT/Yy/7NfPzpSkdhMD1O30D5pZydbJQbMJHSCmmCChoBcvsT1EOgMdXn/NFB6sgnQc28/nQnozCYHqfTuXJMeSfelEEi5RXSBBU0AuT2J6iH4IqpXkKINnS5SRuvP8fTbC6shJnvypxTznsyZpBIeYU0QQWNALn9CeohOHH9LY3sPVMpDqd2Dl8PaMPUT6D4ptx8V24j5c5DBd+VsflTCiFNUEEjQG5/gnoI7UZL41t7iT58cMY7K0zG201598e3kghpggoaAXL7E9RDaDeaPx9iHsmbD+CZd1/CbHI/nacbfFd6XoQbTZ6dyCWkCSpoBMjtT1APod0I+36lQ3T/+5UOIdT3Kx0Cv18JJNyfS41qlPDzp/OVd6fo+u8TOoVIv0/oFPj7hGDC/bm89CBK+PpTUkROJC9U0AgQWXK4P1eW61EC/SkXKmgEiCwZ/76sDUROJC9U0AgQWXKX/j57BkEEJm4bBtLMn3GfG4KoDvoTQcQF/Ykg4oL+RBBxQX8iiLigPxFEXNCfCCIu6E8EERf0J4KIC/oTQcQF/Ykg4oL+RBBxQX8iiLigPxFEXNCfCCIu6E8EERf0J4KIC/oTQcQF/Ykg4oL+RBBxQX8iiLigPxFEXNCfCCIu6E8EEZf/A6O+pvJFOLMcAAAAAElFTkSuQmCC" alt="" />