1.jdbc-odbc桥梁<需要配置数据源>
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class JDBCcom {
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
Connection con=DriverManager.getConnection("jdbc:odbc:news","sa","");
Statement st=con.createStatement();
st.executeUpdate("update Students set ClassName='s209' where SName='Tom'");
ResultSet rs=st.executeQuery("Select * from Students where SName='Tom'");
while(rs.next()){
System.out.println(rs.getString(5));
}
}catch(SQLException e)
{
e.printStackTrace();
}finally{
rs.close();
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余3页未读,立即下载