linkdata.java~5~

wbml地址转换

package httpclient;
import java.sql.*;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class linkdata {
    String sql;
    String username;
    String password;
    Connection conn=null;
    ResultSet res=null;
    Statement stat=null;


    public linkdata() {
    }
    public void link()
    {
      try{
        Class.forName("sun:jdbc:odbc:JdbcOdbc");
        conn=DriverManager.getConnection(jdbc.odbc.datasurce,username,password);
        String sqlstr1="select * from tablename ";
        stat=conn.prepareStatement(sqlstr1);

    }catch(SQLException ee)
    {

    }
    }
}