JDBC编程案例

来源：互联网发布：js uint8array int 编辑：程序博客网时间：2024/06/04 08:29

1、把用户控制台输入的格式为"9999_zhangsan1_SALESMAN_7698_1981-02-20_2000_300_40"
字符串里数据（数据和emp列顺序一致）分割出来存入数据库表emp中，
如果添加成功则控制台打印“添加成功”,添加失败则打印"添加失败"

（如主键重复，列数据长度超出等）。

package com.mysql.jdbc;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;import java.sql.Connection;public class Test1 {public static void main(String[] args){demo1();}private static void demo1() {String sql=getInputsql();Connection conn=null;Statement stmt=null;try{Class.forName("com.mysql.jdbc.Driver");conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql-me","root","123456");stmt=conn.createStatement();int count= stmt.executeUpdate(sql);System.out.println("添加了"+count+"条记录");System.out.println("添加成功");}catch (SQLException e) {System.out.println("与数据库通信出问题");e.printStackTrace();} catch (ClassNotFoundException e) {System.out.println("驱动类没有找到");}finally{if(stmt!=null){try {stmt.close();} catch (SQLException e) {e.printStackTrace();}}if(conn!=null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}private static String getInputsql() {Scanner sc=new Scanner(System.in);System.out.println("请输入emp人员信息数据格式-9999_zhangsan1_SALESMAN_7698_1981-02-20_2000_300_40");String date=sc.next();String[] dataArr=date.split("_");StringBuilder sql=new StringBuilder("insert into emp values(");sql.append(dataArr[0]);sql.append(",'");sql.append(dataArr[1]);sql.append("',\"");sql.append(dataArr[2]);sql.append("\",");sql.append(dataArr[3]);sql.append(",'");sql.append(dataArr[4]);sql.append("',");sql.append(dataArr[5]);sql.append(",");sql.append(dataArr[6]);sql.append(",");sql.append(dataArr[7]);sql.append(")");System.out.println(sql);return sql.toString();}}

0 0