Jbsql

Author: f | 2025-04-25

Download JBSQL latest version for Windows free. JBSQL latest update: Novem

jbsql/Dockerfile at master 0k00l/jbsql - GitHub

最後更新：2018-12-04 來源：互聯網上載者：User /*執行程式*/package enginedb;import java.sql.*;import java.util.*;import java.io.*;public class JBSQL { public String query_statement = null; /*定義sql語句*/ public Connection conn = null; public Statement stmt = null; public ResultSet res = null; public String param[]; /*查詢條件,或者是新的記錄*/ 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; } /*擷取查詢結果*/ 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 select_stm.setString(i + 1, param[i]); } } res = select_stm.executeQuery(); } catch (Exception e) { System.out.println(e); } return res; } //建立資料庫 public void createDateBase() throws SQLException, java.io.UnsupportedEncodingException { try { //程式轉碼,可以解決中文問題 PreparedStatement create_stm = conn.prepareStatement(new String( query_statement.getBytes(), "iso8859_1")); create_stm.executeUpdate(); create_stm.close(); conn.commit(); } catch (Exception e) { System.out.println(e); conn.rollback(); } } //建立工作流程資料庫 public void createEngineDB() throws SQLException, java.io.UnsupportedEncodingException { try { PreparedStatement create_stm = conn.prepareStatement(query_statement); create_stm.executeUpdate(); create_stm.close(); conn.commit(); } catch (Exception e) { System.out.println(e); conn.rollback(); } } //尋找';'位置 public ArrayList findPlace(String fileName) throws Exception { FileReader fileReader = new FileReader(fileName); ArrayList array = new ArrayList(); char[] chrBuffer = new char[1024 * 35]; //所有資料放入到Buffer中 fileReader.read(chrBuffer); //strStream:含有全部讀出的string String strStream = new String(chrBuffer); int index = 0; for (int i = 0; i if (chrBuffer[i] != '/0') { //如果未到末尾 //尋找';'的位置 if (chrBuffer[i] == ';') { //輸出';'所在位置 char[] chars = new char[1024]; strStream.getChars(index, i + 1, chars, 0); //取出的字元傳加到ArrayList中 array.add(new String(chars)); index = i + 1; } //end if } //end if } fileReader.close(); return array; }}/*執行程式*/package enginedb;import java.util.*;public class JBMain { public JBMain() { } public static void main(String[] args) { JBSQL mysqlBean = new JBSQL(); String driverName = "org.gjt.mm.mysql.Driver"; String jdbcURL = "jdbc:mysql://127.0.0.1:3306/"; String username = "root"; String

jbsql/Readme.md at master 0k00l/jbsql - GitHub

. Download JBSQL latest version for Windows free. JBSQL latest update: Novem JBSql is a command-line interface to the Java-based JDBC driver for Oracle database that was first released in version 1.3.5. While JBSql is primarily used with Oracle databases, JBSql is

JBSQL/README.md at main Janyaburton/JBSQL - GitHub

JBSQL - FREE Download JBSQL 1.0 Databases Networks

JBSQL - FREE Download JBSQL 1.0 Databases - WinSite

. Download JBSQL latest version for Windows free. JBSQL latest update: Novem JBSql is a command-line interface to the Java-based JDBC driver for Oracle database that was first released in version 1.3.5. While JBSql is primarily used with Oracle databases, JBSql is

JBSQL - FREE Download JBSQL 1.0 Databases Networks Development