PackageConnutil;Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.PreparedStatement;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Statement; Public classConnutil { Public StaticConnection Getconn () {Connection conn=NULL; Try{class.forname ("Com.mysql.jdbc.Driver"); Conn= Drivermanager.getconnection ("Jdbc:mysql://localhost:3306/homework", "root", "root"); } Catch(ClassNotFoundException e) {//TODO auto-generated Catch blockE.printstacktrace (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); } returnConn; } Public Static voidcloseconn (Connection conn,preparedstatement ps,statement sta,resultset rs) {Try { if(Conn! =NULL) Conn.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); } Try { if(PS! =NULL) Ps.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); } Try { if(STA! =NULL) Sta.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); } Try { if(rs! =NULL) Rs.close (); } Catch(SQLException e) {//TODO auto-generated Catch blockE.printstacktrace (); } }}
Java Link MySQL Toolkit code