JDBC Additions and deletions (using configuration files)

Jdbcdemo2.java

Package Com.zhangbz.jdbc;import Java.sql.connection;import java.sql.resultset;import java.sql.statement;import Org.junit.test;import com.zhangbz.util.JDBCUtils; Public classJDBCDemo2 {@Test Public voidDelete () {Connection conn=NULL; Statement Stat=NULL; Try{conn=Jdbcutils.getconn (); Stat=conn.createstatement (); Stat.executeupdate ("Delete from user where name = ' Zhaoliu '"); } Catch(Exception e) {e.printstacktrace (); } finally{jdbcutils.close (NULL, STAT, conn); }} @Test Public voidfind () {Connection conn=NULL; Statement Stat=NULL; ResultSet RS=NULL; Try{conn=Jdbcutils.getconn (); Stat=conn.createstatement (); RS= Stat.executequery ("select* from user where name = ' Zhaoliu '");  while(Rs.next ()) {String name= Rs.getstring ("name"); String Password= Rs.getstring ("Password"); System. out. println (name +":"+password); }        } Catch(Exception e) {e.printstacktrace (); } finally{jdbcutils.close (RS, stat, conn); }} @Test Public voidUpdate () {Connection conn=NULL; Statement Stat=NULL; Try{conn=Jdbcutils.getconn (); Stat=conn.createstatement (); Stat.executeupdate ("Update user set password=999 where name = ' Zhaoliu '"); } Catch(Exception e) {e.printstacktrace (); } finally{jdbcutils.close (NULL, STAT, conn); }} @Test Public voidAdd () {Connection conn=NULL; Statement Stat=NULL; Try {            //1. Registering the database driver//2. Get the connectionconn =Jdbcutils.getconn (); //3. Get the Transmitter objectStat =conn.createstatement (); //4. Execute SQL statements            intCount = Stat.executeupdate ("INSERT INTO user values (null, ' Zhaoliu ', ' 123456 ', ' [email protected] ', ' 1999-09-09 ')"); //5. Processing Results            if(Count >0) {System. out. println ("Successful Execution! The number of rows affected is"+count); } Else{System. out. println ("Execution failed!! "); }        } Catch(Exception e) {//TODO auto-generated Catch blockE.printstacktrace (); } finally {            //6. Close ResourcesJdbcutils.close (NULL, STAT, conn); }    }}

Jdbcutils.java

1  PackageCom.zhangbz.util;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 ImportJava.sql.ResultSet;6 Importjava.sql.SQLException;7 Importjava.sql.Statement;8 Importjava.util.Properties;9 Ten  Public classJdbcutils { One      Public StaticProperties prop =NULL; A     Privatejdbcutils () { -     } -     //using configuration Files the     Static { -         Try { -Prop =NewProperties (); -Prop.load (jdbcutils.class. getClassLoader (). getResourceAsStream ("Config.properties")); +}Catch(Exception e) { - e.printstacktrace (); +             Throw NewRuntimeException (e); A         } at     } -     /** - * Get Connections -      * @return -      * @throwsclassnotfoundexception -      * @throwsSQLException in      */ -      Public StaticConnection Getconn ()throwsClassNotFoundException, SQLException { to         //1. Registering the database driver +Class.forName (Prop.getproperty ("Driver")); -         //2. Get the connection the         returnDrivermanager.getconnection (prop.getproperty ("url"), Prop.getproperty ("user"), Prop.getproperty ("Password")); *     } $     /**Panax Notoginseng * Close Connection -      */ the      Public Static voidClose (ResultSet RS, Statement Stat, Connection conn) { +         if(rs! =NULL) { A             Try { the rs.close (); +}Catch(SQLException e) { -                 //TODO auto-generated Catch block $ e.printstacktrace (); $}finally { -rs =NULL; -             } the         } -         if(Stat! =NULL) {Wuyi             Try { the stat.close (); -}Catch(SQLException e) { Wu                 //TODO auto-generated Catch block - e.printstacktrace (); About}finally { $Stat =NULL; -             } -         } -         if(Conn! =NULL) { A             Try { + conn.close (); the}Catch(SQLException e) { -                 //TODO auto-generated Catch block $ e.printstacktrace (); the}finally { theconn =NULL; the             } the         } -     } in}

Config.properties

driver=com.mysql.jdbc.Driverurl=jdbc:mysql:///day10user=Rootpassword =root

JDBC Additions and deletions (using configuration files)