Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // DBINFO
- package com.sidahmed;
- import org.springframework.jdbc.core.JdbcTemplate;
- import org.springframework.orm.jpa.vendor.Database;
- /**
- * Created by stevlulz on 30/09/17.
- */
- public class DatabaseInfo {
- JdbcTemplate jdbcTemplate;
- public DatabaseInfo(JdbcTemplate a){
- jdbcTemplate = a;
- }
- public int insertPerson(Person p){
- String sql = "INSERT INTO `person`(`name`, `age`) VALUES ('"+
- p.getName()+"','"+p.getAge()+"')";
- return this.jdbcTemplate.update(sql);
- }
- }
- //==========================================
- //Main
- package com.sidahmed;
- import com.sun.deploy.perf.PerfRollup;
- import org.springframework.context.ApplicationContext;
- import org.springframework.context.support.ClassPathXmlApplicationContext;
- import org.springframework.jdbc.core.JdbcTemplate;
- import org.springframework.jdbc.datasource.DriverManagerDataSource;
- public class Main {
- public static void main(String[] args) {
- /*
- ApplicationContext context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
- Person p =(Person) context.getBean("p");
- DatabaseInfo i = (DatabaseInfo) context.getBean("dbi");
- */
- DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
- driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
- driverManagerDataSource.setUrl("jdbc:mysql://localhost/sidahmed");
- driverManagerDataSource.setUsername("root");
- driverManagerDataSource.setPassword("");
- JdbcTemplate a = new JdbcTemplate(driverManagerDataSource);
- DatabaseInfo db = new DatabaseInfo(a);
- Person achour = new Person("abdo","21");
- int j = db.insertPerson(achour);
- System.out.print(j);
- }
- }
- // ===================================================
- //Person
- package com.sidahmed;
- public class Person {
- private int id;
- private String name;
- private String age;
- public Person(String name, String age){
- this.name = name;
- this.age = age;
- }
- public String getName(){
- return this.name;
- }
- public String getAge(){
- return this.age;
- }
- public void display(){
- System.out.println("ID : "+id);
- System.out.println("Name : "+name);
- System.out.println("Age : "+age);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement