JDBC Simple template

1  Packageorg.db;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 Importjava.sql.SQLException;6 7  Public classDbconn {8     9 //Public final static String URL = "Jdbc:mysql://Localhost:3306/test?usessl=false ";Ten      Public Final StaticString URL = "Jdbc:mysql://localhost:3306/test?characterencoding=utf8";//You can specify the JDBC encoding method One      Public Final StaticString USERNAME = "root"; A      Public Final StaticString PASSWORD = "000000"; -      Public Final StaticString DRIVER = "Com.mysql.jdbc.Driver"; -      the      Public StaticConnection Conn; -      Public StaticConnection Getconn () { -         Try { - Class.forName (DRIVER); +conn =drivermanager.getconnection (URL, USERNAME, PASSWORD); -             if(conn!=NULL) { +SYSTEM.OUT.PRINTLN ("Connection succeeded"); A             } at             returnConn; -}Catch(Exception e) { - e.printstacktrace (); -System.out.println ("Connection Failed"); -             return NULL; -         } in     } -      Public Static voidCloseconn () { to         Try { +             if(conn!=NULL){ - conn.close (); the             } *}Catch(SQLException e) { $ e.printstacktrace ();Panax Notoginseng         } -     } the}

1  Packageorg.test;2 3 Importjava.sql.Connection;4 Importjava.sql.PreparedStatement;5 ImportJava.sql.ResultSet;6 Importjava.sql.SQLException;7 8 ImportOrg.db.DBConn;9 ImportOrg.model.Login;Ten  One  Public classTest { A  -      Public Static voidMain (string[] args) { -Connection conn =dbconn.getconn (); the         if(conn!=NULL) { -SYSTEM.OUT.PRINTLN ("Connection succeeded"); -             Try { -conn =dbconn.getconn (); +String sql = "Select Id,name,password,role from Mbook where name=?" and password=? "; -PreparedStatement PS =conn.preparestatement (SQL); +Ps.setstring (1, "Zhang San"); APs.setstring (2, "000000"); atResultSet rs =ps.executequery (); -                          -                      while(Rs.next ()) { -Login Login =NewLogin (); -Login.setid (Rs.getint (1)); -Login.setname (Rs.getstring (2)); inLogin.setpassword (Rs.getstring (3)); -Login.setrole (Rs.getboolean (4)); toSYSTEM.OUT.PRINTLN ("Get Data:" +login);  +                     } -}Catch(SQLException e) { the e.printstacktrace (); *}finally{ $ dbconn.closeconn ();Panax Notoginseng             }             -         } the     } +}

JDBC Simple template