package util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCUtil {private static String url="jdbc:mysql://localhost:3306/animals";private static String username="root";private static String password="";private static String drivername="com.mysql.jdbc.Driver";static{try {//加载驱动Class.forName(drivername);} catch (ClassNotFoundException e) {e.printStackTrace();}}public static Connection getConnection(){try {//建立连接return DriverManager.getConnection(url, username, password);} catch (SQLException e) {e.printStackTrace();}return null;}public static void release(ResultSet rs, Statement st,Connection conn){//释放资源try {if(rs!=null){rs.close();}if(st!=null){st.close();}if(conn!=null){conn.close();}} catch (SQLException e) {e.printStackTrace();}}}
javaServlet JDBCUtil
最新推荐文章于 2021-11-06 17:27:09 发布