JSON on JSP (JDBC)

here a sample code snippet:

try{

Class.forName("some.jdbc.Driver").newInstance();

Connection conn = DriverManager.getConnection(driver,uname,pword);

conn.setAutoCommit (false);

CallableStatement cs = conn.prepareCall("{call get_pword(?,?)}");

cs.setString(1,userName);

cs.registerOutParameter(2,Types.VARCHAR);

cs.execute();

password1 = cs.getString(2);

conn.close();

cs.close();

}catch(SQLException e){

e.printStackTrace();

}

jgalacambraa at 2007-7-14 17:19:50 >

[nobr]try

{

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/market","root","");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select * from table");

while(rs.next()){

out.print(rs.getString(1)+"<br>");

}

conn.close();

} catch (Exception ex)

{

ex.printStackTrace();

}

[/nobr]

jgalacambraa at 2007-7-14 17:19:50 >