It S No Good Look At This One, Jdbc Jdbc Mysql CreateMySqlTable

import java.sql.*;




public class Connexion {

private Connection con;
private Statement stmt;

private String driver;
private String login;
private String url;
private String psw;
private String createString;
private String db="gousfand";





/** Creates a new instance of Connexion */
public Connexion() {
login = "root";
psw = null;

createString = "create table COFFEES " +
"(COF_NAME VARCHAR(32), " +
"SUP_ID INTEGER, " +
"PRICE FLOAT, " +
"SALES INTEGER, " +
"TOTAL INTEGER)";


driver ="jdbc:mysql";

url = "jdbc:mysql://localhost";
//jdbc:derby:dbName;create=true

try{
Class.forName("com.mysql.jdbc.Driver");
}catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try{

con = DriverManager.getConnection(url, login, psw);
System.out.println("OK connexion réussie...");
stmt = con.createStatement();
//creeon un DB
stmt=con.createStatement();
stmt.executeUpdate("CREATE DATABASE mostafa;");
//creon une table
stmt.executeUpdate(createString);
stmt.close();
con.close();

}

catch(SQLException ex){
System.out.println(ex.getMessage());
}
}




public Statement getStmt() {
return stmt;
}

public Connection getCon() {
return con;
}


//// notre main
public static void main(String[] args) {
Connexion ar = new Connexion();

try{
Connexion connect = new Connexion();
ar.stmt = connect.getStmt();
// ar.con = connect.getCon();

//rqt = new Requete(con, stmt);
//mise_a_jour();
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
}



}

Posted by arash on Monday, 12.3.07 @ 21:15pm | #41193