Comment
arash
it s no good look at this one,
December 3, 2007 at 9:15 PM
December 3, 2007 at 9:15 PM
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());
}
}
}
View All Comments | View Tutorial
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());
}
}
}
View All Comments | View Tutorial
Related Tutorial and Articles
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
- Most Effective SEO Tools
- Assigning value to anchor <a></a> tag using custom tag
- java code using while loop
