0

Please solve my problem i'm using sql server to get values from db but i'm getting below exception i'm my dbConnect class :

first page is my index.jsp than

stateDAO.java is a servlet class:

response.setContentType("text/html")"
PrintWriter out = response.getWriter();
Connection conn;
Statement st=null;
        try {
            conn=dbConnection.connect();

            String state_name= request.getParameter("stateId");

            System.out.println("state name is "+state_name);

            ArrayList State_all=null;

            ArrayList State_id= new ArrayList();

            String query_state="select * from state_master";

            if(state_name != null && !state_name.equals("")) {

                query_state = "select * from master_state where state_name='" + state_name + "'" ;

                System.out.println("query " + query_state);
                    st = conn.createStatement();
                    ResultSet rs = st.executeQuery(query_state);

                    while (rs.next()) {

                        State_all=new ArrayList();

                        State_all.add(rs.getString(1));
                        State_all.add(rs.getString(2));
                        State_all.add(rs.getString(3));
                        State_all.add(rs.getString(4));
                        State_id.add(State_all);

                    }

                    request.setAttribute("State_name", State_id);

                    RequestDispatcher success= request.getRequestDispatcher("success.jsp");

                    success.forward(request, response);

                    conn.close();


                        }
            }


         catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }   

}

provider interface 

public interface provider {

    String username= "sa";
    String Password = "sql@123";
    String url = "jdbc:sqlserver://localhost\\sqlexpress";


}

dbConnection.java

public class dbConnection implements provider {

    static Connection conn=null
        public static Connection connect() throws ClassNotFoundException {

            try {

                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
              conn = DriverManager.getConnection(url, username, Password);
                System.out.println("Connected to the  server successfully.");
            } catch (SQLException e) {
                System.out.println(e.getMessage());
            }

            return conn;
        }

    }

if iam not using class.ForName() i am getting below error "No suitable driver found for jdbc:sqlserver://localhost\sqlexpress"

Please help me i am struggling this issue for last two days thanks in advance

Youcef LAIDANI
  • 55,661
  • 15
  • 90
  • 140
chandrakanth B
  • 349
  • 1
  • 2
  • 9
  • Have you included the required driver `com.microsoft.sqlserver.jdbc.SQLServerDriver`. [See this for help](http://stackoverflow.com/questions/5616898/java-sql-sqlexception-no-suitable-driver-found-for-jdbcmicrosoftsqlserver), i think this is duplicate. – jack jay Feb 05 '17 at 11:38
  • Please edit/fix your question. It's a formatting mess. – JonyD Feb 05 '17 at 11:44

0 Answers0