うｐ７７７７９９ - 経済統計練習帳

package upfate;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.PreparedStatement;
 
 
public class pro {
 
 
    public static void main(String[] args) {
        pro test=new pro();
    }
    pro(){
 
 
 
 
    Connection dbx;   
Statement stx;   
String sqx; 
ResultSet  rsx; 
 
 
 
String db,tab;
 
db="book";
tab="book";
 
        String str;
 
 
String url = "jdbc:h2:"+db+";create=true";   
String usr = "";   
String pwd = ""; 
 
 
 try{
 Class.forName("org.h2.Driver");
 
dbx = DriverManager.getConnection(url, usr, pwd); 
 
 
      stx = dbx.createStatement();
 
 
String sql = "UPDATE book SET author = ?,isbn = ?,pic = ?,box = ?,have = ? WHERE title = ?";
PreparedStatement ps = null;
 
 ps = dbx.prepareStatement(sql);
 ps.setString(1, "兵庫県神戸市");
 ps.setString(2, "078-999-9999");
 ps.setString(3, "6666");
 ps.setString(4, "078-999-9999");
 ps.setString(5, "6666");
 ps.setString(6, "6");
 
 int num = ps.executeUpdate();
 
    stx.close();
 } catch (Exception ex) { ex.printStackTrace();} 
 
 
 
        }
 
 
 
 
String change(String str){
String str1;
str1="'"+str+"'";
return str1;
}
 
 
 
 
 
 
 
 
}