Advertisement
stevlulz

JavaJDBC

Oct 18th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.39 KB | None | 0 0
  1. // DBINFO
  2. package com.sidahmed;
  3.  
  4. import org.springframework.jdbc.core.JdbcTemplate;
  5. import org.springframework.orm.jpa.vendor.Database;
  6.  
  7. /**
  8.  * Created by stevlulz on 30/09/17.
  9.  */
  10. public class DatabaseInfo {
  11.  
  12.     JdbcTemplate jdbcTemplate;
  13.  
  14.     public DatabaseInfo(JdbcTemplate a){
  15.         jdbcTemplate = a;
  16.     }
  17.  
  18.     public int insertPerson(Person p){
  19.  
  20.         String sql = "INSERT INTO `person`(`name`, `age`) VALUES ('"+
  21.                         p.getName()+"','"+p.getAge()+"')";
  22.         return this.jdbcTemplate.update(sql);
  23.  
  24.     }
  25. }
  26.  
  27.  
  28.  
  29.  
  30.  
  31. //==========================================
  32. //Main
  33.  
  34. package com.sidahmed;
  35.  
  36. import com.sun.deploy.perf.PerfRollup;
  37. import org.springframework.context.ApplicationContext;
  38. import org.springframework.context.support.ClassPathXmlApplicationContext;
  39. import org.springframework.jdbc.core.JdbcTemplate;
  40. import org.springframework.jdbc.datasource.DriverManagerDataSource;
  41.  
  42. public class Main {
  43.  
  44.     public static void main(String[] args) {
  45.         /*
  46.         ApplicationContext context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
  47.         Person p =(Person) context.getBean("p");
  48.         DatabaseInfo i = (DatabaseInfo) context.getBean("dbi");
  49.         */
  50.         DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
  51.         driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
  52.         driverManagerDataSource.setUrl("jdbc:mysql://localhost/sidahmed");
  53.         driverManagerDataSource.setUsername("root");
  54.         driverManagerDataSource.setPassword("");
  55.  
  56.         JdbcTemplate a = new JdbcTemplate(driverManagerDataSource);
  57.         DatabaseInfo db = new DatabaseInfo(a);
  58.         Person achour = new Person("abdo","21");
  59.         int j = db.insertPerson(achour);
  60.         System.out.print(j);
  61.  
  62.  
  63.     }
  64. }
  65.  
  66.  
  67. // ===================================================
  68. //Person
  69. package com.sidahmed;
  70.  
  71.  
  72. public class Person {
  73.     private int id;
  74.     private String name;
  75.     private String age;
  76.  
  77.    public Person(String name, String age){
  78.        this.name = name;
  79.        this.age = age;
  80.  
  81.    }
  82.    public String getName(){
  83.        return this.name;
  84.    }
  85.    public String getAge(){
  86.        return this.age;
  87.    }
  88.  
  89.    public void display(){
  90.        System.out.println("ID : "+id);
  91.        System.out.println("Name : "+name);
  92.        System.out.println("Age : "+age);
  93.  
  94.    }
  95. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement