runsql.java~2~

来自「我做的第一个java MIS项目」· JAVA~2~ 代码 · 共 40 行

package server.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import server.entity.Card;
import java.sql.Connection;
import java.sql.SQLException;

public class RunSQL {

    private Connection con = null;
    private Connectionmanager cm=null;
    private PreparedStatement ps = null;

    public static void runsql(String tsql)
    {
        //创建一个连接
        cm =new Connectionmanager();
        con= cm.getconnection();
        try
        {
            ps = con.prepareStatement("select cardpwd from card where cardid='" +testcardid+ "'");
            rs=ps.executeQuery();
            rs.next();
            realcardpwd=rs.getString(1);
        }
        catch (SQLException ex) {return false;}
        //断开数据连接
        finally
        {
            cm.closeresultset(rs);
            cm.closestatement(ps);
            cm.closeconnection(con);
        }

    }


}