sql.java

来自「笔记的管理」· Java 代码 · 共 45 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package bt;
import java.sql.*;
/**
 *
 * @author Administrator
 */
public class sql {
    
    private String results;
    public String result(String sql){
                 String Sql=sql;
                 Connection conn;
                 Statement stmt;
                 ResultSet rs;
          try
          {
                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           String url="jdbc:odbc:java";
           String user="";
           String password="";
                  conn= DriverManager.getConnection(url,user,password);  
                  stmt=conn.createStatement();  
                  
                  rs=stmt.executeQuery(Sql);  
                  if(rs.next())
                  results=rs.getString(1);
                  rs.close();
                  stmt.close();
                  conn.close();
          }
          catch(Exception e)
          {
           e.printStackTrace();
          }
       return results;      
    
    }

}