testpassw.java

这是用JSP和SQL来开发的,基本完成了一个网上书店所要的功能,有待于加油的是细点

package j0202_05_login;
import java.sql.*;
public class Testpassw
{String cus_name,
        cus_passw,
        message="";
 Connection con;
 Statement sql;
 ResultSet rs;
 public Testpassw()
 {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     }
  catch(ClassNotFoundException e){}
 }
public void setCus_name(String name)
{cus_name=name;}
public String getCus_name()
{return cus_name;}
public void setCus_passw(String pw)
{cus_passw=pw;}
public String getCus_passw()
{return cus_passw;}

public String getMessage()
{try{
     con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
     sql=con.createStatement();
     String condition=
     "update cusinf set cus_passw="+cus_passw+"WHERE cus_name="+"'"+cus_name+"'";
     sql.executeQuery(condition);
     
     message="ok";
     con.close();
      return message;
      }
    catch(SQLException e)
      {message="输入信息有错";
       return message;
      }
   }
}