conndb.java

是mysql数据库数据导入程序是从excel中提取数据导入到mysql数据库中

package com.conn;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnDb {

	private Connection conn;
	private Statement st;
	public Connection getConn()
	{
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://localhost:3306/newdatabase_dbo";
			try {
				conn = java.sql.DriverManager.getConnection(url,"root","123456");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	public int insert(String value)
	{
		int i = 0;
		conn = getConn();
		try {
			st = conn.createStatement();
			String sql = "insert into shiyan values(1,'"+value+"')";
			i = st.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			close();
		}
		return i;
	}
	public void close()
	{
		try{
			if(st!= null)
			{
				st.close();
			}
			if(conn!=null)
			{
				conn.close();
			}
		}
		catch (Exception e){
			e.printStackTrace();
		}
	}
}