Hi
i am writing a JSP page which connects to Mysql DataBase
i can get the connection but i cant get to execute the query on the database
plz help
the code of jsp file
i am writing a JSP page which connects to Mysql DataBase
i can get the connection but i cant get to execute the query on the database
plz help
the code of jsp file
| Code: |
| <%@ page import ="java.lang.*" %>
<%@ page import ="java.sql.*" %> <html> <head> <title> Index Page </title> </head> <body> jsp pages is better than ASP.NET <% int x; Connection conn=null; Statement st=null; ResultSet rt=null; String query="select * from user"; Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root","aaaa"); if(conn==null) { out.print("not connected"); } out.print("<br>"+"Connection"+conn+"<br>"); try { st = conn.createStatement(); rt=st.executeQuery("select * from a.a"); while(rt.next()) { String y; String str; x=rt.getInt("id1"+"<br />."); y= rt.getString("id2"+"<br />."); str= rt.getString("id3"+"<br />."); out.print(x); out.print(y); out.print(str); } } catch(Exception ex) { out.print("<br>"); out.print("Timeoooo "+"<br />"); } finally { if (rt != null) rt.close(); if (st != null) st.close(); if (conn != null) conn.close(); out.print("<br>"); out.print("Timeoooo"+"<br />"); } %> <% conn = null; st = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/","root","aaaa"); st = conn.createStatement(); rs = st.executeQuery("select * from a.employees"); while(rs.next()) { %> <TR><TD><%= rs.getString("lname_txt") %></TD> <TD><%= rs.getString("fname_txt") %></TD></TR> <% } %> </TABLE> <% } catch (Exception ex) { ex.printStackTrace(); %> </TABLE> Ooops, something bad happened: <% } finally { if (rs != null) rs.close(); if (st != null) st.close(); if (conn != null) conn.close(); } %> </body> </html> |
