jueves, 17 de mayo de 2007

Coneccion JSP con MySQL

Connection cn;
ResultSet rs;
try{Class.forName("com.mysql.jdbc.Driver");
cn=DriverManager.getConnection("jdbc:mysql://localhost/miBD","root","pasword");
rs=cn.createStatement().executeQuery("select * from usuario");
while(rs.next()){ out.println(rs.getString("usuario"));}}
catch(ClassNotFoundException cnfe)
{ out.println("no hay clase");}
catch(SQLException sqle)
{ out.println("error de coneccion");}%>

No hay comentarios: