In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article will explain in detail how to connect to the jdbc of Mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.
Package util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class DBUtil {Connection conn = null;PreparedStatement stmt = null;String Driver = "com..jdbc.Driver"; String url = "jdbc:mysql://10.137.5.23/mcip?useUnicode=true&characterEncoding=GBK"; String user = "mcip"; String password = "mcip"; ResultSet rs = null;// complete the creation of public Connection getConnection () throws Exception {Class.forName (Driver) If (conn = = null) {conn = DriverManager.getConnection (url, user, password);} return conn;} / / create statement object public PreparedStatement createStatement (String sql) throws Exception {stmt = getConnection (). PrepareStatement (sql); return stmt;} / execute the method public ResultSet excuteQuery () throws Exception {rs = stmt.executeQuery () returned by the result set; return rs;} / / execute the method public int excuteUpdate () throws Exception {return stmt.executeUpdate () that has no result set return } / / close object public void close () {if (rs! = null) try {rs.close ();} catch (Exception e) {} if (stmt! = null) try {stmt.close ();} catch (Exception e) {} if (conn! = null) try {conn.close () } catch (Exception e) {} this is the end of the article on "how to connect the jdbc of Mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
Too lazy to type, QQ screenshot record, ha
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.