Pulse Of The Blogosphere » JAVA

HOME / Other / Java / JAVA – JDBC là gì

JAVA – JDBC là gì

Author: admin - Posted: 09/11/19 - Update: 09/11/19

JDBC

Kết nối vớiJDBC

public class Main {
    public static void main(String[] args) {
        try{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/databasename?useUnicode=true&&characterEncoding=utf-8";
            String username = "root";
            String password = "";
            Connection conn = DriverManager.getConnection(url,username,password);

            Statement stm = conn.createStatement();

            String ins_sql = "INSERT INTO student(student_name,age,mark) VALUES('Ngô Vên Duy',18,2)";
            stm.executeUpdate(ins_sql);

            String sql = "SELECT * FROM student";

            ResultSet rs = stm.executeQuery(sql);
            System.out.println(rs);

            while (rs.next()){
                System.out.println(rs.getInt("id"));
                System.out.println(rs.getString("student_name"));
                System.out.println(rs.getInt("age"));
                System.out.println(rs.getInt("mark"));

            }
        }
        catch (Exception e){
            System.out.println(e.getMessage());
        }
    }
}

public class Main {

public static void main(String[] args) {

try{

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/databasename?useUnicode=true&&characterEncoding=utf-8";

String username = "root";

String password = "";

Connection conn = DriverManager.getConnection(url,username,password);

Statement stm = conn.createStatement();

String ins_sql = "INSERT INTO student(student_name,age,mark) VALUES('Ngô Vên Duy',18,2)";

stm.executeUpdate(ins_sql);

String sql = "SELECT * FROM student";

ResultSet rs = stm.executeQuery(sql);

System.out.println(rs);

while (rs.next()){

System.out.println(rs.getInt("id"));

System.out.println(rs.getString("student_name"));

System.out.println(rs.getInt("age"));

System.out.println(rs.getInt("mark"));

}

catch (Exception e){

System.out.println(e.getMessage());

}

Java

JAVA – Tổng quan