Spring MVC with Sqlite sample
Include all the spring application jar for MVC and for sqlite sqlite-jdbc-3.7.2.jar Note : helloPage.jsp need some amendments to list and iterate the results from controller. /** * SqlLite_CURD.java */ package sample; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; /** * @author PraveenKumar * */ public class SqlLite_CURD { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub //getConnection(); // create(); //populateData(); listAllValues(); } public static Connection getConnection(){ Connection connection=null; try{ Class.forName("org.sqlite.JDBC"); connection=DriverManager.getConnection("jdbc:sqlite:D:/Praveen/sw/SQL_LITE/test.db"); //String sql="SELECT name FROM sqlite_master WHERE type='table' ...
Comments