jdbc-odbc桥接_preparedStatment_statment

import java.sql.*;
import java.net.*;
import java.util.*;
public class data1 {


String dri="sun.jdbc.odbc.JdbcOdbcDriver";
String url="";
Connection cn;
String user;
String pwd;

Statement st;
ResultSet rs;
String sql;


public static void main(String[] args) {
// TODO Auto-generated method stub
data1 da=new data1();
}
public data1(){
try {
Class.forName(dri);
user="sa";
pwd="sql";
url="jdbc:odbc:temp";
sql="select * from mybase";
cn=DriverManager.getConnection(url,user,pwd);
PreparedStatement ps=cn.prepareStatement(sql);
//st=cn.createStatement();

//rs=st.executeQuery(sql);
rs=ps.executeQuery();
while(rs.next())
{
String name=rs.getString(1);
System.out.print(name);
}

} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}


}