Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.util.ArrayList;
- import java.util.HashMap;
- import java.util.List;
- public class Program {
- public static void main(String [] args){}
- public static HashMap getProductsAsMap() {
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:pd");
- ResultSet rs = null;
- Statement st = con.createStatement();
- String sql = ("select * from products");
- rs=st.executeQuery(sql);
- while (rs.next()) {
- HashMap<String, ProductBean> products= new HashMap<String, ProductBean>();
- String name=rs.getString("pname");
- String desc=rs.getString("pdesc");
- String image=rs.getString("pimage");
- products.put("P1", new ProductBean(name,desc,image));
- return products;
- }
- rs.close();
- st.close();
- con.close();
- }
- catch(Exception e){}
- }
- public static List getProductsAsList() {
- List<ProductBean> products = new ArrayList<ProductBean>();
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:pd");
- ResultSet rs = null;
- Statement st = con.createStatement();
- String sql = ("select * from products");
- rs=st.executeQuery(sql);
- while (rs.next()) {
- String name=rs.getString("pname");
- String desc=rs.getString("pdesc");
- String image=rs.getString("pimage");
- products.add(new ProductBean(name,desc,image));
- }
- rs.close();
- st.close();
- con.close();
- }
- catch(Exception e){}
- return products;
- }
- }
Add Comment
Please, Sign In to add comment