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.