JDBC Development model

One "code module ——— Demo.java

  　　　　　　  Public classDemo {Private StaticConnection Connection; Private StaticStatement Statement; Private StaticResultSet rs;  Public Static voidMain (string[] args) {connection=jdbcutils.getconnection (); Try{statement=connection.createstatement (); RS=statement.executequery (Sqlmapping.qeury_all);  while(Rs.next ()) {System.out.println (Rs.getint ("id") + ":" + rs.getstring ("name") + ":" + rs.getstring ("gender")                                    + ":" + rs.getstring ("salary"))); }                                } Catch(SQLException e) {e.printstacktrace ();                            } jdbcutils.closestream (RS, statement, connection); }            

Two "tool module ——— Jdbcutil.java

                     Public classJdbcutils {Private StaticProperties Properties; //get the database driver                    Static{InputStream InputStream= Jdbcutils.class. getClassLoader (). getResourceAsStream ("Com/suse/jdbc/db.properties"); Properties=NewProperties (); Try{properties.load (InputStream); Class.forName (Properties.getproperty ("Driver")); } Catch(IOException e) {e.printstacktrace (); } Catch(ClassNotFoundException e) {e.printstacktrace (); }                    }                                        //get a database connection                     Public StaticConnection getconnection () {Connection Connection=NULL; Try{Connection= Drivermanager.getconnection (properties.getproperty ("url"), properties); } Catch(SQLException e) {e.printstacktrace (); }                            returnconnection; }                                                            //Close the stream                     Public Static voidClosestream (ResultSet rs, Statement stmt, Connection conn) {if(NULL!=RS) {                            Try{rs.close (); } Catch(SQLException e) {e.printstacktrace (); }                        }                        if(NULL!=stmt) {                            Try{stmt.close (); } Catch(SQLException e) {e.printstacktrace (); }                        }                        if(NULL!=conn) {                            Try{conn.close (); } Catch(SQLException e) {e.printstacktrace (); }                        }                    }                    }            

Three "configuration file module ——— db.properties

　　　　　　  Driver = com.mysql.jdbc.Driver            URL  = jdbc:mysql://127.0.0.1:3306/mydb            user = root            password = root

JDBC Development model