java实验4.(2)插入mysql数据库

来源：互联网发布：网络监控存储编辑：程序博客网时间：2024/06/04 00:29

2、编程(InsertStu.java)实现新增学生记录的操作。

SQL语句：

> 13405601 Wang Qiang

INSERT INTO stu(num,name)VALUES('13405601','Wang Qiang');

进行SQL之前要注意的是，当前的环境变量是否能找到mysql-connector-java-5.1.39-bin.jar

插入记录的完整代码如下：

import java.util.*;import java.sql.*;public class InsertStu {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 num = "";                            String name= "";                            for(int i=0;i<lineWords.length;i++){                                if(i==0)num = num + lineWords[i];                                else name = name + lineWords[i];                            }                            updateStuInfo("INSERT INTO stu(num,name)VALUES('"+num+"','"+name+"');");         }}                 else {System.out.println("Connect Error!");}}        public static String[] getNextLineWords(){           if (sno==1){           System.out.println("输入学号和姓名(用空格间隔)，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个记录被加入");                          }          }}

0 0