一个个新搞JSP和MySQL的菜鸟,请求大侠们拉一把

脚本是:
<%@ page contentType="text/html; charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<html>
<head>
<title></title>
<head>
<body>
<script language="javascript">
function shanchu(values2)
{
   with(document.thisform)
   {   sj1.value=values2;
    sjkm.value="2";                            
   action="shuchu.jsp";
   submit();}
}
</script>
<%!Connection conn  = null; %>                      
<%!Statement  stmt  = null; %>
<%!ResultSet  RS=null;%>
<%!ResultSet  RS1=null;%>
<%!String  sql=null;%>
<%!String[]  CName;%>
<%!String[]  sj;%>
<%!ResultSetMetaData  metaData;%>
<%String yhm=request.getParameter("yhm");%>
<%String mm=request.getParameter("mm");%>
<%try{
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("a");
  conn = DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
System.out.println("b");
  stmt = conn.createStatement();
System.out.println("c");
  sql="select * from user where name='"+yhm+"' and password='"+mm+"'";
System.out.println("d");
  RS=stmt.executeQuery(sql);
  RS.last();
  int count=RS.getRow();  System.out.println("e");
  }catch(Exception e)
  {
  System.out.println(e.getMessage());
  }%></body>
</html>