java 連結mysql工具包代碼

標籤：red   localhost   auto   trace   resultset   color   java   get   import   

package connutil;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Connutil {        public static Connection 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 block            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }                        return conn;    }        public static void closeconn(Connection conn,PreparedStatement ps,Statement sta,ResultSet rs){        try {            if(conn != null)                conn.close();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        try {            if(ps != null)                ps.close();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        try {            if(sta != null)                sta.close();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        try {            if(rs != null)                rs.close();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }                    }}

 

java 連結mysql工具包代碼