Home > Developer > MySQL

Org.gjt.mm.mysql.Driver Database Classes

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
  2. Package Pubcls;
  6. Import java.sql.*;
  10. /**
  12. * MYSQL simple Operation class
  14. * @author Itblt
  16.  */  
  18. Public class Mysql
  20. {
  22. Public Connection Livecon = NULL ; 
  24. Public int dbwaittime = 3600;
  26. Public String DbLang = "" ; 
  28. Public String errmessage = "" ; 
  32. Private String Linkurl = "" ; 
  34. Private String linkdb = "" ; 
  36. Private String Linkuser = "" ; 
  38. Private String linkpwd = "" ; 
  42. /**
  44. * Set Default parameters
  46.      */  
  48. Private void SetDefault () {
  50. This . Linkurl = "jdbc:mysql://localhost:3306/" ; 
  52. This . linkdb = "Test" ; 
  54. This . Linkuser = "Root" ; 
  56. This . linkpwd = "" ; 
  58. This . DbLang = "UTF8" ; 
  60. }
  64. /**
  66. * Initialized with default parameters
  68.      */  
  70. Public Mysql () {
  72. This . SetDefault ();
  74. }
  78. /**
  80. * Specify database and encoding for initialization
  82. * @parem String SDB
  84. * Database name
  86. * @parem String Dblang
  88. * Coding (usually UTF8/GBK)
  90.      *
  92.      */  
  94. Public Mysql (String sdb, String Dblang) {
  96. This . SetDefault ();
  98. This . linkdb = SDB;
  100. This . DbLang = DbLang;
  102. }
  106. /**
  108. * Initialized with full parameters
  110. * @parem String surl
  112. * Connection URL (jdbc:mysql://ip: Port/): jdbc:mysql://localhost:3306/
  114. * @parem String SDB
  116. * Database name
  118. * @parem String suser
  120. * User name
  122. * @parem String spwd
  124. * Password
  126. * @parem String Dblang
  128. * Database Encoding
  130.      */  
  132. Public Mysql (String surl, String sdb, String suser, String spwd, String Dblang) {
  134. This . Linkurl = sURL;
  136. This . linkdb = SDB;
  138. This . Linkuser = suser;
  140. This . linkpwd = spwd;
  142. This . DbLang = DbLang;
  144. }
  148. /**
  150. * Get links
  152.     */  
  154. Public Connection getconnection () throws SQLException,
  156. Java.lang.ClassNotFoundException
  158. {
  160. This . Livecon = This . getconnection (this. Linkurl, this.linkdb, this. Linkuser, this. Linkpwd, this. DbLang);
  162. return this. Livecon;
  164. }
  168. /**
  170. * Get links with specified parameters
  172. * @parem String surl
  174. * Connection URL (jdbc:mysql://ip: Port/): jdbc:mysql://localhost:3306/
  176. * @parem String SDB
  178. * Database name
  180. * @parem String suser
  182. * User name
  184. * @parem String spwd
  186. * Password
  188. * @parem String Dblang
  190. * Database Encoding
  192. * @return Connection
  194.      */  
  196. Public Connection getconnection (String surl, String sdb, String suser, String spwd, string Dblang) throws SQLException,
  198. Java.lang.ClassNotFoundException
  200. {
  202. This . Linkurl = sURL;
  204. This . linkdb = SDB;
  206. This . Linkuser = suser;
  208. This . linkpwd = spwd;
  210. This . DbLang = DbLang;
  214. Class.forName ("Org.gjt.mm.mysql.Driver");
  216. This . Livecon = Drivermanager.getconnection (Surl+sdb, Suser, spwd);
  218. This . Prequery ();
  220. return this. Livecon;
  222. }
  226. /**
  228. * MySQL Escape
  230. * @return String
  232.      */  
  234. Public static string Quotestr (String str)
  236. {
  238.         string[] searchs = { ,   " n " ,   "R" ,   ,   "T" ,   ,   " " }; 
  240. String[] Replaces = {"yes", "\ n", "\ r" , "\z" , "\ T" ,  "\\", " \ "" ,  "\'" };
  242. for (int i=0; i < searchs.length; i++)
  244. {
  246. str = str.replace (Searchs[i], replaces[i]);
  248. }
  250. return str;
  252. }
  258. /**
  260. * Test Link
  262. * @return Boolean
  264.      */  
  266. Private boolean Testcon () throws SQLException
  268. {
  270. if (this. livecon==null | | This . livecon.isclosed ())
  272. {
  274. Try  
  276. {
  278. This . getconnection ();
  280. return true;
  282. catch(classnotfoundexception e)
  284. {
  286. return false;
  288. }
  290. Catch (SQLException E2)
  292. {
  294. This . Errmessage = E2.getmessage ();
  296. return false;
  298. }
  300. }
  302. return true;
  304. }
  308. /**
  310. * Execute Write statement
  312. * @parem string query
  314. * SQL Write class operations
  316. * @return int
  318.      */  
  320. Public int execupdate (String query) throws SQLException
  322. {
  324. if (! This . Testcon ())
  326. {
  328. return  - 1 ; 
  330. }
  332. Statement sql_statement = this. livecon.createstatement ();
  334. int Result = sql_statement.executeupdate (query);
  336. Sql_statement.close ();
  338. return Result ;
  340. }
  344. /**
  346. * Execute INSERT statement and return the last inserted primary chain ID
  348. * @parem String
  350. * SQL SQL statement
  352. * @return int
  354.      */  
  356. Public Long execinsert (String query) throws SQLException
  358. {
  360. if (! This . Testcon ())
  362. {
  364. return  - 1 ; 
  366. }
  368. Statement sql_statement = this. livecon.createstatement ();
  370. Long Result = sql_statement.executeupdate (query);
  372. if (result>0)
  374. {
  376. sql_statement = this. Getstatement ("select last_insert_id ();" );
  378. ResultSet rs = Sql_statement.getresultset ();
  380. Rs.next ();
  382. result = Rs.getlong (0);
  384. }
  386. Sql_statement.close ();
  388. return Result ;
  390. }
  394. /**
  396. * Get a recordset
  398. * @parem String query
  400. * SQL statements for queries
  402. * @return ResultSet
  404.      */  
  406. Public ResultSet getresultset (String query) throws SQLException
  408. {
  410. if (! This . Testcon ())
  412. {
  414. return null;
  416. }
  418. Statement sql_statement = this. Getstatement (query);
  420. ResultSet result = Sql_statement.getresultset ();
  422. return Result ;
  424. }
  428. /**
  430. * Obtain a recordset that can be used for update operations
  432. * @parem String query
  434. * SQL statements for queries
  436. * @return ResultSet
  438.      */  
  440. Public ResultSet getresultsetupdate (String query) throws SQLException
  442. {
  444. if (! This . Testcon ())
  446. {
  448. return null;
  450. }
  452. Statement sql_statement = this. Livecon.createstatement (Resultset.type_scroll_insensitive, resultset.concur_updatable);
  454. Sql_statement.executequery (query);
  456. ResultSet result = Sql_statement.getresultset ();
  458. return Result ;
  460. }
  464. /**
  466. * Get a statement
  468. * @parem String query
  470. * Query SQL
  472. * @return Statement
  474.      */  
  476. Public Statement getstatement (String query) throws SQLException
  478. {
  480. if (! This . Testcon ())
  482. {
  484. return null;
  486. }
  488. Statement sql_statement = this. Livecon.createstatement (Resultset.type_forward_only, RESULTSET.CONCUR_READ_ONLY);
  490. Sql_statement.executequery (query);
  492. return sql_statement;
  494. }
  498. /**
  500. * Select Database
  502.      */  
  504. Public void selectdb (String dbname) throws SQLException
  506. {
  508. This . Testcon ();
  510. This . Execupdate ("use")+ dbname +"';" );
  512. }
  516. /**
  518. * pretreatment
  520.      */  
  522. Private void prequery () throws SQLException
  524. {
  526. This . Execupdate ("SET NAMES '"+ this. DbLang +"", character_set_client= Binary, sql_mode= ', wait_timeout='+ this. Dbwaittime +", interactive_timeout = "+ this. Dbwaittime +"; );
  528. }
  532. /**
  534. * Close Link
  536.     */  
  538. Public void close () throws SQLException
  540. {
  542. if (this. Livecon!= null &&! This . livecon.isclosed ())
  544. {
  546. This . Livecon.close ();
  548. }
  550. This . Livecon = NULL ; 
  552. }
  556. /**
  558. * Resource Analysis
  560.     */  
  562. Public void Finalize () {
  564. Try  { 
  566. This . Close ();
  568. catch(SQLException e) {
  570. E = null;
  572. }
  574. }
  578. }//end class

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More