1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| import java.sql.*;
import java.sql.Driver;
public class test_JDBC_mysql {
public static void main(String []args){
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
System.out.println("Pilote JDBC non enregistré");
}
String url = "jdbc:mysql://localhost/data1";
try {
Connection c;
c = DriverManager.getConnection(url,"root","");
Statement st = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String strSql1 = "SELECT nom,prenom FROM client WHERE prenom='ahmed' ";
ResultSet rs1 = st.executeQuery(strSql1);
while (rs1.next()){
rs1.updateString("nom","hi freinds");
rs1.updateRow();
}
} catch (SQLException ex) {
System.out.println("Erreur SQL :"+ex.getMessage());
}
}
} |
Partager