Advertisement
Guest User

Untitled

a guest
Jul 30th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.96 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3.  
  4. public class DBConnection {
  5. public static Connection getDBConnection() {
  6. String url = "jdbc:mysql://localhost:3306/";
  7. String dbName = "expenseCalc";
  8. String driver = "com.mysql.jdbc.Driver";
  9. String userName = "*********";
  10. String password = "*******";
  11. Connection conn = null;
  12. try {
  13. Class.forName(driver).newInstance();
  14. conn = (Connection) DriverManager.getConnection(url + dbName, userName, password);
  15. } catch (Exception e) {
  16. e.printStackTrace();
  17. }
  18. return conn;
  19. }
  20. }
  21.  
  22. SpringConfig.class
  23.  
  24. import org.springframework.context.annotation.Bean;
  25. import org.springframework.context.annotation.Configuration;
  26.  
  27. @Configuration
  28. public class SpringConfig {
  29. @Bean("sqloperations")
  30. public SQLOperationJavaConfig sqLoperationJavaConfig() {
  31. DBConnection dbConnection=new AppJavaConfig<DBConnection>().getbean("dbconnection");
  32. return new SQLOperationJavaConfig(dbConnection);
  33. }
  34. @Bean("dbconnection")
  35. public DBConnection dbConnection() {
  36. return new DBConnection();
  37. }
  38. }
  39.  
  40. SQLOperationJavaConfig.class
  41.  
  42. public class SQLOperationJavaConfig {
  43. private DBConnection dbConnection;
  44. public SQLOperationJavaConfig(DBConnection dbConnection) {
  45. this.dbConnection=dbConnection;
  46. }
  47. private Connection conn;
  48. public void createTable() throws SQLException {
  49. conn = dbConnection.getDBConnection();
  50. String sql="drop table if exists dummy";
  51. String sql1 = "create table dummy (id int,name varchar(20))";
  52. Statement statement = conn.createStatement();
  53. statement.execute(sql);
  54. statement.execute(sql1);
  55. System.out.println("Table Created!!");
  56. }
  57.  
  58. public void insertData() throws SQLException {
  59. conn = dbConnection.getDBConnection();
  60. String sql = "insert into dummy values(12,'Sunny')";
  61. Statement statement = conn.createStatement();
  62. statement.execute(sql);
  63. System.out.println("Record Inserted!!");
  64. }
  65. }
  66.  
  67. public class AppJavaConfig<T> {
  68. static ApplicationContext context;
  69. public static void main(String[] args) throws SQLException {
  70. context = new AnnotationConfigApplicationContext(SpringConfig.class);
  71. SQLOperationJavaConfig sqLoperationJavaConfig = (SQLOperationJavaConfig) context.getBean("sqloperations");
  72. sqLoperationJavaConfig.createTable();
  73. sqLoperationJavaConfig.insertData();
  74. }
  75. public T getbean(String beanName) {
  76. T t=(T) context.getBean(beanName);
  77. return t;
  78. }
  79. }
  80.  
  81. Caused by: java.lang.NullPointerException
  82. at com.src.springproj.AppJavaConfig.getbean(AppJavaConfig.java:17)
  83. at com.src.springproj.SpringConfig.sqLoperationJavaConfig(SpringConfig.java:10)
  84.  
  85. return new SQLOperationJavaConfig(dbConnection());
  86.  
  87. @autowired
  88. private DBConnection dbConnection;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement