studentmanager.java

java 与sql数据连接方法

package com.ctc.bbs.util;
import java.sql.*;

import com.ctc.bbs.beans.StudentLon;

public class StudentManager {
   public StudentLon getStudent(String name,String password)
   {
       Connection conn=DBConnection.getConnection();
       Statement smt=null;
       ResultSet rs=null;
       StudentLon s=new StudentLon();
       try
       {
           smt=conn.createStatement();
           String sql = " select * from t_student where name ='"+name+"',password='"+password+"'" ;
           rs=smt.executeQuery(sql);
           if(rs.next())
           {
               s.setName(rs.getString("name"));
               s.setPassword(rs.getString("password"));
           }
       }
       catch(SQLException ex)
       {
           ex.printStackTrace();
       }
       finally
       {  try{
               rs.close();
               smt.close();
               conn.close();
           }
           catch(SQLException ex)
           {}
       }
       return s;

   }


}