約 3,994,409 件
https://w.atwiki.jp/kazuha1015/pages/11.html
Lv別一覧 [#k7f3122b] Lv1~10 [#ead6c86d] Lv11~20 [#gb5c00f1] Lv21~30 [#lad6fe60] Lv31~40 [#p226a224] Lv41~50 [#s64e29b9] Lv51~60 [#xc9dfa8b] Lv61~70 [#a7228464] Lv71~80 [#cd4b07e1] Lv81~90 [#g99e8380] 旧Monster Database? Lv別一覧 Lv1~10 Lv1 / Lv2 / Lv3 / Lv4 / Lv5 / Lv6 / Lv7 / Lv8 / Lv9 / Lv10 Lv11~20 Lv11 / Lv12 / Lv13 / Lv14 / Lv15 / Lv16 / Lv17 / Lv18 / Lv19 / Lv20 Lv21~30 Lv21 / Lv22 / Lv23 / Lv24 / Lv25 / Lv26 / Lv27 / Lv28 / Lv29 / Lv30 Lv31~40 Lv31 / Lv32 / Lv33 / Lv34 / Lv35 / Lv36 / Lv37 / Lv38 / Lv39 / Lv40 Lv41~50 Lv41 / Lv42 / Lv43 / Lv44 / Lv45 / Lv46 / Lv47 / Lv48 / Lv49 / Lv50 Lv51~60 Lv51 / Lv52 / Lv53 / Lv54 / Lv55 / Lv56 / Lv57 / Lv58 / Lv59 / Lv60 Lv61~70 Lv61 / Lv62 / Lv63 / Lv64 / Lv65 / Lv66 / Lv67 / Lv68 / Lv69 / Lv70 Lv71~80 Lv71 / Lv72 / Lv73 / Lv74 / Lv75 / Lv76 / Lv77 / Lv78 / Lv79 / Lv80 Lv81~90 Lv81 / Lv82 / Lv83 / Lv84 / Lv85 / Lv86 / Lv87 / Lv88 / Lv89 / Lv90
https://w.atwiki.jp/heroeswiki/pages/128.html
DATA 製作/スタッフ 原案ティム・クリング 製作総指揮ティム・クリング デニス・ハマー アラン・アーカッシュ 主要人物/キャスト ピーター・ペトレリ(Peter Petrelli)マイロ・ヴィンティミリア ヒロ・ナカムラ(Hiro Nakamura)マシ・オカ クレア・ベネット(Claire Bennet)ヘイデン・パネッティーア モヒンダー・スレシュ(Mohinder Suresh)センディル・ラママーシー ニキ・サンダース(Niki Sanders)アリ・ラーター ネイサン・ペトレリ(Nathan Petrelli)エイドリアン・パスダー アイザック・メンデス(Isaac Mendez)サンティアゴ・カブレラ シモーヌ・デヴォー(Simone Deveaux)タウニー・サイプレス マット・パークマン(Matt Parkman)グレッグ・グランバーグ マイカ・サンダース(Micah Sanders)ノア・グレイ=ケイビー DL・ホーキンス(D.L. Hawkins)レナード・ロバーツ ノア・ベネット(Noah Bennet)ジャック・コールマン アンドウ・マサハシ(Ando Masahashi)ジェイムズ・カイソン・リー サイラー(Sylar)/ガブリエル・グレイ(Gabriel Gray)ザッカリー・クイント エピソード シーズン1 2006~2007年 第1話~第23話 全23話 シーズン2 2007年 第24話~第34話 全11話 シーズン3 2008年 第35話~ シーズン4 2009~2010年 第60話~第78話 全19話 . .
https://w.atwiki.jp/ittec/pages/21.html
package test.action; import java.math.BigDecimal; import java.util.Date; import test.[[AnotationTestDataSet]]; import logger.[[TraceLogger]]; @TraceLogger public class AnotationTestAction implements AnotationTestActionInterface { public AnotationTestAction() { // TODO 自動生成されたコンストラクター・スタブ System.out.println("AnotationTestActionコンストラクタ"); } @Override public AnotationTestDataSet exec() { System.out.println(test("test")); return setDataSet(); } private String test(String val) { StringBuilder stb = new StringBuilder(); return stb.append(val).append("_test").toString(); } private AnotationTestDataSet setDataSet() { AnotationTestDataSet dataSet = new AnotationTestDataSet(); // コード dataSet.setCode(9999); // 名称 dataSet.setName("動的Profileでのロギング確認"); // 日付 dataSet.setDate(new Date()); // 金額 dataSet.setMoney(new BigDecimal(1234567890)); return dataSet; } }
https://w.atwiki.jp/rai002/pages/27.html
基本(search_dir.h) #ifndef SEARCH_DIR_H #define SEARCH_DIR_H //********************************************************************** //作成日:2009/09/19~ //作成者:雷 rai //********************************************************************** //利用可能OSなど //OS:XP,Vista ⇒ディスクトップなどの取得 //.Net Framework 2.0 ⇒ ショートカットファイルからの情報取得 //********************************************************************** //ドライブを認識して、フォルダを検索するとか //最大パスサイズ:260 //足りるか足りないか検討が必要 //足りないときはUnicode対応にして W の分類となっているのを利用すること //********************************************************************** #include windows.h #include string #include iostream #include vector #include time.h #include conio.h #include tchar.h #include locale.h #include shlobj.h //特殊フォルダへのアドレス取得 #define MAX_NAME_NUMBER ( MAX_PATH ) #define MAX_PATH_NAME 32000 #define OS_XP 5 #define OS_VISTA 6 using namespace std; namespace rai{ class DATA{ public string directory; long long int time; int importance;//重要度:初期ソート用? void disp(); void setTime(FILETIME *ft);//FILETIME を時間に変換して保存 void setSysTime(SYSTEMTIME t);//SYSTEMTIME を時間に変換して保存 bool Comparison( string str){ return directory==str;}//true 同じ DATA(){ directory = "\0"; time = 0; importance = 1; } DATA( const DATA t){ directory = t.directory; time = t.time; importance = t.importance; } }; class get_dir{ string user_name, user_dir;//ユーザー名、Documents and Settingsの場所 string My_desk, My_docu; int os_ver;// -1:対応外 vector string un_search_str; vector string drive_info;//ドライブ情報 long long int nowTime; public vector DATA data; vector DATA all_data;//全データを格納 vector string no_data; vector string desk_dir_data;//ディスクトップショートカットリンク vector string docu_dir_data;//マイドキュメントフォルダショートカット vector string quick_data;//クイックランチャーショートカットリンク string file_name; int filelist(const char *sFindDir, const char *sFindFile, int rank); //除外ファイル指定 bool UnSearch( string str); void UnSearchData(); //ドライブが開けるか検査 bool OpenDrive( string str ); //フォルダ検索 void SearchDir(); //ユーザー名の取得 string get_user_name(); void Get_user_folder(); //ディスクトップ、クイックランチャーのショートカット取得 int filelist_user(const char *sFindDir, const char *sFindFile, vector string tempDir); //Windowsのバージョン情報取得 void Get_OS_Ver_Inf(); //ショートカットの情報取得 string Get_Short_Cut_link_Info( string ); //wchar_t を string に変換 string wchar_t_To_string(wchar_t *wstr); //格納データの加工 void data_Processing(); //拡張子を返す もう少し高速化できないだろうか? string GetExtension( string str); //データのソートおよび重複ファイルの間引き&重要度付け void Set_All_data(); //ファイルの時間取得 DATA get_FileToTime(string ); //コンストラクタ get_dir(){ UnSearchData(); user_name=get_user_name(); Get_OS_Ver_Inf(); //機能確認(日付表示) { SYSTEMTIME T; GetLocalTime( T ); DATA t_temp; t_temp.setSysTime( T ); nowTime = t_temp.time; } } }; }//namespace rai ここまで #endif
https://w.atwiki.jp/bulldogwater/
@wikiへようこそ ウィキはみんなで気軽にホームページ編集できるツールです。 このページは自由に編集することができます。 メールで送られてきたパスワードを用いてログインすることで、各種変更(サイト名、トップページ、メンバー管理、サイドページ、デザイン、ページ管理、等)することができます まずはこちらをご覧ください。 @wikiの基本操作 用途別のオススメ機能紹介 @wikiの設定/管理 分からないことは? @wiki ご利用ガイド よくある質問 無料で会員登録できるSNS内の@wiki助け合いコミュニティ @wiki更新情報 @wikiへのお問合せフォーム 等をご活用ください @wiki助け合いコミュニティの掲示板スレッド一覧 #atfb_bbs_list その他お勧めサービスについて 大容量1G、PHP/CGI、MySQL、FTPが使える無料ホームページは@PAGES 無料ブログ作成は@WORDをご利用ください 2ch型の無料掲示板は@chsをご利用ください フォーラム型の無料掲示板は@bbをご利用ください お絵かき掲示板は@paintをご利用ください その他の無料掲示板は@bbsをご利用ください 無料ソーシャルプロフィールサービス @flabo(アットフラボ) おすすめ機能 気になるニュースをチェック 関連するブログ一覧を表示 その他にもいろいろな機能満載!! @wikiプラグイン @wiki便利ツール @wiki構文 @wikiプラグイン一覧 まとめサイト作成支援ツール バグ・不具合を見つけたら? 要望がある場合は? お手数ですが、メールでお問い合わせください。
https://w.atwiki.jp/chibauotogame/pages/63.html
PUC_Database A.音ゲーサークルPUCで、役に立ちそうな音ゲー関連のデータベースを作ってみようという企画です。 特に作成制限とかはありません。 編集希望の方はTwitter@komkoma2727まで連絡ください。 URL:https //docs.google.com/spreadsheets/d/1F1wZGorY8OC6ijz7Dfhxi6KtFNHCWtJcG0MtfB-F5Yk/edit?usp=sharing
https://w.atwiki.jp/lmes2/pages/94.html
DataBind メソッド 概要 コードページ(default.asp.vb等)の変数を、デザインページ(default.aspx)に渡す方法。 ※webコントロール(dropDownListなど)にもDataBindメソッドがあり、それらは主にDataSourceを指定して関連付けする用途で使用するが、この項で説明するのはPageクラスのDataBindメソッドである。 参照: .NET Framework クラス ライブラリ Page.DataBind メソッド 前提条件 新しいwebサイトの作成 手順 「default.aspx.vb」を以下のように変更。 Partial Class _Default Inherits System.Web.UI.Page Public str_temp As String = "hoge" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load DataBind() End Sub End Class 「default.aspx」を以下のように変更。 %@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" % !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http //www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" html xmlns="http //www.w3.org/1999/xhtml" head runat="server" title 無題のページ /title /head body form id="form1" runat="server" div %Response.Write(str_temp)% /div /form /body /html 実行すると以下のようになる。 not found (206.jpg)
https://w.atwiki.jp/nihongodocuments/pages/20.html
Home » Admin and Setup » Installing the database Installing the Database This document attempts to provide information for both experienced and novice users alike. If the command line is your preference, we have command line examples for you to follow. There are also simple GUI approaches, as described in the pgAdmin section. And if all you want is a quick install for demo purposes, then check out our automated installers information. For additional information, you might also read Perry Clark s blog post "Installing PostBooks... the long way." Quick Overview This quick overview assumes you are not using one of the automated installers. Download and extract the xTuple ERP client application to a local directory Download and install PostgreSQL Initialize PostgreSQL for xTuple (This simply means adding the super user admin and the group xtrole .) Create a database using UTF-8 encoding Download and restore an xTuple database on your new database Automated Installers Automated installers are currently available for PostBooks on Windows and Mac. You can download the installers from the PostBooks project pages on SourceForge. The installers are perfect for users interested in demo-ing the product. When you run the installer, everything is handled for you Installs (and starts) PostrgreSQL Loads a demo PostBooks database Installs the PostBooks client Enterprise users should not rely on the installer for their production systems. Instead, install production databases manually as described in this document. The reason for this is that the installers make certain assumptions which may not be recommended for production environments. PostgreSQL Considerations Before you can start using xTuple ERP, you must first have PostgreSQL 8.1.x or later installed and properly configured. Also make sure to check the SupportedPostgresVersions page for the latest details on which PostgreSQL version will work best with your xTuple ERP version. For information related to easy database administration using the open source tool pgAdmin, please see the pgAdmin section below. And for additional information related to installing PostgreSQL, please visit www.postgresql.org where you will find in-depth documentation and other resources related to PostgreSQL. xTuple ERP uses encryption for credit card processing--and because of this, the PostgreSQL "pgcrypto" module is required to support encryption in xTuple ERP. You should be sure to include the pgcrypto module when installing PostgreSQL. If you do not, you will encounter errors. Detailed Instructions The following paragraphs detail the steps (long version) required to both initialize your PostgreSQL instance to support the xTuple Database and load the database schema. To skip these details, see the (short version) Command Line Examples section below. Or skip to the pgAdmin section below to learn about initializing and loading your database using pgAdmin, a free GUI database administration tool. Once you have the PostgreSQL server running, the next step is to establish the user admin and the group xtrole on your PostgreSQL instance. This is done by executing the init.sql script, which is available in the downloads area. The complete text of the init.sql file is as follows -- ** PLEASE NOTE, THE GROUP ROLE IS NOW xtrole , not openmfg -- This script creates the group xtrole and the user admin -- -- -- Create the xtrole group CREATE GROUP xtrole; -- -- Create the admin user with createdb and createuser -- permissions. Place the user in the xtrole group and -- set the password to the default of admin. -- CREATE USER admin WITH PASSWORD admin CREATEDB CREATEUSER IN GROUP xtrole; -- End of init.sql If you are initializing the database server instance from the command line, the init.sql script must be loaded by the postgres superuser. This is not required if you are using pgAdmin to initialize the database server. Please also note that since the default password the admin user is "admin," you ll want to change it immediately. You may create a different admin user with a different name if you choose to. However, do this with caution as all documentation examples refer to the default admin user. When you have finished executing the init.sql script, you should next create a new PostgreSQL database to contain the xTuple Database schema. Use UTF-8 encoding when creating the database. You can name the database anything you want. Shorter names that are easy to remember are preferred. Once the database has been created, you are ready to load the xTuple schema into it. There are several starter schema to choose from, including the following empty.backup - This is an empty database with no data, but all the tables and structures created. quickstart.backup - This database contains a basic Chart of Accounts and also the Account Assignments required to run the full range of transactions. demo.backup - This database (if available) contains a suite of sample data built on top of the quickstart database Like the init.sql script, the database schema can be loaded on the command line. Alternately, you may use GUI tools like pgAdmin III to execute the script and load the schema. For information on loading the databases using pgAdmin, please see the pgAdmin section below. The .backup format of the xTuple Database schemas is a compressed format used by the pg_restore binary. This format may be loaded seamlessly using pgAdmin. To load a .backup file using pgAdmin, connect to the database you created. Right-click on the database object and select the option Restore . On the resulting screen, use the ellipses to navigate to the location of the .backup file on your local machine. With the .backup file selected, simply click OK. To learn more about the psql utility or the pgAdmin application, please consult the PostgreSQL documentation. Command Line Examples The following examples demonstrate the steps needed to initialize, create, and load an xTuple Database. You may give the database you create any name which does not conflict with the rules for naming PostgreSQL databases. However, we recommend that you choose a simple name with all lowercase characters. For example, we have used a database named production in the following example. With a clean PostgreSQL instance installed, you can use the following commands to get started psql -U postgres -f init.sql template1 createdb -U admin production pg_restore -U admin -d production quickstart.backup -v The first command line example uses the psql utility to load the init.sql script. This script creates the user admin and the group xtrole . The first option ( -U postgres ) tells the system to connect as the postgres user. This user is typically the default PostgreSQL superuser. The next option ( -f init.sql ) tells psql to read the init.sql script and execute the commands. The last option ( template1 ) tells psql which database to connect to. You are not required to run the init.sql script against the template1 database. You may also run it against another database you create. Also In newer versions of PostgreSQL, the postgres database is the new default template. By default, the init.sql script will create the admin user with the password of "admin". You should be sure to change the password once you have your xTuple system installed and running. The second command line example uses createdb to create a new database. Notice that this command uses the same first two options as used in the psql command to specify the user to connect as. Note that now we are using the option -U admin to indicate we want to connect as the admin user created previously. The last option is the name of the new database we want to create (e.g., production ). The third command line example loads the schema for the xTuple quickstart Database. The .backup file format is a compressed format and is used by the pg_restore binary. The -d switch enables you to specify the database into which the restore will be performed (i.e., the production database in this example.) Next, we specify the name of the .backup file with the path to its location if necessary. Finally, we specify -v for verbose output. It is important to keep in mind that if you configured PostgreSQL to listen on a port other than the default port of 5432, you will need to specify this with -p XXXX where XXXX is the port number. If you want a .sql file instead of a .backup, you can easily do this using pg_restore, as follows pg_restore -f quickstart.sql quickstart.backup This example says use pg_restore to create a file called quickstart.sql from the file called quickstart.backup . This completes the command line examples section. Using pgAdmin To Get Started pgAdmin is a free, cross-platform GUI tool for administering PostgreSQL databases. In this section we assume you have PostgreSQL already installed on your system. The following screenshots and narrative describe how to get xTuple ERP running on your PostgreSQL server. We will describe how to accomplish two main objectives Configuring PostgreSQL for xTuple Loading the xTuple database(s) Configuring for xTuple Since you already have PostgreSQL installed, the first thing to do is initialize the server so xTuple databases will run successfully on it. While that last sentence may sound complicated, the reality is you only have to do the following things Link pgAdmin to your PostgreSQL server Create a group called "xtrole" Create a user "admin" Put the user "admin" in the group "xtrole" This section assumes you installed PostgreSQL on your local drive (a.k.a. "localhost" or "127.0.0.1"). Okay, so the first thing to do is to create a link between your pgAdmin application and your PostgreSQL database. If that link already exists, then you can skip this step. But if not, simply select the "File" menu option and then select the "Add Server" option. Add New Server When you are presented with the new server screen, enter the information as it s shown in the next screenshot. You have flexibility in some of the options you choose. However, the following must be used Host = localhost or 127.0.0.1 Port = 5432 Username = postgres Password = Password used for postgres user when you installed PostgreSQL Server Definition Once you have the connection between pgAdmin and PostgreSQL completed, the next step is to configure PostgreSQL so xTuple databases will run successfully on it. The first thing to do then is to create the "xtrole" group. By right-clicking on the Group Roles section, you can select the "New Group Role" option. Group Roles When creating the new group role for "xtrole", you only need to enter a minimal amount of information. Enter the same information as it s shown in the next screenshot. The Role name should be lower case. And the only Role Privilege you need is "Inherits rights from parent roles". That s it. No password required. And you don t have to add any information under the other tabs that are shown. Group Role for xtrole Now that you have the "xtrole" group role define, the next step is to create the "admin" user and place the user in the group "xtrole". The next screenshot shows how you can access the screen for creating a new login role. Login Roles The screen for creating a login role for "admin" looks similar to the screen we saw before for creating the "xtrole" group. However, this time we will need to add more information--and select more options. You have some flexibility over some of the options you choose, but the following should be the same as shown in the screenshot Role name = admin Role Privileges = Select all If you don t need the account to expire at a certain point, then just leave the expiration date blank. That will keep the account open indefinitely. Login Role for admin User Once the "admin" user s properties have been defined, select the Role membership tab. It s on this screen you make the user "admin" a member of the group "xtrole". The following screenshot shows the end result of this action. By using the double arrows " " you can move "admin" from not being a member in "openmfg" to being a member in "openmfg". Admin in Group xtrole And that s all you need to initialize PostgreSQL for xTuple. You can now load xTuple ERP databases onto the server and connect to them using your xTuple ERP client application. Creating New Database The last getting started step is to create a database and load (i.e., restore) an xTuple ERP backup file into it. The next screenshot shows how right-clicking on the "Databases" element enables you to access the "New Database" option. List of Databases You can name your database anything you want to. In our example we will be calling our new database "dbTest". When you are creating a new database with pgAdmin, be sure to use the following values, as shown in the screenshot Owner = admin Encoding = UTF8 Template = template1 You can leave everything else with the default values pgAdmin gives you. And there s no need to enter additional information under any of the other tabs. Create New Database The database we just created now appears in the list of databases, as you can see in the next screenshot. Our final step is now to load an xTuple database backup file into the database we created. For the purposes of this example, we will assume you have already downloaded the database backup file from either the PostBooks site on SourceForge--or from the xTuple website (Standard and Manufacturing Editions only). Restoring from Backup File As the next screenshot shows, we can reach the "Restore" option by right-clicking on the new database we just created. The "Restore" option is the one we need to load the xTuple .backup file. Restore Backup File The Restore screen looks just like the next screenshot. All you have to do here is Browse your computer for the xTuple .backup file you downloaded Select it the .backup file so the path to it appears in the "Filename" field You should leave the other options not-selected--except for the last one, which will give you more verbose messaging during the load process (this can be helpful). And then simply select the OK button to begin the restore process. Begin Restore BeginRestore.png Don t worry if the restore takes several minutes to complete. This is normal. At the end of the process you will see log messages which look like those shown in the following screenshot. Depending on the circumstances of your PostgreSQL installation (e.g., whether previous databases have been installed there, etc.), the messages pgAdmin reports may vary. The ideal scenario on a fresh PostgreSQL install is for 0 errors to be reported and an exit code = 0. However, as the next screenshot shows, pgAdmin may report a number of errors and a non-zero exit code. If this is the result you get, don t be alarmed. Simply review the list of errors by using the scroll bar in the "Restore Database" screen. Scroll to the top and review the list of errors which were reported. Most if not all of the errors you get can safely be ignored. Here are some examples of error messages which can safely be ignored. The first error reports that the PostgreSQL procedural language plpgsql is already installed--and so it does not need to be restored pg_restore creating PROCEDURAL LANGUAGE plpgsql pg_restore [archiver (db)] Error while PROCESSING TOC pg_restore [archiver (db)] Error from TOC entry 2121; 2612 48797691 PROCEDURAL LANGUAGE plpgsql pg_restore [archiver (db)] could not execute query ERROR language "plpgsql" already exists Command was CREATE PROCEDURAL LANGUAGE plpgsql; Likewise, you may see other messages such as the following two, which both indicate functionality already exists and does not need to be restored from the .backup file Example 1 pg_restore [archiver (db)] Error from TOC entry 18; 1255 7469922 FUNCTION armor(bytea) admin pg_restore [archiver (db)] could not execute query ERROR function "armor" already exists with same argument types Command was CREATE FUNCTION armor(bytea) RETURNS text AS $libdir/pgcrypto , pg_armor LANGUAGE c IMMUTABLE STRICT; Example 2 pg_restore [archiver (db)] Error from TOC entry 20; 1255 7470043 FUNCTION crypt(text, text) admin pg_restore [archiver (db)] could not execute query ERROR function "crypt" already exists with same argument types Command was CREATE FUNCTION crypt(text, text) RETURNS text AS $libdir/pgcrypto , pg_crypt LANGUAGE c IMMUTABLE STRICT; In short, you should review any error messages you get when restoring an xTuple database backup file. However, in many cases the errors that are being reported can safely be ignored. Use your common sense when reviewing error messages. If you come across an error message which concerns you, search the xTuple forums to see if others have been concerned about the same thing. Quite often others in the community will have seen the same errors you are concerned about. Once the restore is completed, select the OK button. Restore Complete To see that the restore operation loaded the xTuple database successfully, simply refresh your pgAdmin view. Then expand the new database element to see the xTuple schema (i.e., tables, functions, etc.) listed under the Schema element. The following screenshot shows the "api" and "public" schema found in every xTuple database. Database Schema Loaded Successfully So that s all you have to do. Now simply locate your xTuple client application and open it up. Then use the following login options Server = localhost or 127.0.0.1 Database = dbTest (or whatever you named yours) Port = 5432 Username = admin Password = admin You can use the same steps described above to add more databases to your PostgreSQL server. However, if you are running a production database, we recommend that you run only the production database on the server--and don t load other databases onto the same PostgreSQL instance.
https://w.atwiki.jp/seven-eleven/pages/11.html
data
https://w.atwiki.jp/ce00582/pages/4558.html
import java.sql.*; class bloginsert{ String[] title=new String[100]; String[] des=new String[100]; int bcode; String bname; void makedata(String database,int num,int s){ String url = "jdbc derby db;create=true"; String usr = ""; String pwd = ""; Connection dbx; String sqx; sqx="insert into "; sqx=sqx+database; sqx=sqx+"(num,bname,bcode,title,des) values (?,?,?,?,?)"; try { dbx = DriverManager.getConnection(url, usr, pwd); PreparedStatement pstmt = dbx.prepareStatement(sqx); pstmt.setInt(1, num); pstmt.setString(2,bname); pstmt.setInt(3, bcode); pstmt.setString(4, title[s]); pstmt.setString(5, des[s]); int nu = pstmt.executeUpdate(); dbx.close(); }catch (SQLException e){System.out.println("SQLException " + e.getMessage());} } }