import java.sql.*;

public class class1
{
    
    public static void main (String[] args)
    {
        // TODO: Add initialization code here
        try
        {
            String driver="com.ms.jdbc.odbc.JdbcOdbcDriver";
            String url="jdbc:odbc:mzer";
            DriverManager.registerDriver(new com.ms.jdbc.odbc.JdbcOdbcDriver());
            Connection conn=DriverManager.getConnection(url,"dbo","");
            Statement state=conn.createStatement();
            String sql="select * from test";
            ResultSet rs=state.executeQuery(sql);
            while(rs.next())
            {
                String name=rs.getString("name");
                int password=rs.getInt("password");
                System.out.println("your name:"+name);
                System.out.println("your password:"+password);
            }
        }
        catch(SQLException e)
        {
            System.out.println("error");
        }
    }
}