xls导入远程mysql案例_excel导入数据库实例（含源码 超级详细适合新手）

package com.b510.excel.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.b510.common.Common;

import com.b510.excel.vo.Student;public classDbUtil {//保存到数据库

public static voidinsert(String sql, Student student) throws SQLException {

Connection conn= null;

PreparedStatement ps= null;try{

Class.forName(Common.DRIVER);

conn=DriverManager.getConnection(Common.URL, Common.USERNAME, Common.PASSWORD);

ps=conn.prepareStatement(sql);

ps.setString(1, student.getNo());

ps.setString(2, student.getName());

ps.setString(3, student.getAge());

ps.setString(4, String.valueOf(student.getScore()));

boolean flag=ps.execute();if(!flag){

System.out.println("Save data : No. =" + student.getNo() + ", Name =" + student.getName() + ", Age =" + student.getAge() + "succeed!");

}

}catch(Exception e) {

e.printStackTrace();

}finally{if (ps != null) {

ps.close();

}if (conn != null) {

conn.close();

}

}

}

@SuppressWarnings({"unchecked", "rawtypes"})public staticList selectOne(String sql, Student student) throws SQLException {

Connection conn= null;

PreparedStatement ps= null;

ResultSet rs= null;

List list= newArrayList();try{

Class.forName(Common.DRIVER);

conn=DriverManager.getConnection(Common.URL, Common.USERNAME, Common.PASSWORD);

ps=conn.prepareStatement(sql);

rs=ps.executeQuery();while(rs.next()){if(rs.getString("no").equals(student.getNo()) || rs.getString("name").equals(student.getName())|| rs.getString("age").equals(student.getAge())){

list.add(1);

}else{

list.add(0);

}

}

}catch(Exception e) {

e.printStackTrace();

}finally{if (rs != null) {

rs.close();

}if (ps != null) {

ps.close();

}if (conn != null) {

conn.close();

}

}returnlist;

}public staticResultSet selectAll(String sql) throws SQLException {

Connection conn= null;

PreparedStatement ps= null;

ResultSet rs= null;try{

Class.forName(Common.DRIVER);

conn=DriverManager.getConnection(Common.URL, Common.USERNAME, Common.PASSWORD);

ps=conn.prepareStatement(sql);

rs=ps.executeQuery();

}catch(Exception e) {

e.printStackTrace();

}finally{if (rs != null) {

rs.close();

}if (ps != null) {

ps.close();

}if (conn != null) {

conn.close();

}

}returnrs;

}

}