import java.io.*;
import java.sql.*;
import java.sql.Statement.*;
import java.sql.ResultSet.*;
class show
{
public static void main(String args[])
{
String n,c;
Connection cn;
Statement st;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbc:odbc:ucer","","");
st=cn.createStatement();
rs=st.executeQuery("select * from school");
while(rs.next())
{
n=rs.getString(1);
c=rs.getString(2);
System.out.println("name "+n+" city "+c);
}
}
catch(Exception xx)
{
System.out.println("check data"+xx.getMessage());
}
}
}
import java.sql.*;
import java.sql.Statement.*;
import java.sql.ResultSet.*;
class show
{
public static void main(String args[])
{
String n,c;
Connection cn;
Statement st;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbc:odbc:ucer","","");
st=cn.createStatement();
rs=st.executeQuery("select * from school");
while(rs.next())
{
n=rs.getString(1);
c=rs.getString(2);
System.out.println("name "+n+" city "+c);
}
}
catch(Exception xx)
{
System.out.println("check data"+xx.getMessage());
}
}
}
No comments:
Post a Comment