java连接数据库

连接数据库：
DBUtil.java

package sensitiveword_test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
    private static String driver;
    private static String url;
    private static String username;
    private static String password;

    static
    {
        driver="com.mysql.jdbc.Driver";
        url="jdbc:mysql://127.0.0.1:3306/sensitivedata";
        username="root";
        password="";
    }
    public static Connection open()
    {
        try {
            Class.forName(driver);
            return DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return null;

    }
    public static void close(Connection conn) {
        if(conn!=null) {
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

数据库操作：

Connection conn =DBUtil.open();
sql1="select * from news_sensitive where nsensitivity>='"+f1+"' and nsensitivity<='"+f2+"'";
sql2="delete  from news_sensitive " + "where id="+id+"";
sql3="insert into news_sensitive(a,b,c)"+"values('"+field1+"','"+field2+"','"+field3+"')";

Statement stmt=conn.createStatement();
stmt.execute(sql1);
ResultSet re =stmt.executeQuery(sql1);
DBUtil.close(conn);