JDBC编程案例

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();
	}
}