yz.jsp

在线答疑的代码

<%@ page language="java" contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%
String myname=request.getParameter("name");
String mypassword=request.getParameter("password");
String mysql;

    Connection con = null;
     ResultSet rs=null;
    try {
      // 登记JDBC驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //连接数据库
      con = DriverManager.getConnection("jdbc:odbc:mydb","", "");
      //创建语句对象
      Statement statement = con.createStatement();
       
      //插入记录
	  mysql="select * from user where name='" + myname + "' and password='" + mypassword + "'";
         
          //out.println(mysql);
          //将Unicode编码的String类型数据转化为“ISO-8859-1”编码
          byte[] temp=mysql.getBytes("ISO-8859-1");
          String mysql_str=new String(temp,"GB2312");
          rs=statement.executeQuery(mysql_str);
	  if(rs.next())
          {response.sendRedirect("yhjm.jsp");}
          else
          {
                 out.println("no this user!");}
	}
    catch (Exception e) {
      out.println(e.toString());
    }
   //关闭数据库连接
   rs.close();
   con.close();
 %>
</body>
</html>