怎么彻底删除nosql manager for mongedb

Question

怎么彻底删除nosql manager for mongedb

Answer 1

package basic; 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 JDBC { public void findAll() { try { // 获得数据库驱动 //由于长时间不写，驱动名和URL都忘记了，不知道对不对，你应该知道的，自己改一下的哈 String url = "jdbc:oracle:thin:@localhost:1521:XE"; String userName = "system"; String password = "system"; Class.forName("oracle.jdbc.driver.OracleDriver"); // 创建连接 Connection conn = DriverManager.getConnection(url, userName, password); // 新建发送sql语句的对象 Statement st = conn.createStatement(); // 执行sql String sql = "select * from users"; ResultSet rs = st.executeQuery(sql); // 处理结果 while(rs.next()){ //这个地方就是给你的封装类属性赋值 System.out.println("UserName："+rs.getString(0)); } // 关闭连接 rs.close(); st.close(); conn.close(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void delete(){ try { //步骤还是那六个步骤，前边的两步是一样的 String url = "jdbc:oracle:thin:@localhost:1521:XE"; String userName = "system"; String password = "system"; Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection(url,userName,password); //这里的发送sql语句的对象是PreparedStatement,成为预处理sql对象，因为按条件删除是需要不定值的 String sql = "delete from users where id = ?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(0, 1); int row = ps.executeUpdate(); if(row!=0){ System.out.println("删除成功！"); } // 关闭连接 rs.close(); st.close(); conn.close(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }