package com.conn; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.mysql.jdbc.Statement; public class JBconnection { private static final String drivename="com.mysql.jdbc.Driver"; private static final String URL="jdbc:mysql://localhost:3306/goods_db"; private static final String USER="root"; private static final String PWD="123456"; static { try { Class.forName(drivename); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getcon() { try { return DriverManager.getConnection(URL,USER,PWD); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public static void close(ResultSet rs,PreparedStatement ps,Connection con) throws SQLException { if (rs!=null) { rs.close(); } if (ps!=null) { ps.close(); } if (con!=null)