sql.java

来自「桂林电子科技大学编译原理完整JAVA源代码(词法、语法、语义) 此为完整版本」· Java 代码 · 共 50 行

package news;
/*
 * Sql.java
 *
 * Created on 2007年1月12日, 上午7:46
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import java.sql.*;
public class Sql {
    ResultSet rs;
    String url="jdbc:odbc:scanner";
    Statement stmt;
    Connection conn;
    Statement stmt1;
    public Sql() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn=DriverManager.getConnection(url);
            stmt1=conn.createStatement();
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        } catch (SQLException ex) {
            ex.printStackTrace();
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }
    public ResultSet getResult(String sql){
        try {
            rs=stmt.executeQuery(sql);   
        } catch (SQLException ex) {
            ex.printStackTrace();
        }      
            return rs;
    
    }    
    public void executeSql(String sql){          
        try {
            stmt1.executeQuery(sql);
            conn.commit();
            stmt1.close();
            conn.close();
        } catch (SQLException ex) {
            
        }      
     
    }
    }