runsql.java~4~

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

package server.dao;

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


//导入一个SQL语句并执行。
public class RunSQL {

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

    public void runsql(String tsql)
    {
        //创建一个连接
        cm =new Connectionmanager();
        con= cm.getconnection();
        try
        {
            ps = con.prepareStatement(tsql);
            ps.execute();
        }
        catch (SQLException ex) {}
        //断开数据连接
        finally
        {
            cm.closestatement(ps);
            cm.closeconnection(con);
        }

    }


}