Read the SQL file to create a database inserted into the database

/ * Execute program * / package enginerydb;

Import java.sql. *; import java.util. *; import java.io. *;

Public Class JBSQL {

Public string query_state = null; / * Define SQL statement * / public connection conn = null; public statement stmt = null; public resultset res = null;

Public string param []; / * Query criteria, or new record * / public jbsql () {}

Public void setParam (String [] param) {this.Param = param;}

Public void setQueryStatement (string query_statement) {this.query_statement = query_statement;}

public void setConnection (String driverName, String jdbcURL, String username, String passwd) throws Exception {Connection conn1; Class.forName (driverName); conn1 = DriverManager.getConnection (jdbcURL, username, passwd); conn1.setAutoCommit (false); this .conn = conn1;

/ * Get the query result * / public ResultSet getResult () {try {PreparedStatement select_stm = conn.prepareStatement (query_statement, java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); if (! Param = null) {for (INT i = 0; i

// Find ';' positions public ArrayList findPlace (String fileName) throws Exception {FileReader fileReader = new FileReader (fileName); ArrayList array = new ArrayList (); char [] chrBuffer = new char [1024 * 35]; // all Data is placed in the buffer FileReader.read (chrbuffer); // strastream: contains all String string strstream = new string (chrbuffer); int index = 0; for (int i = 0; i

try {// create a database statement enginedb engine_sql = engine_sql engine_db ";"; mysqlBean.setConnection (driverName, jdbcURL, username, passwd); mysqlBean.setQuerystatement (engine_sql); mysqlBean.createDateBase ();