欢迎使用

package mybeans;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.mysql.cj.result.Row;

public class Batch
{
public Connection connection;
public int row;

public Connection getConnection()
{
	connection=null;
	try {
		Class.forName("com.mysql.cj.jdbc.Driver");
		String url="jdbc:mysql://49.234.45.101/lht?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&useSSL=false";
		String username="root";
		String password="1234";
		connection=DriverManager.getConnection(url,username,password);
		}
	catch (ClassNotFoundException e) 
	{
		e.printStackTrace();
	}
	catch (Exception e) 
	{
		e.printStackTrace();
	}
	return connection;
}



public int getInsert(String sql)
{	
	
	try 
	{		
	PreparedStatement ps=connection.prepareStatement(sql);
	row=ps.executeUpdate();
	
	}
	catch (Exception e)
	{
		e.printStackTrace();
		System.out.println("failure to add data");
	}
	return row;		
}

}

<%@page import=“mybeans.Batch”%>
<%@ page language=“java” contentType=“text/html; charset=ISO-8859-1”
pageEncoding=“ISO-8859-1”%>
<%@page import=“java.sql.Connection”%>

<%-- --%> <%--two ways to use batch.class --%> <% try { Batch batch=new Batch(); Connection conn=batch.getConnection(); String sql="insert into tb_puzzlecases(id,pTime,doctor,title,content)values(?,?,?,?,?)"; int row=batch.getInsert("sql"); if (row==0) { out.println("succeed to add data"); } } catch (Exception e) { out.println("failure"); e.printStackTrace(); } %>