sqlclass.java

来自「网吧计费系统,很强大的功能 大家可以下载下来」· Java 代码 · 共 39 行

package netbar;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;

public class SQLClass {
    
    public SQLClass() {
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }

    public ResultSet SQL(String sql) {
        ResultSet rs = null;
        try {
            Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/netbar","sa","sa");
            Statement st = conn.createStatement();
            rs = st.executeQuery(sql);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return rs;
    }
    public void sql(String sql) {
        try {
            Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/netbar","sa","sa");
            Statement st = conn.createStatement();
            st.executeUpdate(sql);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}