JDBC med java syntax.
import java.sql.*;public class Insert{
public static void main(String[] args) {
System.out.println("Inserting values in Mysql database table!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "mads";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","mohdmasih");
try{
Statement s = con.createStatement();
s.executeUpdate("INSERT into 10it2 (Employee_ID, F_navn, E_navn, CPR_nr, E_mail, Adresse, Ans_dato, Afdeling) VALUES('1', 'Aman', 'azaa', '0201030088', 'aza@hotmail.com', 'asdasdw', '05-08-2010', 'Pro')");
System.out.println("1 row affected");
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
-----------------------------------------------------------
fejlen:
Inserting values in Mysql database table!
SQL statement is not executed!
-----------------------------------------------------------
Jeg er helt ny både i database og java. Kan se fejeln.
tak på forhånd.
