请教JSP中带条件的SQL语句的写法

[iceman_fsm]

用JSP请言连接网络数据库，想查询符合条件的数据信息，SQL语句该怎么写。
select * from test where name=????

[zlq]

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =DriverManager.getConnection(url, username, password);
// conn.setAutoCommit(true);

Statement lStat = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
CallableStatement cs;
String ss;
ss = "tab"

strSQL = "select * from " + ss;
lRS = lStat.executeQuery(strSQL);
while (lRS.next())
{
aa = lRS.getObject(1);
System.out.println(aa.toString());
}
lRS.close();

[ldgs]

PreparedStatement pstmt=con.prepareStatement("select * from test where name=?");
pstmt.setString(1, "Ribin");

[cleverfish]

private void example(HttpServletRequest request,HttpServletResponse response){
String dburl = "jdbc:odbc:fish";
String user = "sa";
String pword = "";

String age = request.getParameter("uage");
String name = request.getPatameter("uname")

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dburl,user,pword);
Statement s = c.createStatement();
String sql = "select * from memberinfo where userage='"+age+"' and username='"+name+"'";
ResultSet rs = s.executeQuery(sql);

while (rs.next()){

//your code to do something;

}
}catch(Exception e){
e.printStackTrace();
}
}