java实验4.(4)删除Mysql数据库记录

4、用Java编程(DeleteStu.java) 删除某id对应的记录或者删除学号和姓名中部分匹配的记录。

SQL语句：>-88

DELETE  FROM stu WHERE  id=88

               >123

               DELETE  FROM stu WHERE num LIKE '%123%'  OR name LIKE '%123%'

完整代码如下：

import java.util.*;
import java.sql.*;

public class DeleteStu {
	static private Connection conn;
	static int cnt = -1;
	static Scanner in = new Scanner(System.in);
        static int sno = 1;
	public static void main(String args[]) {
               	if (connect()) {
                        String lineWords[];
                        // 是否还有输入
 		        while ((lineWords=getNextLineWords())!=null) { 
                            String s = "";
                            for(int i=0;i<lineWords.length;i++){
                                s = s + lineWords[i];
                            }
                            String ss = s.substring(0,1); 
                            if(ss.equals("-")){
                                s = s.substring(1,s.length());
                                updateStuInfo("DELETE  FROM stu WHERE  id="+s+";"); 
                            }
                            else{
                                updateStuInfo("DELETE  FROM stu WHERE num LIKE '%"+s+"%'  OR name LIKE '%"+s+"%';"); 
                            }
                            
		        }

		} 
                else {
			System.out.println("Connect Error!");
		}

	}

        public static String[] getNextLineWords(){
           if (sno==1){
     	      System.out.println("输入学号,姓名或者id,学号，姓名，exit或空行退出.\r\n");
           }
           System.out.print(sno+"> ");			
	   if (!in.hasNextLine()) { // 是否还有输入
              return null;
           }
	   String line = in.nextLine(); // 读取下一行
           line = line.trim();
           if (line.equals("exit") || line.length() == 0) {
	       return null;
	   }
           sno++;
	   return line.split(" ");	
       } 


        // 建立连接
	private static boolean connect() {
		String connectString = "jdbc:mysql://172.18.187.230:3306/teaching"
				+ "?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&&useSSL=false";
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(connectString, "user", "123");
			return true;
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return false;
	}
	
	//执行SQL修改语句, 返回结果集
	static private boolean executeUpdate(String sqlSentence) {
	     Statement stat;
	     ResultSet rs = null;
	        
	     try {
		stat = conn.createStatement();       //获取执行sql语句的对象
		cnt = stat.executeUpdate(sqlSentence); //执行sql修改，返回结果集
	     } catch (Exception e) {
		System.out.println(e.getMessage());
	     }
	     return (cnt>=0);
	}

	//显示插入结果
        private static void updateStuInfo(String sqlSentence){
             if(executeUpdate(sqlSentence)){
                 System.out.println(""+cnt + " 个记录被修改");
             }
             else{
                 System.out.println("0个记录被修改");             
             }
             
       }


}